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