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