java.sql.SQLException: ORA-12801: error signaled in parallel query server P00O, instance sscdb2:sbiofsaa2 (2) ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04001: error opening file /DB001/ODI/SRC_TD_Contracts.csv_001.log

Oracle Community | 2731481 | 11 months ago
tip
Do you find the tips below useful? Click on the to mark them and say thanks to rafael . Or join the community to write better ones.
  1. 0

    Mapping got failed while loading data using LKM from file to oracle (External Table) for huge volume

    Oracle Community | 11 months ago | 2731481
    java.sql.SQLException: ORA-12801: error signaled in parallel query server P00O, instance sscdb2:sbiofsaa2 (2) ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04001: error opening file /DB001/ODI/SRC_TD_Contracts.csv_001.log
  2. 0

    Mapping got failed while loading data using LKM from file to oracle (External Table) for huge volume

    Oracle Community | 11 months ago | 2731481
    java.sql.SQLException: ORA-12801: error signaled in parallel query server P00O, instance sscdb2:sbiofsaa2 (2) ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04001: error opening file /DB001/ODI/SRC_TD_Contracts.csv_001.log
  3. 0
    samebug tip
    This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.
    via Hibernate JIRA by Pierre Post
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MyBatis Error Calling Oracle Function

    Stack Overflow | 2 years ago | greyfox
    java.sql.SQLException: Malformed SQL92 string at position: 15. Expecting "call"
  6. 0

    Ghost index calling oracle function

    Stack Overflow | 3 years ago | Alvaro Gomez
    java.sql.SQLException: Falta el parámetro IN o OUT en el índice:: 2
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-12801: error signaled in parallel query server P00O, instance sscdb2:sbiofsaa2 (2) ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04001: error opening file /DB001/ODI/SRC_TD_Contracts.csv_001.log

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
    8. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
    12. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:5195)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1546)
    13 frames
  3. oracle.odi.runtime
    TaskExecutorAgentRequestProcessor$1.doAction
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:203)
    2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
    4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
    5. oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
    6. oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
    7. oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864)
    8. oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024)
    9. oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
    10. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
    11. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
    11 frames
  4. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
    1 frame
  5. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
    5 frames
  6. Java RT
    Executors$RunnableAdapter.call
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    1 frame
  7. oracle.odi.runtime
    OdiJob.call
    1. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    2. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    2 frames
  8. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:262)
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    4. java.lang.Thread.run(Thread.java:745)
    4 frames