java.lang.RuntimeException: Unable to save result data

GitHub | mraross | 2 months ago
  1. 0

    GitHub comment 42#254330249

    GitHub | 2 months ago | mraross
    java.lang.RuntimeException: Unable to save result data
  2. 0

    auctionmark workload for oracle throws exception

    GitHub | 3 years ago | awajeet
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("TPCC"."ITEM_IMAGE"."II_SATTR0")
  3. 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
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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 [Atlassian]
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated
  6. 0

    OIA Account Import Error

    Oracle Community | 4 years ago | 967853
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("RBACXSERVICE"."ACCOUNTS"."NAME")

    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-01400: cannot insert NULL into ("CPF"."CPF_BATCH_JOB_FILES"."DATA") ORA-06512: at line 1

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.executeBatch
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
      8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10143)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10249)
      11. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
      11 frames
    3. Apache Commons DBCP
      DelegatingStatement.executeBatch
      1. org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
      2. org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
      2 frames
    4. RS Core
      JdbcWriterWrapper.write
      1. com.revolsys.jdbc.io.JdbcWriterImpl.processCurrentBatch(JdbcWriterImpl.java:578)
      2. com.revolsys.jdbc.io.JdbcWriterImpl.insert(JdbcWriterImpl.java:512)
      3. com.revolsys.jdbc.io.JdbcWriterImpl.insert(JdbcWriterImpl.java:475)
      4. com.revolsys.jdbc.io.JdbcWriterImpl.write(JdbcWriterImpl.java:692)
      5. com.revolsys.jdbc.io.JdbcWriterImpl.write(JdbcWriterImpl.java:33)
      6. com.revolsys.jdbc.io.JdbcWriterWrapper.write(JdbcWriterWrapper.java:67)
      7. com.revolsys.jdbc.io.JdbcWriterWrapper.write(JdbcWriterWrapper.java:7)
      7 frames
    5. ca.bc.gov
      AbstractBatchJobChannelProcess.lambda$schedule$0
      1. ca.bc.gov.open.cpf.api.domain.CpfDataAccessObject.write(CpfDataAccessObject.java:938)
      2. ca.bc.gov.open.cpf.api.domain.CpfDataAccessObject.write(CpfDataAccessObject.java:910)
      3. ca.bc.gov.open.cpf.api.web.controller.DatabaseJobController.newJobFile(DatabaseJobController.java:181)
      4. ca.bc.gov.open.cpf.api.web.controller.AbstractJobController.setJobResult(AbstractJobController.java:147)
      5. ca.bc.gov.open.cpf.api.scheduler.BatchJobService.newBatchJobResult(BatchJobService.java:908)
      6. ca.bc.gov.open.cpf.api.scheduler.JobPreProcessTask.addJobValidationError(JobPreProcessTask.java:117)
      7. ca.bc.gov.open.cpf.api.scheduler.JobPreProcessTask.process(JobPreProcessTask.java:295)
      8. ca.bc.gov.open.cpf.api.scheduler.BatchJobService.preProcessBatchJob(BatchJobService.java:1228)
      9. ca.bc.gov.open.cpf.api.scheduler.BatchJobPreProcess.processJob(BatchJobPreProcess.java:53)
      10. ca.bc.gov.open.cpf.api.scheduler.AbstractBatchJobChannelProcess.lambda$schedule$0(AbstractBatchJobChannelProcess.java:191)
      10 frames
    6. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      2 frames
    7. RS Core
      LoggingRunnable.run
      1. com.revolsys.logging.LoggingRunnable.run(LoggingRunnable.java:13)
      1 frame
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame