Triggered runbook never completes in System Center 2012 Orchestrator
This article helps you fix an issue where a triggered runbook never completes in System Center 2012 Orchestrator.
Original product version: Microsoft System Center 2012 Orchestrator
Original KB number: 2805832
A runbook uses the invoke method to trigger a child runbook. The triggered runbook never finishes, and in the policy module log the process shows as terminated.
1 Process terminated: exception caught.
This can occur if disallow results from triggers is enabled on the SQL Server.
To resolve this issue, change the disallow results from triggers value to 0.
First run following SQL statements in SQL Server Management Studio to verify the current setting:
USE master XEC sp_configure 'show advanced option',1 RECONFIGURE XEC sp_configure
If the value is 1, change the setting to 0 by running the following command:
EXEC sp_configure 'disallow results from triggers',0 RECONFIGURE
This issue has been corrected in System Center 2012 Orchestrator Service Pack 1 (SP1).
This feature will be removed in the later version of SQL Server and the recommended setting for this value is 1. For more information, see disallow results from triggers Server Configuration Option.