Workflow Executions View
The Workflow Executions view shows the current workflow that runs for the plan. You can also view the status of all the previous workflows. The list can contain workflow runs for workflows that no longer exist in the plan. The order of the workflow is based on the start date and time. To copy flat files to an integrated test tool, the workflow runs a separate job.
To view the workflow log, you can click Job ID. To view the session log, you can click Session ID in the Sessions tab.
The following table describes the fields in the Workflow Executions view for each workflow run:
Field | Description |
|---|
Job ID | The job number that identifies the job. If you click the Job ID, you can view the workflow log. |
Name | The workflow string that includes the project name, plan name, connection, and table name. |
Description | Describes the type of job that the workflow performs. The job type can be profiling, import, and workflow operations. |
Status | The current status of the workflow. - - In Queue. The PowerCenter Integration Service is waiting for resources before it starts the workflow.
- - Running. The workflow is running.
- - Success. The workflow finished successfully.
- - Error. The workflow did not complete due to errors.
|
Start Date/Time | The date and time that the workflow started. |
End Date/Time | The date and time that the workflow ended. |
User | The name of the user that started the workflow. |
Workflow Tasks
You can stop, abort, and recover the workflow in the Workflow Executions view.
You can perform the following tasks on the Workflow Executions view:
- Auto Refresh
- Causes the view to refresh every ten seconds automatically. You can turn auto refresh on and off.
- Abort
- Stops a job immediately without waiting for a commit. You can abort all jobs, such as profiling and import. You cannot abort workflows.
- Workflow Stop
- Stops a workflow after the next commit occurs.
- Workflow Abort
- Stops a workflow immediately without waiting for a commit.
- Workflow Recover
- Recover a stopped workflow. If high availability recovery is enabled, the PowerCenter Integration Service restarts the workflow from the last saved checkpoint. Otherwise, the PowerCenter Integration Service recovers the workflow according to the recovery strategy that you set in the plan.
Workflow Properties Panel
The Properties panel shows summary information about a workflow that you select in the Workflow Executions view.
The Properties panel shows the same information as the workflow you select in the list. The properties also include generation date, the elapsed time, and the project name.
Workflow Sessions Tab
The Sessions tab lists the sessions that ran in the workflow that you select in the Workflow Executions view.
The following table describes the fields for each session in the Sessions tab:
Field | Description |
|---|
Job ID | The job number that identifies the session. If you click the Job ID, you can view the session log. |
Session Name | The session name is the same value as the workflow name, except the session name starts with "S" and ends with a sequential number. If you click the session name, you can view the session details. |
Status | The current status of the session. - - In Queue. The PowerCenter Integration Service is waiting for resources before it starts the session.
- - Running. The session is running.
- - Success. The session finished successfully.
- - Error. The session did not complete due to errors.
|
Source Rows Succeeded | The number of valid source rows read. |
Source Rows Failed | The number of source rows in error. |
Target Rows Succeeded | The number of rows written to the target. |
Target Rows Failed | The number of rows that were not written to the target. |
Start Date/Time | The date and time that the session started. |
End Date/Time | The date and time that the session ended. |
User | The name of the user that started the workflow. |
Session Details
The Session Details dialog box contains a list of tables that a session processed. The Session Details dialog box appears when you click the session name in the Workflow Execution Sessions tab.
If the Workflow Executions view has refresh enabled, the session details refresh when the workflows refresh.
The following table describes the fields in the Session Details dialog box:
Field | Description |
|---|
Tables | The names of the tables that the session processed. |
Affected Rows | The number of rows that the session processed from the table. |
Rejected Rows | The number of rows that the PowerCenter Integration Service did not process due to errors. |
Throughput | The number of affected rows that the PowerCenter Integration Service did not process due to errors. |
Last Error Message | The text of the last error message in the session. Click the link to view the complete message. |