TSR for PACE Jobs

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 22, 2024 by Kinga Huszno
5 min read

The task status responses (TSR) for PACE jobs have a specific structure which is slightly different different from common EJM TSRs.

There are more details available for such PACE events as DataMart and RDC Composites.

It includes Pace job execution status and error details - and event details for job substeps as well:

<eventDetails>     <eventName>Data Strategy: [3][EGLRDC_25][Vanilla Option]. Gold Copy: [2][DEFAULT][Default]. Effective Date: [22-Apr-2016]</eventName>     <eagleInstanceId>2804764</eagleInstanceId>     <reason>         <reasonTypeEnum>ERROR</reasonTypeEnum>         <reasonCode>1</reasonCode>         <description>The execution of the event Data Strategy: [3][EGLRDC_25][Vanilla Option]. Gold Copy: [2][DEFAULT][Default]. Effective Date: [22-Apr-2016](SD Instance - 2804764) failed. ERROR: Code:[102][EXCEPTION - RW Exception]. Message: [ERROR: Database operation failed with error: [[SERVERERROR] ORA-01400: cannot insert NULL into ("EAGLE_TEMP"."EGLU_2531394_SCRUBDBO_SECMAST"."PROCESS_SEC_TYPE")]]</description>     </reason> </eventDetails>

These additional details are available as of the January 2016 EagleML Release.

<EagleML   eaglemlVersion="2-0"   eaglemlType="TaskStatusResponse"   xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd"   xsi:type="TaskStatusResponse"   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"> <header>     <messageId>B60EMK55QESDPYVC</messageId>     <sentBy>http://www.eagleinvsys.com/</sentBy>     <sendTo>www.client.com</sendTo>     <creationTimestamp>2016-04-22T21:05:52-05:00</creationTimestamp> </header> <statusItem>     <taskIdentifier>         <correlationId correlationIdScheme="correlationIdScheme">TST_PJ_DK_03_2_4</correlationId>         <businessTaskId correlationIdScheme="businessTaskIdScheme">TST_PJ_DK_03_2_4#RUN_JOB</businessTaskId>     </taskIdentifier>     <status>FAILED</status>     <severityCode>1</severityCode>     <reason>         <reasonTypeEnum>ERROR</reasonTypeEnum>         <reasonCode>1</reasonCode>         <description>The execution of the event Run All Data Strategies For All Securities/PROCESS_ENGINE failed. One or more events failed</description>     </reason>     <taskUnit>         <status>FAILED</status>         <severityCode>1</severityCode>         <eventDetails>             <eventName>Run All Data Strategies For All Securities</eventName>             <eagleInstanceId>2804762</eagleInstanceId>             <reason>                 <reasonTypeEnum>ERROR</reasonTypeEnum>                 <reasonCode>1</reasonCode>                 <description>The execution of the event Run All Data Strategies For All Securities/PROCESS_ENGINE failed. One or more events failed</description>             </reason>         </eventDetails>     </taskUnit>     <taskUnit>         <status>FAILED</status>         <severityCode>1</severityCode>         <eventDetails>             <eventName>Run All Data Strategies For All Securities</eventName>             <eagleInstanceId>2804763</eagleInstanceId>             <reason>                 <reasonTypeEnum>ERROR</reasonTypeEnum>                 <reasonCode>1</reasonCode>                 <description>The execution of the event Run All Data Strategies For All Securities(SD Instance - 2804763) failed. </description>             </reason>         </eventDetails>     </taskUnit>     <taskUnit>         <status>FAILED</status>         <severityCode>1</severityCode>         <eventDetails>             <eventName>Data Strategy: [3][EGLRDC_25][Vanilla Option]. Gold Copy: [2][DEFAULT][Default]. Effective Date: [22-Apr-2016]</eventName>             <eagleInstanceId>2804764</eagleInstanceId>             <reason>                 <reasonTypeEnum>ERROR</reasonTypeEnum>                 <reasonCode>1</reasonCode>                 <description>The execution of the event Data Strategy: [3][EGLRDC_25][Vanilla Option]. Gold Copy: [2][DEFAULT][Default]. Effective Date: [22-Apr-2016](SD Instance - 2804764) failed. ERROR: Code:[102][EXCEPTION - RW Exception]. Message: [ERROR: Database operation failed with error: [[SERVERERROR] ORA-01400: cannot insert NULL into ("EAGLE_TEMP"."EGLU_2531394_SCRUBDBO_SECMAST"."PROCESS_SEC_TYPE")]]</description>             </reason>         </eventDetails>     </taskUnit> </statusItem> </EagleML>

This option is available since the May 2016 EagleML Release.

By default the details for successful substeps are switched off. They can be switched on by setting W_CONFIG_SKIP_SUCCESS_STEPS global parameter with the value 'N' in w_config_custom.inc configuration file.

TSR for DataMart PACE Jobs

For DataMart Pace jobs there are two additional options available for TSR messages:

  1. You can make the process treat NO_DATA status of a substep(s) as a warning and therefore not report it with FAILED status. By default this option is switched off. To switch this feature on, set ‘TreatNoDataAsWarning’ task parameter as ‘Y’ in the RTR message. Like this:

    <taskParameter>    <name>TreatNoDataAsWarning</name>    <dataType>S</dataType>    <value>Y</value> </taskParameter>

    Note: This option is available since the March 2016 EagleML Release.

<EagleML   eaglemlVersion="2-0"   eaglemlType="TaskStatusResponse"   xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd"   xsi:type="TaskStatusResponse"   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"> <header>     <messageId>B60ELJ403JUJKRRG</messageId>     <sentBy>http://www.eagleinvsys.com/</sentBy>     <sendTo>www.client.com</sendTo>     <creationTimestamp>2016-04-22T18:44:00-05:00</creationTimestamp> </header> <statusItem>     <taskIdentifier>         <correlationId correlationIdScheme="correlationIdScheme">TST_PJ_DK_02_2_2</correlationId>         <businessTaskId correlationIdScheme="businessTaskIdScheme">TST_PJ_DK_02_2_2#RUN_JOB</businessTaskId>     </taskIdentifier>     <status>SUCCESS</status>     <severityCode>0</severityCode>     <taskUnit>         <status>NO_DATA</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>Data Mart Report [Transactions] [As of 01/31/2015]</eventName>             <eagleInstanceId>2804306</eagleInstanceId>         </eventDetails>     </taskUnit>     <taskUnit>         <status>NO_DATA</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>Data Mart Report [Cash Activity] [As of 01/31/2015]</eventName>             <eagleInstanceId>2804312</eagleInstanceId>         </eventDetails>         </taskUnit>     <taskUnit>         <status>NO_DATA</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>Data Mart Report [Position Detail] [As of 01/31/2015]</eventName>             <eagleInstanceId>2804437</eagleInstanceId>         </eventDetails>     </taskUnit>     <taskUnit>         <status>NO_DATA</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>Data Mart Report [Lot Level Position Detail] [As of 01/31/2015]</eventName>             <eagleInstanceId>2804446</eagleInstanceId>         </eventDetails>     </taskUnit>     <taskUnit>         <status>NO_DATA</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>Data Mart Report [Ledger] [As of 01/31/2015]</eventName>             <eagleInstanceId>2804464</eagleInstanceId>         </eventDetails>     </taskUnit> </statusItem> </EagleML>
<EagleML   eaglemlVersion="2-0"   eaglemlType="TaskStatusResponse"   xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd"   xsi:type="TaskStatusResponse"   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"> <header>     <messageId>B51MFI24THORKOBH</messageId>     <sentBy>http://www.eagleinvsys.com/</sentBy>     <sendTo>www.client.com</sendTo>     <creationTimestamp>2015-12-25T17:22:42-05:00</creationTimestamp> </header> <statusItem>     <taskIdentifier>         <correlationId correlationIdScheme="correlationIdScheme">TST_DM_JOB_10_1</correlationId>         <businessTaskId correlationIdScheme="businessTaskIdScheme">8547817585289001#RUN_DM_JOB</businessTaskId>     </taskIdentifier>     <status>SUCCESS</status>     <severityCode>0</severityCode>     <taskUnit>         <status>SUCCESS</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>DataMart_Build_STAR_Daily[TST_DM_JOB_10_1]</eventName>             <eagleInstanceId>1721141</eagleInstanceId>         </eventDetails>     </taskUnit>     <taskUnit>         <status>SUCCESS</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>DataMart_LotNumber_Update_Daily</eventName>             <eagleInstanceId>1721142</eagleInstanceId>         </eventDetails>     </taskUnit>      <taskUnit>         <status>SUCCESS</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>DATAMART_STARDIRECT_DAILY</eventName>             <eagleInstanceId>1721143</eagleInstanceId>         </eventDetails>     </taskUnit>     <taskUnit>         <status>SUCCESS</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>DATAMART_STARGAAP_DAILY</eventName>             <eagleInstanceId>1721145</eagleInstanceId>         </eventDetails>     </taskUnit>     <taskUnit>         <status>SUCCESS</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>DATAMART_STARUSTAX_DAILY</eventName>             <eagleInstanceId>1721149</eagleInstanceId>         </eventDetails>     </taskUnit>     <taskUnit>         <status>SUCCESS</status>         <severityCode>0</severityCode>         <eventDetails>             <eventName>DATAMART_STARMGMT_DAILY</eventName>             <eagleInstanceId>1721150</eagleInstanceId>         </eventDetails>     </taskUnit> </statusItem> </EagleML> 

  1. Toggle reporting Event Entity Details for DataMart Model Manager steps:
    Summary details (number of failed entities, total number of processed entities)
    Entity Details (the set of failed entity ids)

This option is available since the May 2016 EagleML Release.

By default Event Entity Details are switched off. To enable these details in the Final TSR, the task parameter ReportEventEntitiesDetails = Y should be populated in the RTR message or the set as global parameter W_CONFIG_INCLUDE_ENTITIES_DETAILS = Y in w_config_custom.inc.

Example of task parameter in the RTR:

<taskParameter>      <name>ReportEventEntitiesDetails</name>      <dataType>S</dataType>      <value>Y</value> </taskParameter>

The example of DataMart Model Manager step with Event Entity Details:

<taskUnit>   <status>FAILED</status>   <severityCode>1</severityCode>   <eventDetails>     <eventName>Model Manager for [Cash Flow Details] [As of 12/31/2014] [21756]</eventName>     <eagleInstanceId>2774897</eagleInstanceId>     <reason>       <reasonTypeEnum>ERROR</reasonTypeEnum>       <reasonCode>1</reasonCode>       <description>The execution of the event Model Manager for [Cash Flow Details] [As of 12/31/2014] [21756](SD Instance - 2774897) failed.    </description>     </reason>     <eventEntities>       <summary>         <failedRecords>3</failedRecords>         <totalRecords>3</totalRecords>       </summary>         <eventEntity><entityId>11330001</entityId></eventEntity>         <eventEntity><entityId>11330002</entityId></eventEntity>         <eventEntity><entityId>11330003</entityId></eventEntity>       </eventEntities>     </eventDetails> </taskUnit>

Security-Level Details in the TSR for RDC Composites

By default RDC event security details are switched off. To enable adding security details to the Final TSR the task parameter ReportEventSecurityDetails = Y should be populated in the

RTR message:

<taskParameter>     <name>ReportEventSecurityDetails</name>     <dataType>S</dataType>     <value>Y</value> </taskParameter>

or W_CONFIG_INCLUDE_SECURITY_DETAILS = Y set in the configuration file w_config_custom.inc.

<EagleML eaglemlVersion="2-0" eaglemlType="TaskStatusResponse" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xsi:type="TaskStatusResponse" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0">   <header>     <messageId>B70BGH95TDLFBUQS</messageId>     <sentBy>http://www.eagleinvsys.com/</sentBy>     <sendTo>www.client.com</sendTo>     <creationTimestamp>2017-01-16T06:39:52-05:00</creationTimestamp>   </header>   <statusItem>     <taskIdentifier>       <correlationId correlationIdScheme="correlationIdScheme">BGH92FDJVFTMF002</correlationId>       <businessTaskId correlationIdScheme="businessTaskIdScheme">46E576_RT_728D2639C8520DAD#run_rdc</businessTaskId>     </taskIdentifier>     <status>FAILED</status>     <severityCode>1</severityCode>     <reason>       <reasonTypeEnum>ERROR</reasonTypeEnum>       <reasonCode>1</reasonCode>       <description>The execution of the event BT142717 Test RDC job/PROCESS_ENGINE failed. One or more events failed</description>     </reason>     <taskUnit>       <status>FAILED</status>       <severityCode>1</severityCode>       <eventDetails>         <eventName>BT142717 Test RDC job</eventName>         <eagleInstanceId>10208327</eagleInstanceId>         <reason>           <reasonTypeEnum>ERROR</reasonTypeEnum>           <reasonCode>1</reasonCode>           <description>The execution of the event BT142717 Test RDC job/PROCESS_ENGINE failed. One or more events failed</description>         </reason>       </eventDetails>     </taskUnit>     <taskUnit>       <status>FAILED</status>       <severityCode>1</severityCode>       <eventDetails>         <eventName>TST 142717 Security DS</eventName>         <eagleInstanceId>10208329</eagleInstanceId>         <reason>           <reasonTypeEnum>ERROR</reasonTypeEnum>           <reasonCode>1</reasonCode>           <description>The execution of the event TST 142717 Security DS(SD Instance - 10208329) failed. </description>         </reason>       </eventDetails>     </taskUnit>     <taskUnit>       <status>FAILED</status>       <severityCode>1</severityCode>       <eventDetails>         <eventName>Data Strategy: [800][TST_DS_01][BT142717 TST Currency (FX) Swap]. Gold Copy: [32][DEFAULT][Default]. Effective Date: [09-Jan-2017]</eventName>         <eagleInstanceId>10208331</eagleInstanceId>         <reason>           <reasonTypeEnum>ERROR</reasonTypeEnum>           <reasonCode>1</reasonCode>           <description>The execution of the event Data Strategy: [800][TST_DS_01][BT142717 TST Currency (FX) Swap]. Gold Copy: [32][DEFAULT][Default]. Effective Date: [09-Jan-2017](SD Instance - 10208331) failed. ERROR: Code:[104][EXCEPTION - PACE Exception]. Message: [Process Definition (id:1070) for field: Alt Asset ID Type not found]</description>         </reason>         <eventSecurities>           <summary>             <totalRecords>9</totalRecords>           </summary>           <eventSecurity><securityAlias>681844597</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844598</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844599</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844600</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844601</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844602</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844603</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844604</securityAlias></eventSecurity>           <eventSecurity><securityAlias>681844605</securityAlias></eventSecurity>         </eventSecurities>       </eventDetails>     </taskUnit>   </statusItem> </EagleML>

 

Â