Jump to content


Aquintus

Object Replication Error After R2 SP1 Upgrade

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...