大网数据广告活动
启动与系统组件

Service Manager workflows display Needing attention

· 52CE 我爱测

Fixes an issue where new service requests don't change status, workflows don't execute, and list item changes aren't saved in System Center 2012 Service Manager.

This article helps you fix an issue where new service requests don't change status, workflows don't execute, and list item changes aren't saved in Microsoft System Center 2012 Service Manager.

Original product version:   System Center 2012 Service Manager, System Center 2012 R2 Service Manager
Original KB number:   3029574

Symptoms

When new service requests (SRs) are submitted in System Center 2012 Service Manager, the status of the SRs doesn't change from New. Additionally, corresponding workflows don't execute for other work items, and the workflows display Needing attention in the console under Administration > Workflows > Status.

Also, after you change a list item in the console, close the console, and then reopen the console, the change is no longer present in the list.

The list item behavior can also be observed for any secondary management server. In some cases, you may not see any issues on the primary workflow server. Even though the primary workflow server appears to be functioning correctly, you won't see any updates made from the primary server on the secondary server.

Cause

This issue can occur if Microsoft SQL Server Service Broker isn't enabled on the Service Manager database. When the Service Manager database is created, Service Broker is enabled. However, if a disaster-recovery scenario is met and the database has to be restored, Service Broker will be disabled when the restoration is finished, and Service Broker must be enabled manually.

Resolution

To resolve this issue, enable SQL Server Service Broker. To do this, follow these steps:

Note: Do this at a time when the Management Server services can be stopped.

  1. On the management server or servers, open the Services.msc in Microsoft Management Console (MMC) snap-in.

  2. Take one of the following actions, depending on your version of Service Manager:

    • For System Center 2012 Service Manager and System Center 2012 Service Manager Service Pack 1 (SP1), stop the following services:

      • System Center Management Configuration Service
      • System Center Management Service
      • System Center Data Access Service
    • For System Center 2012 R2 Service Manager, stop the following services:

      • System Center Management Configuration Service
      • System Center Data Access Service
      • Microsoft Monitoring Agent Service
  3. Start Microsoft SQL Server Management Studio on the Service Manager database server or on a computer that has the SQL Server tools installed and that can connect to the Service Manager database server.

  4. Select New Query.

  5. In the navigation pane, expand Databases, and then select ServiceManager.

  6. In the details pane, type the following command, and then select Execute:

    SELECT is_broker_enabled FROM sys.databases WHERE name = 'ServiceManager'
    
  7. In the results that are displayed, verify the value that's displayed in the is_broker_enabled field. SQL Server Service Broker is disabled if this value is 0 (zero).

  8. In the details pane, type the following command, and then select Execute:

    ALTER DATABASE ServiceManager SET ENABLE_BROKER
    
  9. Verify that the command succeeded. If it did, SQL Server Service Broker is now enabled.

  10. On the management server or servers, take one of the following actions, depending on your version of Service Manager:

    • For System Center 2012 Service Manager and System Center 2012 Service Manager Service Pack 1, start the following services:

      • System Center Management Configuration Service
      • System Center Management Service
      • System Center Data Access Service
    • For System Center 2012 R2 Service Manager, start the following services:

      • System Center Management Configuration Service
      • System Center Data Access Service
      • Microsoft Monitoring Agent Service
  11. Close all open windows and dialog boxes.

  12. Test the workflows by restarting any workflow that needs attention.

  13. Submit a new service request, and verify that it moves to the In Progress state.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 04/08/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。