The table events_restored does not exist in table

Symptom

 When attempting to archive, purge, or run a report, you might encounter the error:

The table events_restored does not exist in table 

Resolution

 Run the following query against your Access Control database:

alter view events_archived as select * from dbname.dbo.EVENTS_RESTORED

change dbname to your archival database. For example:

alter view events_archived as select * from AccessControlArchive.dbo.EVENTS_RESTORED 

Applies To

 OnGuard (all versions) 

Additional Information

Copyright © 2022 Carrier. All rights reserved.