Overview of Batch Error Mode
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 Enabled by the EAGLEML_WAREHOUSE_BATCH_ERROR_MODE global parameter in w_config_custom.inc:
| Code Block |
|---|
|
<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.
| Expand |
|---|
| title | Sample incoming data file (click to expand) |
|---|
|
Name the file as BM_WAREHOUSE_DATA.xml to use with the control message below | Code Block |
|---|
| <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> |
|
| Expand |
|---|
| title | Control Message for the Load (click to expand) |
|---|
|
| Code Block |
|---|
| <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 Feature
| Warning |
|---|
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 in Batch mode. 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 being committed 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:
| Code Block |
|---|
|
</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":
| Code Block |
|---|
|
<COL TAG="W_BATCH_COLLECT_ERRORS_FLAG" EXPRESSION="'Y'"/> |
Default Mode - Example of Error Report
Image Removed
Image Removed1. Error description:
| Code Block |
|---|
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:
| Code Block |
|---|
Security for the identifier "CUSIP_DKTEST3MA_FLD2/CUSIP" does not exist in Eagle. |
| Expand |
|---|
| title | Task Status Response (click to expand) |
|---|
|
| 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>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
Image Removed 
Image Removed1. Error description:
| Code Block |
|---|
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:
| Code Block |
|---|
Security no found for the following identifiers: CUSIP/CUSIP_DKTEST3MA_FLD2
CUSIP/CUSIP_DKTEST2MA_FLD3 |
| Expand |
|---|
| title | Task Status Response (click to expand) |
|---|
|
| 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>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.
...