soitoolbox findConnectorDatabaseAnamolie not found

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:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight-monthly-update-kit/MUK/monthly-update-kits/ca-soi-4-2/so01669.html