[CONFSERVER-36588] XML Space import failed in Oracle databases

Type: Bug
Resolution: Duplicate
Priority: High
Fix Version/s: None
Affects Version/s: 5.7
Component/s: None
Labels:

Bug Fix Policy:
View Atlassian Server bug fix policy

NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

Steps to Reproduce:

Install Confluence 5.7 with any databases (e.g. Postgres, HSQL)
Create a space.
Export the Space.
Install another Confluence 5.7 with Oracle database.
Import the space.

Expected Behavior:

Should be able to import the Space Backup.

Actual Behavior:

Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated

Following appears in the log:


2015-02-19 13:21:15,725 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import
-- referer: http://10.60.4.82:8090/admin/backup.action | url: /admin/restore.action | userName: admin | action: restore
com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated

at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:430)
at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:388)
at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:150)
at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:259)
at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:50)
at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:50)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:211)
at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:77)
...
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated

at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:73)
at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:420)
... 30 more
Caused by: org.xml.sax.SAXException: Error while importing backup: Could not execute JDBC batch update
net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:55)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103)
at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:110)
at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:61)
... 31 more
Caused by: net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:73)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:135)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2465)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2419)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2288)
at com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.flushIfNeeded(ImportProcessorContext.java:246)
at com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.objectImported(ImportProcessorContext.java:81)
at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:50)
at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:37)
at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:51)
... 43 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
... 51 more
caused by:
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10298)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10404)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
....

Workaround

Delete any previously failed, half-imported space.
Shut down Confluence.

Run the following query in database:

alter table
CONTENT_PERM
DISABLE constraint
CP_UNIQUE_USER_GROUPS;

Start Confluence.
Import Space.
Shut down Confluence again.
Run the following query in database:
```
alter table
CONTENT_PERM
ENABLE constraint
CP_UNIQUE_USER_GROUPS;
```
Please backup your database before running the above query.

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

SpaceBug.png
35 kB
19/Feb/2015 5:45 AM

is detailed by

CONFSERVER-35969 XML space import failed from the latest OD for Oracle Database

Closed

is related to

CONFSERVER-36430 On certain configurations, the attachments upgrade task very slow or hangs when upgrading to 5.7

Closed

relates to

CONFCLOUD-36588 XML Space import failed in Oracle databases

Closed

Rick Carini added a comment - 14/Mar/2023 2:02 AM

Occurs with Import of Cloud to DC 7.13.8 with some imports

Rick Carini added a comment - 14/Mar/2023 2:02 AM Occurs with Import of Cloud to DC 7.13.8 with some imports

Tomas added a comment - 02/Jun/2021 11:05 AM

Same Problem in Version 7.4.8 from Cloud Export.

Tomas added a comment - 02/Jun/2021 11:05 AM Same Problem in Version 7.4.8 from Cloud Export.

alifada63 added a comment - 15/Jun/2017 7:34 PM

I resolved this issue , when I pressed import the xml file , and I run sqlplus

this command alter table USER_MAPPING disable constraint UNQ_LWR_USERNAME

and I kept pressing this command continuously the import passed 100 % and the system worked successfully .

the issue was there is two values with the same name ,after the I mported the xml file just i edit one of them to another value and enabled the constraint .

KR

Ammar

alifada63 added a comment - 15/Jun/2017 7:34 PM I resolved this issue , when I pressed import the xml file , and I run sqlplus this command alter table USER_MAPPING disable constraint UNQ_LWR_USERNAME and I kept pressing this command continuously the import passed 100 % and the system worked successfully . the issue was there is two values with the same name ,after the I mported the xml file just i edit one of them to another value and enabled the constraint . KR Ammar

Stemcell Helpdesk added a comment - 01/Jun/2017 1:27 AM

This issue does not appear to be resolved... it just occurred attempting a space import on Confluence version 6.2.1

Stemcell Helpdesk added a comment - 01/Jun/2017 1:27 AM This issue does not appear to be resolved... it just occurred attempting a space import on Confluence version 6.2.1

Details

Description

Steps to Reproduce:

Expected Behavior:

Actual Behavior:

Attachments

Attachments

Issue Links

Forms

Activity

Collapse comment: Rick Carini added a comment - 14/Mar/2023 2:02 AM

Expand comment: Rick Carini added a comment - 14/Mar/2023 2:02 AM

Collapse comment: Tomas added a comment - 02/Jun/2021 11:05 AM

Expand comment: Tomas added a comment - 02/Jun/2021 11:05 AM

Collapse comment: alifada63 added a comment - 15/Jun/2017 7:34 PM

Expand comment: alifada63 added a comment - 15/Jun/2017 7:34 PM

Collapse comment: Stemcell Helpdesk added a comment - 01/Jun/2017 1:27 AM

Expand comment: Stemcell Helpdesk added a comment - 01/Jun/2017 1:27 AM

People

Dates