Viewing Flow Status and History

You can view a history of job, process flow, and service execution in Spectrum Management Console and Spectrum Enterprise Designer.

In Spectrum Management Console

To view flow status and history in Spectrum Management Console, go to Flows > History. The Flows tab shows job and process flow history, and the Transactions tab shows services history.
Note: For flow history, the record counts shown when you hover over the Results column reflect the total number of records written as output by all the flow sinks. This number may differ from the number of input records if the flow combines records, splits records, or creates new records.

By default, transaction history is disabled because enabling transaction history can have an adverse impact on performance. If you want to see transaction history you must turn on transaction history logging by clicking the Transaction logging switch. To view user activity, consider using the audit log which you can access under System > Logs.

The flow history list updates automatically every 30 seconds. If you want to update it sooner, click the Refresh button .

In Spectrum Enterprise Designer

To view flow status and history in Spectrum Enterprise Designer, go to View > Execution History.

The flow history list updates automatically every 30 seconds. If you experience slowness when viewing execution history uncheck the Auto refresh box.

The Jobs tab is used to monitor job status and to pause, resume, or cancel jobs that are running as well as delete completed jobs.

Note: The record counts shown on the Jobs tab reflect the total number of records written as output by all the flow sinks. This number may differ from the number of input records if the flow combines records, splits records, or creates new records.
  • The Succeeded column shows the total number of records written as output by all the flow sinks that have an empty value in the Status field.
  • The Failed column shows the total number of records written as output by the flow sinks that have a value of F in the Status field.
  • The Malformed column shows the total number of records coming out of all source stage error ports.

The Process Flows tab is used to monitor process flow status and to cancel process flows that are running as well as delete completed process flows. If you click the plus sign next to any given process flow, you will view Activity Status information for the process flow. This information is included in this area:

ActivityName
Includes the names of all activities, including any success activities, that make up the process flow.
State
The status of the activity (failed, succeeded, running, canceled).
ReturnCode
A code that indicates the result of the process flow:
1
The process flow failed.
0
The process flow finished successfully.
-1
The process flow was canceled.
Other numbers
If the process flow contains a Run Program activity, the external program may return codes of its own. Any values in the ReturnCode column other than 1, 0, and -1 are from the external program. See the external program's documentation for an explanation of its return codes.
Started
The date and time the activity started.
Finished
The date and time the activity ended.
Comment
Any comments associated with the activity.