Advertisement

SCCM 2012 SQL Service Broker ConfigMgrRCMQueue is Getting Disabled

Recently, I’ve received a comment from Johan Pol on my post How to Check backlog of Inboxes in SCCM 2012. The command was regarding an issue related to Service broker queue “ConfigMgrRCMQueue”. One old secondary server site entries are not removed from DB and those old entries are causing issues with DB replication. Also, ConfigMgrRCMQueue is getting disabled again and again.
 
The secondary site attached to SCCM / ConfigMgr 2012 hierarchy was removed/deleted but the entries from the SCCM 2012 console was not getting removed. Other secondary server replication links are getting impacted. Always use recommended way “Preinst /delsite” to remove (secondary) sites from SCCM 2012 database. The /DELSITE option does not uninstall the site on the computer specified by the ChildSiteCodeToRemove parameter. This option only removes the site information from the Configuration Manager site database.
 
After doing some search, I found similar kind of issues discussed in the technet forum thread hereSo I thought of simulating the issue in lab environment and provide more information on this issue. 
####Warning#### Do NOT perform this in production environment. Directly editing SCCM 2012 DB is not supported by Microsoft. Contact CSS to perform this action for you.
Following are few steps you can perform to test and resolve the issue in your lab environments. 

1. How to validate the broker service is enabled and running 
 
select is_broker_enabled, * from sys.databases where name = ‘CM_PR1’
 
When is_broker_enabled = 1 then broker service is enabled. In this case Service broker is fine.
is_broker_enabled

is_broker_enabled

2. To validate the requests are executing by SQL server
 
select * from sys.dm_exec_requests
 
Returns information about each request that is executing within SQL Server. Most of the status look good.
Returns information about each request that is executing within SQL Server.

Returns information about each request that is executing within SQL Server.

3.  List of transaction details created to validate data is being written to or received.
 
When we still have the data of old secondary over here. That may cause problems to ConfigMgrRCMQueue. 
 
select * from sys.transmission_queue 
 
ConfigMgrRCM_SiteSE2 and ConfigMgrBGB_SiteSE2 are two conversations related to my old secondary site SE2.
sys.transmission_queue

sys.transmission_queue

4.  ConfigMgrRCMQueue is getting disabled again and again problem 
 
The old site conversations that we’ve seen in step 3 may create problem which may intern disable ConfigMgrRCMQueue…..
 
How to get into ConfigMgrRCMQueue and enable the ConfigMgrRCMQueue : CM_PR1 -> Service Broker -> Queues ->ConfigMgrRCMQueue
ConfigMgrRCMQueue

ConfigMgrRCMQueue

5. How to remove the unwanted or orphan conversations listed in ConfigMgr DB
 
Here, old secondary site SE2 entries (conversations) are creating problems and this conversations handle (conversations_handle) mentioned below is related to that secondary site.  To remove conversation run the following command with conversation_handle ID.
 
END CONVERSATION ‘conversation_handle’ 
 
END conversation ‘A84D7AE3-2E93-E311-ADF0-00155D80801B’
END CONVERSATION 'conversation handle'

END CONVERSATION ‘conversation handle’ 

More troubleshooting tips on SQL Service Broker here.

About Author 

Anoop is Microsoft MVP and Veeam Vanguard ! He is a Solution Architect on enterprise client management with more than 13 years of experience (calculation done on the year 2014) in IT. He is Blogger, Speaker and Local User Group Community leader. His main focus is on Device Management technologies like SCCM 2012,Current Branch, Intune. He writes about the technologies like SCCM, SCOM, Windows 10, Azure AD, Microsoft Intune, RMS, Hyper-V etc...

    Find more about me on:
  • googleplus
  • twitter
  • facebook
  • linkedin
  • youtube
Posted in: CM2012, ConfigMgr (SCCM), Configmgr2012, SCCM 2012, System Center 2012 Configuration Manager

3 Comments

  1. Renato Flief says:

    Anoop,

    Thank you as very much, I always learn something new and practical from your posts.

    Thank you so much,

    Renato

  2. khutjo says:

    Good Morning Anoop,
    hope all is well with you.
    i need your assistance with ConfigMgrRCMQueue system queues.
    we have a total of 103 secondary servers and 1 primary server, all servers are reporting in the console but the ConfigMgrRCMQueue keep going into disable mode. i deleted old convesssion handle but that dint seem t help. how can i establish which conversation is causing it to be disabled.
    i checked endpoint login certificates and all seem to be in order..
    please help

Leave a Comment and Contact Anoop