Page Comparison

...

...

...

...

Configuration files

OrderEntry, TIP , and ServiceLayer and Client 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" />

And is now:

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

 You can safely do find replace on the configs for each service and the client config.

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.

You can safely update the database while the older version is running, it Kodiak OMS will just ignore the additional fields.

ORACLE

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 NUMBER(1,0) NULL;

ALTER TABLE ALLOCATIONS ADD QUANTITY_TYPE NUMBER(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;

MSSQL

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 bit NULL;

ALTER TABLE ALLOCATIONS ADD QUANTITY_TYPE

...

 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;