soitoolbox findConnectorDatabaseAnamolie not found
Article ID: 131379
CA Service Operations Insight (SOI)
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', " [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'findConnectorDatabaseAnamolie'. (2812) (SQLExecDirectW)"))
The SQL query should be run manually as part of patch post-install procedure
Release: Component: SOIMGR
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: