Warehouse Data Object - Batch Error Mode

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. Enabled by the EAGLEML_WAREHOUSE_BATCH_ERROR_MODE global parameter in 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 Feature

Currenly available for Warehouse Position, Warehouse Open Lot, and Warehouse Trade

EJM supports collecting all errors at once when loading WarehousePosition, WarehouseOpenLot, and WarehouseTrade feed types 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 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:

</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.

Â