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 | 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 Issue - java.sql.SQLException: Unexpected token: ) in statement [select ..]

    Oracle Community | 2 years 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 | 1 year 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