Upgrade to 1702 failed to update database

[anyweb]

hi Alv2005

can you email me your cmupdate.log and any additional details and i'll see what i can find out

 

cheers

niall

[Alv2005]

20 hours ago, anyweb said:

hi Alv2005

can you email me your cmupdate.log and any additional details and i'll see what i can find out

 

cheers

niall

 

Helo,

Thank you in advance for your help.

Here is the log files  CMUpdate.log, ConfigMgrPrereq.log :

 

 

sccm_to-1702.zip

[joegoad1]

On 5/24/2017 at 11:23 AM, Alv2005 said:

Helo,

Good Day,

Completely new to SCCM, tried to apply "1702 Hotfix Rollup (KB4019926) and failed. Completed download/replication/Prereq's. Failure comes back as -  Failed to apply update changes 0x87d20b15

Thank you in advance for your help.

Here is the log files  CMUpdate.log

 

SCCM.txt

[dinci5]

Is this only an issue if upgrading from 1610?

I'm planning an upgrade from 1606 to 1702; This topic just scared the shit out of me. I wouldn't know what to do if it fails.

[Eze]

I having the same issue my CAS and one of the primaries – PS2 sitting on its dedicated separate SQL server upgraded successfully  from 1606 - 1702 

 

But sadly the other primary PS1 sitting on its own dedicated DB ‘alone’ failed to upgrade with error message “[Failed]:Upgrading ConfigMgr database” Please any solutions to this. Have been researching...

 

[spyder]

On 2017-06-13 at 11:19 AM, dinci5 said:

Is this only an issue if upgrading from 1610?

I'm planning an upgrade from 1606 to 1702; This topic just scared the shit out of me. I wouldn't know what to do if it fails.

Sorry for the late reply.
Shortly after we did our upgrade, Microsoft made some changes to their upgrade files, and I am pretty sure the problem is not there anymore. And with 1706 out any day now, you might as well go there.

[spyder]

5 hours ago, Eze said:

I having the same issue my CAS and one of the primaries – PS2 sitting on its dedicated separate SQL server upgraded successfully  from 1606 - 1702 

 

But sadly the other primary PS1 sitting on its own dedicated DB ‘alone’ failed to upgrade with error message “[Failed]:Upgrading ConfigMgr database” Please any solutions to this. Have been researching...

 

You should probably get in touch with anyweb/Niall and see if he can help you, as he helped us.
 

[Eze]

Thanks

[anyweb]

yes if you have an Upgrade issue then contact me at niall@windows-noob.com and i'll see what I can do

[vassil_p]

HI All,

I have almost the same issue updating from 1610 to 1702. SQL is 2012 and OS is 2008R2. In CMUpdate.log task failed:

INFO: sql object usertargetedsoftware_creationtimesmsdefaulttoday with hash SHA256:91FA555663F1479E8B2FDB5B09DD7ED3A22D4B1125955C91D3F78E0DDEE52A7C already exists.    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:21 PM    1800 (0x0708)
Successfully restored database role permission.    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:21 PM    1800 (0x0708)
Successfully reverted Site Control changes.    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:31 PM    1800 (0x0708)
INFO: Installing Site Component Manager ...    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
INFO: File \\?\C:\Program Files\Microsoft Configuration Manager\inboxes\sitecomp.box\shutdown.trn does not exist. No zapping needed.    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
Old build 8355 is detected installed    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
delete SMS_BUSINESS_APP_PROCESS_MANAGER component registry    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
INFO: Installing Site Component Manager...    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
INFO: Installing Site Component Manager under acct <NT AUTHORITY\SYSTEM> path <C:\Program Files\Microsoft Configuration Manager\bin\x64\sitecomp.exe>    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Unsecure    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
INFO: Running Post Auto Upgrade script.    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
INFO: Starting Site Component Manager...    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:32 PM    1800 (0x0708)
INFO: Started Site Component Manager service    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:34 PM    1800 (0x0708)
INFO: Site Component Manager installation completed.    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:34 PM    1800 (0x0708)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:34 PM    1800 (0x0708)
Turned on activation for service broker queue    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:35 PM    1800 (0x0708)
Failed to apply update changes 0x80004005    CONFIGURATION_MANAGER_UPDATE    8/21/2018 12:53:35 PM    1800 (0x0708)

 

Any idea how to solve?

Thanks in advance
 

Edited August 21, 2018 by vassil_p