Friday, June 5, 2015

Object Replication errors after a ConfigMgr 2012 R2 SP1 upgrade

Right after a ConfigMgr 2012 R2 SP1 upgrade, you may have Object Replication errors in the SMS_Object_Replication_Manager. After 7 upgrades this is the first one having this kind of errors.

The errors will looks like this:
Microsoft SQL Server reported SQL message 547, severity 16: [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "CI_CurrentRuleDetail_CIID_FK". The conflict occurred in database "CM_***", table "dbo.CI_CurrentRuleDetail", column 'Setting_
Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

When looking in objreplmgr.log you will see the following errors:
*** delete vCI_ConfigurationItems where CI_ID=16835455
*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "CI_CurrentRuleDetail_CIID_FK". The conflict occurred in database "CM_***", table "dbo.CI_CurrentRuleDetail", column 'Setting_CI_ID'.
Failed to delete Deployment Type ScopeId_5D63A272-7854-4697-8F30-AF7069C4E611/DeploymentType_00b65bce-7f88-467a-8e5a-10c1755d3b8a/4

These errors will come back every 30 minutes!

The solution for this can be found on the ConfigMgr database, starting the query:
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16835455'

When restarting SMS_Object_Replication Manager within Configuration Manager Service Manager, you see the lines:
Successfully deleted Deployment Type ScopeId_5D63A272-7854-4697-8F30-AF7069C4E611/DeploymentType_00b65bce-7f88-467a-8e5a-10c1755d3b8a/4
*** delete vCI_ConfigurationItems where CI_ID=16835455

Very good, but another error came back immediately with another ID!

In my situation I did a query 6 (!) times on the ConfigMgr database:
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16835455'
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16835731'
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16846410'
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16847715'
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16857770'
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16857778'


After that everything went fine again. Is it supported? No, i guess not! Is it working? Yes, the errors are gone now! More information can be found on Microsoft TechNet: After R2 SP1 installation: Object Replication manager has errors. Hope it helps!

More blogposts about ConfigMgr 2012 R2 SP1:
ConfigMgr 2012 R2 SP1 and ConfigMgr 2012 SP2 released
Upgrade ConfigMgr 2012 R2 to SP1 with SP2 media (confusing)
New functionality in System Center 2012 R2 Configuration Manager SP1
Doing a ConfigMgr 2012 R2 SP1 upgrade (Notes from the field)
Check the database before doing a ConfigMgr 2012 R2 SP1 upgrade

8 comments:

  1. Thanks.. this post help me to solve a similar problem

    ReplyDelete
  2. Thanks as well. Helped me fix my issue as well. Oddly it never occurred for quite a while after i did the upgrade. I only had to remove 2 entries then a flood of deletions occurred so it was obviously stuck on the 2 that had error-ed.

    ReplyDelete
  3. Thank you Henk, Worked perfect! Had 13 rows in total with two error Ids.
    Thanks :)

    ReplyDelete
  4. Thanks Henk, Great instructions and really helped me out. I didn't get this issue for about 6 months after the SP1 upgrade... very odd... I've removed 10+ Entries over a 2 hour period. can't believe how many deletions there were that needed completing after...

    ReplyDelete