Setup was unable to compile Sql CE script file CIStateDBUpgrade.sqlce during CCM Setup

2014-08-13 ConfigMgr SCCM
Share on:

Recently I was troubleshooting a Windows 7 Service Pack 1 system where the CCM Client would not install manually or via push. The following was reported in the CCMSETUP.LOG:

MSI: Setup was unable to compile Sql CE script file C:\Windows\CCM\CIStateDBUpgrade.sqlce. The error code is 87D00244. MSI: Action 13:27:05: Rollback. Rolling back action: File C:\Windows\ccmsetup\{181D79D7-1115-4D96-8E9B-5833DF92FBB4}\client.msi installation failed. Error text: ExitCode: 1603 Action: CcmCompileSqlCEScripts. ErrorMessages: Setup was unable to compile Sql CE script file C:\Windows\CCM\CIStateDBUpgrade.sqlce. The error code is 87D00244.

I tried all my standard troubleshooting steps to resolve the issue, which included making sure all versions of the client were removed, attempting to repair WMI, and even going as far as deleting the WMI repository, which is strongly discouraged by Microsoft, but is often a last resort. I also tried toying around with SQL Server Compact Edition, doing things like re-registering all the associated DLLs, but still no luck.

After numerous installation attempts, reboots, and WMI work, I was able to resolve the issue by doing the following:

  1. Running c:\windows\ccmsetup\ccmsetup.exe /uninstall just to make sure we were clean(ish).
  2. Removing the folder c:\windows\ccm. This is because I had seen issues with the SDFs being left behind in this folder causing problems.
  3. Running CCMCLEAN.EXE /Q from this install.
  4. Running c:\windows\ccmsetup\ccmsetup.exe SMSSITECODE=AUTO to reinstall the client.

A quick note about the CCMCLEAN - this tool is actually from the SMS 2003 toolkit, so not only is it not supported on its own, but definitely not supported for SCCM 2012, but I had run through all those steps numerous times without using CCMCLEAN, and it wasn't until I ran it that it worked. Hope this helps someone!

Credit to Whizz1969 in this forum post for pointing out CCMCLEAN. Although I was not the original poster in that thread, it was the only useful result I found when googling this error.


5 comments

Basam

Thank you. This is just what the doctor ordered! CCMCLEAN.EXE worked to clean up sccm 2012 client. I downloaded the new toolkit and it did not include that file.

I also did registry removals found on another forum, though I'm not sure if they are necessary: REG DELETE HKLM\software\Microsoft\ccm /f REG DELETE HKLM\software\Microsoft\CCMSETUP /f REG DELETE HKLM\software\Microsoft\SMS
REG DELETE HKLM\software\Microsoft\Systemcertificates\SMS\Certificates /f

Everything worked flawlessly, even thought you said it was not supported.

Landon

This saved my bacon. I was banging my head trying to figure out why it refused to reinstall properly. That clean tool made all the difference.

thanks!

Sam

You're doing the Lord's work. Fixed all my issues. Thanks for the post!

Mirko

Definitively works for me!!!.Many thanks, and Kudos to Chris. Deleted CCM folder do the magic.