Hi,
We are getting frequent connection not usable status in CA SOI Console. CA SOI is integrated with CA Nimsoft using Catalyst Connector. It is showing the status below when we have this problem.
offline 0 CA:00050_<Nimsoft_Hub_Server_Name@<SOI_Connector_Host_Name>_CatalystConnector Data Source Catalyst 3.x connector running in Catalyst node <SOI_Connector_Host_Name>_CatalystConnector
Fri Feb 06 06:42:35 EST 2015 Connector is loading
Fri Feb 06 06:42:35 EST 2015 Connector is shutting down
Fri Feb 06 05:43:54 EST 2015 Connector is running normally
We also found the following entry in log during the problem.Can anyone suggest on this?
Versions:
CA SOI : 3.2 SP1
CA SOI Connector : Catalyst 3.4.1 Container (RO56911)/CA Nimsoft Connector
[2015-02-02 03:43:13] [ModuleErrorListener: CA:00050_<Nimsoft_Hub_Server_name>] ERROR [com.ca.usm.ucf.nimsoft.impl.NSConnector] - Error connecting to database: 4060
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "NimsoftSLM" requested by the login. The login failed. ClientConnectionId:c22a6856-9cf7-4983-ae2d-fbe16b8f07f0
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.ca.usm.ucf.nimsoft.impl.NSConnector.initialize(NSConnector.java:240)
at com.ca.ucf.container.ModuleWrapper.initialize(ModuleWrapper.java:386)
at com.ca.ucf.container.NodeImpl.startModule(NodeImpl.java:714)
at com.ca.ucf.container.ModuleExceptionHandler.handleException(ModuleExceptionHandler.java:113)
at com.ca.ucf.container.ModuleExceptionHandler.run(ModuleExceptionHandler.java:41)
Regards,
Manu
+91 9650726222