SCCM Upgrade Stuck Checking Prerequisites

SCCM Upgrade stuck checking prerequisites

Today I upgraded a customer to SCCM 1702, but I ran into an issue that made things difficult. For some reason, they had a SCCM upgrade stuck checking prerequisites. A previous hotfix that was not installed had been in this state for a very long time and blocked all upgrades for them. Restarting SMS_Executive service or even rebooting the server did not fix this, and the option to upgrade was not available as SCCM thought some other upgrade was running a prerequisite check. This is how I fixed it.

It was actually quite simple to fix SCCM when an upgrade is stuck checking prerequisites. All I had to do was remove the entry of that specific update from the SQL database. Then SCCM re-downloaded all the information about the update, and it was no longer stuck in checking its prerequisites.

From SQL Management Studio, click “New Query”. Make sure your SCCM database is selected, it is usually CM_XXX, where XXX is your sitecode.

Execute the following SQL query list all updates processed by SCCM

Running this query on the SCCM database listed all the updates available for SCCM. This customer had an issue with KB3292796, and I saw it had two entries with two different PackageGuids. These are the ones I want to remove from the database.

SQL query to delete the specific update from SQL. Replace the PackageGuid to match the update you want to remove.

SQL outputted 2 row(s) affected, which is what I wanted.

My last step was to restart the SMS_Executive service. SCCM was now acting as normal again, and I could run the prerequisite check for Configuration Manager 1702 and begin the upgrade.

The customer was happy to hear the issue was fixed, and the upgrade was successful without any more issues. And now they know what to do if this would even happen again.

About the Author

Anders Rodland
Anders Rødland started his carrer as an IT consultant in 2006 and now works as a Senior IT-Specialist and Service Owner for Atea, one of the major IT companies in Scandinavia. My main focus is on Microsoft System Center, and I currently have more than 13 Microsoft certifications. Certified on Windows Server, Windows Client, SQL, Exchange and System Center Configuration Manager. Anders Rodland also holds an ITIL Foundation certification. This is my private blog and do not represent my employer. I use this to share information that I find useful. Sharing is caring.