Error: Arithmetic overflow error converting IDENTITY to data type int. - when attempting to refresh the DataWarehouse

Within CRM, it is possible to refresh a deployed DataWarehouse.  When running the refresh process, you may receive Error: Error: 2016-01-20 09:02:24.20
   Code: 0x00000000
   Source: Insert into Fact 
   Description: Arithmetic overflow error converting IDENTITY to data type int.
End Error
Error: 2016-01-20 09:02:24.26
   Code: 0xC002F210
   Source: Insert into Fact Execute SQL Task
   Description: Executing the query "declare @COUNTS table([INSERTED] int);

insert int..." failed with the following error: "Arithmetic overflow occurred.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
End Error  
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1.  Log-in. 
2.  Go to Administration, Data warehouses, go to your Data Warehouse and attempt to refresh.  Notice Error.

Error: 2016-01-20 09:02:24.20
   Code: 0x00000000
   Source: Insert into Fact 
   Description: Arithmetic overflow error converting IDENTITY to data type int.
End Error
Error: 2016-01-20 09:02:24.26
   Code: 0xC002F210
   Source: Insert into Fact Execute SQL Task
   Description: Executing the query "declare @COUNTS table([INSERTED] int);

insert int..." failed with the following error: "Arithmetic overflow occurred.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
End Error

Environment

 Blackbaud CRM
 4.0

Was this article helpful?