Symptom
After setting up a new AccessControl database for a regional server, and then running Database Setup and configuring Replication Administration, the first full download performed in Replicator deletes tables from the AccessControl database.
Replicator runs for several minutes until an error is generated:
Internal exception [Invalid object name “Table name”.
Statement(s) could not be prepared.
Unexpected application error! Internal Error Code [###########].
When reviewing the database in the region, the table(s) identified in the error are not listed.
Resolution
Install OnGuard 7.2 Enterprise with Update 1 (7.2.269.67).
Applies To
OnGuard 7.2 Enterprise
Additional Information
Manually recreating the table through INSERT will not resolve this symptom, as other tables might also be deleted during the full download.