Symptom
The following error occurs when trying to Replicate:
Exception occured while initializing log table events for replication. Unexpected application error. Internal Code: 513000001 Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occured.
The max value is 2,147,483,647.
Resolution
LASTLOCATION_REPL table identifier of LASTLOCATION_REPLID exceeded its maximum size for the integer.
The value of the identifier can be verified by running DBCC CHECKIDENT ("LASTLOCATION_REPL", NORESEED) on the master. If the value is more than 2,147,483,647, the identity must be reseeded.
Note: Be sure to create a database backup prior to executing the below query.
Reseed by running DBCC CHECKIDENT ("LASTLOCATION_REPL", RESEED, 10) on the master.
This will reseed the identifier to a value of 10.
This will reseed the identifier to a value of 10.
Applies To
OnGuard Enterprise (All versions)
