ServiceDiscovery connector showing isSystemUp() returned false

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

ServiceDiscovery connector is showing error 

Connector error occurred: Connector is reporting problem interfacing with the domain manager. isSystemUp() returned false

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

The problem with the ServiceDiscovery connector error was due to the \soi\ServiceDiscovery\connectivityContext.xml file not having the correct DB connection values.

<property name="driverClassName" value="@[email protected]" />
<property name="url" value="@[email protected]" />
<property name="username" value="@[email protected]" />
<property name="password" value="@[email protected]" />

 

To fix problem,  

Take the values from section <tns:dataSource inj:injID="dbconfig"> in the  \soi\tomcat\registry\topology\physical\node0\sor\sorapp.xml

<tns:url>jdbc:jtds:sqlserver://hostname:1433/SAMStore;instance=;socketKeepAlive=true;</tns:url>
<tns:username>sa</tns:username>
<tns:password>AAAAEIKBYozMGGA8W5XP3tVOmvifAmLW2hmnqyP78kkHkIxG</tns:password>
<tns:driverClassName>net.sourceforge.jtds.jdbc.Driver</tns:driverClassName>

 

edit connectivityContext.xml and fill in the missing values 

 

<property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
<property name="url" value="jdbc:jtds:sqlserver://hostname:1433/SAMStore" />
<property name="username" value="sa" />
<property name="password" value="AAAAEIKBYozMGGA8W5XP3tVOmvifAmLW2hmnqyP78kkHkIxG" />

 

Stop/Start CA SAM Integration Services