IS 10.5 not starting with database error

[paulryan.uchi]

Hi Everyone,

We are unable to access our IS and restarting does not work. Whenever we try to restart below logs are appearing:

2021-06-17 10:16:13 PDT [ISU.0000.9999C] com.wm.app.tn.db.DatastoreException: Trading Networks could not retrieve data from your database. Go to the JDBC Pools page in the Integration Server Administrator and make sure your database URL, user name, and password are set correctly. Also make sure you created the Trading Networks database tables as described in the webMethods Installation Guide.
(0) java.sql.SQLSyntaxErrorException: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Invalid object name ‘TNModelVersion’.
(1) java.sql.SQLException: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

2021-06-17 10:16:14 PDT [TNS.0002.1082E]
java.sql.SQLSyntaxErrorException: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Invalid object name ‘TNStatistics’.
at com.wm.dd.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.wm.dd.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.wm.dd.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.wm.dd.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at com.wm.dd.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at com.wm.dd.jdbc.sqlserver.dda4.m(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.ddev.e(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.ddev.a(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.dddv.a(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.ddev.x(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.ddev.w(Unknown Source)
at com.wm.dd.jdbc.sqlserverbase.dddv.executeQuery(Unknown Source)
at com.wm.app.tn.db.StatOperations.getStatistics(StatOperations.java:28)
at com.wm.app.tn.manage.DocStatistics.init(DocStatistics.java:114)
at wm.tnextdc.TNServer.(TNServer.java:69)
at wm.tnextdc.TNResourceMonitor.init(TNResourceMonitor.java:52)

[Holger_von_Thomsen]

Hi Paul,

but IS is accessible after restart and only TN parts are not working?

If so, please go to the Settings section in the IS Admin UI and check for the JDBC Pool associated with the TN function.
Looks like the connection is pointing to an user/schema, which does not have TN database parts created into.

Additionally you can run Database Configurator to check the database schema.

Regards,
Holger

[Venkata_Kasi_Viswanath_Mugada1 (Kasi Mugada)]

What changed, Paul? Did you migrate the IS or its database?
Or is it a new installation?

It’s possible that the DB scripts weren’t executed or executed correctly - please assign appropriate permissions to the DB user and rerun the scripts.

Double-check the DB configuration (URL, etc.) for TN, in the IS config file - /…/IntegrationServer/instances/yourInstanceName/config/pool/yourTNJDBCAliasName.xml

P.S - This seems similar to the MWS issue that @Holger_von_Thomsen helped you with, 2 days ago.

KM

[paulryan.uchi]

IS is not accessible after restart. We have just re run the dbConfiguration and this error no longer appear. However we still cant see our IS up and running. We can see a process running using ps -fu <> command on the unix box. Is there any other logs where i can check why we cannot access the IS?

[Venkata_Kasi_Viswanath_Mugada1 (Kasi Mugada)]

Yes, check what other errors are present in the server.log file and post them here.

KM

[Holger_von_Thomsen]

Hi Paul,

please check the profiles/IS_/logs for further logs.

Regards,
Holger