ConfigMgr 2012R2 – Erro 620 e 6004 no componente SMS_OBJECT_REPLICATION_MANAGER

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.

error_msg

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:

Blog do Henk Hoogendoorn

 

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *