- Created by Natalie Gesin, last modified by Dmitry Donosiyan on Mar 22, 2018
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 8 Next »
Overview
Sometimes when you load a Warehouse object, its securities are missing in the database and you get errors when trying to load them. If such errors occur when you load a Warehouse object in Batch mode, there are two modes to display them:
- Default mode: only the first error is reported in the Task Status Response (TSR).
- Batch Error mode: all errors are reported in the TSR. To enable this mode add the following line to w_config_custom.inc:
<CODE> :EAGLEML_WAREHOUSE_BATCH_ERROR_MODE::='Y'; </CODE>
For better performance, this logic is triggered only if the stored procedure returned an error. Batch Error mode makes the Security Resolution check and then creates a list of missing securities from their sec_alias values.
Name the file as BM_WAREHOUSE_DATA.xml to use with the control message below
<EagleML xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" eaglemlVersion="2-0" eaglemlType="WarehouseTransactionMessage" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xsi:type="WarehouseTransactionMessage"> <warehouseTransaction> <header> <batchKey>entity^20140130^EAGLE PACE</batchKey> <objectType>WarehouseOpenLot</objectType> </header> <warehouseOpenLot> <objectType>WarehouseOpenLot</objectType> <objectId>WarehouseOpenLot</objectId> <sourceName>EAGLE PACE</sourceName> <updateSource>MCADMIN</updateSource> <linkEventId>TSR80A</linkEventId> <localCurrency>USD</localCurrency> <effectiveDate>2014-01-30</effectiveDate> <longShortIndicator>L</longShortIndicator> <xrefAccountId>A1Q2W3R4U5K</xrefAccountId> <xrefAccountIdType>A1Q</xrefAccountIdType> <xrefClassCode>TF4</xrefClassCode> <accountingBasis>GAAP</accountingBasis> <procedureFlag>PD</procedureFlag> <primaryAssetId>CUSIP_DKTEST2MA</primaryAssetId> <primaryAssetType>CUSIP</primaryAssetType> <cusip>CUSIP_DKTEST2MA</cusip> <isin>ISIN_DKTEST2MA</isin> <sedol>SEDOL_DKTEST2MA</sedol> <sicovmId>SICOVM_DKTEST2MA</sicovmId> <xrefIdentifiers> <xId1> <xId>TSTID1_DKTEST2MA</xId> <xIdType>TESTID1</xIdType> </xId1> <xId2> <xId>TSTID2_DKTEST2MA</xId> <xIdType>TESTID2</xIdType> </xId2> </xrefIdentifiers> <assetResolutionOption>MATCH_ALL</assetResolutionOption> <battingOrder>cusip,xId1,isin,xId2,sicovmId,sedol</battingOrder> <baseCurrency>USD</baseCurrency> <transactionType>SHORTSELL</transactionType> <urglSecurityBase>675.262</urglSecurityBase> <urglCurrencyBase>255.037</urglCurrencyBase> <closeOpenEventId>TSTR825</closeOpenEventId> <closeEventId>TSR80A</closeEventId> <updateDate>2014-12-12</updateDate> <closeIndexWeight>897.549</closeIndexWeight> <closeTipsIncomeLtdLocal>355.196</closeTipsIncomeLtdLocal> <closeTipsIncomeLtdBase>964.483</closeTipsIncomeLtdBase> <marketValueLocal>226.887</marketValueLocal> <marketValueBase>983.955</marketValueBase> <marketValueIncomeLocal>297.519</marketValueIncomeLocal> <notionalMarketValueBase>963.515</notionalMarketValueBase> <notionalUnrealizedGlBase>653.28</notionalUnrealizedGlBase> <notionalCostLocal>706.742</notionalCostLocal> <notionalCostBase>302.738</notionalCostBase> <notionalMarketValueLocal>446.019</notionalMarketValueLocal> <notionalUnrealizedGlLocal>416.695</notionalUnrealizedGlLocal> <notionalUnrealizedCurrGl>653.167</notionalUnrealizedCurrGl> <notionalUnrealizedSecGl>271.51</notionalUnrealizedSecGl> <sourceLongShortInd>S</sourceLongShortInd> <settledQuantity>274.783</settledQuantity> <settleLocation>SETTLE_LOC</settleLocation> <accountingDate>2014-11-28</accountingDate> <amortizedLtdBase>873.405</amortizedLtdBase> <amortizedLtdLocal>374.578</amortizedLtdLocal> <amortizedPtdBase>811.57</amortizedPtdBase> <amortizedPtdLocal>690.483</amortizedPtdLocal> <closeAmortizedLocal>503.856</closeAmortizedLocal> <closeAmortizedBase>942.918</closeAmortizedBase> <amortizedCostBase>631.732</amortizedCostBase> <accruedInterestType>CUM</accruedInterestType> <accruedLtdBase>114.949</accruedLtdBase> <accruedLtdLocal>306.995</accruedLtdLocal> <accruedIncomeLocal>570.705</accruedIncomeLocal> <accruedIncome>318.626</accruedIncome> <acquisitionCode>ACQ_CODE</acquisitionCode> <currBuiltInGlSecurity>552.51</currBuiltInGlSecurity> <currBuiltInGlCurrency>386.413</currBuiltInGlCurrency> <currBuiltInGlDeferred>652.659</currBuiltInGlDeferred> <currBuiltInGlOid>450.061</currBuiltInGlOid> <currBuiltInGlMktDisc>555.575</currBuiltInGlMktDisc> <currFxRate>531.109</currFxRate> <departmentAcquisitionDate>2014-11-28</departmentAcquisitionDate> <expenses>490.914</expenses> <exchangeRate>539.532</exchangeRate> <executionBroker>Test_D</executionBroker> <federalTaxCostUnknown>F_T_C_UN</federalTaxCostUnknown> <gaapPremDisInd>G_P_D_IN</gaapPremDisInd> <gaapSettle>2014-11-28</gaapSettle> <gaapTrade>2014-11-28</gaapTrade> <gaapTradeDate>2014-11-28</gaapTradeDate> <idCost>642.594</idCost> <incomeDue>454.43</incomeDue> <intPurchased>192.813</intPurchased> <lastUpdateSrcDate>2014-11-28</lastUpdateSrcDate> <leg1NxtPmtAmt>349.337</leg1NxtPmtAmt> <leg1NxtPmtDate>2014-11-28</leg1NxtPmtDate> <leg2NxtPmtAmt>657.169</leg2NxtPmtAmt> <leg2NxtPmtDate>2014-11-28</leg2NxtPmtDate> <lastSaleSettle>2014-11-28</lastSaleSettle> <locationCode>Test_E</locationCode> <lastSaleTrade>2014-11-28</lastSaleTrade> <managedFl>MANA_FL</managedFl> <marketValueIncome>452.798</marketValueIncome> <netcashflwsNxtPmt>2014-11-28</netcashflwsNxtPmt> <netcashflwsNxtPmtDate>2014-11-28</netcashflwsNxtPmtDate> <otherCharges>666.033</otherCharges> <originalAcquisitionCostBase>224.303</originalAcquisitionCostBase> <originalAcquisitionCostLocal>624.308</originalAcquisitionCostLocal> <originalBuiltInGlMktDisc>832.129</originalBuiltInGlMktDisc> <originalBuiltInGlCurrency>313.052</originalBuiltInGlCurrency> <originalBuiltInGlDeferred>497.714</originalBuiltInGlDeferred> <originalBuiltInGlOid>206.708</originalBuiltInGlOid> <originalBuiltInGlSecurity>938.588</originalBuiltInGlSecurity> <originalTradePrice>188.198</originalTradePrice> <originalSourceCode>Test_F</originalSourceCode> <originalAcquisitionDate>2014-11-28</originalAcquisitionDate> <originalFace>524.53</originalFace> <origLotNumber>Test_G</origLotNumber> <origOpenSettleDate>2014-11-28</origOpenSettleDate> <origEventId>TSR821</origEventId> <performanceFlow>111.222</performanceFlow> <performancePrice>840.198</performancePrice> <performanceFlag>PF</performanceFlag> <price>896.457</price> <smInactiveFlag>N</smInactiveFlag> <purchaseQuantity>840.892</purchaseQuantity> <purYld>324.871</purYld> <pledgeFlag>PLE_FLAG</pledgeFlag> <prYrAccrIncome>129.05</prYrAccrIncome> <purchAccruedInterestAmt>307.37</purchAccruedInterestAmt> <reason>SPLIT</reason> <recParOrShares>681.709</recParOrShares> <registrationCode>BMCD</registrationCode> <reinvestCode>BVCFDS</reinvestCode> <restrictionCode>GFRDE</restrictionCode> <statPremDiscInd>S_P_D_IN</statPremDiscInd> <statSettle>2014-11-28</statSettle> <statTrade>2014-11-28</statTrade> <stateAcquisitionDate>2014-11-28</stateAcquisitionDate> <taxAcquisitionDate>2014-11-28</taxAcquisitionDate> <taxPremDiscInd>Test_H</taxPremDiscInd> <taxSettle>2014-11-28</taxSettle> <taxStatus>Test_I</taxStatus> <taxTrade>2014-11-28</taxTrade> <termIndicator>657.431</termIndicator> <intReceived>166.86</intReceived> <income>126.785</income> <votingAuthorityCode>VOAUC</votingAuthorityCode> <clientId>TSTR825</clientId> <covFlag>N</covFlag> <eventSubPriority>416743</eventSubPriority> <factor>613.171</factor> <ioIssuerAlias>Test_K</ioIssuerAlias> <ioIssuerId>TSTR210A</ioIssuerId> <origAcctDate>2014-11-28</origAcctDate> <origMonthlyAcctDate>2014-11-28</origMonthlyAcctDate> <parOrShares>965.969</parOrShares> <pendingTradeId>504244</pendingTradeId> <qtyWashSaleEligible>330.847</qtyWashSaleEligible> <strategy>Test_L</strategy> <tradeYield>239.2</tradeYield> <washSaleEligibleInd>N</washSaleEligibleInd> <aiaNetB>351.522</aiaNetB> <aiaNetL>177.79</aiaNetL> <buySellFlag>BUY</buySellFlag> <bookValue>15</bookValue> <bookValueLocal>776.052</bookValueLocal> <cpNetB>959.298</cpNetB> <cpNetL>538.021</cpNetL> <creditLossB>530.218</creditLossB> <creditLossL>769.722</creditLossL> <costBasisType>F</costBasisType> <futureFeeNetB>755.089</futureFeeNetB> <futureFeeNetL>798.772</futureFeeNetL> <impairmentLtdBase>414.216</impairmentLtdBase> <impairmentLtdLocal>280.34</impairmentLtdLocal> <mbaNetB>394.449</mbaNetB> <mbaNetL>971.647</mbaNetL> <naiaNetB>347.2</naiaNetB> <naiaNetL>421.234</naiaNetL> <nonCreditLossB>933.96</nonCreditLossB> <nonCreditLossL>767.559</nonCreditLossL> <adjustedShares>990.614</adjustedShares> <baseGaapMarketValue>350.704</baseGaapMarketValue> <baseStatMarketValue>294.697</baseStatMarketValue> <cashEquivalents>823.299</cashEquivalents> <cirBrkFees>152.549</cirBrkFees> <closeOidIncome>174.634</closeOidIncome> <closeOidIncomeLocal>322.017</closeOidIncomeLocal> <closeTipsIncomeLocal>978.696</closeTipsIncomeLocal> <closeTipsIncome>578.878</closeTipsIncome> <deferredIncomeTotalPtdB>466.831</deferredIncomeTotalPtdB> <deferredIncomeTotalPtdL>217.897</deferredIncomeTotalPtdL> <deltaAdjQty>394.804</deltaAdjQty> <dlta>632.319</dlta> <expoPrice>295.687</expoPrice> <earnThruDate>2014-11-28</earnThruDate> <execBrkFees>298.928</execBrkFees> <fedTaxCostValue>322.338</fedTaxCostValue> <gaapUnitBookValue>168.952</gaapUnitBookValue> <gaapUnitCost>650.915</gaapUnitCost> <gaapBookValue>752.556</gaapBookValue> <gaapCostValue>838.674</gaapCostValue> <hedgedCusip>Test_M</hedgedCusip> <hedgeTrading>Test_N</hedgeTrading> <interestEarned>757.761</interestEarned> <lastSettlementDate>2014-11-28</lastSettlementDate> <localGaapCostValue>421.612</localGaapCostValue> <localGaapUnitCost>551.414</localGaapUnitCost> <localGaapBookValue>171.979</localGaapBookValue> <localGaapUnitBookValue>601.952</localGaapUnitBookValue> <localGaapMarketValue>845.863</localGaapMarketValue> <localTaxUnitBookValue>957.592</localTaxUnitBookValue> <localStatUnitCost>763.119</localStatUnitCost> <localStatBookValue>181.064</localStatBookValue> <localStatCostValue>891.553</localStatCostValue> <localStatMarketValue>530.679</localStatMarketValue> <localStatUnitBookValue>985.645</localStatUnitBookValue> <localTaxBookValue>156.224</localTaxBookValue> <localTaxCostValue>725.376</localTaxCostValue> <localTaxUnitCost>808.945</localTaxUnitCost> <nonCreditLossAmortLtdB>208.773</nonCreditLossAmortLtdB> <nonCreditLossAmortLtdL>800.01</nonCreditLossAmortLtdL> <oidPtdBase>944.928</oidPtdBase> <oidPtdLocal>187.47</oidPtdLocal> <oidLtdIncomeLocal>292.856</oidLtdIncomeLocal> <oidLtdIncomeBase>411.76</oidLtdIncomeBase> <openMktPrice>219.334</openMktPrice> <origAccrPtdBase>587.66</origAccrPtdBase> <origSoldInterestBase>944.079</origSoldInterestBase> <origTradedInterestBase>415.021</origTradedInterestBase> <originalCostAmount>786.588</originalCostAmount> <payEpAccrued>180.385</payEpAccrued> <payRecInd>R</payRecInd> <posnFullyEarned>D</posnFullyEarned> <purchasePrincipalBase>832.941</purchasePrincipalBase> <purchasePrincipalLocal>236.615</purchasePrincipalLocal> <pv01total>923.197</pv01total> <preTaxAdjYld>168.521</preTaxAdjYld> <recEpAccrued>601.995</recEpAccrued> <statCostValue>995.176</statCostValue> <soldInterestBase>670.473</soldInterestBase> <scrubFlag>SF</scrubFlag> <sourceInternalAssetId>TS21A</sourceInternalAssetId> <statBookValue>433.593</statBookValue> <statUnitBookValue>528.924</statUnitBookValue> <soldInterestLocal>672.256</soldInterestLocal> <statUnitCost>778.238</statUnitCost> <stateCostValue>514.57</stateCostValue> <swapAccrMethod>I</swapAccrMethod> <totalUnrealizedGainLossLocal>503.616</totalUnrealizedGainLossLocal> <totalUnrealizedGainLossBase>237.482</totalUnrealizedGainLossBase> <tipsPtdBase>751.22</tipsPtdBase> <tipsPtdLocal>217.593</tipsPtdLocal> <taxBookValue>182.411</taxBookValue> <taxCostValue>752.657</taxCostValue> <taxUnitBookValue>410.449</taxUnitBookValue> <taxUnitCost>494.172</taxUnitCost> <tradeFxRate>871.991</tradeFxRate> <undPrice>898.109</undPrice> <uniqueAssetFlag>UN_A_FLA</uniqueAssetFlag> <bankAlias>200979</bankAlias> <batchEventId>TSTR821A</batchEventId> <brokerCode>EAGLE</brokerCode> <clearingBrokerCode>EAGLE</clearingBrokerCode> <commissionAmount>179.512</commissionAmount> <lotNumber>Num1</lotNumber> <masterTicketNumber>Test_P</masterTicketNumber> <monthEndAccountingDate>2014-11-28</monthEndAccountingDate> <secFee>549.501</secFee> <settlementDate>2014-11-28</settlementDate> <tradeDate>2014-11-28</tradeDate> <transactionCode>REC</transactionCode> <userChar1>USER1</userChar1> <userChar2>USER2</userChar2> <userChar3>USER3</userChar3> <userDefinedFloat1>248.033</userDefinedFloat1> <userDefinedFloat2>151.497</userDefinedFloat2> <userDefinedFloat3>510.408</userDefinedFloat3> <pclUserDate1>2014-11-28</pclUserDate1> <pclUserDate2>2014-11-28</pclUserDate2> <pclUserDate3>2014-11-28</pclUserDate3> <userGroup1>USER_GR1</userGroup1> <userGroup2>USER_GR2</userGroup2> <userGroup3>USER_GR3</userGroup3> <userGroup4>USER_GR4</userGroup4> <userGroup5>USER_GR5</userGroup5> <userGroup6>USER_GR6</userGroup6> <userGroup7>USER_GR7</userGroup7> <userGroup8>USER_GR8</userGroup8> <userGroup9>USER_GR9</userGroup9> <userGroup10>USER_GR10</userGroup10> <userGroup11>USER_GR11</userGroup11> <userGroup12>USER_GR12</userGroup12> <userGroup13>USER_GR13</userGroup13> <userGroup14>USER_GR14</userGroup14> <userGroup15>USER_GR15</userGroup15> <userGroup16>USER_GR16</userGroup16> <userGroup17>USER_GR17</userGroup17> <userGroup18>USER_GR18</userGroup18> </warehouseOpenLot> <warehouseOpenLot> <objectType>WarehouseOpenLot</objectType> <objectId>WarehouseOpenLot</objectId> <objectDescription>WAREHOUSE</objectDescription> <sourceName>EAGLE PACE</sourceName> <updateSource>MCADMIN</updateSource> <linkEventId>TSR80A</linkEventId> <localCurrency>USD</localCurrency> <effectiveDate>2014-01-30</effectiveDate> <longShortIndicator>L</longShortIndicator> <xrefAccountId>A1Q2W3R4U5K</xrefAccountId> <xrefAccountIdType>A1Q</xrefAccountIdType> <xrefClassCode>TF4</xrefClassCode> <accountingBasis>GAAP</accountingBasis> <procedureFlag>PD</procedureFlag> <primaryAssetId>CUSIP_DKTEST3MA_FLD2</primaryAssetId> <primaryAssetType>CUSIP</primaryAssetType> <assetResolutionOption>MATCH_ALL</assetResolutionOption> <battingOrder>cusip,xId1,isin,xId2,sicovmId,sedol</battingOrder> <baseCurrency>USD</baseCurrency> <transactionType>SHORTSELL</transactionType> <urglSecurityBase>6</urglSecurityBase> <urglCurrencyBase>257</urglCurrencyBase> <closeOpenEventId>TSTR825</closeOpenEventId> <closeEventId>TSR80A</closeEventId> <updateDate>2014-12-12</updateDate> <closeIndexWeight>297.519</closeIndexWeight> <closeTipsIncomeLtdLocal>963.515</closeTipsIncomeLtdLocal> <closeTipsIncomeLtdBase>653.28</closeTipsIncomeLtdBase> <marketValueLocal>706.742</marketValueLocal> <marketValueBase>302.738</marketValueBase> <marketValueIncomeLocal>446.019</marketValueIncomeLocal> <notionalMarketValueBase>416.695</notionalMarketValueBase> <notionalUnrealizedGlBase>653.167</notionalUnrealizedGlBase> <notionalCostLocal>271.51</notionalCostLocal> <notionalCostBase>352.13</notionalCostBase> <notionalMarketValueLocal>274.783</notionalMarketValueLocal> <notionalUnrealizedGlLocal>873.405</notionalUnrealizedGlLocal> <notionalUnrealizedCurrGl>374.578</notionalUnrealizedCurrGl> <notionalUnrealizedSecGl>811.57</notionalUnrealizedSecGl> <sourceLongShortInd>S</sourceLongShortInd> <settledQuantity>2.3</settledQuantity> <settleLocation>SETTLE_LOC</settleLocation> <accountingDate>2014-11-29</accountingDate> <amortizedLtdBase>942.918</amortizedLtdBase> <amortizedLtdLocal>631.732</amortizedLtdLocal> <amortizedPtdBase>415.668</amortizedPtdBase> <amortizedPtdLocal>114.949</amortizedPtdLocal> <closeAmortizedLocal>306.995</closeAmortizedLocal> <closeAmortizedBase>570.705</closeAmortizedBase> <amortizedCostBase>318.626</amortizedCostBase> <accruedInterestType>CUM</accruedInterestType> <accruedLtdBase>386.413</accruedLtdBase> <accruedLtdLocal>652.659</accruedLtdLocal> <accruedIncomeLocal>450.061</accruedIncomeLocal> <accruedIncome>555.575</accruedIncome> <acquisitionCode>ACQ_CODE</acquisitionCode> <currBuiltInGlSecurity>552.51</currBuiltInGlSecurity> <currBuiltInGlCurrency>386.413</currBuiltInGlCurrency> <currBuiltInGlDeferred>652.659</currBuiltInGlDeferred> <currBuiltInGlOid>450.061</currBuiltInGlOid> <currBuiltInGlMktDisc>555.575</currBuiltInGlMktDisc> <currFxRate>531.109</currFxRate> <departmentAcquisitionDate>2014-11-28</departmentAcquisitionDate> <expenses>490.914</expenses> <exchangeRate>539.532</exchangeRate> <executionBroker>Test_D</executionBroker> <federalTaxCostUnknown>F_T_C_UN</federalTaxCostUnknown> <gaapPremDisInd>G_P_D_IN</gaapPremDisInd> <gaapSettle>2014-11-28</gaapSettle> <gaapTrade>2014-11-28</gaapTrade> <gaapTradeDate>2014-11-28</gaapTradeDate> <idCost>642.594</idCost> <incomeDue>454.43</incomeDue> <intPurchased>192.813</intPurchased> <lastUpdateSrcDate>2014-11-28</lastUpdateSrcDate> <leg1NxtPmtAmt>349.337</leg1NxtPmtAmt> <leg1NxtPmtDate>2014-11-28</leg1NxtPmtDate> <leg2NxtPmtAmt>657.169</leg2NxtPmtAmt> <leg2NxtPmtDate>2014-11-28</leg2NxtPmtDate> <lastSaleSettle>2014-11-28</lastSaleSettle> <locationCode>Test_E</locationCode> <lastSaleTrade>2014-11-28</lastSaleTrade> <managedFl>MANA_FL</managedFl> <marketValueIncome>452.798</marketValueIncome> <netcashflwsNxtPmt>2014-11-28</netcashflwsNxtPmt> <netcashflwsNxtPmtDate>2014-11-28</netcashflwsNxtPmtDate> <otherCharges>666.033</otherCharges> <originalAcquisitionCostBase>24.303</originalAcquisitionCostBase> <originalAcquisitionCostLocal>24.308</originalAcquisitionCostLocal> <originalBuiltInGlMktDisc>32.129</originalBuiltInGlMktDisc> <originalBuiltInGlCurrency>13.052</originalBuiltInGlCurrency> <originalBuiltInGlDeferred>97.714</originalBuiltInGlDeferred> <originalBuiltInGlOid>26.708</originalBuiltInGlOid> <originalBuiltInGlSecurity>98.588</originalBuiltInGlSecurity> <originalTradePrice>18.198</originalTradePrice> <originalSourceCode>Test_F</originalSourceCode> <originalAcquisitionDate>2014-11-28</originalAcquisitionDate> <originalFace>24.53</originalFace> <origLotNumber>Test_G</origLotNumber> <origOpenSettleDate>2014-11-28</origOpenSettleDate> <origEventId>TSR821</origEventId> <performanceFlow>11.222</performanceFlow> <performancePrice>40.198</performancePrice> <performanceFlag>PF</performanceFlag> <price>96.457</price> <smInactiveFlag>N</smInactiveFlag> <purchaseQuantity>40.892</purchaseQuantity> <purYld>24.871</purYld> <pledgeFlag>PLE_FLAG</pledgeFlag> <prYrAccrIncome>29.05</prYrAccrIncome> <purchAccruedInterestAmt>07.37</purchAccruedInterestAmt> <reason>SPLIT</reason> <recParOrShares>81.709</recParOrShares> <registrationCode>BMCD</registrationCode> <reinvestCode>BVCFDS</reinvestCode> <restrictionCode>GFRDE</restrictionCode> <statPremDiscInd>S_P_D_IN</statPremDiscInd> <statSettle>2014-11-29</statSettle> <statTrade>2014-11-29</statTrade> <stateAcquisitionDate>2014-11-29</stateAcquisitionDate> <taxAcquisitionDate>2014-11-29</taxAcquisitionDate> <taxPremDiscInd>Test_H</taxPremDiscInd> <taxSettle>2014-11-28</taxSettle> <taxStatus>Test_I</taxStatus> <taxTrade>2014-11-29</taxTrade> <termIndicator>57.431</termIndicator> <intReceived>66.86</intReceived> <income>26.785</income> <votingAuthorityCode>VOAUC</votingAuthorityCode> <clientId>TSTR825</clientId> <covFlag>N</covFlag> <eventSubPriority>42</eventSubPriority> <factor>13.171</factor> <ioIssuerAlias>Test_K</ioIssuerAlias> <ioIssuerId>TSTR210A</ioIssuerId> <origAcctDate>2014-11-28</origAcctDate> <origMonthlyAcctDate>2014-11-28</origMonthlyAcctDate> <parOrShares>65.969</parOrShares> <pendingTradeId>504244</pendingTradeId> <qtyWashSaleEligible>30.847</qtyWashSaleEligible> <strategy>Test_L</strategy> <tradeYield>39.2</tradeYield> <washSaleEligibleInd>N</washSaleEligibleInd> <aiaNetB>51.522</aiaNetB> <aiaNetL>77.79</aiaNetL> <buySellFlag>BUY</buySellFlag> <bookValue>15</bookValue> <bookValueLocal>292.88</bookValueLocal> <cpNetB>755.089</cpNetB> <cpNetL>798.772</cpNetL> <creditLossB>414.216</creditLossB> <creditLossL>280.34</creditLossL> <costBasisType>C</costBasisType> <futureFeeNetB>971.647</futureFeeNetB> <futureFeeNetL>347.2</futureFeeNetL> <impairmentLtdBase>421.234</impairmentLtdBase> <impairmentLtdLocal>933.96</impairmentLtdLocal> <mbaNetB>767.559</mbaNetB> <mbaNetL>990.614</mbaNetL> <naiaNetB>350.704</naiaNetB> <naiaNetL>294.697</naiaNetL> <nonCreditLossB>823.299</nonCreditLossB> <nonCreditLossL>152.549</nonCreditLossL> <adjustedShares>174.634</adjustedShares> <baseGaapMarketValue>322.017</baseGaapMarketValue> <baseStatMarketValue>978.696</baseStatMarketValue> <cashEquivalents>578.878</cashEquivalents> <cirBrkFees>466.831</cirBrkFees> <closeOidIncome>217.897</closeOidIncome> <closeOidIncomeLocal>394.804</closeOidIncomeLocal> <closeTipsIncomeLocal>632.319</closeTipsIncomeLocal> <closeTipsIncome>295.687</closeTipsIncome> <deferredIncomeTotalPtdB>298.928</deferredIncomeTotalPtdB> <deferredIncomeTotalPtdL>322.338</deferredIncomeTotalPtdL> <deltaAdjQty>168.952</deltaAdjQty> <dlta>650.915</dlta> <expoPrice>752.556</expoPrice> <earnThruDate>2015-01-26</earnThruDate> <execBrkFees>838.674</execBrkFees> <fedTaxCostValue>757.761</fedTaxCostValue> <gaapUnitBookValue>421.612</gaapUnitBookValue> <gaapUnitCost>551.414</gaapUnitCost> <gaapBookValue>171.979</gaapBookValue> <gaapCostValue>601.952</gaapCostValue> <hedgedCusip>Test_M</hedgedCusip> <hedgeTrading>Test_N</hedgeTrading> <interestEarned>57.761</interestEarned> <lastSettlementDate>2014-11-29</lastSettlementDate> <localGaapCostValue>957.592</localGaapCostValue> <localGaapUnitCost>763.119</localGaapUnitCost> <localGaapBookValue>181.064</localGaapBookValue> <localGaapUnitBookValue>891.553</localGaapUnitBookValue> <localGaapMarketValue>530.679</localGaapMarketValue> <localTaxUnitBookValue>985.645</localTaxUnitBookValue> <localStatUnitCost>156.224</localStatUnitCost> <localStatBookValue>725.376</localStatBookValue> <localStatCostValue>808.945</localStatCostValue> <localStatMarketValue>208.773</localStatMarketValue> <localStatUnitBookValue>800.01</localStatUnitBookValue> <localTaxBookValue>944.928</localTaxBookValue> <localTaxCostValue>187.47</localTaxCostValue> <localTaxUnitCost>292.856</localTaxUnitCost> <nonCreditLossAmortLtdB>411.76</nonCreditLossAmortLtdB> <nonCreditLossAmortLtdL>219.334</nonCreditLossAmortLtdL> <oidPtdBase>587.66</oidPtdBase> <oidPtdLocal>944.079</oidPtdLocal> <oidLtdIncomeLocal>415.021</oidLtdIncomeLocal> <oidLtdIncomeBase>786.588</oidLtdIncomeBase> <openMktPrice>180.385</openMktPrice> <origAccrPtdBase>397.94</origAccrPtdBase> <origSoldInterestBase>351.47</origSoldInterestBase> <origTradedInterestBase>832.941</origTradedInterestBase> <originalCostAmount>236.615</originalCostAmount> <payEpAccrued>923.197</payEpAccrued> <payRecInd>R</payRecInd> <posnFullyEarned>D</posnFullyEarned> <purchasePrincipalBase>32.941</purchasePrincipalBase> <purchasePrincipalLocal>36.615</purchasePrincipalLocal> <pv01total>23.197</pv01total> <preTaxAdjYld>68.521</preTaxAdjYld> <recEpAccrued>01.995</recEpAccrued> <statCostValue>95.176</statCostValue> <soldInterestBase>70.473</soldInterestBase> <scrubFlag>SF</scrubFlag> <sourceInternalAssetId>TS21A</sourceInternalAssetId> <statBookValue>33.593</statBookValue> <statUnitBookValue>28.924</statUnitBookValue> <soldInterestLocal>72.256</soldInterestLocal> <statUnitCost>78.238</statUnitCost> <stateCostValue>14.57</stateCostValue> <swapAccrMethod>I</swapAccrMethod> <totalUnrealizedGainLossLocal>3.616</totalUnrealizedGainLossLocal> <totalUnrealizedGainLossBase>37.482</totalUnrealizedGainLossBase> <tipsPtdBase>51.22</tipsPtdBase> <tipsPtdLocal>17.593</tipsPtdLocal> <taxBookValue>82.411</taxBookValue> <taxCostValue>52.657</taxCostValue> <taxUnitBookValue>10.449</taxUnitBookValue> <taxUnitCost>94.172</taxUnitCost> <tradeFxRate>71.991</tradeFxRate> <undPrice>98.109</undPrice> <uniqueAssetFlag>UN_A_FLA</uniqueAssetFlag> <bankAlias>256</bankAlias> <batchEventId>TSTR821A</batchEventId> <brokerCode>EAGLE</brokerCode> <clearingBrokerCode>EAGLE</clearingBrokerCode> <commissionAmount>79.512</commissionAmount> <lotNumber>Num2</lotNumber> <masterTicketNumber>Test_P</masterTicketNumber> <monthEndAccountingDate>2014-11-29</monthEndAccountingDate> <secFee>49.501</secFee> <settlementDate>2014-11-29</settlementDate> <tradeDate>2014-11-29</tradeDate> <transactionCode>REC</transactionCode> <userChar1>USER1</userChar1> <userChar2>USER2</userChar2> <userChar3>USER3</userChar3> <userDefinedFloat1>48.033</userDefinedFloat1> <userDefinedFloat2>51.497</userDefinedFloat2> <userDefinedFloat3>10.408</userDefinedFloat3> <pclUserDate1>2014-11-29</pclUserDate1> <pclUserDate2>2014-11-29</pclUserDate2> <pclUserDate3>2014-11-29</pclUserDate3> <userGroup1>USER_GR1</userGroup1> <userGroup2>USER_GR2</userGroup2> <userGroup3>USER_GR3</userGroup3> <userGroup4>USER_GR4</userGroup4> <userGroup5>USER_GR5</userGroup5> <userGroup6>USER_GR6</userGroup6> <userGroup7>USER_GR7</userGroup7> <userGroup8>USER_GR8</userGroup8> <userGroup9>USER_GR9</userGroup9> <userGroup10>USER_GR10</userGroup10> <userGroup11>USER_GR11</userGroup11> <userGroup12>USER_GR12</userGroup12> <userGroup13>USER_GR13</userGroup13> <userGroup14>USER_GR14</userGroup14> <userGroup15>USER_GR15</userGroup15> <userGroup16>USER_GR16</userGroup16> <userGroup17>USER_GR17</userGroup17> <userGroup18>USER_GR18</userGroup18> </warehouseOpenLot> <warehouseOpenLot> <objectType>WarehouseOpenLot</objectType> <objectId>WarehouseOpenLot</objectId> <objectDescription>WAREHOUSE</objectDescription> <sourceName>EAGLE PACE</sourceName> <updateSource>MCADMIN</updateSource> <linkEventId>TSR80A</linkEventId> <localCurrency>USD</localCurrency> <effectiveDate>2014-01-30</effectiveDate> <longShortIndicator>L</longShortIndicator> <xrefAccountId>A1Q2W3R4U5K</xrefAccountId> <xrefAccountIdType>A1Q</xrefAccountIdType> <xrefClassCode>TF4</xrefClassCode> <accountingBasis>GAAP</accountingBasis> <procedureFlag>PD</procedureFlag> <primaryAssetId>CUSIP_DKTEST2MA_FLD3</primaryAssetId> <primaryAssetType>CUSIP</primaryAssetType> <assetResolutionOption>MATCH_ALL</assetResolutionOption> <battingOrder>cusip,xId1,isin,xId2,sicovmId,sedol</battingOrder> <baseCurrency>USD</baseCurrency> <transactionType>SHORTSELL</transactionType> <urglSecurityBase>746.703</urglSecurityBase> <urglCurrencyBase>402.423</urglCurrencyBase> <closeOpenEventId>TSTR825</closeOpenEventId> <closeEventId>TSR80A</closeEventId> <updateDate>2014-12-12</updateDate> <closeIndexWeight>814.793</closeIndexWeight> <closeTipsIncomeLtdLocal>419.069</closeTipsIncomeLtdLocal> <closeTipsIncomeLtdBase>922.661</closeTipsIncomeLtdBase> <marketValueLocal>669.323</marketValueLocal> <marketValueBase>595.256</marketValueBase> <marketValueIncomeLocal>425.256</marketValueIncomeLocal> <notionalMarketValueBase>792.738</notionalMarketValueBase> <notionalUnrealizedGlBase>709.952</notionalUnrealizedGlBase> <notionalCostLocal>450.428</notionalCostLocal> <notionalCostBase>911.524</notionalCostBase> <notionalMarketValueLocal>935.433</notionalMarketValueLocal> <notionalUnrealizedGlLocal>707.649</notionalUnrealizedGlLocal> <notionalUnrealizedCurrGl>701.895</notionalUnrealizedCurrGl> <notionalUnrealizedSecGl>208.482</notionalUnrealizedSecGl> <sourceLongShortInd>S</sourceLongShortInd> <settledQuantity>4.3</settledQuantity> <settleLocation>SETTLE_LOC</settleLocation> <accountingDate>2014-11-12</accountingDate> <amortizedLtdBase>315.311</amortizedLtdBase> <amortizedLtdLocal>317.382</amortizedLtdLocal> <amortizedPtdBase>127.283</amortizedPtdBase> <amortizedPtdLocal>911.811</amortizedPtdLocal> <closeAmortizedLocal>258.063</closeAmortizedLocal> <closeAmortizedBase>675.262</closeAmortizedBase> <amortizedCostBase>255.037</amortizedCostBase> <accruedInterestType>CUM</accruedInterestType> <accruedLtdBase>431.549</accruedLtdBase> <accruedLtdLocal>901.74</accruedLtdLocal> <accruedIncomeLocal>520.066</accruedIncomeLocal> <accruedIncome>897.549</accruedIncome> <acquisitionCode>ACQ_CODE</acquisitionCode> <currBuiltInGlSecurity>355.196</currBuiltInGlSecurity> <currBuiltInGlCurrency>964.483</currBuiltInGlCurrency> <currBuiltInGlDeferred>226.887</currBuiltInGlDeferred> <currBuiltInGlOid>983.955</currBuiltInGlOid> <currBuiltInGlMktDisc>297.519</currBuiltInGlMktDisc> <currFxRate>963.515</currFxRate> <departmentAcquisitionDate>2014-11-17</departmentAcquisitionDate> <expenses>653.28</expenses> <exchangeRate>706.742</exchangeRate> <executionBroker>Test_D</executionBroker> <federalTaxCostUnknown>F_T_C_UN</federalTaxCostUnknown> <gaapPremDisInd>G_P_D_IN</gaapPremDisInd> <gaapSettle>2014-11-28</gaapSettle> <gaapTrade>2014-11-12</gaapTrade> <gaapTradeDate>2014-11-12</gaapTradeDate> <idCost>302.738</idCost> <incomeDue>446.019</incomeDue> <intPurchased>416.695</intPurchased> <lastUpdateSrcDate>2014-11-17</lastUpdateSrcDate> <leg1NxtPmtAmt>653.167</leg1NxtPmtAmt> <leg1NxtPmtDate>2014-11-17</leg1NxtPmtDate> <leg2NxtPmtAmt>271.51</leg2NxtPmtAmt> <leg2NxtPmtDate>2014-11-17</leg2NxtPmtDate> <lastSaleSettle>2014-11-17</lastSaleSettle> <locationCode>Test_E</locationCode> <lastSaleTrade>2014-11-212</lastSaleTrade> <managedFl>MANA_FL</managedFl> <marketValueIncome>352.13</marketValueIncome> <netcashflwsNxtPmt>2014-11-17</netcashflwsNxtPmt> <netcashflwsNxtPmtDate>2014-11-17</netcashflwsNxtPmtDate> <otherCharges>274.783</otherCharges> <originalAcquisitionCostBase>873.405</originalAcquisitionCostBase> <originalAcquisitionCostLocal>374.578</originalAcquisitionCostLocal> <originalBuiltInGlMktDisc>811.57</originalBuiltInGlMktDisc> <originalBuiltInGlCurrency>690.483</originalBuiltInGlCurrency> <originalBuiltInGlDeferred>503.856</originalBuiltInGlDeferred> <originalBuiltInGlOid>942.918</originalBuiltInGlOid> <originalBuiltInGlSecurity>631.732</originalBuiltInGlSecurity> <originalTradePrice>415.668</originalTradePrice> <originalSourceCode>Test_F</originalSourceCode> <originalAcquisitionDate>2014-11-12</originalAcquisitionDate> <originalFace>54.53</originalFace> <origLotNumber>Test_G</origLotNumber> <origOpenSettleDate>2014-11-12</origOpenSettleDate> <origEventId>TSR821</origEventId> <performanceFlow>11.22</performanceFlow> <performancePrice>40.198</performancePrice> <performanceFlag>PF</performanceFlag> <price>96.457</price> <smInactiveFlag>N</smInactiveFlag> <purchaseQuantity>40.892</purchaseQuantity> <purYld>24.871</purYld> <pledgeFlag>N</pledgeFlag> <prYrAccrIncome>29.05</prYrAccrIncome> <purchAccruedInterestAmt>37.37</purchAccruedInterestAmt> <reason>SPLIT</reason> <recParOrShares>81.709</recParOrShares> <registrationCode>BMCD</registrationCode> <reinvestCode>BVCFDS</reinvestCode> <restrictionCode>GFRDE</restrictionCode> <statPremDiscInd>S_P_D_IN</statPremDiscInd> <statSettle>2014-11-12</statSettle> <statTrade>2014-11-12</statTrade> <stateAcquisitionDate>2014-11-12</stateAcquisitionDate> <taxAcquisitionDate>2014-11-12</taxAcquisitionDate> <taxPremDiscInd>Test_H</taxPremDiscInd> <taxSettle>2014-11-12</taxSettle> <taxStatus>Test_I</taxStatus> <taxTrade>2014-11-12</taxTrade> <termIndicator>57.41</termIndicator> <intReceived>6.86</intReceived> <income>2.785</income> <votingAuthorityCode>VOAUC</votingAuthorityCode> <clientId>TSTR825</clientId> <covFlag>N</covFlag> <eventSubPriority>643</eventSubPriority> <factor>6.171</factor> <ioIssuerAlias>Test_K</ioIssuerAlias> <ioIssuerId>TSTR210A</ioIssuerId> <origAcctDate>2014-11-28</origAcctDate> <origMonthlyAcctDate>2014-11-28</origMonthlyAcctDate> <parOrShares>965.969</parOrShares> <pendingTradeId>504244</pendingTradeId> <qtyWashSaleEligible>330.847</qtyWashSaleEligible> <strategy>Test_L</strategy> <tradeYield>239.2</tradeYield> <washSaleEligibleInd>N</washSaleEligibleInd> <aiaNetB>65.522</aiaNetB> <aiaNetL>48.79</aiaNetL> <buySellFlag>BUY</buySellFlag> <bookValue>840.198</bookValue> <bookValueLocal>896.457</bookValueLocal> <cpNetB>840.892</cpNetB> <cpNetL>324.871</cpNetL> <creditLossB>129.05</creditLossB> <creditLossL>307.37</creditLossL> <costBasisType>C</costBasisType> <futureFeeNetB>681.709</futureFeeNetB> <futureFeeNetL>657.431</futureFeeNetL> <impairmentLtdBase>166.86</impairmentLtdBase> <impairmentLtdLocal>126.785</impairmentLtdLocal> <mbaNetB>148.346</mbaNetB> <mbaNetL>606.392</mbaNetL> <naiaNetB>669.38</naiaNetB> <naiaNetL>416.743</naiaNetL> <nonCreditLossB>613.171</nonCreditLossB> <nonCreditLossL>918.717</nonCreditLossL> <adjustedShares>887.878</adjustedShares> <baseGaapMarketValue>965.969</baseGaapMarketValue> <baseStatMarketValue>498.717</baseStatMarketValue> <cashEquivalents>926.147</cashEquivalents> <cirBrkFees>504.244</cirBrkFees> <closeOidIncome>330.847</closeOidIncome> <closeOidIncomeLocal>239.2</closeOidIncomeLocal> <closeTipsIncomeLocal>901.958</closeTipsIncomeLocal> <closeTipsIncome>351.522</closeTipsIncome> <deferredIncomeTotalPtdB>177.79</deferredIncomeTotalPtdB> <deferredIncomeTotalPtdL>904.123</deferredIncomeTotalPtdL> <deltaAdjQty>776.052</deltaAdjQty> <dlta>959.298</dlta> <expoPrice>538.021</expoPrice> <earnThruDate>2014-11-17</earnThruDate> <execBrkFees>530.218</execBrkFees> <fedTaxCostValue>769.722</fedTaxCostValue> <gaapUnitBookValue>292.88</gaapUnitBookValue> <gaapUnitCost>755.089</gaapUnitCost> <gaapBookValue>798.772</gaapBookValue> <gaapCostValue>414.216</gaapCostValue> <hedgedCusip>Test_M</hedgedCusip> <hedgeTrading>Test_N</hedgeTrading> <interestEarned>280.34</interestEarned> <lastSettlementDate>2014-11-17</lastSettlementDate> <localGaapCostValue>394.449</localGaapCostValue> <localGaapUnitCost>971.647</localGaapUnitCost> <localGaapBookValue>347.2</localGaapBookValue> <localGaapUnitBookValue>421.234</localGaapUnitBookValue> <localGaapMarketValue>933.96</localGaapMarketValue> <localTaxUnitBookValue>767.559</localTaxUnitBookValue> <localStatUnitCost>990.614</localStatUnitCost> <localStatBookValue>350.704</localStatBookValue> <localStatCostValue>294.697</localStatCostValue> <localStatMarketValue>823.299</localStatMarketValue> <localStatUnitBookValue>152.549</localStatUnitBookValue> <localTaxBookValue>174.634</localTaxBookValue> <localTaxCostValue>322.017</localTaxCostValue> <localTaxUnitCost>978.696</localTaxUnitCost> <nonCreditLossAmortLtdB>578.878</nonCreditLossAmortLtdB> <nonCreditLossAmortLtdL>466.831</nonCreditLossAmortLtdL> <oidPtdBase>217.897</oidPtdBase> <oidPtdLocal>394.804</oidPtdLocal> <oidLtdIncomeLocal>632.319</oidLtdIncomeLocal> <oidLtdIncomeBase>295.687</oidLtdIncomeBase> <openMktPrice>298.928</openMktPrice> <origAccrPtdBase>322.338</origAccrPtdBase> <origSoldInterestBase>168.952</origSoldInterestBase> <origTradedInterestBase>650.915</origTradedInterestBase> <originalCostAmount>752.556</originalCostAmount> <payEpAccrued>838.674</payEpAccrued> <payRecInd>R</payRecInd> <posnFullyEarned>D</posnFullyEarned> <purchasePrincipalBase>551.414</purchasePrincipalBase> <purchasePrincipalLocal>171.979</purchasePrincipalLocal> <pv01total>601.952</pv01total> <preTaxAdjYld>845.863</preTaxAdjYld> <recEpAccrued>957.592</recEpAccrued> <statCostValue>763.119</statCostValue> <soldInterestBase>181.064</soldInterestBase> <scrubFlag>SF</scrubFlag> <sourceInternalAssetId>TS21A</sourceInternalAssetId> <statBookValue>985.645</statBookValue> <statUnitBookValue>156.224</statUnitBookValue> <soldInterestLocal>725.376</soldInterestLocal> <statUnitCost>808.945</statUnitCost> <stateCostValue>208.773</stateCostValue> <swapAccrMethod>I</swapAccrMethod> <totalUnrealizedGainLossLocal>944.928</totalUnrealizedGainLossLocal> <totalUnrealizedGainLossBase>187.47</totalUnrealizedGainLossBase> <tipsPtdBase>292.856</tipsPtdBase> <tipsPtdLocal>411.76</tipsPtdLocal> <taxBookValue>219.334</taxBookValue> <taxCostValue>587.66</taxCostValue> <taxUnitBookValue>944.079</taxUnitBookValue> <taxUnitCost>415.021</taxUnitCost> <tradeFxRate>786.588</tradeFxRate> <undPrice>180.385</undPrice> <uniqueAssetFlag>N</uniqueAssetFlag> <bankAlias>47</bankAlias> <batchEventId>TSTR821A</batchEventId> <brokerCode>EAGLE</brokerCode> <clearingBrokerCode>EAGLE</clearingBrokerCode> <commissionAmount>179.512</commissionAmount> <lotNumber>Num3</lotNumber> <masterTicketNumber>Test_P</masterTicketNumber> <monthEndAccountingDate>2014-11-12</monthEndAccountingDate> <secFee>54.501</secFee> <settlementDate>2014-11-12</settlementDate> <tradeDate>2014-11-12</tradeDate> <transactionCode>REC</transactionCode> <userChar1>USER1</userChar1> <userChar2>USER2</userChar2> <userChar3>USER3</userChar3> <userDefinedFloat1>447.859</userDefinedFloat1> <userDefinedFloat2>866.736</userDefinedFloat2> <userDefinedFloat3>433.593</userDefinedFloat3> <pclUserDate1>2014-11-17</pclUserDate1> <pclUserDate2>2014-11-17</pclUserDate2> <pclUserDate3>2014-11-17</pclUserDate3> <userGroup1>USER_GR1</userGroup1> <userGroup2>USER_GR2</userGroup2> <userGroup3>USER_GR3</userGroup3> <userGroup4>USER_GR4</userGroup4> <userGroup5>USER_GR5</userGroup5> <userGroup6>USER_GR6</userGroup6> <userGroup7>USER_GR7</userGroup7> <userGroup8>USER_GR8</userGroup8> <userGroup9>USER_GR9</userGroup9> <userGroup10>USER_GR10</userGroup10> <userGroup11>USER_GR11</userGroup11> <userGroup12>USER_GR12</userGroup12> <userGroup13>USER_GR13</userGroup13> <userGroup14>USER_GR14</userGroup14> <userGroup15>USER_GR15</userGroup15> <userGroup16>USER_GR16</userGroup16> <userGroup17>USER_GR17</userGroup17> <userGroup18>USER_GR18</userGroup18> </warehouseOpenLot> </warehouseTransaction> </EagleML>
<EagleML xmlnxsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="RunTaskRequest" eaglemlVersion="2-0" actualBuild="1" xmlns=""> <header xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"> <messageId>BM_20160520</messageId> <sentBy>User</sentBy> <sendTo>http://www.eagleinvsys.com/eagle_ml-2-0_default_cm_control_message</sendTo> <replyTo>test</replyTo> </header> <taskIdentifier xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"> <correlationId correlationIdScheme="correlationIdScheme">BM_20160525_004</correlationId> <businessTaskId correlationIdScheme="businessTaskIdScheme">BM_20160525</businessTaskId> </taskIdentifier> <taskTypeEnum xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0">LOAD</taskTypeEnum> <taskParameters xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"> <taskParameter> <name>ActionType</name> <dataType>S</dataType> <value>ACQUIRE</value> </taskParameter> <taskParameter> <name>StreamName</name> <dataType>S</dataType> <value>eagle_ml-2-0_default_cm_acquire_data</value> </taskParameter> <taskParameter> <name>WAREHOUSE</name> <dataType>S</dataType> <value>BM_WAREHOUSE_DATA.xml</value> </taskParameter> </taskParameters> </EagleML>
Report All Errors at Once
Currenly available for Warehouse Position, Warehouse Open Lot, and Warehouse Trade
EJM supports collecting all errors at once when loading in Batch mode WarehousePosition, WarehouseOpenLot, and WarehouseTrade feed types. Now, in case of an error during batch load, the batch request will be split into records and each record will be loaded separately WITHOUT committing to the database. All returned errors are then collected and reported in the TSR in a format with record keys, which can uniquely identify the failed record. This feature is turned off by default and is controlled either by the batchCollectErrorsFlag element in the incoming message:
</batchCollectErrorsFlag>Y</batchCollectErrorsFlag>
or by its global variation - W_BATCH_COLLECT_ERRORS_FLAG parameter in the w_config_custom.inc file and setting it to "Y":
<COL TAG="W_BATCH_COLLECT_ERRORS_FLAG" EXPRESSION="'Y'"/>
Default Mode - Example of Error Report
1. Error description:
Error executing DB Request. Status Code: -2 Channel Status Code: -5 Error Message: 'Error code -1(FFFFFFFF) returned while executing the request. Security Not Found in xreference table " CUSIP_DKTEST3MA_FLD2/CUSIP"'
2. Error description:
Security for the identifier "CUSIP_DKTEST3MA_FLD2/CUSIP" does not exist in Eagle.
<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>150V7OH1MD1CHPL1</messageId> <sentBy>http://www.eagleinvsys.com/</sentBy> <sendTo>test</sendTo> <creationTimestamp>2016-05-26T07:54:37-05:00</creationTimestamp> </header> <statusItem> <taskIdentifier> <correlationId correlationIdScheme="correlationIdScheme">BM_20160525_004</correlationId> <businessTaskId correlationIdScheme="businessTaskIdScheme">BM_20160525</businessTaskId> </taskIdentifier> <status>FAILED</status> <severityCode>1</severityCode> <taskUnit> <loadDetails> <URI>file://*BM_20160525_004_WAREHOUSE-*.xml</URI> <details> <file> <fileName>PROCESSING\5C20160526-075434-1L7V2GMV7S57Y1U6_BM_20160525_004_WAREHOUSE-.XML</fileName> <type>WAREHOUSE</type> <summary> <eagleStatId>8380815</eagleStatId> <failedRecords>3</failedRecords> <totalRecords>3</totalRecords> </summary> <record> <transactionId>WAK6L7O09OHP9FN</transactionId> <eagleDetailId>95174772</eagleDetailId> <identifier><identifierName>fromId</identifierName><identifierValue>TST3791^20140130^EAGLE PACE</identifierValue> </identifier><identifier><identifierName>account</identifierName><identifierValue>TST3791</identifierValue> </identifier><identifier><identifierName>amount</identifierName><identifierValue>3</identifierValue> </identifier><identifier><identifierName>referenceNumber</identifierName><identifierValue>AMTR</identifierValue> </identifier><identifier><identifierName>identifier1</identifierName><identifierValue>TST3791</identifierValue> </identifier><identifier><identifierName>identifier2</identifierName><identifierValue>20140130</identifierValue> </identifier><identifier><identifierName>identifier3</identifierName><identifierValue>4</identifierValue> </identifier><reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-7</reasonCode> <description>Error executing DB Request. Status Code: -2 Channel Status Code: -5 Error Message: 'Error code -1(FFFFFFFF) returned while executing the request. Security Not Found in xreference table " CUSIP_DKTEST3MA_FLD2/CUSIP"'</description> </reason> <reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-21</reasonCode> <description>Security for the identifier "CUSIP_DKTEST3MA_FLD2/CUSIP" does not exist in Eagle.</description> <reasonTag>1233</reasonTag> </reason> <reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-21</reasonCode> <description>The message hasn't been sent to engine due to EditCheck violation. Sending Reject Message.</description> </reason> <reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-10</reasonCode> <description>The request was not processed</description> </reason> </record> </file> </details> </loadDetails> </taskUnit> </statusItem> </EagleML>
The TSR says that the date file contains 3 records. 2 of 3 records have errors.
Only the first error is displayed, as expected for default mode.
Batch Error Mode - Example of Error Report
1. Error description:
Error executing DB Request. Status Code: -2 Channel Status Code: -5 Error Message: 'Error code -1(FFFFFFFF) returned while executing the request. Security Not Found in xreference table " CUSIP_DKTEST3MA_FLD2/CUSIP"'
2. Error description:
Security no found for the following identifiers: CUSIP/CUSIP_DKTEST3MA_FLD2 CUSIP/CUSIP_DKTEST2MA_FLD3
<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>8LMP31FASKVR7NB</messageId> <sentBy>http://www.eagleinvsys.com/</sentBy> <sendTo>test</sendTo> <creationTimestamp>2016-05-26T07:58:25-05:00</creationTimestamp> </header> <statusItem> <taskIdentifier> <correlationId correlationIdScheme="correlationIdScheme">BM_20160525_005</correlationId> <businessTaskId correlationIdScheme="businessTaskIdScheme">BM_20160525</businessTaskId> </taskIdentifier> <status>FAILED</status> <severityCode>1</severityCode> <taskUnit> <loadDetails> <URI>file://*BM_20160525_005_WAREHOUSE-*.xml</URI> <details> <file> <fileName>PROCESSING\5C20160526-075821-1JBIVPT1MNRMGFLS_BM_20160525_005_WAREHOUSE-.XML</fileName> <type>WAREHOUSE</type> <summary> <eagleStatId>8380835</eagleStatId> <failedRecords>3</failedRecords> <totalRecords>3</totalRecords> </summary> <record> <transactionId>1R2UR9SSYMDKSWQ1</transactionId> <eagleDetailId>95176217</eagleDetailId> <identifier><identifierName>fromId</identifierName><identifierValue>TST3791^20140130^EAGLE PACE</identifierValue> </identifier><identifier><identifierName>account</identifierName><identifierValue>TST3791</identifierValue> </identifier><identifier><identifierName>amount</identifierName><identifierValue>3</identifierValue> </identifier><identifier><identifierName>referenceNumber</identifierName><identifierValue>AMTR</identifierValue> </identifier><identifier><identifierName>identifier1</identifierName><identifierValue>TST3791</identifierValue> </identifier><identifier><identifierName>identifier2</identifierName><identifierValue>20140130</identifierValue> </identifier><identifier><identifierName>identifier3</identifierName><identifierValue>4</identifierValue> </identifier><reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-7</reasonCode> <description>Error executing DB Request. Status Code: -2 Channel Status Code: -5 Error Message: 'Error code -1(FFFFFFFF) returned while executing the request. Security Not Found in xreference table " CUSIP_DKTEST3MA_FLD2/CUSIP"'</description> </reason> <reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-21</reasonCode> <description>Security no found for the following identifiers: CUSIP/CUSIP_DKTEST3MA_FLD2 CUSIP/CUSIP_DKTEST2MA_FLD3 </description> <reasonTag>1168</reasonTag> </reason> <reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-21</reasonCode> <description>The message hasn't been sent to engine due to EditCheck violation. Sending Reject Message.</description> </reason> <reason> <reasonTypeEnum>ERROR</reasonTypeEnum> <reasonCode>-10</reasonCode> <description>The request was not processed</description> </reason> </record> </file> </details> </loadDetails> </taskUnit> </statusItem> </EagleML>
The TSR says that the date file contains 3 records. 2 of 3 records have errors.
Both wrong asset identifiers are displayed in the description fields, as expected for Batch Error mode.
- No labels