java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EPM_FDMEE.AIF_COA_LEDGERS_U2) violated

Oracle Community | 1063612 | 2 years ago
  1. 0

    FDMEE Intialize Source System error

    Oracle Community | 2 years ago | 1063612
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EPM_FDMEE.AIF_COA_LEDGERS_U2) violated
  2. 0

    BIAPPS ODI loading error ORA-02291: integrity constraint C_SRC_DOMAIN_MEMBER_TL_FK violated - parent key not found

    Oracle Community | 1 year ago | maskebe
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (C_SRC_DOMAIN_MEMBER_TL_FK) violated - parent key not found
  3. 0

    Unique constraint issue with Finance Load

    Oracle Community | 3 years ago | Saro
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_DW.W_POSITION_DH_U2) violated
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Missing Expression error in ODI

    Oracle Community | 5 years ago | 858592
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SALES_DEV"."TRG_CUSTOMER"."CITY_ID")
  6. 0

    Synchronizing changes between sql developer and ODI

    Oracle Community | 5 years ago | 926353
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: Schending van UNIQUE-beperking (TIME_UK).

  1. Michael 1 times, last 4 months ago
  2. kkandda 12 times, last 6 months ago
2 unregistered visitors
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 (EPM_FDMEE.AIF_COA_LEDGERS_U2) violated

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    12 frames
  3. oracle.odi.runtime
    TaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
    2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
    4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
    4 frames
  4. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
    6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)
    6 frames
  5. oracle.odi.runtime
    StartScenRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
    1 frame
  6. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  7. oracle.odi.runtime
    DefaultAgentTaskExecutor$1.run
    1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
    2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
    3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)
    4 frames
  8. Spring Core
    SyncTaskExecutor.execute
    1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
    1 frame
  9. oracle.odi.runtime
    AgentServlet.doPost
    1. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)
    2. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)
    3. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)
    4. oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
    5. oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)
    6. oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)
    6 frames
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  11. 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
  12. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    2. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
    3. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
    4. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    5. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    6. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    6 frames
  13. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  14. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
    1 frame
  15. 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
  16. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  17. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  18. 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
  19. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames