Oracle upgrade guide

Because Oracle treats an empty string the same as a null value, and due to a bug in our upgrade task, it may happen that you loose some configuration from your database (e.g.: the SQL scripts longer that 255 characters from a database custom field). 

Step-by-step guide

Our old configuration used to memorize the configuration value (CFG_VALUE), the default configuration value (CFG_DEFAULT_VALUE), the long configuration value (CFG_L_VALUE), and the default long configuration value (CFG_L_DEFAULT_VALUE). In case that the first two columns are null and the other not, we need to set the first ones to a non-null (but still empty) value.

All you need to do is set the null values to a space before upgrading.

1. Execute the next SQL:

   UPDATE "KPLUGINSCFG"
   SET CFG_VALUE = ' ', CFG_DEFAULT_VALUE = ' '
   WHERE CFG_L_VALUE is not null

2. Now you can safely upgrade to katl-commons 4.0.x.

Related articles