This post discusses about one of the upgrade issues that I worked on while Upgrading the ConfigMgr 2012 RTM to ConfigMgr 2012 SP1.
Upgrading to SP1 fails with the error below in the ConfigMgrSetup.log:
Arithmetic overflow error converting expression to data type int. : MDM_ExtractAppCIData Configuration Manager Setup 3/8/2013 8:00:25 PM 3532 (0x0DCC)
We know we are failing some where in the procedure MDM_ExtractAPPCIData in the section, after the function call to MDM_GetApplicability:
So, from looking at this I am suspecting it is the insert and after looking at the table MDMDeploymentTypeProperties I think it is due to the insert.
Took the query:
Loaded all the CI_ID into a table and ran them through the call to the procedure but it did not fail. Used that list for the CIs from the CI_ConfigurationItems table to call the procedure and found the CI_ID that failed. We then found in the CI_Contents table, the source size for one row was larger than an int (2147483647)
Used the query:
Got more details of the CI and found the application corresponding to it:
For the CI, we were able to find the content and deleted it:
We then removed the application from the Distribution Point (DP) and then verified that we did not have any records which exceeded the value.
We then ran the upgrade again and it succeeded.
Hope it helps !!
Support Escalation Engineer | Microsoft System Center ConfigMgr
Note: Please do not make any changes in the ConfigMgr database until recommended by a Microsoft Support Professional.
This posting is provided "AS IS" with no warranties and confers no rights.