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

Oracle Community | 3002728 | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Failed to save assets

    Oracle Community | 9 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 | 6 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 | 3 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