CA UIM connector for SOI is getting a database error
Article ID: 131892
CA Service Operations Insight (SOI)
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.
Release: Component: SOIMGR
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.