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)"))

Cause

The SQL query should be run manually as part of patch post-install procedure

Environment

Release:
Component: SOIMGR

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://docops.ca.com/ca-service-operations-insight/monthly-update-kit/monthly-update-kits/ca-soi-4-2/so01669