java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

Oracle Community | Edwin-ACE | 5 months ago
  1. 1

    Failed Data Load - SIL

    Oracle Community | 5 months ago | Edwin-ACE
    java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  2. 0

    ODI Sequences error after deplopment: Missing IN or OUT parameter at index:: 1

    Oracle Community | 2 years ago | bb55232c-70b5-467b-aaec-a4eab129d656
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  3. 0

    ODI Load Plan in BI APPS 11.1.1.7.1

    Oracle Community | 3 years ago | user11156570
    java.sql.SQLException: ORA-20000: Error creating Index/Constraint : W_EMPLOYEE_DS_U1 => ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at line 213at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-01653: unable to extend table DW.W_ITEM_COST_G by 128 in tablespace DW_DATA

    Oracle Community | 2 years ago | 1020987
    java.sql.SQLException: ORA-01653: unable to extend table DW.W_ITEM_COST_G by 128 in tablespace DW_DATA
  6. 0

    Oracle Technical Information

    blogspot.com | 3 months ago
    java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49

  1. balintn 11 times, last 2 months ago
  2. Cafecanudo 2 times, last 3 months ago
18 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.SQLException

    ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    6. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    7. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    11. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    11 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:2925)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
    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:2093)
    6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
    6 frames
  5. oracle.odi.runtime
    StartScenRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
    1 frame