Batch Monitor in the Infrastructure system facilitates you to view the status of executed Batch definitions along with the tasks details. You can track the issues if any, on regular intervals and ensure smoother Batch execution. An event log provides you the real time status of the executed Batches.
You should have Batch Read Only User Role mapped to your user group. The Batch Monitor screen displays a list of Batches with the other details such as Batch ID and Batch Description.
You can search for a specific Batch based on Date range, Module, Status, and Batch Description. The Batches listed in the Batch Details section can be sorted based on the current state as Successful, Failed, Held, or New.
There are 3 different servers to execute a specific executable such as ICC, Router and Activation Manager (AM). Request from ICC goes to Router and get forwarded to Activation Manager (AM). Then AM executes the task and sends result back to Router which further gets forwarded to ICC.
If any of the server crashes while executing the batch and when recovery happens, the status is sent back to ICC server.
Router goes down: When router goes down, the Task Status will become indeterminate and the Batch Status will become Failed.
AM goes down: If AM goes down while executing a task, as soon as AM comes up, status of all tasks in the Batch will change to Indeterminate and the Batch Status will become Failed.
ICC goes down: When ICC goes down, the status of the task will become interrupted and the Batch Status will become Failed.
ICC will mark all the task status as interrupted even though some of the tasks might have executed successfully.
You have to manually validate the data before you re-trigger the batch again.
The Batch Details section in the Batch Monitor screen lists all the Batches which are schedule or executed within the Infrastructure system. You can view and monitor the required Batch definitions and the corresponding task details. You can also export the values in Microsoft Excel format for reference.
To monitor a Batch in the Batch Monitor screen:
Select the checkbox adjacent to the Batch ID whose details are to be monitored.
You can also search for a specific Batch by using the Search option and filter the search results by selecting the required Status as Successful, Failed, Held, or New in the drop down list.
Enter the Batch Run Details as tabulated.
Field |
Description |
Information Date |
Select the information date from the drop down list which consists of recently executed Batch Information dates. |
Monitor Refresh Rate |
Specify the refresh rate at which the latest Batch status details have to be fetched in seconds. You can enter a value between 5 to 999 seconds. |
Batch Run ID |
Select the Batch Run ID from the drop down list which consists of Batch ID's form which the Batch has been executed. |
Click button
in the Batch Run Details tool bar.
The state of the selected Batch is monitored and status the displayed in the following order:
The Batch Status section displays the Batch Run ID with the Batch Status as Successful, Failed, Held, or New.
Successful- Batch execution is successful.
Failed- Batch execution failed. A notification mail is sent to all users mapped to the user groups with the OPRMON role mapped to them. The mail will show the exact task status as Not Run, Excluded, Held, Interrupted, Indeterminate and Cancelled.
Held- Batch execution is put on hold.
Not Started- Batch execution has not started.
The Task Details section displays the executed task details such as Task ID, Task Description, Metadata Value, Component ID, Task Status and Task Log. Click View Log link to view the View Logger window. You can select the checkbox adjacent to the Task ID to view the task component execution details in Event Log section.
Note: If the component used in the task is Data Transformation, the status will be Successful or Failed based on the invocation of function/procedure is successful or failure. The errors produced by PL/SQL will not have impact on task status unless it throws an oracle exception.
The Event Log section displays the list of errors and events of the Batch being executed. The events are displayed in the ascending order with the latest event being displayed at the top. The Event log consists of:
Message ID, which is auto generated.
Description, which has the error details.
Severity, which can be Fatal, Inform, or Successful.
Time, which indicates the time of the event.
In the Batch Run Details tool bar, you can do the following:
Click button to
Stop the Batch monitoring
process.
Click
button to reset Batch Run Details.
In the Event Log
tool bar, you can click Export button to export the event
log details to Microsoft Excel file for reference.