DX Operational Intelligence

  • 1.  Connection Not Usable

    Posted 02-06-2015 09:59 AM

    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