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 | 5 months ago
  1. 0

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

    Oracle Community | 5 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 | 5 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

    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Groovy Sql.execute() with sql statement as string variable not working

    Stack Overflow | 4 years ago | jwest
    java.sql.SQLException: Invalid SQL type: sqlKind = 0
  6. 0

    Oracle enterprise manager 11g - Internal Error ... | Oracle Community

    oracle.com | 1 year ago
    java.sql.SQLException: ORA-20101: Metric PhysAddress for target type netapp_filer not configured ORA-06512: at "SYSMAN.ECM_CT", line 718 ORA-06512: at line 1 ORA-06512: at "SYSMAN.EMD_LOADER", line 4931 ORA-06512: at line 1

  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-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