Error Message :
Executing an Autoforecast may cause the WP process to hang in certain situations like in the example below.
The following statement doesn’t return a result for XPRESSSIONS hostgroup but XPRESSIONS is used in many jobs within the client.
select distinct AHG_HostGroupName from uc4.dbo.AHG;
With the setting above, the issue can be reproduced using the following steps:
- Activate a Schedule that includes a workflow that the Autoforecast will be forecasting on (JSCH.POLICY). The workflow in the schedule does not need to be active. Ensure that the workflow has several layers of jobs and jobp's.
- If the schedule is active the Autoforecast hangs when it tries to generate the script. If the schedule is not active it runs without a problem.
- Activate the script object. Autoforecast is stuck in generating and it can’t be canceled. In order to remove it, manually modify the task.
:print “START: autoforecast request”
:print “END: autoforecast request”
:print “Results from autoforecast (0 = successful): &autoforecast#”
:if &autoforecast# = 0
:print “We are OK”
:print “We are stuck!”