When migrating a tremendous amount of data mail or calendar synchronization may eventually fail with "Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred."
Due to SQL limitation Migration Manager 8.11 tables can store information about 2 billion migrated records. If the number of migrated messages is more than 2 billion, you may encounter the failure described above. To avoid such a failure Migration Manager 8.12 database tables limitation was drastically increased.
However, SQL tables are not automatically updated while upgrading Migration Manager from version 8.11 to version 8.12, if Migration for Exchange Agent (MAgE) has already started synchronizing mailboxes. Please follow the steps in the resolution section to update SQL tables.
RESOLUTION for Migration Manager 8.12: If you get "Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred." after upgrading to Migration Manager 8.12, please run the following SQL queries on the Migration Manager for Exchange SQL database server (you can find out which SQL database / server you need to upgarde in the bottom right corner of Project Manager application). To run the queries:
1) Start SQL Studio.
2) Connect to Migration Manager SQL database.
3) Click New Query
4) Paste the queries below into the New Query window
5) Click Execute! button.
ALTER TABLE ICS_CACHE DROP CONSTRAINT PK_ICS_CACHE
ALTER TABLE ICS_CACHE ALTER COLUMN [ID] [bigint] NOT NULL
ALTER TABLE ICS_CACHE ADD CONSTRAINT PK_ICS_CACHE PRIMARY KEY(ID)
ALTER TABLE ITEM_MATCH DROP CONSTRAINT PK_ITEM_MATCH
ALTER TABLE ITEM_MATCH ALTER COLUMN [ID] [bigint] NOT NULL
ALTER TABLE ITEM_MATCH ADD CONSTRAINT PK_ITEM_MATCH PRIMARY KEY(ID)
RESOLUTION for Migration Manager 8.11: If you get "Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred." when running Migration Manager 8.11, please upgrade to Migration Manager 8.12 according to the Upgrade Guide and run the SQL queries above after upgrading.
