Aquintus Posted June 3, 2015 Report post Posted June 3, 2015 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 Quote Share this post Link to post Share on other sites More sharing options...
Peter33 Posted June 3, 2015 Report post Posted June 3, 2015 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. Quote Share this post Link to post Share on other sites More sharing options...
Aquintus Posted June 3, 2015 Report post Posted June 3, 2015 Thank you very much! The errors are gone! :-) Quote Share this post Link to post Share on other sites More sharing options...
Adam Bise Posted July 30, 2015 Report post Posted July 30, 2015 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! Quote Share this post Link to post Share on other sites More sharing options...
Wilson Betancurth Posted April 12 Report post Posted April 12 Your solution for this post worked, thanks. @Peter33 Quote Share this post Link to post Share on other sites More sharing options...
