soitoolbox utility is returning ProgrammingError

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Executing soitoolbox utility resulting in the following error

 

-> Deleting cleared Alerts older than 1500 days from the SOI database... ('Error while doing Database operations : ', ProgrammingError('42000', '[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot find the object "ca_ssa_notebooks_timestamp_temp" because it does not exist or you do not have permissions. (1088) (SQLExecDirectW)'))
In None
ERROR: Exception while processing SQL section 0 : ('42S02', "[42S02] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot drop the index 'ca_ssa_notebooks_timestamp_temp.IX_Id', because it does not exist or you do not have permission. (3701) (SQLExecDirectW)")
 Failed query:

declare @AlertBatch as int
 SET @AlertBatch = ?

exec PurgeClearedAlerts @AlertBatch

The table ca_ssa_notebooks_timestamp_temp is missing. The SOI DB user has role db_owner.

Resolution

The problem was cause by existng database table deleteAlerts.

Needed to delete the deleteAlerts table by executing this SQL query

drop table deleteAlerts