Execution Log Viewer Job Order Misleading

Execution Log Viewer Job Order Misleading

book

Article ID: KB0078148

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight 7.9.1

Description

The Execution Log Viewer displays the Integration Processes (IP), Workbench executions, and individual transactions associated with an execution, and allows you to filter the results displayed.

Using the Execution Log Viewer, and looking at the DTS column can be misleading. In this example, it seems the order of execution is assaf2.dts->assaf1.dts->assaf3.dts->assaf5.dts->assaf4.dts.
 
kA2320000004GjeCAE_en_US_1_0
 

This particular integration is a chained DTS where the actual order of execution is:

assaf1.dts ->assaf2.dts->assaf3.dts->assaf4.dts->assaf5.dts

The Execution Job Viewer does not take milliseconds into account when sorting the DTS executions. Since assaf1, 2, and 3 all have a start time of 11:49:24, the Viewer displays them randomly. Timestamps, including milliseconds, are stored in the Scribe Internal database and can be located using a SQL Query.
 
To check if the DTS executions were run in the correct order, open SQL Server Management Studio and run the following query:

USE SCRIBEINTERAL
GO
SELECT * FROM SCRIBE.EXECUTIONLOG where  listenerid = [put your IP ID value. in our example IP ID is 7] order by starttime desc ;
GO


The output should be similar to:

kA2320000004GjeCAE_en_US_1_1

Note that assaf1.dts was started at 11:49:24.416, followed by assaf2.dts, starting at 11:49:24.707, etc. These timestamps indicate that the DTS files are following the order specified by the chained DTS.

Chained DTS Files

For a time based integration, only set up the very first DTS in the chain as a job in the TIBCO Scribe Console. Running the first DTS automatically kicks off the entire chain.
 
To create a chained DTS
  1. Use the TIBCO Scribe Workbench to open the first DTS in the chain.
  2. Select Run ->Edit Settings.
  3. In the Enter the filename of the DTS to run next text box, either enter a DTS name or click Browse to locate and select a DTS file to run after the current job. Enter the name of the DTS only with no path.
NOTE: All chained DTS files must be stored in the same directory.

For additional information, see the following in the TIBCO Scribe Insight Help: Next Job Tab

Issue/Introduction

The Execution Log Viewer displays the Integration Processes (IP), Workbench executions, and individual transactions associated with an execution, and allows you to filter the results displayed. The order in which jobs display can be misleading.

Environment

TIBCO Scribe Insight