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

Oracle Community | Sremugaan | 1 year 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

    Error in Mirroring site to target sytem in WCS

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

    GitHub comment 2440#254041246

    GitHub | 5 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.I1435333282216) 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