Importing space into Confluence results in ORA-22993 error
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When importing a space into Confluence, the import fails with an ORA-22993 error. The following appears in the UI:
Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: Could not create Oracle LOB; nested exception is java.io.IOException: ORA-22993: specified input amount is greater than actual source amount.
Diagnosis
Environment
- Oracle
Diagnostic Steps
Verify that the database is using a character set other than AL32UTF8 by running the following query on the database:
select * from v$nls_parameters where parameter like '%CHARACTERSET%';
Cause
An ORA-22993 error occurs when the amount of data received is different from the amount that was indicated would be sent. This can be caused because of CLOB datatype in the table. Your database should be configured to use the same character encoding as Confluence. The recommended encoding is AL32UTF8 (the Oracle equivalent of Unicode UTF-8).