soitoolbox findConnectorDatabaseAnamolie not found
book
Article ID: 131379
calendar_today
Updated On:
Products
CA Service Operations Insight (SOI)
Issue/Introduction
We have recently upgraded to 4.2 with Cummulative patch SO07205 but when we run the soitoolbox with findConnectorDatabaseAnamolie command fails with stored procedure not found.
ERROR: ('Exception:', ProgrammingError('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'findConnectorDatabaseAnamolie'. (2812) (SQLExecDirectW)"))
Environment
Release: Component: SOIMGR
Cause
The SQL query should be run manually as part of patch post-install procedure
Resolution
This command was introduced in one of the earlier patch and we need to run below SQL query manually as part of patch post-install step. The missing stored procedure is documented in this fix and needs to be added manually: