3 Replies Latest reply on Jan 9, 2020 12:50 AM by Yusuf Rampurawala

    database error while installing TSNA

    Amol Kotwal
      Share This:

      Hello Experts,

       

      We are getting below database error while installing TSNA with external Oracle database.

       

      Jan 06, 2020 2:08:01 PM com.bmc.bcan.agent.shared.imported.network.messages.DebugLogger log

      INFO: NICListener-wildcard-514 listening for syslog messages ...

      Jan 06, 2020 2:26:59 PM com.bmc.bcan.engine.database.persistence.DBTools closeSilent

      WARNING: failed to close db connection

      java.sql.SQLException: Protocol violation

      at oracle.jdbc.driver.T4CTTIfun.readDCB(T4CTTIfun.java:778)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:469)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)

      at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:62)

      at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:938)

      at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:2125)

      at com.bmc.bcan.engine.database.persistence.DBTools.closeSilent(DBTools.java:80)

      at com.bmc.bcan.engine.database.admin.BcanPopulator.addExtraIndexes(BcanPopulator.java:423)

      at com.bmc.bcan.engine.database.admin.BcanPopulator.work(BcanPopulator.java:4725)

      at com.bmc.bcan.engine.database.admin.Populator.populate(Populator.java:47)

      at com.bmc.bcan.engine.database.admin.BcanPopulator.main(BcanPopulator.java:218)

      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)

      Jan 06, 2020 2:26:59 PM com.bmc.bcan.engine.database.admin.Populator populate

      SEVERE: database population error

      java.lang.NullPointerException

      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:943)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1099)

      at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1293)

      at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)

      at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3818)

      at com.bmc.bcan.engine.database.admin.BcanPopulator.addExtraIndexes(BcanPopulator.java:372)

      at com.bmc.bcan.engine.database.admin.BcanPopulator.work(BcanPopulator.java:4725)

      at com.bmc.bcan.engine.database.admin.Populator.populate(Populator.java:47)

      at com.bmc.bcan.engine.database.admin.BcanPopulator.main(BcanPopulator.java:218)

      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)

      Jan 06, 2020 2:26:59 PM com.bmc.bcan.engine.database.persistence.DBSession rollbackTransaction

      WARNING: transaction was not active, ignoring rollback

      Failure with exit code 1

      ]]}

       

      fun fact, another TSNA instance with same configuration worked.

       

      Appreciate help to resolve the same.

       

      Thanks & Regards,
      Amol Kotwal