com.atlassian.confluence.importexport.ImportExportException

Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web186

  • via Atlassian JIRA by Mauro Fernandez Badii [Atlassian], 1 year ago
    Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at
  • via Atlassian JIRA by Mauro Fernandez Badii [Atlassian], 11 months ago
    Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at
  • via Atlassian JIRA by Paula Silveira [Atlassian], 10 months ago
    Unable to complete import: Error while importing backup: The scope of the import extends outside of the space. 2016-07-04 11:00:20.029368500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:67
  • Stack trace

    • com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at $Proxy331.performImport(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.