Upgrade to 1702 failed to update database

[spyder 8]

Hi all,

Yesterday we tried to upgrade from 1610. Pre-requisite check had no errors, but the upgrade failed at the 'Upgrade ConfigMgr database’ step.

CMUpdate.log error output (full log attached to this post):

*** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR 547, Level 16, State 0, Procedure sp_SetupSettingsAndRules, Line 177, Message: The MERGE statement conflicted with the REFERENCE constraint “CI_CurrentRuleDetail_SettingID_FK”. The conflict occurred in database “CM_V01”, table “dbo.CI_CurrentRuleDetail”, column ‘SettingID’. : spRethrowError CONFIGURATION_MANAGER_UPDATE 2017-04-04 14:59:30 41488 (0xA210)
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned -1 CONFIGURATION_MANAGER_UPDATE 2017-04-04 14:59:30 41488 (0xA210)
ERROR: Failed to install default configuration items (FinalSqlOperations). CONFIGURATION_MANAGER_UPDATE 2017-04-04 14:59:30 41488 (0xA210)
Failed to update database. CONFIGURATION_MANAGER_UPDATE 2017-04-04 14:59:30 41488 (0xA210)
Failed to apply update changes 0x87d20b15 CONFIGURATION_MANAGER_UPDATE 2017-04-04 14:59:59 41488 (0xA210)

 

We retried the installation with the same result as before. There were two hotfixes for 1610 available, so we tried installing one of them, SCCM 1610 Update Rollup 3 (KB4010155), and it installed fine. We then restarted the server and tried once more with the 1702 upgrade, but it still failed with the same error.

Any ideas are highly appreciated at this moment. ConfigMgr seems to work fine and, strange enough, the console as well as the site says they're now upgraded to 1702 (5.00.8498.100).

 

Thanks,
Pär

CMUpdate_log.zip

[anyweb 475]

please update the status of this thread

[spyder 8]

4 minutes ago, anyweb said:

please update the status of this thread

Up and running again! Thanks to anyweb (and Microsoft) we are now running 1702 and so far everything looks good!

A huuuge thank you for the help!

[anyweb 475]

glad to hear it, to summarize Microsoft is aware of the issue and has produced a fix

[chrisiss 0]

Hi, i am having the exact same problem, Do you have a solution please.

Thanks 

Chris

[spyder 8]

3 hours ago, chrisiss said:

Hi, i am having the exact same problem, Do you have a solution please.

Thanks 

Chris

Hi Chris,

You should get in contact with anyweb, niall@windows-noob.com, since I made a promise not to share the solution he provided. But I'm sure he will help you.

Cheers,
Pär

[chrisiss 0]

Hi Par,

ok i have sent an email, it looks like this may of taken out all my secondary site servers which is a major problem. And SMSexec cannot read the reg on the sccm db. 

He did mention that MS hs produced a fix tho ? 

And i have the 060417 release.. 

 

Edited April 12, 2017 by chrisiss
extra info

[spyder 8]

Chris,

For us, it involved some sql editing to clean out the bad data, a solution provided by MS.

We have no secondary site, so we didn't experience any urgent issues.

According to anyweb, MS has "slipstreamed the fix", whatever that means. Maybe you need to re-download the files for 1702. Hopefully anyweb will reply soon...

 

Cheers,

Pär

[anyweb 475]

hi Chris

after looking at your logs your error is not the same as Par's i'll see what i can find out but please contact me as you mentioned this morning so we can decide how to troubleshoot it, do you have any possibility of doing a teamviewer session with me ?

[Alv2005 0]

Hi anyweb,

I upgraded SCCM from 1610 Hotfix (KB4016483) to 1702 and the process ends with the error:

Failed upgrade ConfigMgr database.

CMUpdate.log:

INFO: Site Component Manager installation completed.    CONFIGURATION_MANAGER_UPDATE    2017-05-23 16:12:39    1308 (0x051C)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure    CONFIGURATION_MANAGER_UPDATE    2017-05-23 16:12:39    1308 (0x051C)
Turned on activation for service broker queue    CONFIGURATION_MANAGER_UPDATE    2017-05-23 16:12:39    1308 (0x051C)
Failed to apply update changes 0x87d20b15    CONFIGURATION_MANAGER_UPDATE    2017-05-23 16:12:39    1308 (0x051C)
Waiting for changes to the "\\sccm.server\SMS_VK1\inboxes\cmupdate.box" directories, updates will be polled in 600 seconds...    CONFIGURATION_MANAGER_UPDATE    2017-05-23 16:12:39    1308 (0x051C)
There are no pending update package to be processed.    CONFIGURATION_MANAGER_UPDATE    2017-05-23 16:22:39    1308 (0x051C)

Maybe you can help to correct this error.
Thank you

[anyweb 475]

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 0]

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 0]

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 7]

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 0]

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 8]

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 8]

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 0]

Thanks

[anyweb 475]

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 0]

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

[AlekseyM 0]

Hi All! I'm asking for Your help. The following SCCM infrastructure is available: CAS and two Primary sites. When upgrading from version 1802 to 1902, there were problems on one of the Primary site. The ConfMgr database cannot be upgraded. Primary site configurations are identical. CmUpdate file attached. Forgot to say that the Primary website on which the problem has three Secondary site. Replication between them takes place in the normal mode. I hope for Your help.

 

CMUpdate.log

[Rowdy 0]

Need some assistance. I've been trying to upgrade from 1606. I've tried going 1610,1702,1710 and the update continues to fail. Under monitoring I get failed updating the admin console binaries. When I look at the CPUpdate.log I see failed to process AdminUI UI manifest.xml and then further down I get Failed to apply update changes  0x80004005. I really need to figure out what is preventing me from updating this. I am doing the update via offline mode and below is a snippet of my CMUpdate.log. Thanks for the help

 

Successfully restored database role permission.    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:08 AM    3132 (0x0C3C)
Successfully reverted Site Control changes.    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:09 AM    3132 (0x0C3C)
INFO: Installing Site Component Manager ...    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:09 AM    3132 (0x0C3C)
INFO: File \\?\F:\SCCM Install Folder\Microsoft Configuration Manager\inboxes\sitecomp.box\shutdown.trn does not exist. No zapping needed.    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:09 AM    3132 (0x0C3C)
Old build 8498 is detected installed    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:09 AM    3132 (0x0C3C)
INFO: Installing Site Component Manager...    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:09 AM    3132 (0x0C3C)
INFO: Installing Site Component Manager under acct <NT AUTHORITY\SYSTEM> path <F:\SCCM Install Folder\Microsoft Configuration Manager\bin\x64\sitecomp.exe>    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:11 AM    3132 (0x0C3C)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Unsecure    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:11 AM    3132 (0x0C3C)
INFO: Running Post Auto Upgrade script.    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:11 AM    3132 (0x0C3C)
INFO: Starting Site Component Manager...    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:11 AM    3132 (0x0C3C)
INFO: Started Site Component Manager service    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:14 AM    3132 (0x0C3C)
INFO: Site Component Manager installation completed.    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:14 AM    3132 (0x0C3C)
INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:14 AM    3132 (0x0C3C)
Turned on activation for service broker queue    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:14 AM    3132 (0x0C3C)
Failed to apply update changes 0x80004005    CONFIGURATION_MANAGER_UPDATE    3/12/2020 11:30:14 AM    3132 (0x0C3C)
 

[anyweb 475]

it could be anything, is there 3rd party av installed on the server ? any details of the setup would be useful as would a full cmupdate.log, that snippet doesn't help unfortunately and the failure would be before that...

[Rowdy 0]

Here is the full log. No 3rd party AV Software

 

[anyweb 475]

does this file exist ?

 

WARNING: Failed to find default package file F:\SCCM Install Folder\Microsoft Configuration Manager\bin\x64\00000409\CMUpdateInstallationStatus.en-US.resx. LastError=2