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.