"Error processing ping report" messages in logs in vRealize Automation 7
search cancel

"Error processing ping report" messages in logs in vRealize Automation 7

book

Article ID: 325889

calendar_today

Updated On:

Products

VMware Aria Suite

Issue/Introduction

Symptoms:
In the vRealize Automation UI under Infrastructure > Monitoring > Logs, you see messages similar to:

Error processing ping response
System.ApplicationException: Error occurred while executing stored proc usp_InsertUpdateHost Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table 'dbo.Agent' directly or indirectly in database '<IaaS_SQL_DB_Name>' to update, delete, or insert the row that has been modified or deleted by another transaction. Retry the transaction or change the isolation level for the update/delete statement. ---> System.Data.SqlClient.SqlException: Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table 'dbo.Agent' directly or indirectly in database '<IaaS_SQL_DB_Name>' to update, delete, or insert the row that has been modified or deleted by another transaction. Retry the transaction or change the isolation level for the update/delete statement.


Environment

VMware vRealize Automation 7.x

Cause

This error is seen when the vRealize Automation Proxy Agent and the ping report are attempting to update the database at the same time. The ping report fails as the data collection processing has locked the dbo.agent table in the IaaS SQL database. The ping report runs on a very regular basis and will succeed on the next run since data collection has already been processed.

Resolution

This error message can safely be ignored.

The occurrence of this issue can be reduced by increasing the time between data collections.