Symptom
Enterprise transactions are failing. When running Replicator manually, the following error is observed while replicating:
"Exception occurred while replicating hardware transaction for table [Reader].
Unexpected application error! Internal Error Code [509000012]:
Cannot insert duplicate key row object 'dbo.reader' with unique index 'readdescid'. The duplicate key value is 9(3606, "Reader’s Name")
The statement has been terminated."
Resolution
In the Region that is producing this error when running Replicator as an application, complete the following steps:
- Locate the reader described in the error message in System Administration. The reader you are looking for is provided where it says "Reader’s Name" in the error message.
- Change the the name of that reader by adding one (1) character to it.
- Run Replicator and verify that the error message does not re-occur.
- Replicator should run normally after that point.
Applies To
OnGuard Enterprise
Additional Information
None
