sqlserver probe custom query Com Error: Code=0x800a0e78 : the object is closed

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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

 

Environment

Release : UIM 20.4 , sqlserver probe

Resolution

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.