Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this page:

Table of Contents

Add Extract Stats to TSRs for Extracts

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

The following model with additional information can be added to extract TSRs:

Code Block
languagexml
<extractStats>
   <extractFilename>65B4103E3B9CD110__WAREHOUSEPERFORMANCE__1_4_20180425.xml</extractFilename>
   <transactionCount>4</transactionCount>
   <objectCount>4</objectCount>
   <rowCount>4</rowCount>
</extractStats>

by setting IncludeExtractStats task parameter in the control message or W_INCLUDE_EXTRACT_STATS global parameter with the value of Y.

Optimize TSR Detail Information

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.

Valid values are: Y or N.

  • Y (default value) - if the parameter is not set or its value is ‘Y’, Detail information is added to TSR.
  • N - if its value is ‘N’, only Summary information is added.
Expand
titleClick for more details:


Background Color
colorgrey

<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>B80JB533F9JUHFQM</messageId>
<sentBy>http://www.eagleinvsys.com/</sentBy>
<sendTo>http://www.client.com/Eagle Control Messages</sendTo>
<creationTimestamp>2018-09-21T09:53:35-04:00</creationTimestamp>
</header>
<statusItem>
<taskIdentifier>
<correlationId correlationIdScheme="correlationIdScheme">JB532JCPDRAFB006</correlationId>
<businessTaskId correlationIdScheme="businessTaskIdScheme">tvSMFLOAD201809_062#load_generic_smf</businessTaskId>
</taskIdentifier>
<status>FAILED</status>
<severityCode>1</severityCode>
<taskUnit>
<loadDetails>
<URI>file://*JB532JCPDRAFB006**_GENERICSMF_*</URI>
<details>
<file>
<fileName>20180921-095329-JB532JCPDRAFB006_DATA_ESP376_GENERICSMF_001_TVSMFLOAD201809_062_20180921.XML</fileName>
<type>CUSTOM</type>


Background Color

<summary>
<eagleStatId>6643222</eagleStatId>
<failedRecords>1</failedRecords>
<totalRecords>1</totalRecords>
<taskType>Stream</taskType>
<taskName>eagle_ml-2-0_default_in_xml_smf_generic</taskName>
</summary>


Background Color
coloryellow

<record>
<transactionId>B80JB533C8GKYWNY</transactionId>
<eagleDetailId>22692576</eagleDetailId>
<identifier><identifierName>fromId</identifierName><identifierValue>ESP376S1</identifierValue>
</identifier><identifier><identifierName>currency</identifierName><identifierValue>USD</identifierValue>
</identifier><identifier><identifierName>referenceNumber</identifierName><identifierValue>0</identifierValue>
</identifier><identifier><identifierName>identifier1</identifierName><identifierValue>X376S1</identifierValue>
</identifier><identifier><identifierName>identifier2</identifierName><identifierValue>SEDOL</identifierValue>
</identifier><reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-9</reasonCode>
<description>Maturity Date: Maturity Date Cannot Be Less Than Or Equal First Coupon Date</description>
<reasonTag>38</reasonTag>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-7</reasonCode>
<description>Failed to Finalize data conversion</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-9</reasonCode>
<description>The message hasn&apos;t been sent to engine due to errors received from PanelProcessor.</description>
</reason>
<reason>
<reasonTypeEnum>ERROR</reasonTypeEnum>
<reasonCode>-10</reasonCode>
<description>The request was not processed</description>
</reason>
</record>


Background Color
colorgrey

</file>
</details>
</loadDetails>
</taskUnit>
</statusItem>
</EagleML>