How can we predict whether a long running session is hang or just long running
How can we predict whether a long running session is hang or just long running?
October 15, 2018
Informatica Data Quality Transformations
Transformations in Informatica Data Qulaity (IDQ)
January 1, 2019
Show all

What are the different Workflow/task status in PowerCenter?

In PowerCenter, the different workflow/task status is as follows:

 

Status Name Status for Description
Aborted
Workflows
task​
You want to abort the workflow or task in the Workflow Monitor or through pmcmd. You can also abort all running workflows when you disable the service or service process in the Administrator tool. The Integration Service kills the DTM process and aborts the task.​
Aborting
Workflows Tasks ​
The Integration Service is in the process of aborting the workflow or task. ​
Disabled​
Workflows Tasks ​
You select the Disabled option in the workflow or task properties. The Integration Service does not run the disabled workflow or task until you clear the Disabled option. ​
Failed​
Workflows Tasks ​
The Integration Service fails the workflow or task because it encountered errors. ​
Preparing to Run ​ Workflows The Integration Service is waiting for an execution lock for the workflow. ​
Running ​ WorkflowsTasks The Integration Service is running the workflow or task. ​
Scheduled ​ Workflows​ You schedule the workflow to run at a future date. The Integration Service runs the workflow for the duration of the schedule. ​
Stopped ​
Workflows Tasks​
You want to stop the workflow or task in the Workflow Monitor or through pmcmd. The Integration Service stops processing the task and all other tasks in its path. The Integration Service continues running concurrent tasks. You can also stop all running workflows when you disable the service or service process in the Administrator tool.​
Stopping​ Workflows Tasks​ The Integration Service is in the process of stopping the workflow or task.​
Succeeded ​ Workflows Tasks​ The Integration Service successfully completes the workflow or task.​
Suspended ​
Workflows Worklets
The Integration Service suspends the workflow because a task failed and no other tasks are running in the workflow. This status is available when you select the Suspend on Error option. ​
Suspending ​ Workflows Worklets A task fails in the workflow when other tasks are still running. The Integration Service stops running the failed task and continues running tasks in other paths. This status is available when you select the Suspend on Error option.​
Terminated WorkflowsTasks The Integration Service stops unexpectedly or loses network connection to the master service process.​
Terminating​ WorkflowsTasks The Integration Service is in the process of terminating the workflow or task. ​
Unknown Status ​ WorkflowsTasks
This status displays in the following situations:
The Integration Service cannot determine the status of the workflow or task.
The Integration Service does not respond to a ping from the Workflow Monitor.
The Workflow Monitor cannot connect to the Integration Service within the resilience timeout period.
Unscheduled​ Workflows You remove a workflow from the schedule. ​
Waiting​ WorkflowsTasks The Integration Service is waiting for available resources so it can run the workflow or task. For instance, you may set the maximum number of running Session and Command tasks allowed for each Integration Service process on the node to 10. If the Integration Service is already running 10 concurrent sessions, all other workflows and tasks have the Waiting status until the Integration Service is free to run more tasks.
There is no timeout for a Workflow that is in Waiting status, it simply remains in Waiting status.

Comments are closed.

Share
+1
Tweet
Pin
Share