MWS not starting up after installation

[paulryan.uchi]

Hi Everyone,

We have just installed MWS on one server and IS on another server. Both installation run and completed, and IS came up running but MWS gets an error. The error from the logs we got are copied below.

java.sql.SQLNonTransientConnectionException: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Cannot open database “WM_INSTALLATION_FILE” requested by the login. The login failed.
at com.wm.dd.jdbc.sqlserverbase.ddco.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserverbase.ddco.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserverbase.ddco.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserver.tds.ddr.v(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserver.tds.ddr.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserver.tds.ddj.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserver.tds.ddr.c(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserver.tds.ddj.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserver.SQLServerImplConnection.j(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserverbase.BaseConnection.b(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserverbase.BaseConnection.l(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserverbase.BaseConnection.c(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserverbase.BaseConnection.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at com.wm.dd.jdbc.sqlserverbase.BaseDriver.connect(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0001-0002.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_222]
at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_222]
at com.webMethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:111) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]

DBConfigurator was run on the IS and on the MWS it was not run.

[Harsh_Chincholi]

Hi Paul,

It seems you are unable to connect to DB from MWS. Please make sure login credentials are correct when connecting to DB and tables are created correctly. IS will come up if its not connected to DB but not same with MWS.
Thanks,
Harsh

[Holger_von_Thomsen]

Addendum:

Please check your MWS/server/default/config/mws.db.xml for db connectivity parameters.

It is not neccessary to run the db configurator for each installation, but you can run it once from one of them and then make sure to create the schemas for the neccessary products and/or components.

Regards,
Holger

[paulryan.uchi]

Thanks a lot this one made it work.

[Jake2264 (Alicia Madeleine)]

Please make sure login credentials are correct when connecting to DB and tables are created correctly. IS will come up if its not connected to DB but not same with MWS.