java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SITESUSER.I1435333282413) violated

Oracle Community | Sremugaan | 2 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Error in Mirroring site to target sytem in WCS

    Oracle Community | 2 years ago | Sremugaan
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SITESUSER.I1435333282413) violated
  2. 0

    GitHub comment 2440#254041246

    GitHub | 7 months ago | gpproton
    liquibase.exception.DatabaseException: ORA-01400: cannot insert NULL into ("TRACCAR"."SERVER"."ID") INFO | jvm 1 | 2016/10/16 12:18:15 | WrapperSimpleApp Error: [Failed SQL: INSERT INTO TRACCAR.server (registration, latitude, longitude, zoom) VALUES (1, 0, 0, 0)]

Root Cause Analysis

  1. java.sql.SQLIntegrityConstraintViolationException

    ORA-00001: unique constraint (SITESUSER.I1435333282413) violated

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OracleStatementWrapper.execute
    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.T4CStatement.doOall8(T4CStatement.java:193)
    8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    10. oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4680)
    11. oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4825)
    12. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1913)
    13. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
    14. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
    14 frames
  3. weblogic.jdbc.wrapper
    Statement.execute
    1. weblogic.jdbc.wrapper.Statement.execute(Statement.java:485)
    1 frame
  4. COM.FutureTense.Servlet
    JDBCConn$1.execute
    1. COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:995)
    2. COM.FutureTense.Servlet.JDBCConn$1.execute(JDBCConn.java:606)
    2 frames
  5. com.fatwire.cs
    NestedTransactionBlock.execute
    1. com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
    1 frame
  6. COM.FutureTense.Servlet
    JDBCConn.ExecuteQuery
    1. COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:611)
    1 frame
  7. COM.FutureTense.Common
    ftDBTable.doSQL
    1. COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2199)
    2. COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2186)
    2 frames
  8. COM.FutureTense.CatalogManager
    MirrorEngine$1.execute
    1. COM.FutureTense.CatalogManager.MirrorEngine.commitTables_trans_logic(MirrorEngine.java:3960)
    2. COM.FutureTense.CatalogManager.MirrorEngine$1.execute(MirrorEngine.java:3634)
    2 frames
  9. com.fatwire.cs
    NestedTransactionBlock.execute
    1. com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189)
    1 frame
  10. COM.FutureTense.CatalogManager
    MirrorEngine.commitTables
    1. COM.FutureTense.CatalogManager.MirrorEngine.commitTables_trans(MirrorEngine.java:3639)
    2. COM.FutureTense.CatalogManager.MirrorEngine.commitTables(MirrorEngine.java:3118)
    2 frames
  11. COM.FutureTense.Common
    CatalogManager.execute
    1. COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:2024)
    1 frame
  12. 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
  13. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  14. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  15. com.fatwire.cs
    HttpFilter.doFilter
    1. com.fatwire.cs.core.logging.context.filter.ContextHeaderFilter.doFilterWork(ContextHeaderFilter.java:37)
    2. com.fatwire.cs.core.logging.context.filter.RunOncePerRequestFilter.doFilter(RunOncePerRequestFilter.java:54)
    3. com.fatwire.cs.core.logging.context.filter.HttpFilter.doFilter(HttpFilter.java:46)
    3 frames
  16. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  17. com.fatwire.auth
    RequestAuthenticationFilter.doFilter
    1. com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193)
    1 frame
  18. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  19. COM.FutureTense.Servlet
    URLRewriteFilter.doFilter
    1. COM.FutureTense.Servlet.URLRewriteFilter.doFilter(URLRewriteFilter.java:81)
    1 frame
  20. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  21. com.fatwire.wem
    SSOFilter.doFilter
    1. com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:701)
    2. com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
    2 frames
  22. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    3 frames
  23. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  24. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  25. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    3 frames
  26. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames