Skip to content

Object Replication Error After R2 SP1 Upgrade

Featured Replies

Hi,

 

after upgrading to R2 SP1 we got some errors in the objreplmgr.log.

*** delete vCI_ConfigurationItems where CI_ID=16872948	SMS_OBJECT_REPLICATION_MANAGER	03.06.2015 06:59:13	6808 (0x1A98)
*** [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_DMS", table "dbo.CI_CurrentRuleDetail", column 'Setting_CI_ID'.	SMS_OBJECT_REPLICATION_MANAGER	03.06.2015 06:59:13	6808 (0x1A98)
Failed to delete Deployment Type ScopeId_1B4BE20B-7489-4B85-A3D4-0D851F955481/DeploymentType_918277a9-7054-46be-844d-39813cd6cec9/3	SMS_OBJECT_REPLICATION_MANAGER	03.06.2015 06:59:13	6808 (0x1A98)

Is it possible to fix it?

 

best regards

Yes, you can fix it.

Open the SQL Server Management Studio on your Primary Server (run as Administrator, otherwise the query will throw an error just as in the log file :) ) and select the SCCM Database.

Run a new query: select the ID from line before the error in the objreplmgr.log

 

delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID = '16872948'

 

Restart the Object Replication Manager with the Configuration Manager Service Manager.

You will have to repeat the steps until there is no errors anymore in the objreplmgr.log

 

As a side note. If you delete an application in the console, make sure that you delete every deployment type before. Otherwise you will see this error again in your logs.

 

 

Anyways, this is not a supported method. Only do this if you feel comfortable with it.

I fixed the errors this way.

  • 1 month later...

We had the same issues on our site after upgrading to 2012 R2 SP1

 

The command in SQL Mgmt Studio worked:

delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID = 'XXX'

Where XXX is the Configuration Item ID in the line above the error in objreplmgr.log..

 

objreplmgr.log:

*** delete vCI_ConfigurationItems where CI_ID=XXX SMS_OBJECT_REPLICATION_MANAGER 7/30/2015 8:49:32 AM 3156 (0x0C54)

*** [23000][547][Microsoft]

[sql Server]The DELETE statement conflicted with the REFERENCE constraint "CI_CurrentRuleDetail_CIID_FK". The conflict occurred in database "CM_P01", table "dbo.CI_CurrentRuleDetail", column 'Setting_CI_ID'.

Failed to delete Deployment Type ScopeId_E36C69C0-4828-4E8D-AB4A-A820638A16BF/DeploymentType_16b9837d-6ef5-4bd6-8055-3d633c901d06/3

 

Thank You!

  • 8 years later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.