Business Contact Manager 2010: Arithmetic overflow error converting IDENTITY to data type int

  • Article

SYMPTOMS

User would encounter the following error message when attempting to perform any activity in the Affected database

 

CAUSE

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

RESOLUTION

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

MORE INFORMATION

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

Rahul Thomas