Skip to end of banner
Go to start of banner

SIL and Oracle upgrade guide

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Because Oracle treats an empty string the same as a null value, 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)

All you need to do is set the null values to an empty string (or a space, just to be sure). 

  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.0.

 

Filter by label

There are no items with the selected labels at this time.



  • No labels