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

## 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;


You might need to check if your database collation is supported