User would encounter the following error message when attempting to perform any activity in the Affected database
This was caused by a limitation on the number of ID’s (ie.. Identities) that a table can have in SQL.
In this case, the error was caused when the ID Column in the ChangeQueue Table attempted to Exceed the (INT Type) limitation of 2147483647 entries
To resolve the problem we did the following:
1. In SQL MGMT Studio, we deleted the contents of the dbo.changequeue table using the command
delete from dbo.ChangeQueue
2. Then we ran this command to reseed the ID Table
DBCC CHECKIDENT (Changequeue, reseed, 1)
Note: any remote users connecting to this database might have to re-sync the changes
The BCM Error log had the following entry
[E] [18:03:08.5739241]BCMRes: Text:
[E] [18:03:08.5788076]BCMRes: Message:Arithmetic overflow error converting IDENTITY to data type int.
Arithmetic overflow occurred.
[E] [18:03:08.7585204]BCMRes: Arithmetic overflow error converting IDENTITY to data type int.Arithmetic overflow occurred.
In addition, when this database was loaded on a local machine, all of the BCM Contacts and Accounts would load as Outlook Forms – rather than BCM Forms
Thanks & Regards