Failed to upgrade confluence with error: Caused by: java.sql.SQLException: ORA-12899: value too large for column

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

The following appears in the atlassian-confluence.log:

Caused by: java.sql.SQLException: ORA-12899: value too large for column "CONFPROD5"."AO_9412A1_AONOTIFICATION"."GLOBAL_ID" (actual: 419, maximum: 255)

Cause

There is an entry(s) in your existing database that is too long. It may be because of the encoding that is being used in your previous database, which does not match up to the encoding you have set for Oracle.

Resolution


Truncate all data with column length larger than 255.


 update <table_name> set <column_name>= left(<column_name>, 255) where length(<column_name>) > 255;

Example:

value too large for column "CONFPROD5"."AO_9412A1_AONOTIFICATION"."GLOBAL_ID" (actual: 419, maximum: 255)
update AO_9412A1_AONOTIFICATION set GLOBAL_ID= left(GLOBAL_ID, 255) where length(GLOBAL_ID) > 255;


(info) You might need to check if your database collation is supported


Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.