spyder 8 Posted April 5, 2017 Report post Posted April 5, 2017 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 Quote Share this post Link to post Share on other sites
anyweb 478 Posted April 7, 2017 Report post Posted April 7, 2017 please update the status of this thread Quote Share this post Link to post Share on other sites
spyder 8 Posted April 7, 2017 Report post Posted April 7, 2017 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! 2 Quote Share this post Link to post Share on other sites
anyweb 478 Posted April 7, 2017 Report post Posted April 7, 2017 glad to hear it, to summarize Microsoft is aware of the issue and has produced a fix 3 Quote Share this post Link to post Share on other sites
chrisiss 0 Posted April 12, 2017 Report post Posted April 12, 2017 Hi, i am having the exact same problem, Do you have a solution please. Thanks Chris Quote Share this post Link to post Share on other sites
spyder 8 Posted April 12, 2017 Report post Posted April 12, 2017 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 Quote Share this post Link to post Share on other sites
chrisiss 0 Posted April 12, 2017 Report post Posted April 12, 2017 (edited) 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 Quote Share this post Link to post Share on other sites
spyder 8 Posted April 12, 2017 Report post Posted April 12, 2017 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 1 Quote Share this post Link to post Share on other sites
anyweb 478 Posted April 13, 2017 Report post Posted April 13, 2017 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 ? 1 Quote Share this post Link to post Share on other sites
Alv2005 0 Posted May 23, 2017 Report post Posted May 23, 2017 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 Quote Share this post Link to post Share on other sites
anyweb 478 Posted May 23, 2017 Report post Posted May 23, 2017 hi Alv2005 can you email me your cmupdate.log and any additional details and i'll see what i can find out cheers niall Quote Share this post Link to post Share on other sites
Alv2005 0 Posted May 24, 2017 Report post Posted May 24, 2017 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 Quote Share this post Link to post Share on other sites
joegoad1 0 Posted June 12, 2017 Report post Posted June 12, 2017 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 Quote Share this post Link to post Share on other sites
dinci5 7 Posted June 13, 2017 Report post Posted June 13, 2017 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. Quote Share this post Link to post Share on other sites
Eze 0 Posted August 22, 2017 Report post Posted August 22, 2017 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... Quote Share this post Link to post Share on other sites
spyder 8 Posted August 22, 2017 Report post Posted August 22, 2017 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. Quote Share this post Link to post Share on other sites
spyder 8 Posted August 22, 2017 Report post Posted August 22, 2017 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. Quote Share this post Link to post Share on other sites
Eze 0 Posted September 1, 2017 Report post Posted September 1, 2017 Thanks Quote Share this post Link to post Share on other sites
anyweb 478 Posted September 1, 2017 Report post Posted September 1, 2017 yes if you have an Upgrade issue then contact me at niall@windows-noob.com and i'll see what I can do Quote Share this post Link to post Share on other sites
vassil_p 0 Posted August 21, 2018 Report post Posted August 21, 2018 (edited) 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 Quote Share this post Link to post Share on other sites
AlekseyM 0 Posted June 19, 2019 Report post Posted June 19, 2019 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 Quote Share this post Link to post Share on other sites
Rowdy 0 Posted March 12, 2020 Report post Posted March 12, 2020 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) Quote Share this post Link to post Share on other sites
anyweb 478 Posted March 12, 2020 Report post Posted March 12, 2020 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... Quote Share this post Link to post Share on other sites
Rowdy 0 Posted March 12, 2020 Report post Posted March 12, 2020 Here is the full log. No 3rd party AV Software Quote Share this post Link to post Share on other sites
anyweb 478 Posted March 12, 2020 Report post Posted March 12, 2020 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 Quote Share this post Link to post Share on other sites