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: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]
  2. 0

    Cannot load data into Essbase using ODI | Oracle Community

    oracle.com | 1 year ago
    java.sql.SQLException: Unexpected token: ACCOUNT in statement [select   C1_ACCOUNT    ""Account]
  3. 0

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

    Oracle Community | 8 years ago | Sravan Ganti
    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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cannot load data into Essbase using ODI

    Oracle Community | 8 years ago | 672531
    java.sql.SQLException: Unexpected token: ACCOUNT in statement [select C1_ACCOUNT ""Account]
  6. 0

    Error while loading Data into Essbase using ODI

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

    1 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

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

      at org.hsqldb.jdbc.jdbcUtil.sqlException()
    2. HSQLDB
      jdbcStatement.executeQuery
      1. org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
      3 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:592)
      4 frames
    4. Jython
      PyInstance.invoke
      1. org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java)
      2. org.python.core.PyMethod.__call__(PyMethod.java)
      3. org.python.core.PyObject.__call__(PyObject.java)
      4. org.python.core.PyInstance.invoke(PyInstance.java)
      4 frames