Troubleshooting

Flowchart execution status not communicated to HCL Unica Director

Under circumstances described below, the flowchart execution status is not communicated to Unica Director.

1. Killing the server process.
2. Killing the listener and removing the flowchart active sessions from listener.
3. Delete schedules while the flowchart is in running status...and so on.

Thus, flowcharts might be shown as running even they are completed or have failed. To rectify this please perform the following steps in such scenarios:

1. Log on to HCL Unica Director.
2. Click Monitoring.
3. Hover mouse on the ‘running’ flowchart that is shown as completed/failed
4. Note down the RunID and flowchartID of such flowchart. example runId= 124504 &flowchartId=3455.
5. You can also get this information by clicking on the flowchart and opening the detailed execution window. In address bar, you will see something similar to http://<HOST>:<PORT>/process-box?runId= 124504&flowchartId=3455.
6. Use the RunID in the following queries, review this SQL script with your DBA, take a backup of the Unica Director database and then execute:
   • db2 " delete from AO_PROCESSRUNEVENTS where RUN_ID= 124504"
   • db2 " delete from AO_processruninfo where RUN_ID= 124504"
   • db2 " delete from AO_RUNINFO where RUN_ID = 124504"