CM Update Reset Tool Fixes SCCM CB Update Download Issue

SCCM CB Update is stuck in Downloading state? CMUpdateReset is the tool you should try out. This will help to delete the problematic updates from your SCCM DB. This method is fully supported.

11

Have you faced SCCM CB update getting stuck in the “Downloading” state? I have seen SCCM CB updates are getting stuck in downloading stage. But, in most of the scenarios, a service restart resolves this issue. In this post, we will see “CM Update Reset Tool Fixes SCCM CB Update Download Issue.”

Video Tutorial to Fix SCCM CB updates stuck in Downloading here

[Related Post –  Fix SCCM Updates and Servicing Redist Download Issue]

I have one more post which explain to the fix of SCCM Updates Stuck in Downloading State. I would recommend reading the post SCCM update stuck.

Issue Statement – SCCM CB Update Stuck in Downloading state 

SCCM CB 1710 version is released a couple of weeks back. I have posted about the how to download SCCM CB preview version. The SCCM CB 1710 update got stuck in downloading state. I checked the size of the folder C:\Program Files\Microsoft Configuration Manager\EasySetupPayload. And the size was over 1 GB. I tried to restart the SMS Executive service couple of times without any luck.

CM Update Reset Tool Fixes SCCM CB Update Download Issue

DMPDownloader.log

ERROR: HasIntuneSubscription has failed to run query fn_HasIntuneSubscription with following exception : System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. 
The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. 
The duration spent while attempting to connect to this server was - [Pre-Login] initialization=4997; handshake=15872; ---> System.ComponentModel.Win32Exception (0x80004005): 
The wait operation timed out~~ at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity
ERROR: Failed to download redist for c410f586-cf7a-4279-b963-139606fc25be with command /RedistUrl
http://go.microsoft.com/fwlink/?LinkID=855656 /LnManifestUrl http://go.microsoft.com/fwlink/?LinkID=855641 /RedistVersion 201710 /NoUI "\\SCCMTP1.INTUNE.COM\EasySetupPayload\c410f586-cf7a-4279-b963-139606fc25be\redist"

What is a CMUpdateReset.exe tool?

CMUpdateReset.exe is Configuration Manager Update Reset tool, and this is part of the CD.Latest folder.  This is a command line tool should be run from the topmost SQL server in SCCM hierarchy. This is the tool to help SCCM admins to fix issues when SCCM CB in-console updates have problems downloading or replicating.

You can find the CM Update Reset tool in the following folder \cd.latest\SMSSETUP\TOOLS. We should run this tool either from CAS SQL server or standalone primary SQL server.

More details Video Tutorial to Fix SCCM CB updates stuck in Downloading here

What is the Use Case for CM Update Reset Tool?

  • Update is stuck in downloading state for more than an hour
  • Update is stuck, and EasySetupPayload folder size is not increasing at all
  • Update package replication to SCCM child primary sites are stuck for a long time
  • Update package replication to child primary server is failed

CM Update Reset Tool Fixes SCCM CB Update Download Issue

First Try – SCCM Update Reset

When you want to reset an update that has download problems then, you can run the following command from the topmost SQL server. In the background, the tool will reset some SQL table entries to remove the update entry from the console. But, this action won’t delete the folders and files in C:\Program Files\Microsoft Configuration Manager\ EasySetupPayload.

CMUpdateReset.exe -S SCCMTP1.Intune.com -D CM_TP1 -P c410f586-cf7a-4279-b963-139606fc25be

The above command didn’t resolve my issue in my scenario explained in this post. I ran the command, and the update of SCCM CB 1710 got removed from SCCM console. Restarted the SMS Executive service and the update came back in the console. But, the update was again stuck in downloading stage.

More details Video Tutorial to Fix SCCM CB updates stuck in Downloading here

SCCM Update Reset Force Delete Option

Once the above command line didn’t resolve the download or replication issue then, we need to force delete the updates. This is an extreme scenario; you want to force deletion of the problematic update package.

High-Level Process of CMUpdateReset.EXE -FDELETE

  • Add all activities stored in CM_UpdatePackageSiteStatus_HIST table
  • Delete Package distribution list for update package
  • Delete update package from EasySetupSettings table
  • Delete update package from cm_updatepackageSiteStatus table
  • Delete update package from CM_UpdatePackage_MonitoringStatus table
  • Delete update package from cm_updatepackages table
  • Verify the table entries for package is deleted from CM_UpdatePackage_MonitoringStatus
  • Delete the CAB files from \SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\ folder
  • Delete the folders from \\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\ folder

CM Update Reset Tool Fixes SCCM CB Update Download Issue

Command Line

CMUpdateReset.exe -FDELETE -S SCCMTP1.Intune.com -D CM_TP1 -P c410f586-cf7a-4279-b963-139606fc25be

More details Video Tutorial to Fix SCCM CB updates stuck in Downloading here

Results of Command Line

C:\Program Files\Microsoft Configuration Manager\cd.latest\SMSSETUP\TOOLS\CMUpdateReset>CMUpdateReset.exe -FDELETE -S SCCMTP1.Intune.com -D CM_TP1 -P c410f586-cf7a-4279-b963-139606fc25be
[Warning]
You can use this tool when an in-console update has not yet installed and is in a failed state. A failed state can mean the update download remains in progress but is stuck and taking an excessively long time, perhaps hours longer than your historical expectations for update packages of similar size. It can also be a failure to replicate the update to child primary sites. When you run the tool, it runs against the update that you specify. If the package is in pre-installation state, it will delete it. If package is in replicating state, it will reinitiate replication. Are you sure you want to run the tool? Enter Y for Yes and N for No.
Y
Running CMUpdateReset.exe tool ...
Verified that the SQL server FQDN belongs to the top level site.
Verified that the site servers run version 1606 or later.
Verified that replication is active.
Package is in pre-installation state. Attempting to clean up the package.
Verified that the service connection point is installed on the top level site.
Verified that the account has permission to service connection point share.
Verified that the account has permission to the inboxes\hman.box folder.
Service SMS_EXECUTIVE is Running on machine SCCMTP1.Intune.com.
Verified that service SMS_EXECUTIVE is running on machine SCCMTP1.Intune.com.
Service CONFIGURATION_MANAGER_UPDATE is Running on machine SCCMTP1.Intune.com.
Verified that service CONFIGURATION_MANAGER_UPDATE is running on machine SCCMTP1.Intune.com.
Verified that the package is not in post-replication state for all the child sites (if any).
Marking package in the package distribution list as deleted.
(0 row(s) affected.)
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Marked package in the package distribution list as deleted.
Deleting update package c410f586-cf7a-4279-b963-139606fc25be from EasySetupSettings table on site server SCCMTP1.Intune.com.
(0 row(s) affected.)
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Update package is deleted from EasySetupSettings table.
Deleting update package c410f586-cf7a-4279-b963-139606fc25be from cm_updatepackageSiteStatus table on site server SCCMTP1.Intune.com.
(0 row(s) affected.)
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Update package is deleted from cm_updatepackageSiteStatus table.
Deleting update package c410f586-cf7a-4279-b963-139606fc25be from CM_UpdatePackage_MonitoringStatus table on site server SCCMTP1.Intune.com.
(0 row(s) affected.)
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Update package is deleted from cm_updatepackageSiteStatus table.
Deleting update package c410f586-cf7a-4279-b963-139606fc25be from cm_updatepackages table on site server SCCMTP1.Intune.com.
(1 row(s) affected.)
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Update package is deleted from CM_UpdatePackage_MonitoringStatus table.
Verifying whether the table entries for package c410f586-cf7a-4279-b963-139606fc25be is deleted on site server SCCMTP1.Intune.com.
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Deleting \\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\c410f586-cf7a-4279-b963-139606fc25be.cab.
Deleted \\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\c410f586-cf7a-4279-b963-139606fc25be.cab.
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Deleting \\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\Offline\c410f586-cf7a-4279-b963-139606fc25be.cab.
\\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\Offline\c410f586-cf7a-4279-b963-139606fc25be.cab does not exist to delete.
Deleting \\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\Offline\ConfigMgr.Update.Manifest.cab
\\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\Offline\ConfigMgr.Update.Manifest.cab does not exist to delete.
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Deleting \\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\c410f586-cf7a-4279-b963-139606fc25be.
Deleted \\SCCMTP1.Intune.com\sms_TP1\EasySetupPayLoad\c410f586-cf7a-4279-b963-139606fc25be.
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
Deleting cmupdate notifications.
Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
(1 row(s) affected.)
[Success]Successfully ran the CMUpdateReset.exe tool. If the tool deleted the package (check Updates and Servicing to see if the package is listed), you must restart the SMS_EXECUTIVE service on the top level site. Or, use Check for Update in console to redownload the package.
If the package is reinitiating replication or installation, DO NOT restart the SMS_EXECUTIVE service. You can use the flowchart at (https://docs.microsoft.com/sccm/core/servers/manage/update-replication-flowchart) to troubleshoot additional issues..

Success – SCCM CB Updates Downloaded 

After running the tool, I restarted the SMS Executive service. The update entry for SCCM 1710 has been created, and it was ready “Available to Download” state. I started the download, and it finished downloading the update. Now the update state is “Ready to Install.”

CM Update Reset Tool Fixes SCCM CB Update Download Issue Log entries of Successful completion of SCCM CB update Download 

EasySetupDownloadSinglePackage finishes downloading c410f586-cf7a-4279-b963-139606fc25be.
Successfully Dropped the state message 13
Generating state message: 13 for package c410f586-cf7a-4279-b963-139606fc25be
Generating state message: 13 for package c410f586-cf7a-4279-b963-139606fc25be~~ $$<SMS_DMP_DOWNLOADER><11-05-2017 11:40:30.480-330><thread=5984 (0x1760)>
Write the state message in C:\Program Files\Microsoft Configuration Manager\inboxes\auth\statesys.box\incoming\high\___CMUvx2u44jq.SMX~~ $$<SMS_DMP_DOWNLOADER><11-05-2017 11:40:30.500-330><thread=5984 (0x1760)>
Successfully Dropped the state message 13~~ $$<SMS_DMP_DOWNLOADER><11-05-2017 11:40:30.533-330><thread=5984 (0x1760)>
EasySetupDownloadSinglePackage finishes downloading c410f586-cf7a-4279-b963-139606fc25be. ~~ $$<SMS_DMP_DOWNLOADER><11-05-2017 11:40:30.557-330><thread=5984 (0x1760)>
Get Easy Setup installed Packages to delete payload~~ $$<SMS_DMP_DOWNLOADER><11-05-2017 11:40:30.577-330><thread=5984 (0x1760)>

More details Video Tutorial to Fix SCCM CB updates stuck in Downloading here

References:-

Update reset tool details/documentation – here

11 COMMENTS

  1. My update is stucked in checking prerequisites, its been for more than a day now. i don’t see anything in monitoring as well. What shall i do next ?

  2. Hi Anoop,

    I am getting “failed to extract the payload cab of package tp \\<LAB01.lab.com\EasySetupPaload\” error. In order to resolve, I tried method describe above, however, I am getting following error:

    0x80131904 – Subquery returned more than 1 value.

    Any suggestions ?

  3. Installed update / hotfix KB4490434 but after installation showing full version showing 5.00.8740.1033 but client version showing blank why it is showing blank it should show same version…

    any idea why ?

  4. Question 1
    Installed hotfix KB4490434 and after installation showing full version as 5.00.8740.1033 but client version showing blank, why it is showing blank it should show same version…
    any idea why ?

    Question 2
    Any idea about meaning of below error showing in dmpdownloder.log file
    ERROR: Failed to download Admin UI content payload with exception: The underlying connection was closed: Could not established trust relationship for the SSL/TLS secure channel.
    Failed to call AdminUIContentDownload. error = Error -2146233079

  5. Any advice for when this happens:

    Running CMUpdateReset.exe tool …
    Verified that the SQL server FQDN belongs to the top level site.
    Verified that the site servers run version 1606 or later.

    Verified that replication is active.

    Package is in pre-installation state. Attempting to clean up the package.

    Verified that the service connection point is installed on the top level site.
    Verified that the account has permission to service connection point share.
    Verified that the account has permission to the inboxes\hman.box folder.

    Service SMS_EXECUTIVE is Running on machine cas.mydomain.org.
    Verified that service SMS_EXECUTIVE is running on machine cas.mydomain.org.

    Service SMS_EXECUTIVE is Running on machine site2.mydomain.org.
    Verified that service SMS_EXECUTIVE is running on machine site2.mydomain.org.

    Service SMS_EXECUTIVE is Running on machine site1.mydomain.org.
    Verified that service SMS_EXECUTIVE is running on machine site1.mydomain.org.

    Service CONFIGURATION_MANAGER_UPDATE is Running on machine cas.mydomain.org.
    Verified that service CONFIGURATION_MANAGER_UPDATE is running on machine cas.mydomain.org.

    Service CONFIGURATION_MANAGER_UPDATE is Running on machine site2.mydomain.org.
    Verified that service CONFIGURATION_MANAGER_UPDATE is running on machine site2.mydomain.org.

    Service CONFIGURATION_MANAGER_UPDATE is Running on machine site1.mydomain.org.
    Verified that service CONFIGURATION_MANAGER_UPDATE is running on machine site1.mydomain.org.

    [Error]
    0xSystem.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred dur
    ing the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) —> Syste
    m.ComponentModel.Win32Exception (0x80004005): The certificate chain was issued by an authority that is not trusted
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCred
    ential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionStr
    ing userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)

    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroup
    ProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOpti
    ons options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInterna
    l oldConnection)
    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionIn
    ternal oldConnection)
    at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean al
    lowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
    at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOption
    s userOptions, DbConnectionInternal& connection)
    at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectio
    nOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
    at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFa
    ctory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
    at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
    at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.ConfigurationManagement.ResetTool.DatabaseProxy.GetPackageSiteState(String packageGuid)
    ClientConnectionId:df154402-6826-439a-87cf-707bcd7572f1
    Error Number:-2146893019,State:0,Class:20 – A connection was successfully established with the server, but then an error occurred during the
    login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)
    Verified that the package is not in post-replication state for all the child sites (if any).
    Marking package in the package distribution list as deleted.

    (1 row(s) affected.)
    Adding entry in CM_UpdatePackageSiteStatus_HIST for history tracking.
    [Error]
    0x80131904 – Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= or when the subquery
    is used as an expression.
    The statement has been terminated.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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