com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string: "2016-02-08 19:54:35.123"

Atlassian JIRA | Jing Hwa [Atlassian] | 1 year ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    h3. Summary Backup created from Cloud instance cannot be restore if it contains audit logs h3.Step to replicate: # Ensure that there are entries in the [Audit log|https://confluence.atlassian.com/confcloud/audit-log-802164269.html]. If there is no entries in the audit logs, try to make some modication to the user to create a few entries. # Create a backup from Cloud # Restore the backup to the latest OD version 6.0.0-OD-2016.06.1-0009 h3. Expected Result The backup successfully restore. h3. Observed Result The backup fail to restored with error similar to the following: {code} 2016-02-10 11:29:16,745 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | traceId: a172a52c7cd939d9 | userName: admin | action: longrunningtaskxml com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string: "2016-02-08 19:54:35.123" at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:400) {code} The issue seem to be cause by entries from {{auditrecord}} table. h3. Workaround 1 Manually delete all the object related to {{com.atlassian.confluence.impl.audit}} package from the entities.xml in the backup h3.Workaround 2 Create a support ticket in support.atlassian.com to request our Cloud Support Engineer to create a backup without the data from the following table since they have references against each other: * audit_affected_object * audit_changed_value * auditrecord

    Atlassian JIRA | 1 year ago | Jing Hwa [Atlassian]
    com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string: "2016-02-08 19:54:35.123"
  2. 0

    h3. Summary Backup created from Cloud instance cannot be restore if it contains audit logs h3.Step to replicate: # Ensure that there are entries in the [Audit log|https://confluence.atlassian.com/confcloud/audit-log-802164269.html]. If there is no entries in the audit logs, try to make some modication to the user to create a few entries. # Create a backup from Cloud # Restore the backup to the latest OD version 6.0.0-OD-2016.06.1-0009 h3. Expected Result The backup successfully restore. h3. Observed Result The backup fail to restored with error similar to the following: {code} 2016-02-10 11:29:16,745 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | traceId: a172a52c7cd939d9 | userName: admin | action: longrunningtaskxml com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string: "2016-02-08 19:54:35.123" at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:400) {code} The issue seem to be cause by entries from {{auditrecord}} table. h3. Workaround 1 Manually delete all the object related to {{com.atlassian.confluence.impl.audit}} package from the entities.xml in the backup h3.Workaround 2 Create a support ticket in support.atlassian.com to request our Cloud Support Engineer to create a backup without the data from the following table since they have references against each other: * audit_affected_object * audit_changed_value * auditrecord

    Atlassian JIRA | 1 year ago | Jing Hwa [Atlassian]
    com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string: "2016-02-08 19:54:35.123"
  3. 0

    [CONF-18509] MySQL databases incapabable of handling 4byte UTF-8 Characters. Confluence should handle this gracefully - Atlassian JIRA

    atlassian.com | 1 year ago
    com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.I mportExportException: Unable to complete : Error importing backup: could not insert: [bu cket.user.propertyset.BucketPropertySetItem#BucketPropertySetItem[entityId=340,entityName=confluence _ContentEntityObject,key=atlassian.dynamictasklist:ToDo,_������,type=6, = ,string=< >,t ext=<com.atlassian.confluence.extra.dynamictasklist.model.TaskList> <name>ToDo,_�������</name> <tasks class= resolves-to="java.util.Collectio ns-SynchronizedList"> <list> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>��������������� ������ � JIRA - ������� �� ����� Jira (���������</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>��������������� ������ � JIRA - ������� �� ����� Jira (���������</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>test</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>test sdfsdf</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>test</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>111</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>test</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>dddd</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>gfdgdfg</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>Apples</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name></name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>��������������. ������ ��������</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name></name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>111</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> <com.atlassian.confluence.extra.dynamictasklist.model.Task> <name>admins. reestr serverov</name> </com.atlassian.confluence.extra.dynamictasklist.model.Task> </list> <c class= reference= /> <mutex class= > <list reference= /> <c class= reference= /> <mutex class= reference= /> </mutex> </tasks> </com.atlassian.confluence.extra.dynamictasklist.model.TaskList>, =0, =0.0, =0,date=< >]]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When I start to migrate in the log ERROR. {code} 2015-01-22 11:06:50,037 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: -- url: /admin/restore-local-file.action | userName: gonchik | referer: http://192.168.139.201:8090/admin/backup.action | action: restore-local-file com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:76) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:387) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:355) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy93.performImport(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:88) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) 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: org.xml.sax.SAXException: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType net.sf.hibernate.PropertyValueException: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:53) 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:108) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:60) ... 32 more Caused by: net.sf.hibernate.PropertyValueException: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType at net.sf.hibernate.impl.SessionImpl.checkNullability(SessionImpl.java:1302) at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:954) at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:883) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:837) at com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.saveObject(ImportProcessorContext.java:286) at com.atlassian.confluence.importexport.xmlimport.persister.ReflectiveObjectPersister.persist(ReflectiveObjectPersister.java:207) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:46) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:36) at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:49) ... 44 more 2015-01-22 11:06:50,055 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- url: /admin/restore-local-file.action | userName: gonchik | referer: http://192.168.139.201:8090/admin/backup.action | action: restore-local-file com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:397) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:355) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy93.performImport(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:88) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) {code}

    Atlassian JIRA | 2 years ago | Gonchik Tsymzhitov
    com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType
  6. 0

    h6. 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. h6. Expected Behavior: Should be able to import the Space Backup. h6. Actual Behavior: !SpaceBug.png|width=512! {code} 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 {code} Following appears in the log: {code} 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) .... {code} *Workaround* # Delete any previously failed, half-imported space. # Shut down Confluence. # Run the following query in database: {code} alter table CONTENT_PERM DISABLE constraint CP_UNIQUE_USER_GROUPS; {code} # Start Confluence. # Import Space. # Shut down Confluence again. # Run the following query in database: {code} alter table CONTENT_PERM ENABLE constraint CP_UNIQUE_USER_GROUPS; {code} (!) *Please backup your database before running the above query.*

    Atlassian JIRA | 2 years ago | Saleh Parsa
    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

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.atlassian.confluence.importexport.ImportExportException

      com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string: "2016-02-08 19:54:35.123"

      at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities()
    2. com.atlassian.confluence
      BackupImporter.importEntities
      1. com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:400)
      1 frame