java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated

Atlassian JIRA | Michael Jositz | 6 years ago
  1. 0

    We tried to import our 3.4.5 backup into Confluence 3.5.4 but get errors like: {code} 2011-05-23 11:20:30,191 ERROR [Importing data task] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local 2011-05-23 11:20:30,191 ERROR [Importing data task] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local 2011-05-23 11:20:30,191 ERROR [Importing data task] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported[com.atlassian.confluence.labels.Label] [Id[id]=24412184, Property[name]=permissions, Property[owner]=, Property[namespace]=global, Property[creationDate]=2009-08-21 09:44:59.000, Property[lastModificationDate]=2009-08-21 09:44:59.000] -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local 2011-05-23 11:20:30,191 ERROR [Importing data task] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#38502405]; SQL []; ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:61) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:212) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:173) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:103) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:104) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:71) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) 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 $Proxy83.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:55) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:21) at java.lang.Thread.run(Thread.java:619) Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#38502405]; SQL []; ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated 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 org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:198) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:93) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:45) ... 20 more Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#38502405]; SQL []; ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findByLabel(HibernateLabelDao.java:79) at com.atlassian.confluence.labels.DefaultLabelManager.getLabel(DefaultLabelManager.java:426) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) 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 com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy28.getLabel(Unknown Source) at com.atlassian.confluence.importexport.xmlimport.persister.ReflectiveObjectPersister.persist(ReflectiveObjectPersister.java:111) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:42) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:32) at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:49) ... 33 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2390) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1819) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1576) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1541) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$1.doInHibernate(HibernateLabelDao.java:101) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) ... 53 more {code} The import fails.

    Atlassian JIRA | 6 years ago | Michael Jositz
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated
  2. 0

    We tried to import our 3.4.5 backup into Confluence 3.5.4 but get errors like: {code} 2011-05-23 11:20:30,191 ERROR [Importing data task] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local 2011-05-23 11:20:30,191 ERROR [Importing data task] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local 2011-05-23 11:20:30,191 ERROR [Importing data task] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported[com.atlassian.confluence.labels.Label] [Id[id]=24412184, Property[name]=permissions, Property[owner]=, Property[namespace]=global, Property[creationDate]=2009-08-21 09:44:59.000, Property[lastModificationDate]=2009-08-21 09:44:59.000] -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local 2011-05-23 11:20:30,191 ERROR [Importing data task] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: -- referer: https://our.server/confluence/setup/setup-restore-start.action | url: /confluence/setup/setup-restore-local.action | userName: anonymous | action: setup-restore-local com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#38502405]; SQL []; ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:61) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:212) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:173) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:103) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:104) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:71) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) 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 $Proxy83.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:55) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:21) at java.lang.Thread.run(Thread.java:619) Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#38502405]; SQL []; ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated 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 org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:198) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:93) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:45) ... 20 more Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#38502405]; SQL []; ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findByLabel(HibernateLabelDao.java:79) at com.atlassian.confluence.labels.DefaultLabelManager.getLabel(DefaultLabelManager.java:426) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) 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 com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy28.getLabel(Unknown Source) at com.atlassian.confluence.importexport.xmlimport.persister.ReflectiveObjectPersister.persist(ReflectiveObjectPersister.java:111) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:42) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:32) at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:49) ... 33 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2390) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1819) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1576) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1541) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$1.doInHibernate(HibernateLabelDao.java:101) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) ... 53 more {code} The import fails.

    Atlassian JIRA | 6 years ago | Michael Jositz
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated
  3. 0

    JDBC exceptionlarını Spring exceptionlarına dönüştürmek için nasıl bir yöntem uygulanmalı? - BTSoru.com

    btsoru.com | 7 months ago
    org.springframework.dao.DataIntegrityViolationException: could not delete: [core.domain.Test#1098323]; SQL [delete from test.test where id=? and versiyon=?]; constraint [TEST.FK_TEST_BORC_ODEME]; nested exception is org.hibernate.exception.ConstraintViolationException: could not delete: [core.domain.Test#1098323]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cannot insert NULL into column

    Stack Overflow | 5 years ago | Scott
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_1"."COL_A")
  6. 0

    jdbc implement test I get java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 违反唯一约束条件 (db.OAUTH_CLIENT_DETAILS_PK)

    GitHub | 2 years ago | jast90
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 违反唯一约束条件 (FCNJAVA.OAUTH_CLIENT_DETAILS_PK)
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. java.sql.SQLIntegrityConstraintViolationException

    ORA-00001: unique constraint (CONFLUENCE_3_5_4.CP_UNIQUE_USER_GROUPS) violated

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
    12 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeUpdate
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
    1 frame
  4. net.sf.hibernate
    QueryImpl.list
    1. net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
    2. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
    3. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
    4. net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
    5. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447)
    6. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433)
    7. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2390)
    8. net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1819)
    9. net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1576)
    10. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1541)
    11. net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
    11 frames
  5. com.atlassian.confluence
    HibernateLabelDao$1.doInHibernate
    1. com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$1.doInHibernate(HibernateLabelDao.java:101)
    1 frame
  6. Hibernate
    HibernateTemplate.execute
    1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
    1 frame
  7. Spring Framework
    SQLStateSQLExceptionTranslator.translate
    1. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)
    1 frame
  8. Hibernate
    HibernateTemplate.execute
    1. org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
    2. org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351)
    3. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
    4. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
    4 frames
  9. com.atlassian.confluence
    DefaultLabelManager.getLabel
    1. com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findByLabel(HibernateLabelDao.java:79)
    2. com.atlassian.confluence.labels.DefaultLabelManager.getLabel(DefaultLabelManager.java:426)
    2 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  11. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  12. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  13. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    1 frame
  14. com.atlassian.spring
    SpringProfilingInterceptor.invoke
    1. com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)
    1 frame
  15. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  16. Unknown
    $Proxy28.getLabel
    1. $Proxy28.getLabel(Unknown Source)
    1 frame
  17. com.atlassian.confluence
    BackupParser.endElement
    1. com.atlassian.confluence.importexport.xmlimport.persister.ReflectiveObjectPersister.persist(ReflectiveObjectPersister.java:111)
    2. com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:42)
    3. com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:32)
    4. com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:49)
    4 frames