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 | User799910-Oracle | 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. 1

    ODI-1217: Session SILOS_SIL_APTRANSACTIONFACT_REVERSE_DIFFMANLOAD (5782500) fails with return code 20942

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

    how can i increase performance of interface

    Oracle Community | 5 years ago | 970612
    java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified
  3. 0

    CASE in mapping interface

    Oracle Community | 6 years ago | tmazight
    java.sql.SQLException: Param├Ętre IN ou OUT absent dans l'index :: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error: while populating the target.

    Oracle Community | 6 years ago | 882628
    java.sql.SQLException: ORA-01471: cannot create a synonym with same name as object
  6. 0

    table partitioned then CDC journal

    Oracle Community | 6 years ago | 898042
    java.sql.SQLException: ORA-01403: no data found ORA-06512: in line 24
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)
    5 frames
  5. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:380)
    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$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:312)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:304)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:874)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)
    5 frames
  8. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame