View task plan template executions
View tracking and diagnostic information for every execution of task plan templates in the Task Plan Template Executions table. The information available includes success, failure, and skipped details, along with references for traceability.
Before you begin
Role required: sn_task_plan.viewer
Procedure
- Navigate to All > Task plan templates > Published Task Plan Templates.
- Select a task plan template from the list, then navigate to the Task Plan Template Execution related list to see the execution record.
-
In the record, view the information for each task plan template execution.
The information available includes the following.
Table 1. Task plan template executions Number The task plan template execution number Expected records The total number of records expected to be created. Created records How many records actually created, once the task plan is applied. Errored records How many records were not created due to an error encountered somewhere (for example, if there is a business rule preventing insert on the target table of the template item) Skipped records How many records were skipped and not created, due to a condition check failing on the Template Item condition record [sn_task_plan_template_item_condition] Execution status Status can be
Completed,In_progress, orCompleted with Errors.If the task plan has been applied, but there are remaining template items yet to be visited/used to create records, then the status is set to
In_progress.If the task plan has fully been applied with NO errors, then the status is set to
Completed.If the task plan has fully been applied with NO errors, but some records were skipped, then the status is set to
Completed.If the task plan has fully been applied with at least ONE error spotted when attempting to create a record using a template item, then the status is set to
Completed with Errors.Execution details This is a field of type JSON. At the bare minimum, if the task plan has been applied and no records have been
"skipped"or"errored", then the JSON object looks something like this:{ Status: "Completed", ParentRecord: ['CS0001', 'CS0002'], RequestNumber: TPEX00001 }The
Statuskey in the JSON object is the same as theexecution_statusfield.The
ParentRecordkey represents the top-level parent record(s) within the newly created hierarchy. It may either represent a singular Glide Record (record existing in the database) that was provided, or an array holding the first level of records created from ROOT template items. Root template items are template items without any parent (top-level).The
RequestNumberkey points back to theNumberof the Task Plan Template Execution record.If there are skipped records or errored records, then the Template Item number of the skipped/errored item is provided. The following is an example where both 'Skipped' and 'Errored' template items were encountered during task plan execution:
{ Status: "Completed with Errors", //status is set to Completed With Errors, as we encountered an errored record ParentRecord: ['CS0001', 'CS0002'], RequestNumber: TPEX00001, Skipped: ['TP0002', 'TP0005'], Errors: ['TP0008'] }