CA UIM connector for SOI is getting a database error

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

The UIM connector is not fetching any data from UIM. The following error was seen in the CatalystContainer_wrapper.log
2019-05-01 14:25:31,007 ERROR [CA:[email protected]_CatalystConnector] impl.NSConnector - nimsoft connector: Unable to get Alarms java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist.

Environment

Release:
Component: SOIMGR

Resolution

The error happens when the user trying to connect to the UIM DB don't have the appropriate rights to access the DB. The UIM connector uses the same user account that the UIM itself uses to connect to the UIM DB and this user should already have the needed privileges. SO make sure you have the connector configuration file with the the following information:
- On the UIM connector machine you'll find the following file containing the Oracle DB user name and password                                                             CA\Catalyst\CatalystConnector\registry\topology\physical\_CatalystConnector\modules\configuration \Nimsoftconnector.conf
 wsUrl - Shows the path or connection to the UIM DB
 wsUsername - Shows the user name used to connect to the above DB
 wsPassword - Password for the Oracle DB user. This is encrypted. If needed CA\Catalyst\CatalystConnector\tools\encrypt\encrypter.bat can be used to encrypt the password again
- On the UIM side you can look in to the data_engine configuration for the DB user name.