Increase String length is not working

[former_member730677]

Hi,

As I am getting string data truncation error due to huge value, for existing attribute, I have added custom columns for the database in persistence column and done the system update. But it is still throwing data truncation error. If I create new attribute by adding these database columns, then it is working fine. But for existing attributes, it is not getting effected.

Is there any way to resolve this issue without doing system initialization.

Thanks,
Raghavendra

[Former Member]

use 'dontOptimize="true" while declaring your attribute and it will do the trick for you. :)

[mpern]

don't do that! dontOptimze has a considerable performance penalty

[arvind-kumar_avinash]

Hi - System Update does not alter the column size. You will need to alter the column size directly on the database. Every database allows increasing the column size e.g. the following command can be used in Oracle to increase the size of the column to 100.

 ALTER TABLE table_name MODIFY column_name VARCHAR2(100);

[mpern]

Unfortunately, that's to be expected.

The update process does not modify the column definition of existing attributes.

Workaround: ALTER the column directly in the database while the application servers are down.