Page Comparison

Configuration files

OrderEntry, TIP and ServiceLayer configs all have to update the version number of the assembly redirect binding for common.logging and Newtonsoft.Json.

Before

 <assemblyIdentity name="Common.Logging" publicKeyToken="af08829b84f0328e" culture="neutral" />
 <bindingRedirect oldVersion="0.0.0.0-2.0.0.0" newVersion="2.0.0.0" />

 <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
 <bindingRedirect oldVersion="0.0.0.0-4.0.8.0" newVersion="4.0.8.0" />

 <assemblyIdentity name="Apache.NMS" publicKeyToken="82756feee3957618" culture="neutral" />
 <bindingRedirect oldVersion="0.0.0.0-1.4.0.2075" newVersion="1.4.0.2075" />

Now

 <assemblyIdentity name="Common.Logging" publicKeyToken="af08829b84f0328e" culture="neutral" />
 <bindingRedirect oldVersion="0.0.0.0-2.1.1.0" newVersion="2.1.1.0" />

 <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
 <bindingRedirect oldVersion="0.0.0.0-4.5.0.0" newVersion="4.5.0.0" />

 <assemblyIdentity name="Apache.NMS" publicKeyToken="82756feee3957618" culture="neutral" />
 <bindingRedirect oldVersion="0.0.0.0-1.5.0.2194" newVersion="1.5.0.2194" />

...

The client config needs this added:

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Common.Logging" publicKeyToken="af08829b84f0328e" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-2.1.1.0" newVersion="2.1.1.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Spring.Data" publicKeyToken="65e474d141e25e07" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.3.2.40943" newVersion="1.3.2.40943" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Spring.Core" publicKeyToken="65e474d141e25e07" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.3.2.40943" newVersion="1.3.2.40943" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Spring.Aop" publicKeyToken="65e474d141e25e07" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.3.2.40943" newVersion="1.3.2.40943" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="NHibernate" publicKeyToken="aa95f207798dfdb4" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-3.2.0.4000" newVersion="3.2.0.4000" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Apache.NMS" publicKeyToken="82756feee3957618" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-1.5.0.2194" newVersion="1.5.0.2194" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.5.0.0" newVersion="4.5.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="InfragisticsWPF4.Controls.Editors.XamSlider.v11.2" publicKeyToken="7dd5c3163f2cd0cb" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-11.2.20112.2242" newVersion="11.2.20112.2242" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="InfragisticsWPF4.v11.2" publicKeyToken="7dd5c3163f2cd0cb" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-11.2.20112.2046" newVersion="11.2.20112.2046" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>

Database

Kodiak OMS 1.7 has a few additional database fields that need to be added before upgrading.

...

ALTER TABLE ALLOCATIONS ADD INTEREST_DAYS NUMBER(10,0) NULL;
ALTER TABLE ALLOCATIONS ADD YIELD FLOAT NULL;
ALTER TABLE ALLOCATIONS ADD INTEREST_AMOUNT FLOAT NULL;
ALTER TABLE ALLOCATIONS ADD INDEXATION_AMOUNT FLOAT NULL;

ALTER TABLE CUSTOMERS ADD DEFAULT_SEND_EMAIL bitNUMBER(1,0) NULL;

ALTER TABLE ALLOCATIONS ADD QUANTITY_TYPE INTNUMBER(10,0) NULL;

ALTER TABLE TRADE_REPORTS ADD INCLUDE_FEE_IN_PRICE NUMBER(1,0) NULL;
ALTER TABLE TRADE_REPORTS ADD FEE FLOAT NULL;
ALTER TABLE TRADE_REPORTS ADD ALLOCATION_PRICE FLOAT NULL;
ALTER TABLE TRADE_REPORTS ADD FEE_TYPE NUMBER(10,0) NULL;
ALTER TABLE TRADE_REPORTS ADD TOTAL_FEE FLOAT NULL;
ALTER TABLE TRADE_REPORTS ADD TOTAL_PAYMENT FLOAT NULL;

...

ALTER TABLE ALLOCATIONS ADD INTEREST_DAYS DOUBLE PRECISION NULL;
ALTER TABLE ALLOCATIONS ADD YIELD DOUBLE PRECISION NULL;
ALTER TABLE ALLOCATIONS ADD INTEREST_AMOUNT DOUBLE PRECISION NULL;
ALTER TABLE ALLOCATIONS ADD INDEXATION_AMOUNT DOUBLE PRECISION NULL;

ALTER TABLE CUSTOMERS ADD DEFAULT_SEND_EMAIL NUMBER(1,0)bit NULL;

ALTER TABLE ALLOCATIONS ADD QUANTITY_TYPE NUMBER(10,0)INT NULL;

ALTER TABLE TRADE_REPORTS ADD INCLUDE_FEE_IN_PRICE bit NULL;
ALTER TABLE TRADE_REPORTS ADD FEE DOUBLE PRECISION NULL;
ALTER TABLE TRADE_REPORTS ADD ALLOCATION_PRICE DOUBLE PRECISION NULL;
ALTER TABLE TRADE_REPORTS ADD FEE_TYPE INT NULL;
ALTER TABLE TRADE_REPORTS ADD TOTAL_FEE DOUBLE PRECISION NULL;
ALTER TABLE TRADE_REPORTS ADD TOTAL_PAYMENT FLOAT NULL;