java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEMO.SYS_C007767) violated

Oracle Community | 3002728 | 5 months ago
  1. 0

    Failed to save assets

    Oracle Community | 5 months ago | 3002728
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEMO.SYS_C007767) violated
  2. 0

    FW_InvalidationMemory table not found

    Oracle Community | 3 years ago | Sups
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CSUSER"."TT1387030416308"."URL")
  3. 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")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Integrity constraint violated just when I commit the transaction

    Stack Overflow | 4 years ago | Julio
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (PERPLADM.ADDRESS_EMPLOYEE_FK) violated - parent key not found
  6. 0

    hibernate delete parent record if only no child record exist

    Stack Overflow | 2 years ago | Dilis
    java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (DEPOT_OS.SYS_C007642) violated - child record found
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 (DEMO.SYS_C007767) violated

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
    12 frames
  3. org.apache.tomcat
    DelegatingPreparedStatement.executeUpdate
    1. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    2. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    2 frames
  4. COM.FutureTense.Servlet
    JDBCTable$1.execute
    1. COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367)
    2. COM.FutureTense.Servlet.JDBCTable.access$000(JDBCTable.java:68)
    3. COM.FutureTense.Servlet.JDBCTable$1.execute(JDBCTable.java:1319)
    3 frames
  5. com.fatwire.cs
    NestedTransactionBlock.execute
    1. com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
    1 frame
  6. COM.FutureTense.Servlet
    JDBCTable.AddRow
    1. COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1324)
    2. COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211)
    3. COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943)
    3 frames
  7. COM.FutureTense.Common
    ftDBTable.insertRow
    1. COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1281)
    1 frame
  8. COM.FutureTense.CatalogManager
    CatalogEngine$2.execute
    1. COM.FutureTense.CatalogManager.CatalogEngine._addRowsToTable(CatalogEngine.java:1034)
    2. COM.FutureTense.CatalogManager.CatalogEngine.access$200(CatalogEngine.java:45)
    3. COM.FutureTense.CatalogManager.CatalogEngine$2.execute(CatalogEngine.java:968)
    3 frames
  9. com.fatwire.cs
    NestedTransactionBlock.execute
    1. com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
    1 frame
  10. COM.FutureTense.CatalogManager
    CatalogEngine.addRowsToTable
    1. COM.FutureTense.CatalogManager.CatalogEngine.addRowsToTable_trans(CatalogEngine.java:977)
    2. COM.FutureTense.CatalogManager.CatalogEngine.addRowsToTable(CatalogEngine.java:860)
    2 frames
  11. COM.FutureTense.Common
    CS.CatalogManager
    1. COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:778)
    2. COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3442)
    3. COM.FutureTense.Common.CS.CatalogManager(CS.java:1503)
    4. COM.FutureTense.Common.CS.CatalogManager(CS.java:1457)
    4 frames
  12. com.openmarket.xcelerate
    BulkAsset.SaveAllNoLocks
    1. com.openmarket.xcelerate.asset.BulkAsset.SaveAllNoLocks(BulkAsset.java:343)
    1 frame
  13. com.openmarket.assetframework
    ComplexAsset.SaveAllNoPubLock
    1. com.openmarket.assetframework.complexasset.ComplexAsset.superSaveListNoLocks(ComplexAsset.java:2440)
    2. com.openmarket.assetframework.complexasset.AssetManager.saveListNoLocks(AssetManager.java:1811)
    3. com.openmarket.assetframework.common.BulkTransactionalAssetManager.saveAllNoPubLock(BulkTransactionalAssetManager.java:305)
    4. com.openmarket.assetframework.complexasset.ComplexAsset.SaveAllNoPubLock(ComplexAsset.java:2460)
    4 frames
  14. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  15. com.openmarket.xcelerate
    Asset$4.execute
    1. com.openmarket.xcelerate.asset.Asset.callSaveAllNoPubLock(Asset.java:4763)
    2. com.openmarket.xcelerate.asset.Asset.SaveAll_logic(Asset.java:4992)
    3. com.openmarket.xcelerate.asset.Asset$4.execute(Asset.java:4917)
    3 frames
  16. com.fatwire.cs
    NestedTransactionBlock.execute
    1. com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
    1 frame
  17. com.openmarket.xcelerate
    Asset.SaveAll
    1. com.openmarket.xcelerate.asset.Asset.SaveAll_trans(Asset.java:4940)
    2. com.openmarket.xcelerate.asset.Asset.SaveAll(Asset.java:4894)
    2 frames
  18. com.openmarket.assetframework
    ComplexAsset.Save
    1. com.openmarket.assetframework.complexasset.ComplexAsset.superSaveAll(ComplexAsset.java:2523)
    2. com.openmarket.assetframework.complexasset.AssetManager.saveAll(AssetManager.java:1835)
    3. com.openmarket.assetframework.common.BulkTransactionalAssetManager.save(BulkTransactionalAssetManager.java:437)
    4. com.openmarket.assetframework.complexasset.ComplexAsset.Save(ComplexAsset.java:1144)
    4 frames
  19. com.openmarket.xcelerate
    AssetDispatcher.Save
    1. com.openmarket.xcelerate.asset.Asset.Save(Asset.java:3695)
    2. com.openmarket.xcelerate.commands.AssetDispatcher.Save(AssetDispatcher.java:273)
    2 frames
  20. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  21. com.openmarket.framework
    Dispatcher.Execute
    1. com.openmarket.framework.commands.Dispatcher.Execute(Dispatcher.java:145)
    1 frame
  22. COM.FutureTense.XML
    XMLEval.run
    1. COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:269)
    2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    4. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    5. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    6. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    7. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    8. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    9. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    10. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    11. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    12. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    13. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    14. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    15. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    16. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
    17. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
    17 frames
  23. COM.FutureTense.Common
    ContentServer.processElement
    1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3290)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2551)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1999)
    3 frames
  24. COM.FutureTense.XML
    XMLEval.run
    1. COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
    2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    4. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    5. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    6. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    7. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    8. COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:241)
    9. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    10. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:233)
    11. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:233)
    12. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    13. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    14. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:501)
    15. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    16. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    17. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
    18. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
    18 frames
  25. COM.FutureTense.Common
    CS.CallElement
    1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3290)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2551)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1999)
    4. COM.FutureTense.Common.CS.CallElement(CS.java:1603)
    4 frames
  26. com.divine.ics
    CallElement.doEndTag
    1. com.divine.ics.jsp.CallElement.doEndTag(CallElement.java:84)
    1 frame
  27. com.openmarket.framework
    Base.doEndTag
    1. com.openmarket.framework.jsp.Base.doEndTag(Base.java:143)
    1 frame
  28. org.apache.jsp
    ApplicationPage_jsp._jspService
    1. org.apache.jsp.jsp.cs_005fdeployed.OpenMarket.Xcelerate.UIFramework.ApplicationPage_jsp._jspx_meth_ics_005fcallelement_005f1(ApplicationPage_jsp.java:273)
    2. org.apache.jsp.jsp.cs_005fdeployed.OpenMarket.Xcelerate.UIFramework.ApplicationPage_jsp._jspx_meth_ics_005felse_005f0(ApplicationPage_jsp.java:246)
    3. org.apache.jsp.jsp.cs_005fdeployed.OpenMarket.Xcelerate.UIFramework.ApplicationPage_jsp._jspService(ApplicationPage_jsp.java:124)
    3 frames
  29. GWT dev
    HttpJspBase.service
    1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    1 frame
  30. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    1 frame
  31. GWT dev
    JspServlet.service
    1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
    2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    3 frames
  32. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    1 frame
  33. Glassfish Core
    ApplicationDispatcher.include
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    4. org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
    5. org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
    5 frames
  34. COM.FutureTense.Servlet
    JSPServices.runJSP
    1. COM.FutureTense.Servlet.ServletRequest.include(ServletRequest.java:1411)
    2. COM.FutureTense.Servlet.FRequestObj.include(FRequestObj.java:1428)
    3. COM.FutureTense.Servlet.JSPServices.runJSP(JSPServices.java:111)
    3 frames
  35. COM.FutureTense.Platform
    FILESYSTEMJSPManager.runJSP
    1. COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager.runJSP(FILESYSTEMJSPManager.java:463)
    1 frame
  36. COM.FutureTense.Servlet
    JSPServices.runJSPObject
    1. COM.FutureTense.Servlet.JSPServices.runJSPObject(JSPServices.java:50)
    1 frame
  37. COM.FutureTense.Platform
    FILESYSTEMJSPManager$JSPDataFile.run
    1. COM.FutureTense.Platform.FileSystem.FILESYSTEMJSPManager$JSPDataFile.run(FILESYSTEMJSPManager.java:190)
    1 frame
  38. COM.FutureTense.Common
    ContentServer.execute
    1. COM.FutureTense.Common.ContentServer.jspExecute(ContentServer.java:3027)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2621)
    3. COM.FutureTense.Common.ContentServer.generatePage(ContentServer.java:1640)
    4. COM.FutureTense.Common.ContentServer.evalPage(ContentServer.java:1276)
    5. COM.FutureTense.Common.ContentServer.execute(ContentServer.java:465)
    5 frames
  39. COM.FutureTense.Servlet
    FTServlet.doPost
    1. COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
    2. COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61)
    2 frames
  40. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    2 frames
  41. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  42. com.fatwire.auth
    RequestAuthenticationFilter.doFilter
    1. com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193)
    1 frame
  43. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  44. COM.FutureTense.Servlet
    URLRewriteFilter.doFilter
    1. COM.FutureTense.Servlet.URLRewriteFilter.doFilter(URLRewriteFilter.java:81)
    1 frame
  45. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  46. com.fatwire.wem
    SSOFilter.doFilter
    1. com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:241)
    2. com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
    2 frames
  47. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  48. com.fatwire.cs
    UIFilter.doFilter
    1. com.fatwire.cs.ui.framework.UIFilter.doFilter(UIFilter.java:108)
    1 frame
  49. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    7. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
    8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    9 frames
  50. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    3 frames
  51. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame