java.lang.Exception: The application script threw an exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist BSF info: Get Join columns at line: 0 column: columnNo

Oracle Community | User638087-Oracle | 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 Load fails - ODI-17517: Error during task interpretation.ORA-00942: table or view does not exist

    Oracle Community | 2 years ago | User638087-Oracle
    java.lang.Exception: The application script threw an exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist BSF info: Get Join columns at line: 0 column: columnNo
  2. 0

    Error Error during task interpretation in ODI

    Stack Overflow | 3 years ago | priya77
    java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: `` if (sUseDbLink.equals("Y") && (!sIsSDSDeployed.equals("Y"))) { out.print("\n\n . . . '' : Attempt to resolve method: equals() on undefined variable or class name: sUseDbLink : at Line: 1 : in file: inline evaluation of: `` if (sUseDbLink.equals("Y") && (!sIsSDSDeployed.equals("Y"))) { out.print("\n\n . . . '' : sUseDbLink .equals ( "Y" ) BSF info: Create view on source at line: 0 column: columnNo
  3. 0

    Load plan error

    Oracle Community | 3 years ago | HimanshuP
    java.lang.Exception: The application script threw an exception: java.lang.NullPointerException: Null Pointer in Method Invocation BSF info: Initialize variables at line: 0 column: columnNo
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI-17517: Error during task interpretation

    Oracle Community | 3 years ago | 2717688
    java.lang.Exception: The application script threw an exception: java.lang.NullPointerException: Null Pointer in Method Invocation BSF info: Initialize variables at line: 0 column: columnNo
  6. 0

    ODI-17517: Error during task interpretation. Exception getObjectName("R", "%COL_PRF0HOME", "W")

    Oracle Community | 1 year ago | 08bf9fa9-56ef-48ec-9bfd-13ad50d724d9
    java.lang.Exception: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("R", "%COL_PRF0HOME", "W") : BSF info: Create work table on target at line: 0 column: columnNo

    6 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. org.apache.bsf.BSFException

      The application script threw an exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist BSF info: Get Join columns at line: 0 column: columnNo

      at bsh.util.BeanShellBSFEngine.eval()
    2. BeanShell
      BeanShellBSFEngine.exec
      1. bsh.util.BeanShellBSFEngine.eval(Unknown Source)
      2. bsh.util.BeanShellBSFEngine.exec(Unknown Source)
      2 frames
    3. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:471)
      2. com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:711)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:461)
      4. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)
      5 frames
    4. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      1 frame
    5. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    6. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      4 frames
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:682)
      1 frame