Table of Contents

Overview

This article is intended to help customers who use ICE Private Order Feed Drop Copy connection to upgrade their FIXEdge based solution to the latest version. The article provides upgrade instruction for the following scenarios:

...

ICE Private Order Feed Drop Copy solution will contain latest FIXEdge version with all the new features and bugfixes
all customer's specific ICE Private Order Feed Drop Copy configurations and database schemes will be discarded
no migration of existing of existing data from the current database to the new upgraded database takes place (means new clean Database from the package to be setup)

Upgrade Preparation

Make sure you have sufficient administration permissions for further uninstall/install procedures.
Download new ICE Private Order Feed Drop Copy solution package for the corresponding OS version from the Client Space;
Stop the FIXEdge instance;
Stop the FIXICC-agent instance;
Remove all the files except servers.xml from FIXICC's working dir .fixicc/dev normally placed in C:\Users\%USER%\AppData\Roaming directory;
Make a backup copy of your current installation (configuration and binaries);
Make a backup copy of your current license (engine.license).
If your license has expired or was lost, contact sales@btobits.com to obtain the new one;

...

Upgrade FIXEdge:
1. For Windows version:
  Replace* all the files in <bin> directory with new binaries from the package;
2. For Linux version:
  Replace* files in <bin> directory with new binaries from the package - all except *.sh files;

Upgrade FIXICC:

Replace* the whole <fixicc-agent> directory with new one from the package;
Replace* the whole <fixicc> directory with new one from the package;

Note
"Replace" in this context means that files should be deleted from the current FIXEdge directory and new files from the package should be added there. This clarification is made in order to avoid the situation when two (or more) same libraries with different versions appear in the directory as it may cause issues.

Replace <jre> directory with new one from the package;
Update all the files in the FIXEdge /conf directory with files from the new package except the following ones which should be preserved from your current installation:
1. ICEPOF_Logon.msg
2. engine.properties
3. FIXEdge.properties
4. BL_Config.xml
Start the FIXICC-agent instance;
Start the FIXEdge via FIX Integrated Control Center (FIXICC)

Note

In order to ensure that upgraded ICE ICE Private Order Feed Drop Copysolution was successfully setup, please check the FixEdge.log file:

Find the following record with the target FIXEdge version:
Code Block
language bash
title FixEdge.log
2016-09-20 10:46:19,459 UTC INFO [CC_Layer] 5552 FIXEdge Version X.Y.Z (rxyz) started
Make sure there are no [ERROR] records in the log file.

Upgrade of the existing configuration files

...

for FIXEdge

...

This section contains a list of changes that need to be made to update the ICE the ICE Private Order Feed Drop Copy Solution configuration. The upgrade process is similar to the process described in this section Upgrade of the existing ICE Private Order Feed Drop Copy setup . But, no migration of existing data from the current database to the new upgraded database takes place (means new clean Database from the package to be setup).

ICE Private Order Feed Drop Copy configuration update (instead of Upgrade of the existing ICE Private Order Feed Drop Copy setup, step 4)

Update all the files in the FIXEdge /conf directory with files from the new package except the following ones which should be preserved from your current installation:

ICETC_Logon.msg
engine.properties
FIXEdge.properties
BL_Config.xml

Adjust ICE Private Order Feed Drop Copy configuration (typically located here ‘C:/B2BITS/FIXEdge/FIXEdge1/conf/’). Make a backup copy of your current configuration before.

Update Update the ICEPOFBL_LogonConfig.msg file (Logon Message):

Set the 9007 tags to "1 "

...

xml file

Change ICEPOFReports, ICEPOFReportsCombiDefinitions, Sent_Messages_ICE_POF History descriptions with corresponding history descriptions from BL_Config.xml from the package (adjust change the ConnectionString parameter if necessary)

Code Block

language	xml
title	BL_Config.xml

    <History Name="ICEPOFReports"
             StorageType="ODBC"
             TableName="ICEPOFReports"
             ColumnSize="256"
             ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">

      <KeyField ColumnName="ExecID" ColumnSize="128">17</KeyField>
      <KeyField ColumnName="Symbol" ColumnSize="128">55</KeyField>
      <KeyField ColumnName="Side" ColumnSize="128">54</KeyField>
      <KeyField ColumnName="SourceFeed" ColumnSize="128">9009</KeyField>
      <KeyField ColumnName="ExecType" ColumnSize="128">150</KeyField>
      <KeyField ColumnName="TransactTime" ColumnSize="128">60</KeyField>
      <Field ColumnName="TransactTimeWasNULL" ColumnSize="128">00</Field>
      <Field ColumnName="PossDupFlag" ColumnSize="128">43</Field>
      <Field ColumnName="PossResend" ColumnSize="128">97</Field>
      <Field ColumnName="SendingTime" ColumnSize="128">52</Field>
      <Field ColumnName="OrderID" ColumnSize="128">37</Field>
      <Field ColumnName="ClOrdID" ColumnSize="128">11</Field>
      <Field ColumnName="OrigClOrdID" ColumnSize="128">41</Field>
      <Field ColumnName="ClientID" ColumnSize="128">109</Field>
      <Field ColumnName="TargetCompId" ColumnSize="128">56</Field>
      <Field ColumnName="ExecInst" ColumnSize="128">18</Field>
      <Field ColumnName="OnBehalfOfCompId" ColumnSize="128">115</Field>
      <Field ColumnName="OnBehalfOfSubId" ColumnSize="128">116</Field>
      <Field ColumnName="OnBehalfOfLocationId" ColumnSize="128">144</Field>
      <Field ColumnName="HistoryRequestId" ColumnSize="128">9415</Field>
      <Field ColumnName="OriginatorUserID" ColumnSize="128">9139</Field>
      <Field ColumnName="ExecTransType" ColumnSize="128">20</Field>
      <Field ColumnName="ExecRefID" ColumnSize="128">19</Field>
      <Field ColumnName="OrdStatus" ColumnSize="128">39</Field>
      <Field ColumnName="OrderState" ColumnSize="128">9175</Field>
      <Field ColumnName="OrdRejReason" ColumnSize="128">103</Field>
      <Field ColumnName="OrderQty" ColumnSize="128">38</Field>
      <Field ColumnName="SecurityType" ColumnSize="128">167</Field>
      <Field ColumnName="PutOrCall" ColumnSize="128">201</Field>
      <Field ColumnName="StrikePrice" ColumnSize="128">202</Field>
      <Field ColumnName="MaxShow" ColumnSize="128">210</Field>
      <Field ColumnName="OrdType" ColumnSize="128">40</Field>
      <Field ColumnName="Price" ColumnSize="128">44</Field>
      <Field ColumnName="ExecRestatementReason" ColumnSize="128">378</Field>
      <Field ColumnName="CustOrderHandlingInst" ColumnSize="128">1031</Field>
      <Field ColumnName="LiquidityIndicator" ColumnSize="128">9120</Field>
      <Field ColumnName="MemoField" ColumnSize="128">9121</Field>
      <Field ColumnName="TransactDetails" ColumnSize="128">9123</Field>
      <Field ColumnName="NumberOfCycles" ColumnSize="128">9022</Field>
      <Field ColumnName="SequenceWithinMillis" ColumnSize="128">9028</Field>
      <Field ColumnName="ClientAppType" ColumnSize="128">9413</Field>
      <Field ColumnName="CustClearingVenue" ColumnSize="128">9209</Field>
      <Field ColumnName="TrdType" ColumnSize="128">828</Field>
      <Field ColumnName="TimeInForce" ColumnSize="128">59</Field>
      <Field ColumnName="PositionEffect" ColumnSize="128">77</Field>
      <Field ColumnName="LeavesQty" ColumnSize="128">151</Field>
      <Field ColumnName="CumQty" ColumnSize="128">14</Field>
      <Field ColumnName="AvgPx" ColumnSize="128">6</Field>
      <Field ColumnName="LastQty" ColumnSize="128">32</Field>
      <Field ColumnName="LastPx" ColumnSize="128">31</Field>
      <Field ColumnName="LastParPx" ColumnSize="128">669</Field>
      <Field ColumnName="MultiLegReportingType" ColumnSize="128">442<

Update the engine.properties file:

Specify the parameters as further described:

AdditionalParsersList = FIX44ICEPOF;

Info
See AdditionalParsersList also

Update the FIXEdge.properties file
- - - FixLayer.FixEngine.Session.ICEPOFSession.SessionQualifierValue = Q1
- - Add the Username and Password parameters for ICEPOFSession as further described:
- - - FixLayer.FixEngine.Session.ICEPOFSession.Username = <ICEUserName>
- - - FixLayer.FixEngine.Session.ICEPOFSession.Password = <ICEUserPassword>

...

Update the BL_Config.xml file

Change ICEReports, ICEPOFReportsCombiDefinitions, Sent_Messages_ICE_POF History descriptions as further described (adjust change the ConnectionString parameter if necessary)

Code Block

language	xml
title	BL_Config.xml

    <History Name="ICEPOFReports"
             StorageType="ODBC"
             MaxNumberOfRecords="15000"
             TableName="ICEPOFReports"
             ColumnSize="256"
             ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
      <KeyField ColumnName="ExecID" ColumnSize="128">17</KeyField>
      <KeyField ColumnName="Symbol" ColumnSize="128">55</KeyField>
      <KeyField ColumnName="Side" ColumnSize="128">54</KeyField>
      <KeyField ColumnName="SourceFeed" ColumnSize="128">9009</KeyField>
      <KeyField ColumnName="ExecType" ColumnSize="128">150</KeyField>
      <KeyField ColumnName="TransactTime" ColumnSize="128">60</KeyField>
   <Field ColumnName="TransactTimeWasNULL" ColumnSize="128">00</Field>
   <Field ColumnName="PossDupFlag" ColumnSize="128">43</Field>
   <Field ColumnName="PossResend" ColumnSize="128">97</Field>
      <Field ColumnName="SendingTimeSecondaryExecID" ColumnSize="128">52<>527</Field>
      <Field ColumnName="OrderIDCrossId" ColumnSize="128">37<>548</Field>
      <Field ColumnName="ClOrdIDCrossType" ColumnSize="128">11<>549</Field>
      <Field ColumnName="OrigClOrdIDClearingFirm" ColumnSize="128">41<>439</Field>
      <Field ColumnName="ClientIDClearingAccount" ColumnSize="128">109<>440</Field>
      <Field ColumnName="TargetCompIdStartDate" ColumnSize="128">56<>916</Field>
      <Field ColumnName="ExecInstEndDate" ColumnSize="128">18<>917</Field>
      <Field ColumnName="OnBehalfOfCompIdAccountCode" ColumnSize="128">115<>9195</Field>
      <Field ColumnName="OnBehalfOfSubIdCustomerAccountRefId" ColumnSize="128">116<>9207</Field>
      <Field ColumnName="OnBehalfOfLocationIdCrossExecutionType" ColumnSize="128">144<>9405</Field>
      <Field ColumnName="HistoryRequestIdDeliveryStartDate" ColumnSize="128">9415<>9520</Field>
      <Field ColumnName="OriginatorUserIDDeliveryEndDate" ColumnSize="128">9139<>9521</Field>
      <Field ColumnName="ExecTransTypeLocationCode" ColumnSize="128">20<>9522</Field>
      <Field ColumnName="ExecRefIDMeterNumber" ColumnSize="128">19<>9523</Field>
      <Field ColumnName="OrdStatusLeadTime" ColumnSize="128">39<>9524</Field>
      <Field ColumnName="OrderStateReasonCode" ColumnSize="128">9175<>9525</Field>
      <Field ColumnName="OrdRejReasonDayRate" ColumnSize="128">103<>9526</Field>
      <Field ColumnName="OrderQtyText" ColumnSize="128">38<>58</Field>      
      <Field ColumnName="SecurityTypePriceType" ColumnSize="128">167<>423</Field>
      <Field ColumnName="PutOrCallStopPx" ColumnSize="128">201<>99</Field>
      <Field ColumnName="StrikePriceExpireDate" ColumnSize="128">202<>432</Field>
      <Field ColumnName="MaxShowExpireTime" ColumnSize="128">210<>126</Field>
      <Field ColumnName="OrdTypeLinkExecID" ColumnSize="128">40<>9527</Field>
      <Field ColumnName="PriceBrokerCompID" ColumnSize="128">44<>9065</Field>
      <Field ColumnName="ExecRestatementReasonBrokerCompName" ColumnSize="128">378<>9066</Field>
      <Field ColumnName="CustOrderHandlingInstBrokerUserID" ColumnSize="128">1031<>9067</Field>
      <Field ColumnName="LiquidityIndicatorDeleteReason" ColumnSize="128">9120<>285</Field>
      <Field ColumnName="MemoFieldQuoteRespID" ColumnSize="128">9121<>693</Field>
      <Field ColumnName="TransactDetailsWaiverIndicator" ColumnSize="128">9123<>8013</Field>
      <Field ColumnName="NumberOfCyclesImpliedIndicator" ColumnSize="128">9022<>9003</Field>
      <Field ColumnName="SequenceWithinMillisCTICode" ColumnSize="128">9028<>9208</Field>
      <Field ColumnName="ClientAppTypeDirectElectronicAccess" ColumnSize="128">9413<>9700</Field>
      <Field ColumnName="CustClearingVenueTradingCapacity" ColumnSize="128">9209<>9701</Field>
      <Field ColumnName="TrdTypeLiquidityProvision" ColumnSize="128">828<>9702</Field>
      <Field ColumnName="TimeInForceCommodityDerivIndicator" ColumnSize="128">59<>9703</Field>
      <Field ColumnName="PositionEffectInvestmentDecision" ColumnSize="128">77<>9704</Field>
      <Field ColumnName="LeavesQtyExecutionDecision" ColumnSize="128">151<>9705</Field>
      <Field ColumnName="CumQtyClientIDCode" ColumnSize="128">14<>9706</Field>
      <Field ColumnName="AvgPxMiFIDID" ColumnSize="128">6<>9707</Field>
      <Field ColumnName="LastQtyMemberName" ColumnSize="128">32<>5364</Field>
      <Field ColumnName="LastPxCounterpartyTraderID" ColumnSize="128">31<>6347</Field>
      <Field ColumnName="LastParPxCounterpartyCompID" ColumnSize="128">669<>6822</Field>
      <Field ColumnName="MultiLegReportingTypeContraFirm" ColumnSize="128">442<>9068</Field>
      <Field ColumnName="SecondaryExecIDComplianceID" ColumnSize="128">527<>376</Field>	  
      <Field ColumnName="CrossIdNumOfCombiDefinitions" ColumnSize="128">548<>9500</Field>
      <Field ColumnName="CrossTypeTermsQualityComments" ColumnSize="128">549<>9510</Field>	  
      <Field ColumnName="ClearingFirmNoLegExecutions" ColumnSize="128">439<>9029</Field>
      <Field ColumnName="ClearingAccountOCOOrders" ColumnSize="128">440<>9430</Field>
      <Field ColumnName="StartDateParentCompID" ColumnSize="128">916<>9428</Field>
      <Field ColumnName="EndDateTradeLinkID" ColumnSize="128">917<>820</Field>
      <Field ColumnName="AccountCodeTradeLinkMktID" ColumnSize="128">9195<>9414</Field>
      <Field ColumnName="CustomerAccountRefIdOrderSequenceID" ColumnSize="128">9207<>9431</Field>
      <Field ColumnName="CrossExecutionTypeContract" ColumnSize="128">9405<>9097</Field>
      <Field ColumnName="DeliveryStartDateGeneralTerms" ColumnSize="128">9520<>9098</Field>
      <Field ColumnName="DeliveryEndDateCurrency" ColumnSize="128">9521<>15</Field>
      <Field ColumnName="LocationCodeSystemPricedDeal" ColumnSize="128">9522<>9077</Field>
      <Field ColumnName="MeterNumberCompanyName" ColumnSize="128">9523<>9427</Field>
      <Field ColumnName="LeadTimeCounterPartyBrokerCompID" ColumnSize="128">9524<>9432</Field>
      <Field ColumnName="ReasonCodeCounterPartyBrokerCompName" ColumnSize="128">9525<>9433</Field>
      <Field ColumnName="DayRateCounterPartyBrokerUserID" ColumnSize="128">9526<>9434</Field>
      <Field ColumnName="TextOCORepeat" ColumnSize="128">58<>9511</Field>
      
   <Field ColumnName="PriceTypeEditorUserID" ColumnSize="128">423<>9419</Field>
      <Field ColumnName="StopPxNumOfLots" ColumnSize="128">99<>9018</Field>
      <Field ColumnName="ExpireDateDisplayQty" ColumnSize="128">432<>1138</Field>
      <Field ColumnName="ExpireTimeQuantityMax" ColumnSize="128">126<>9512</Field>
      <Field ColumnName="LinkExecIDCDIOverride" ColumnSize="128">9527<>9036</Field>
      <Field ColumnName="BrokerCompIDPlattsWindowState" ColumnSize="128">9065<>9436</Field>
      <Field ColumnName="BrokerCompNameManualOrderIndicator" ColumnSize="128">9066<>1028</Field>
      <Field ColumnName="BrokerUserIDDealAdjustIndicator" ColumnSize="128">9067<>9124</Field>
      <Field ColumnName="DeleteReasonSelfMatchPreventionID" ColumnSize="128">285<>9821</Field>
      <Field ColumnName="QuoteRespIDSelfMatchPreventionInstruction" ColumnSize="128">693<>9822</Field>
      <Field ColumnName="WaiverIndicatorOptolMinQuantity" ColumnSize="128">8013<>9513</Field>
      <Field ColumnName="ImpliedIndicatorOptolMaxQuantity" ColumnSize="128">9003<>9514</Field>
      <Field ColumnName="CTICodeOptolPriceBasis" ColumnSize="128">9208<>9515</Field>
      <Field ColumnName="DirectElectronicAccessOptolPriceBasisPeriod" ColumnSize="128">9700<>9516</Field>
      <Field ColumnName="TradingCapacityOptolPrice" ColumnSize="128">9701<>9517</Field>
      <Field ColumnName="LiquidityProvisionOptolPriceBasisSubLevel" ColumnSize="128">9702<>9518</Field>
      <Field ColumnName="CommodityDerivIndicatorRepeatedOrderId" ColumnSize="128">9703<>9079</Field>
      <Field ColumnName="InvestmentDecisionWindowID" ColumnSize="128">9704<>9418</Field>
      <Field ColumnName="ExecutionDecisionOrderDuration" ColumnSize="128">9705<>9435</Field>
      <Field ColumnName="ClientIDCodeRepeatedIndicator" ColumnSize="128">9706<>9478</Field>
      <Field ColumnName</History>

	<History Name="MiFIDIDICEPOFReportsCombiDefinitions" ColumnSize
             StorageType="128ODBC">9707</Field>

            <Field ColumnNameTableName="MemberNameICEPOFReportsCombiDefinitions"
             ColumnSize="128256">5364</Field>
       <Field ColumnName="CounterpartyTraderID" ColumnSize="128">6347</Field>      ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
	  
      <Field<KeyField ColumnName="CounterpartyCompIDExecID" ColumnSize="128">6822<>17</Field>KeyField>
      <Field<KeyField ColumnName="ContraFirmSymbol" ColumnSize="128">9068<>55</Field>KeyField>
      <Field<KeyField ColumnName="ComplianceIDSide" ColumnSize="128">376</Field>   >54</KeyField>
      <Field<KeyField ColumnName="NumOfCombiDefinitionsSourceFeed" ColumnSize="128">9500<>9009</Field>KeyField>
      <Field<KeyField ColumnName="TermsQualityCommentsExecType" ColumnSize="128">9510<>150</Field>KeyField>
   
   <Field<KeyField ColumnName="NoLegExecutionsTransactTime" ColumnSize="128">9029<>60</Field>KeyField>	  
 
    </History>
 <History<KeyField NameColumnName="ICEPOFReportsCombiDefinitionsCombiDefinitionsEntry"
   ColumnSize="128">5999</KeyField> 
      <Field     StorageTypeColumnName="CombiPercentage" ColumnSize="ODBC128">9501</Field>
             MaxNumberOfRecords<Field ColumnName="15000CombiPriceBasis"
             TableName ColumnSize="ICEPOFReportsCombiDefinitions"
   128">9502</Field>
      <Field ColumnName="CombiPriceBasisPeriod"   ColumnSize="256128">9503</Field>
      <Field       ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">ColumnName="CombiPriceBasisSubLevel" ColumnSize="128">9504</Field>
   
   <Field   <KeyField ColumnName="ExecIDCombiLegPrice" ColumnSize="128">17<>9505</KeyField>Field>
    </History>
	
   <KeyField ColumnName="Symbol" ColumnSize="128">55</KeyField><History Name="Sent_Messages_ICE_POF"
      <KeyField ColumnName="Side" ColumnSize="128">54</KeyField>       StorageType="ODBC"
      <KeyField ColumnName="SourceFeed" ColumnSize="128">9009</KeyField>
       TableName="Sent_Messages_ICE_POF"
       <KeyField ColumnName="ExecType"      ColumnSize="128256">150</KeyField>

            <KeyField ColumnName="TransactTime" ColumnSize="128">60</KeyField>   
ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
      <KeyField ColumnName="CombiDefinitionsEntryExecID" ColumnSize="128">5999<>17</KeyField> 
      <Field<KeyField ColumnName="CombiPercentageSymbol" ColumnSize="128">9501<>55</Field>KeyField>
      <Field<KeyField ColumnName="CombiPriceBasisSide" ColumnSize="128">9502<>54</Field>KeyField>
      <Field<KeyField ColumnName="CombiPriceBasisPeriodSourceFeed" ColumnSize="128">9503<>9009</Field>KeyField>
      <Field<KeyField ColumnName="CombiPriceBasisSubLevelExecType" ColumnSize="128">9504<>150</Field>KeyField>
      <Field<KeyField ColumnName="CombiLegPriceTransactTime" ColumnSize="128">9505</Field>>60</KeyField>	  
    </History>
 
    <History Name="Sent_Messages_ICE_POF"
             StorageType="ODBC

Change ICEPOFAllocation, ICEPOFAllocationExecs, ICEPOFAllocationAllocs, ICEPOFAllocationAllocsInfo, Sent_Allocation_ICE_POF History descriptions with corresponding history descriptions from BL_Config.xml from the package (adjust change the ConnectionString parameter if necessary);

Code Block

language	xml
title	BL_Config.xml

   <History Name="ICEPOFAllocation"
             MaxNumberOfRecordsStorageType="15000ODBC"
             TableName="Sent_Messages_ICE_POFICEPOFAllocation"
             ColumnSize="256"
             ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
      <KeyField ColumnName="ExecIDAllocID" ColumnSize="128256">17<>70</KeyField>
      <KeyField ColumnName="SymbolTransactTime" ColumnSize="128">55<>60</KeyField>
      <KeyField<Field ColumnName="SideTransactTimeWasNULL" ColumnSize="128">54<>00</KeyField>Field>
      <KeyField<Field ColumnName="SourceFeedPossDupFlag" ColumnSize="128">9009<>43</KeyField>Field>
      <KeyField<Field ColumnName="ExecTypePossResend" ColumnSize="128">150<>97</KeyField>Field>
      <KeyField<Field ColumnName="TransactTimeSendingTime" ColumnSize="128">60<>52</KeyField>Field>	   
    </History>

Add ICEPOFAllocation, ICEPOFAllocationExecsdescriptions, ICEPOFAllocationAllocs, ICEPOFAllocationAllocsInfoas, Sent_Allocation_ICE_POF History descriptions as further described (adjust change the ConnectionString parameter if necessary);

Code Block

language	xml
title	BL_Config.xml

   <History Name="ICEPOFAllocation"   <Field ColumnName="AllocTransType" ColumnSize="128">71</Field>
      <Field       StorageTypeColumnName="ClearingBusinessDate" ColumnSize="ODBC128">715</Field>
      <Field       MaxNumberOfRecordsColumnName="AllocReportType" ColumnSize="15000128">794</Field>
      <Field ColumnName="AllocStatus" ColumnSize="128">87</Field>
      <Field TableNameColumnName="ICEPOFAllocationNoOrders"
    ColumnSize="128">73</Field>
      <Field ColumnName="ClOrdID"   ColumnSize="256128">11</Field>
      <Field ColumnName="NoExecs" ColumnSize="128">124</Field>
     ConnectionString <Field ColumnName="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">TrdType" ColumnSize="128">828</Field>
      <KeyField<Field ColumnName="AllocIDSymbol" ColumnSize="256128">70<>55</KeyField>Field>
      <KeyField<Field ColumnName="TransactTimeSecurityType" ColumnSize="128">60<>167</KeyField>Field>
      <Field ColumnName="TransactTimeWasNULLMaturityMonthYear" ColumnSize="128">00<>200</Field>
      <Field ColumnName="PossDupFlagPutOrCall" ColumnSize="128">43<>201</Field>
      <Field ColumnName="PossResendStrikePrice" ColumnSize="128">97<>202</Field>
      <Field ColumnName="SendingTimeSecurityExchange" ColumnSize="128">52<>207</Field>   
      <Field ColumnName="AllocTransTypeShares" ColumnSize="128">71<>53</Field>
      <Field ColumnName="ClearingBusinessDateAvgPx" ColumnSize="128">715<>6</Field>
      <Field ColumnName="AllocReportTypeTradeDate" ColumnSize="128">794<>75</Field>
      <Field ColumnName="AllocStatusTradeInputSource" ColumnSize="128">87<>578</Field>
      <Field ColumnName="NoOrdersText" ColumnSize="128">73<>58</Field>
      <Field ColumnName="ClOrdIDLiquidityIndicator" ColumnSize="128">11<>9120</Field>
      <Field ColumnName="NoExecsNoAllocs" ColumnSize="128">124<>78</Field>
      <Field ColumnName="TrdTypeRequestID" ColumnSize="128">828<>9415</Field>
      <Field ColumnName="SymbolSide" ColumnSize="128">55<>54</Field>

    </History>

    <Field<History ColumnNameName="SecurityTypeICEPOFAllocationExecs" ColumnSize="128">167</Field>

           <Field ColumnName="MaturityMonthYear" ColumnSizeStorageType="128ODBC">200</Field>
       <Field ColumnName="PutOrCall" ColumnSize="128">201</Field>      TableName="ICEPOFAllocationExecs"
      <Field ColumnName="StrikePrice"       ColumnSize="128256">202</Field>
      <Field ColumnName="SecurityExchange" ColumnSize="128">207</Field>
      <Field ColumnName="Shares" ColumnSize="128">53</Field>ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
      <Field<KeyField ColumnName="AvgPxAllocID" ColumnSize="128256">6<>70</Field>KeyField>
      <Field<KeyField ColumnName="TradeDateTransactTime" ColumnSize="128">75<>60</Field>KeyField>
      <Field<KeyField ColumnName="TradeInputSourceExecEntry" ColumnSize="128">578<>7771</Field>KeyField>
      <Field ColumnName="TextLastShares" ColumnSize="128">58<>32</Field>
      <Field ColumnName="LiquidityIndicatorExecID" ColumnSize="128">9120<>17</Field>
      <Field ColumnName="NoAllocsLastPx" ColumnSize="128">78<>31</Field>
    </History>
  <Field  <History NameColumnName="ICEPOFAllocationExecsTradeID"
             StorageType ColumnSize="ODBC128"
     >1003</Field>
      <Field ColumnName="ClientAppType" MaxNumberOfRecordsColumnSize="15000"
128">9413</Field>	  
    </History>

    <History   TableNameName="ICEPOFAllocationExecsICEPOFAllocationAllocs"
             ColumnSizeStorageType="256ODBC"
             ConnectionStringTableName="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">ICEPOFAllocationAllocs"
      <KeyField ColumnName="AllocID"       ColumnSize="256">70</KeyField>
      <KeyField ColumnName="TransactTime" ColumnSize="128">60</KeyField>
       <KeyField ColumnName="ExecEntry" ColumnSize="128">7771</KeyField>ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
      <Field<KeyField ColumnName="LastSharesAllocID" ColumnSize="128256">32<>70</Field>KeyField>
      <Field<KeyField ColumnName="ExecIDTransactTime" ColumnSize="128">17<>60</Field>KeyField>
      <Field<KeyField ColumnName="LastPxAllocEntry" ColumnSize="128">31<>7772</Field>KeyField>
      <Field ColumnName="TradeIDAllocShares" ColumnSize="128">1003<>80</Field>
      <Field ColumnName="ClientAppTypeAllocAccount" ColumnSize="128">9413<>79</Field>   
    </History>
    <History Name="ICEPOFAllocationAllocs"
   <Field ColumnName="AllocPrice" ColumnSize="128">366</Field>
      <Field ColumnName="SecondaryIndividualAllocID" StorageTypeColumnSize="ODBC128">989</Field>
      <Field       MaxNumberOfRecordsColumnName="IndividualAllocType" ColumnSize="15000128">992</Field>
      <Field       TableNameColumnName="AllocCustomerCapacity" ColumnSize="ICEPOFAllocationAllocs128">993</Field>
      <Field       ColumnName="AllocPositionEffect" ColumnSize="256"
    128">1047</Field>
      <Field   ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">ColumnName="AllocText" ColumnSize="128">161</Field>
      <KeyField<Field ColumnName="AllocIDSettlementAccountCode" ColumnSize="256128">70<>9194</KeyField>Field>
      <KeyField<Field ColumnName="TransactTimeAllocAcceptanceTime" ColumnSize="128">60<>9060</KeyField>Field>
      <KeyField<Field ColumnName="AllocEntryNoAllocInfo" ColumnSize="128">7772</KeyField>
>9140</Field>
    </History>
	
    <History Name="ICEPOFAllocationAllocsInfo"
           <Field ColumnName="AllocShares" ColumnSizeStorageType="128ODBC">80</Field>
      <Field ColumnName="AllocAccount" ColumnSize="128">79</Field>
       TableName="ICEPOFAllocationAllocsInfo"
          <Field  ColumnName="AllocPrice" ColumnSize="128256">366</Field>
      <Field ColumnName="SecondaryIndividualAllocID" ColumnSize="128">989</Field>
      <Field ColumnName="IndividualAllocType" ColumnSize="128">992</Field>ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
      <Field<KeyField ColumnName="AllocCustomerCapacityAllocID" ColumnSize="128256">993<>70</Field>KeyField>
      <Field<KeyField ColumnName="AllocPositionEffectTransactTime" ColumnSize="128">1047<>60</Field>KeyField>
      <Field<KeyField ColumnName="AllocTextAllocEntry" ColumnSize="128">161<>7773</Field>KeyField>
      <Field<KeyField ColumnName="SettlementAccountCodeAllocInfoEntry" ColumnSize="128">9194<>7774</Field>KeyField>
      <Field ColumnName="AllocAcceptanceTimeAllocSideInfo" ColumnSize="128">9060<>9141</Field>
      <Field ColumnName="NoAllocInfoClientID" ColumnSize="128">9140<>109</Field>
    </History>
 
   <Field <History NameColumnName="ICEPOFAllocationAllocsInfoBrokerCompID"
             StorageType ColumnSize="ODBC128">9065</Field>
      <Field       MaxNumberOfRecordsColumnName="OriginatorUserID" ColumnSize="15000128">9139</Field>
      <Field       TableNameColumnName="AccountCode" ColumnSize="ICEPOFAllocationAllocsInfo128">9195</Field>
      <Field       ColumnName="TMMnemonic" ColumnSize="256128">9103</Field>
      <Field       ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">ColumnName="RIMnemonic" ColumnSize="128">9603</Field>
      <KeyField<Field ColumnName="AllocIDCMMnemonic" ColumnSize="256128">70<>9604</KeyField>Field>
      <KeyField<Field ColumnName="TransactTimeClrHouseCode" ColumnSize="128">60<>9609</KeyField>Field>
      <KeyField<Field ColumnName="AllocEntryCustomerAccountRefID" ColumnSize="128">7773<>9207</KeyField>Field>
      <KeyField<Field ColumnName="AllocInfoEntryCTICode" ColumnSize="128">7774<>9208</KeyField>Field>
    </History>
		
  <Field  <History ColumnNameName="AllocSideInfo" ColumnSize="128">9141</Field>
Sent_Allocation_ICE_POF"
             StorageType="ODBC"
           <Field ColumnName="ClientID" ColumnSizeTableName="128">109</Field>
Sent_Allocation_ICE_POF"
         <Field ColumnName="BrokerCompID"    ColumnSize="128256">9065</Field>
      <Field ColumnName="OriginatorUserID" ColumnSize="128">9139</Field>
      <Field ColumnName="AccountCode" ColumnSize="128">9195</Field>ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
      <Field<KeyField ColumnName="TMMnemonicAllocID" ColumnSize="128256">9103<>70</Field>KeyField>
      <Field<KeyField ColumnName="RIMnemonicTransactTime" ColumnSize="128">9603<>60</Field>KeyField>
      <Field ColumnName="CMMnemonic" ColumnSize="128">9604</Field>
      <Field ColumnName="ClrHouseCode" ColumnSize="128">9609</Field>
      <Field ColumnName="CustomerAccountRefID" ColumnSize="128">9207</Field>
    </History>
  
    <History Name="Sent_Allocation_ICE_POF"</History>

Change"Rule to notify java script creating Historic Request about established ICE POF FIX session" rule descriptions with corresponding rule from BL_Config.xml from the package(adjust change the SENDER_COMP_ID)

Code Block

language	xml
title	BL_Config.xml

<Rule Description="Rule to notify java script creating Historic Request about established ICE POF FIX session">
      <Source>
             StorageType="ODBC"<FixSession SenderCompID=".*" TargetCompID=".*" /> 
      </Source>
       MaxNumberOfRecords="15000"<Condition>
        <EqualField Field="35" Value="C" />
		<EqualField Field="50" TableNameValue="Sent_Allocation_ICE_POF"
             ColumnSize="256"Q1"/>
		<!-- PLACE YOUR SENDER COMP ID HERE -->
		<MatchMessage Value=".*147=\[NOTE\] 200055:ICE Established.*"/>
      </Condition>
       ConnectionString="DSN=ICE_POF;UID=pof_admin;Pwd=temp_pass;">
<Action>
	   <Script   <KeyField ColumnNameLanguage="AllocIDJavaScript" ColumnSizeFileName="256">70</KeyField>
FIXEdge1/conf/ICEPofHistoryReq.js"/>  
    <KeyField ColumnName="TransactTime" ColumnSize="128">60</KeyField>
 </Action>
     </History>Rule>

Change "Rule to notify java script creating Historic Request about established Save ICE POF FIX sessionAllocation Reports" rule descriptions as further described (adjust change the SENDER_COMP_ID)with corresponding rule descriptions from BL_Config.xml from the package

Code Block

language	xml
title	BL_Config.xml

<RuleRule Description="Rule to notify java script creating Historic Request about establishedSave ICE POF FIX session">
	<Source>
        	<FixSession SenderCompID=".*" TargetCompID="Allocation Reports">
	  <Source Name="ICEPOF.*" /> 
	</Source>
	<Condition>
	        <EqualField Field="35" Value="C" />  <Condition>
		<EqualField Field="50" Value="Q1"/>
		  <!-- PLACE YOUR SENDER COMP ID HERE -->
		<MatchMessage35" Value=".*147=\[NOTE\] SENDER_COMP_ID:ICE Established.*"J" />
	  </Condition>
	  <Action>
		<Script Language="JavaScript" FileName="FIXEdge1/conf/ICEPofHistoryReqICEPofAllocRpt.js" />
	  
	</Action>
	</Rule>

Add Change "Save ICE POF Allocation Execution Reports" rule descriptions as further described rule descriptions with corresponding rule descriptions from BL_Config.xml from the package

Code Block

language	xml
title	BL_Config.xml

 <Rule Description="Save ICE POF AllocationExecution Reports">
	      <Source Name="ICEPOF.*" />
	  <Condition>
		    <EqualField Field="35" Value="J8" />
	  </Condition>
		  <Action>
		    <Script Language="JavaScript" FileName="FIXEdge1/conf/ICEPofAllocRptICEPofExecRpt.js" />
	  </Action>
 	</Rule>

Database Schema update

Make a copy of your current Database scheme;
Run the ICE_POF_database.sql script. This script recreates these the tables (data will be lost):
- Execution Report (MsgType = ''8")
- Table: ICEPOFReports
- Table: ICEPOFReportsCombiDefinitions
- Table: Sent_Messages_ICE_POF

Allocation Report (MsgType = ''J")
Table: ICEPOFAllocation
Table: ICEPOFAllocationExecs
Table: ICEPOFAllocationAllocs
Table: ICEPOFAllocationAllocsInfo
Table: Sent_Allocation_ICE_POF;.

Page tree

Versions Compared

Old Version 2

New Version Current

Key

Overview

Upgrade Preparation

Upgrade of the existing configuration files

for FIXEdge

ICE Private Order Feed Drop Copy configuration update (instead of Upgrade of the existing ICE Private Order Feed Drop Copy setup, step 4)

Database Schema update

Page tree

Page History

Versions Compared

Old Version 2

New Version Current

Key

Overview

Upgrade Preparation

Upgrade of the existing configuration files

for FIXEdge

ICE Private Order Feed Drop Copy configuration update (instead of Upgrade of the existing ICE Private Order Feed Drop Copy setup, step 4)

Database Schema update