OnGuard Database errors in Server Event Viewer

Problem Description : 

When the failedRPC table gets too big it can cause communication errors with the Controllers

 Resolution : 

Run all statements on AccessControl table in SQL Server...

Get Panel IDs for identification...

select NAME, Panelid, Paneltype from accesscontrol.dbo.ACCESSPANE where PANELID < 5000 order by panelID asc 

Run this SQL to check the number of records in the table...

SELECT COUNT(*) FROM failedrpc

Run this SQL to check which panels are showing the most errors..

SELECT COUNT(*) number,panelid FROM failedrpc GROUP BY panelid

Purge table if it becomes too large...

Truncate table FailedRPC

 Revision Date : 1/20/2017