We have created a custom checkpoint with a custom query that is checking Batch Jobs errors.
We are getting alerts with the following error:
Com Error: Code=0x800a0e78 SourceADODB.Recordset Description=Operation is not allowed when the object is closed
Release : UIM 20.4 , sqlserver probe
The probe is simply executing a query, and if it is failing in the backend it will give this error. When this error is seen, execute the custom query manually in SQL Management Studio and verify the error there and debug with the DBA.
If the query executes correctly you won't get the error alarm.
The alarm is only received if the query fails. The reason why the query fails is that the object has not been opened, but must be opened in order for the operation to take place.