java.sql.SQLException: ORA-20000: Error creating indexes in parallel, see W_ETL_EVENT_LOG for details ORA-06512: at line 119at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

Oracle Community | Hari Prasad Yarlagadda | 2 years 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

    ODI-1228: Task SIL_BudgetFact.W_ACCT_BUDGET_F (Integration) fails on the target ORACLE connection

    Oracle Community | 2 years ago | Hari Prasad Yarlagadda
    java.sql.SQLException: ORA-20000: Error creating indexes in parallel, see W_ETL_EVENT_LOG for details ORA-06512: at line 119at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  2. 0

    ODI 11g Load Plan Error -- Error creating indexes in parallel, see W_ETL_EVENT_LOG for details

    Oracle Community | 2 years ago | ather.shaikh
    java.sql.SQLException: ORA-20000: Error creating indexes in parallel, see W_ETL_EVENT_LOG for details ORA-06512: at line 119at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  3. 0

    how can i increase performance of interface

    Oracle Community | 4 years ago | 970612
    java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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)
  6. 0

    CASE in mapping interface

    Oracle Community | 6 years ago | tmazight
    java.sql.SQLException: Param├Ętre IN ou OUT absent dans l'index :: 1
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-20000: Error creating indexes in parallel, see W_ETL_EVENT_LOG for details ORA-06512: at line 119at 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: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:2093)
    5 frames
  5. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:376)
    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:309)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:301)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:865)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  8. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame