...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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.
You can safely update the database while the older version is running, 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 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;
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 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;