The main topics in this hot fix upgrade notes are the removal of the supervisor role from the administrator users and the issue with the Oracle initial schema.
Removal of the supervisor role from the administrator users
In the case you already upgraded to 1.5.0.S92
please go through all administrator users and re-add the supervisor role if the role is needed, for example in service tasks etc.
Oracle NVARCHAR2
length
The problem is that Oracle does not support NVARCHAR2
columns with the length of 4000 characters. Depending on the database configuration the columns are automatically converted
to NCLOB
. All NVARCHAR2(4000)
database columns were converted to NVARCHAR2 (2000)
. In the case you already upgraded to 1.5.0.S92
and because we changed the Oracle
initial schema SQL script in this release you have to convert the following columns types from NVARCHAR2(4000)
to NVARCHAR2(2000)
:
ALTER TABLE EDW_GEAR_WRK_OBJ MODIFY( WRK_OBJ_DESCRIPTION NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_WRK_VAR MODIFY( WRK_VAR_STRING_VALUE NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_WRK_OBJ_DEF MODIFY( WRK_OBJ_DEF_DESCRIPTION NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_WRK_PROP MODIFY( WRK_PROP_STRING_VALUE NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_BEAT MODIFY( BEAT_DESCRIPTION NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_BEAT MODIFY( BEAT_SRC_OLD_VALUE_STRING NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_BEAT MODIFY( BEAT_SRC_NEW_VALUE_STRING NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_BEAT MODIFY( BEAT_VAR_STRING_VALUE NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_DOM_OBJ MODIFY( DOM_OBJ_DESCRIPTION NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_DOM_VAR MODIFY( DOM_VAR_STRING_VALUE NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_DOM_OBJ_DEF MODIFY( DOM_OBJ_DEF_DESCRIPTION NVARCHAR2(2000) );
ALTER TABLE EDW_GEAR_DOM_PROP MODIFY( DOM_PROP_STRING_VALUE NVARCHAR2(2000) );