...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Table of Contents
Configuration changes
C:\KodiakServicesServer\Configs\KodiakServices.config
MembershipService has a new property (ExternalUserRepository) and now looks like this.
<object id="MembershipService" singleton="false" type="Kodi.Kodiak.Services.MembershipService, Kodi.Kodiak.Services"> <property name="UserRepository" ref="UserRepository"/> <property name="GroupRepository" ref="GroupRepository"/> <property name="AccessRuleListRepository" ref="AccessRuleListRepository"/> <property name="ExternalUserRepository" ref="ExternalUserRepository"/> <property name="UserEntityBuilder" ref="UserEntityBuilder"/> <property name="GroupEntityBuilder" ref="GroupEntityBuilder"/>
</object>
Database changes
Kodiak OMS 1.8 has a few new database fields and one new table.
Note that for Oracle the Kodiak User needs to be granted read/write access to the new USER_SYSTEM_ACCESS table.
MSSQL
ALTER TABLE USERS ADD TRADER_TYPE INT null; ALTER TABLE USERS ADD LAST_MODIFIED DATETIME null; ALTER TABLE USERS ADD COMMENTS varchar(500) null;
...
ALTER TABLE EXECUTIONS ADD EXECUTION_REPORT_DATE DATETIME; -- SET EXECUTION_REPORT_DATE to TRANSACTION_TIME but truncate the time part. UPDATE EXECUTIONS SET EXECUTION_REPORT_DATE = cast(convert(char(11), TRANSACTION_TIME, 113) as DATETIME); -- EXECUTION_REPORT_DATE should never be null ALTER TABLE EXECUTIONS ALTER COLUMN EXECUTION_REPORT_DATE DATETIME NOT NULL; ALTER TABLE ORDERS ADD LAST_TRANSACTION_TIME DATETIME;
ORACLE
ALTER TABLE USERS ADD TRADER_TYPE NUMBER(10,0) null; ALTER TABLE USERS ADD LAST_MODIFIED TIMESTAMP null; ALTER TABLE USERS ADD COMMENTS varchar2(500) null;
...