6 Replies Latest reply on Jul 30, 2019 12:34 AM by Amol Kotwal

    TSNA installation failed with external database oracle

    Amol Kotwal
      Share This:

      Hello Experts,

       

      We are installing TSNA with external database oracle, however installation got failed.

       

      PFB screenshot for reference:-

       

       

      I can see below error messages:-

       

      LOG EVENT {Description=[TrueSight Network Automation Server failed: Execution of [D:\Program Files\BMC Software\BCA-Networks\tools\populate_db.bat] failed],Detail=[featureBcanServer]}

       

      javax.jdo.JDODataStoreException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

      Most recent SQL:

      -- com.bmc.bcan.engine.user.security.ACL

      CREATE TABLE a_c_l (

          a_c_l_id INTEGER NOT NULL,              -- <pk>

          jdo_version SMALLINT NOT NULL,          -- <opt-lock>

          CONSTRAINT pk_a_c_l PRIMARY KEY (a_c_l_id)

      )

      at com.versant.core.jdo.tools.ant.JdoTaskBase.throwBuildException(VOA 4.0.3.27 ---:262)

      at com.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.generateDatabase(VOA 4.0.3.27 ------------:208)

      at com.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.execute(VOA 4.0.3.27 ------------:138)

      at com.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.main(VOA 4.0.3.27 ------------:46)

      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.base/java.lang.reflect.Method.invoke(Unknown Source)

      at com.bmc.bcan.tools.bootstrap.ApplicationLauncher.launch(ApplicationLauncher.java:65)

      at com.bmc.bcan.tools.bootstrap.ApplicationLauncher.main(ApplicationLauncher.java:98)

      Caused by: javax.jdo.JDODataStoreException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

      Most recent SQL:

      -- com.bmc.bcan.engine.user.security.ACL

      CREATE TABLE a_c_l (

          a_c_l_id INTEGER NOT NULL,              -- <pk>

      Populating BCA-Networks database tables ...

          jdo_version SMALLINT NOT NULL,          -- <opt-lock>

          CONSTRAINT pk_a_c_l PRIMARY KEY (a_c_l_id)

      )

       

       

      Does it mean the database User does not have enough permission to create database/tables/schema on remote oracle instance?

       

      Thanks & Regards,
      Amol Kotwal

        • 2. Re: TSNA installation failed with external database oracle
          Amol Kotwal

          Hi Smitty,

           

          We now have all required permission for the user. still getting below error. what could be the reason?

           

          ORA-00604: error occurred at recursive SQL level 1

          ORA-06502: PL/SQL: numeric or value error: character string buffer too small

          ORA-06512: at "C##SERVICE_MANAGER.GENERIC_FUNCTIONS", line 20

          ORA-06512: at line 100

          Most recent SQL:

          -- com.bmc.bcan.engine.network.pcm.AcquiredAddress

          CREATE TABLE acquired_address (

              acquired_address_id INTEGER NOT NULL,   -- <pk>

              condition VARCHAR2(1024) NULL,          -- condition

              acquired_flag SMALLINT NULL,            -- acquiredFlag

              address NVARCHAR2(255) NULL,            -- address

              address_name NVARCHAR2(255) NULL,       -- addressName

              address_pool_id INTEGER NULL,           -- addressPool

              gateway_flag SMALLINT NULL,             -- gatewayFlag

              register_d_n_s SMALLINT NULL,           -- registerDNS

              jdo_version SMALLINT NOT NULL,          -- <opt-lock>

              CONSTRAINT pk_acquired_address PRIMARY KEY (acquired_address_id)

          )

          at com.versant.core.jdo.tools.ant.JdoTaskBase.throwBuildException(VOA 4.0.3.27 ---:262)

          at com.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.generateDatabase(VOA 4.0.3.27 ------------:208)

          at com.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.execute(VOA 4.0.3.27 ------------:138)

          at com.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.main(VOA 4.0.3.27 ------------:46)

          at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

          at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

          at java.base/java.lang.reflect.Method.invoke(Unknown Source)

          at com.bmc.bcan.tools.bootstrap.ApplicationLauncher.launch(ApplicationLauncher.java:65)

          at com.bmc.bcan.tools.bootstrap.ApplicationLauncher.main(ApplicationLauncher.java:98)

          Caused by: javax.jdo.JDODataStoreException: java.sql.SQLSyntaxErrorException: ORA-04088: error during execution of trigger 'C##SERVICE_MANAGER.DDL_TRIGGER'

          ORA-00604: error occurred at recursive SQL level 1

          ORA-06502: PL/SQL: numeric or value error: character string buffer too small

          ORA-06512: at "C##SERVICE_MANAGER.GENERIC_FUNCTIONS", line 20

          ORA-06512: at line 100

           

          Thanks & Regards,
          Amol Kotwal

          • 3. Re: TSNA installation failed with external database oracle
            James Smith

            At this point. I would recommend your DBA blow away the TSNA DB. Then recreate it from scratch. Make sure all the Directories created in the install process are blown away so your server is clean again. Then run the install as if this was the first time. Make sure you've followed all the preparing the environment steps in the documentation. If you do all the required steps then the install should be completed with no errors.

             

            Thanks

            Smitty

            2 of 2 people found this helpful
            • 4. Re: TSNA installation failed with external database oracle
              Yusuf Rampurawala

              From the error :

               

               

              ORA-00604: error occurred at recursive SQL level 1

               

              ORA-06502: PL/SQL: numeric or value error: character string buffer too small

               

              ORA-06512: at "C##SERVICE_MANAGER.GENERIC_FUNCTIONS", line 20

               

              ORA-06512: at line 100

              It looks like an issue with the TRIGGER named “SERVICE_MANAGER.GENERIC_FUNCTIONS” and that is not something that TSNA creates so my guess is it is pre-existing in the system.

               

              Check with the DBADMIN and he should be able to help you with the trigger and may be just disable it for databaseUser used with TSNA.

              1 of 1 people found this helpful
              • 5. Re: TSNA installation failed with external database oracle
                Amol Kotwal

                Hi Smitty,

                 

                Thanks for the information.

                 

                We are using Oracle service name alongside username/password while installing TSNA.

                 

                could you let us know which database we should ask DBA to clean?

                 

                Thanks & Regards,
                Amol Kotwal

                • 6. Re: TSNA installation failed with external database oracle
                  Amol Kotwal

                  Sure Yusuf.

                   

                  we will check that possibility as well.

                   

                  Thanks & Regards,
                  Amol Kotwal