java.sql.SQLException: java.sql.SQLException: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]

Oracle Community | AravindhK | 1 year ago
  1. 0

    ODI Issue - java.sql.SQLException: Unexpected token: ) in statement [select ..]

    Oracle Community | 1 year ago | AravindhK
    java.sql.SQLException: java.sql.SQLException: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]
  2. 0

    Unexpected Token error loading data to Essbase ... | Oracle Community

    oracle.com | 1 year ago
    java.sql.SQLException: java.sql.SQLException: unexpected token: ||C6_FUND_CODE "Fund", : line: 17
  3. 0

    Unexpected Token error loading data to Essbase ... | Oracle Community

    oracle.com | 11 months ago
    java.sql.SQLException: java.sql.SQLException: unexpected token: ||C6_FUND_CODE "Fund", : line: 17
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI error-THIS CLAUSE USES MULTIPLE CONNECTIONS AND THEREFORE CANNOT BE EXE

    Oracle Community | 8 years ago | Sravan Ganti
    java.sql.SQLException: java.sql.SQLException: Table not found: EXCEPTION in statement [select C1_PERIOD "Period",C2_ACCOUNT "Account",C3_ENTITY "Entity",C4_EMPLOYEE "Employee",C5_YEAR "Year",C6_SCENARIO "Scenario",C7_VERSION "Version",'Local' "Currency",'HSP_InputValue' "HSP_Rates",CASE WHEN C10_ENTRY_ID IS NULL THEN C8_DATA ELSE C10_ENTRY_ID END "Data" from "C$_1Totplan_WrkforceData" left outer join "C$_0Totplan_WrkforceData" ON C8_DATA=C11_NAME AND C9_ENUMERATION_ID= (SELECT ENUMERATION_ID FROM Exception]
  6. 0

    Error while loading Data into Essbase using ODI

    Oracle Community | 8 years ago | 610500
    java.sql.SQLException: java.sql.SQLException: Unexpected token: TIME in statement [select C3_C1 ""Time]

    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

      java.sql.SQLException: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]

      at org.apache.bsf.engines.jython.JythonEngine.exec()
    2. Bean Scripting Framework
      JythonEngine.exec
      1. org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
      1 frame
    3. com.sunopsis.dwg
      DwgCmd.run
      1. com.sunopsis.dwg.codeinterpretor.j.a(Unknown Source)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(Unknown Source)
      3. com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
      4. com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
      5. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
      6. com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(Unknown Source)
      7. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
      8. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
      9. com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
      10. com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(Unknown Source)
      11. com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
      12. com.sunopsis.dwg.cmd.DwgCmd.k(Unknown Source)
      13. com.sunopsis.dwg.cmd.f.F(Unknown Source)
      14. com.sunopsis.dwg.dbobj.SnpScen.a(Unknown Source)
      15. com.sunopsis.dwg.dbobj.SnpScen.localExecuteSync(Unknown Source)
      16. com.sunopsis.dwg.tools.StartScen.actionExecute(Unknown Source)
      17. com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(Unknown Source)
      18. com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(Unknown Source)
      19. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
      20. com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(Unknown Source)
      21. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
      22. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
      23. com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
      24. com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(Unknown Source)
      25. com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
      26. com.sunopsis.dwg.cmd.DwgCmd.k(Unknown Source)
      27. com.sunopsis.dwg.cmd.g.z(Unknown Source)
      28. com.sunopsis.dwg.cmd.DwgCmd.run(Unknown Source)
      28 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:637)
      1 frame