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

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:

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.

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

5 Comments

  1. 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.

    Reply
  2. 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!

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

    Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.