Importing space into Confluence results in ORA-22993 error
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Summary
Problem
When importing a space into Confluence, the import fails with an ORA-22993 error. The following appears in the UI:
1
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:
1select * 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).
Solution
Resolution
Change the target character set to AL32UTF8 OR recreate the target database with the AL32UTF8 character set.
Was this helpful?