Sintoma
O componente SMS_OBJECT_REPLICATION_MANAGER apresenta status Critico.
Troubleshooting
Ao verificar as mensagens do componente é possível observar duas mensagens ocorrendo repetidamente com os códigos de erro 6004 e 620.
A descrição da mensagem de erro cujo o código é 620 é mais ou menos assim:
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_BR5”, 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.
Ao verificar o log objreplmgr.log é possível ver as seguintes mensagens, que ocorrem a cada 30 minutos.
*** delete vCI_ConfigurationItems where CI_ID=16817226 SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:06:26 11068 (0x2B3C)
*** [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_XXX”, table “dbo.CI_CurrentRuleDetail”, column ‘Setting_CI_ID’. SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:06:26 11068 (0x2B3C)
Failed to delete Deployment Type ScopeId_7F26062F-DE14-4189-B89E-F6881B0F1EFF/DeploymentType_8ba20f84-b8d6-4273-be55-81d21ebbf6b0/3 SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:06:26 11068 (0x2B3C)
Resolução
Observe o número do CI_ID destacado na mensagem acima (esse numero poderá ser diferente no seu ambiente).
Abra a console do SQL e execute a seguinte query:
delete from dbo.CI_CurrentRuleDetail where Setting_CI_ID='16817226'
Reinicie o componente SMS_OBJECT_REPLICATION_MANAGER e observe o log objreplmgr.log.
Se tudo der certo você observará mensagens como a abaixo no log.
Em todo caso, o erro poderá ocorrer novamente para outro CI_ID. Neste caso, execute novamente a query para os novos CIs reportados.
+++Completed processing CIN notification files SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:07:45 14168 (0x3758)
Successfully deleted Deployment Type ScopeId_7F26062F-DE14-4189-B89E-F6881B0F1EFF/DeploymentType_8ba20f84-b8d6-4273-be55-81d21ebbf6b0/3 SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:07:47 14168 (0x3758)
Successfully deleted Install Policy Type ScopeId_7F26062F-DE14-4189-B89E-F6881B0F1EFF/RequiredApplication_8e1504ee-5c1b-4e2b-b17e-62fb6b8979bd/6 SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:07:50 14168 (0x3758)
Successfully deleted Install Policy Type ScopeId_7F26062F-DE14-4189-B89E-F6881B0F1EFF/ProhibitedApplication_8e1504ee-5c1b-4e2b-b17e-62fb6b8979bd/6 SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:07:52 14168 (0x3758)
Try to delete related packages for app 16817226 SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:07:53 14168 (0x3758)
Successfully deleted AppModel ScopeId_7F26062F-DE14-4189-B89E-F6881B0F1EFF/Application_080bd596-36b9-4e76-bd09-38a9b0de6bab/14 SMS_OBJECT_REPLICATION_MANAGER 24/11/2015 08:07:54 14168 (0x3758).
Fontes: