In this page:
...
CreateConsolidatedTSR - Enhanced TSR Report
A consolidated TSR actually represents an additional report for your workflow, summing up the TSRs for each of the subprocesses of your workflow. This option can be useful when you want to have several task responses on a single file.
| Excerpt |
|---|
To enable this kind of reply messages, please add the following task parameter to your control message: | Code Block |
|---|
| <taskParameter>
<name>CreateConsolidatedTSR</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter> |
Consolidated TSR has the following structure: 
First of all this report provides some general information adding separate blocks which refer to different files. Each of these blocks starts with load details for the file followed by the description of errors if any occurred. | Expand |
|---|
| title | Example of Consolidated TSR: |
|---|
|
| Code Block |
|---|
| <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>B60G1E45EKTQHRJR</messageId>
<sentBy>http://www.eagleinvsys.com/</sentBy>
<sendTo>www.client.com</sendTo>
<creationTimestamp>2016-06-30T13:04:51-05:00</creationTimestamp>
</header>
<statusItem>
<taskIdentifier>
<correlationId correlationIdScheme="correlationIdScheme">KK_TEST_DATAMART_009</correlationId>
<businessTaskId correlationIdScheme="businessTaskIdScheme">KK_TEST_DATAMART20160617T104117+0300</businessTaskId>
</taskIdentifier>
<status>FAILED</status>
<severityCode>1</severityCode>
<taskUnit>
<loadDetails>
<URI>file://*20160630-053814-_C~B60G0G81EH5RTNOV_C~KK_TEST_DATAMART20160617*.dat</URI>
<details>
<file>
<fileName>20160630-053814-_C~B60G0G81EH5RTNOV_C~KK_TEST_DATAMART20160617.DAT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715319</eagleStatId>
<failedRecords>1</failedRecords>
<totalRecords>1</totalRecords>
</summary>
<record>
<eagleDetailId>41476585</eagleDetailId>
<identifier>
<identifierName>fromId</identifierName>
<identifierValue>Data Mart Report [Performance] [As of 03/01/2016]</identifierValue>
</identifier>
<identifier>
<identifierName>toId</identifierName>
<identifierValue>3</identifierValue>
</identifier>
<identifier>
<identifierName>referenceNumber</identifierName>
<identifierValue>B60G0G81EH5RTNOV</identifierValue>
</identifier>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-21</reasonCode>
<description>No process found with name 'Data Mart Report [Performance] [As of 03/01/2016]' and process type 'PROCESS_ENGINE'</description>
<reasonTag>1</reasonTag>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-10</reasonCode>
<description>The request was not processed. EDITCHECK validation failed.</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-11</reasonCode>
<description>An empty message was generated as a result of translation.</description>
</reason>
</record>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-053815-_C~B60G0G81FI5RCHUN_C~KK_TEST_DATAMART20160617*.dat</URI>
<details>
<file>
<fileName>20160630-053815-_C~B60G0G81FI5RCHUN_C~KK_TEST_DATAMART20160617.DAT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715324</eagleStatId>
<failedRecords>1</failedRecords>
<totalRecords>1</totalRecords>
</summary>
<record>
<eagleDetailId>41476588</eagleDetailId>
<identifier>
<identifierName>fromId</identifierName>
<identifierValue>Default Mart - TEST DKC</identifierValue>
</identifier>
<identifier>
<identifierName>toId</identifierName>
<identifierValue>3</identifierValue>
</identifier>
<identifier>
<identifierName>referenceNumber</identifierName>
<identifierValue>B60G0G81FI5RCHUN</identifierValue>
</identifier>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-21</reasonCode>
<description>No process found with name 'Default Mart - TEST DKC' and process type 'DATAMART_MANAGER'</description>
<reasonTag>1</reasonTag>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-10</reasonCode>
<description>The request was not processed. EDITCHECK validation failed.</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-11</reasonCode>
<description>An empty message was generated as a result of translation.</description>
</reason>
</record>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-053816-_C~B60G0G81FCDFPNTD_C~KK_TEST_DATAMART20160617*.dat</URI>
<details>
<file>
<fileName>20160630-053816-_C~B60G0G81FCDFPNTD_C~KK_TEST_DATAMART20160617.DAT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715327</eagleStatId>
<failedRecords>1</failedRecords>
<totalRecords>1</totalRecords>
</summary>
<record>
<eagleDetailId>41476592</eagleDetailId>
<identifier>
<identifierName>fromId</identifierName>
<identifierValue>Data Quality Daily Checks 113169CP 062513</identifierValue>
</identifier>
<identifier>
<identifierName>toId</identifierName>
<identifierValue>3</identifierValue>
</identifier>
<identifier>
<identifierName>referenceNumber</identifierName>
<identifierValue>B60G0G81FCDFPNTD</identifierValue>
</identifier>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-21</reasonCode>
<description>No process found with name 'Data Quality Daily Checks 113169CP 062513' and process type 'PROCESS_ENGINE'</description>
<reasonTag>1</reasonTag>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-10</reasonCode>
<description>The request was not processed. EDITCHECK validation failed.</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-11</reasonCode>
<description>An empty message was generated as a result of translation.</description>
</reason>
</record>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-053817-_C~B60G0G81GB6EGIET_C~KK_TEST_DATAMART20160617*.dat</URI>
<details>
<file>
<fileName>20160630-053817-_C~B60G0G81GB6EGIET_C~KK_TEST_DATAMART20160617.DAT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715337</eagleStatId>
<failedRecords>1</failedRecords>
<totalRecords>1</totalRecords>
</summary>
<record>
<eagleDetailId>41476604</eagleDetailId>
<identifier>
<identifierName>fromId</identifierName>
<identifierValue>Data Mart Report [Performance] [As of 03/01/2016]</identifierValue>
</identifier>
<identifier>
<identifierName>toId</identifierName>
<identifierValue>3</identifierValue>
</identifier>
<identifier>
<identifierName>referenceNumber</identifierName>
<identifierValue>B60G0G81GB6EGIET</identifierValue>
</identifier>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-21</reasonCode>
<description>No process found with name 'Data Mart Report [Performance] [As of 03/01/2016]' and process type 'PROCESS_ENGINE'</description>
<reasonTag>1</reasonTag>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-10</reasonCode>
<description>The request was not processed. EDITCHECK validation failed.</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-11</reasonCode>
<description>An empty message was generated as a result of translation.</description>
</reason>
</record>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-053817-_C~B60G0G81GG4EGIEM_C~KK_TEST_DATAMART20160617*.dat</URI>
<details>
<file>
<fileName>20160630-053817-_C~B60G0G81GG4EGIEM_C~KK_TEST_DATAMART20160617.DAT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715336</eagleStatId>
<failedRecords>1</failedRecords>
<totalRecords>1</totalRecords>
</summary>
<record>
<eagleDetailId>41476599</eagleDetailId>
<identifier>
<identifierName>fromId</identifierName>
<identifierValue>Default Mart - TEST DKC</identifierValue>
</identifier>
<identifier>
<identifierName>toId</identifierName>
<identifierValue>3</identifierValue>
</identifier>
<identifier>
<identifierName>referenceNumber</identifierName>
<identifierValue>B60G0G81GG4EGIEM</identifierValue>
</identifier>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-21</reasonCode>
<description>No process found with name 'Default Mart - TEST DKC' and process type 'DATAMART_MANAGER'</description>
<reasonTag>1</reasonTag>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-10</reasonCode>
<description>The request was not processed. EDITCHECK validation failed.</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-11</reasonCode>
<description>An empty message was generated as a result of translation.</description>
</reason>
</record>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-053817-_C~B60G0G81GQTKBYMH_C~KK_TEST_DATAMART20160617*.dat</URI>
<details>
<file>
<fileName>20160630-053817-_C~B60G0G81GQTKBYMH_C~KK_TEST_DATAMART20160617.DAT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715338</eagleStatId>
<failedRecords>1</failedRecords>
<totalRecords>1</totalRecords>
</summary>
<record>
<eagleDetailId>41476602</eagleDetailId>
<identifier>
<identifierName>fromId</identifierName>
<identifierValue>Data Quality Daily Checks 113169CP 062513</identifierValue>
</identifier>
<identifier>
<identifierName>toId</identifierName>
<identifierValue>3</identifierValue>
</identifier>
<identifier>
<identifierName>referenceNumber</identifierName>
<identifierValue>B60G0G81GQTKBYMH</identifierValue>
</identifier>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-21</reasonCode>
<description>No process found with name 'Data Quality Daily Checks 113169CP 062513' and process type 'PROCESS_ENGINE'</description>
<reasonTag>1</reasonTag>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-10</reasonCode>
<description>The request was not processed. EDITCHECK validation failed.</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-11</reasonCode>
<description>An empty message was generated as a result of translation.</description>
</reason>
</record>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-054237-GO1NL0LEOA3IIAA2-u-DIMATEST-u-reporter_trigger2*.txt</URI>
<details>
<file>
<fileName>20160630-054237-GO1NL0LEOA3IIAA2-U-DIMATEST-U-REPORTER_TRIGGER2.TXT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715361</eagleStatId>
<failedRecords>0</failedRecords>
<totalRecords>1</totalRecords>
</summary>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-054423-IL1HBMMAO1UGB00T-u-DIMATEST-u-reporter_trigger2*.txt</URI>
<details>
<file>
<fileName>20160630-054423-IL1HBMMAO1UGB00T-U-DIMATEST-U-REPORTER_TRIGGER2.TXT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715365</eagleStatId>
<failedRecords>0</failedRecords>
<totalRecords>1</totalRecords>
</summary>
</file>
</details>
</loadDetails>
</taskUnit>
<taskUnit>
<loadDetails>
<URI>file://*20160630-054738-REJNAEK310Q58OH2-u-DIMATEST-u-reporter_trigger2*.txt</URI>
<details>
<file>
<fileName>20160630-054738-REJNAEK310Q58OH2-U-DIMATEST-U-REPORTER_TRIGGER2.TXT</fileName>
<type>CUSTOM</type>
<summary>
<eagleStatId>3715368</eagleStatId>
<failedRecords>0</failedRecords>
<totalRecords>1</totalRecords>
</summary>
</file>
</details>
</loadDetails>
</taskUnit>
</statusItem>
</EagleML> |
|
|
| Info |
|---|
Please note, that this feature is supported for a limited number of interfaces: Schedule, GenericSMF, WarehouseCashActivity, WarehouseCashFlowProjection, WarehouseCloseLot, CustodyRestrictionActivity, CustodyRestrictionBalance, WarehouseDisclosureStatus, WarehouseGLBalances, WarehouseNAVMonthEnd, WarehouseNAVMulti, WarehouseNAV, WarehouseOpenLot, WarehousePendingTrade, WarehousePerformance, WarehousePosition, WarehouseTrade, WarehouseWashSaleTrade |
...
by setting IncludeExtractStats task parameter in the control message or W_INCLUDE_EXTRACT_STATS global parameter with the value of Y.
Sometimes you want to make TSR information more compact and return only the "summary". In this case you should use IncludeRecordErrorDetails parameter in the control message. It also improves execution time of queries.
...