Forum Discussion

Chandu509's avatar
Chandu509
New Contributor II
10 months ago
Solved

Drill Back

Hi, Encountering the following error when attempting to drill back to the source system. Does anyone have any insights? Exception Type: XFException Thread Id: 330 Message: Smart Integration Con...
Data Integration
  • Henning's avatar
    Henning
    10 months ago

    Hi, this is an example from a Google search, though there are a variety of sources to be found on this error code (non-OneStream):

    To resolve the ORA-00936 error:

    1. Check that your column names are all listed correctly in the SELECT clause
    2. Ensure you have a FROM clause in your SELECT statement. Even if you aren’t selecting from a table, you still need FROM in Oracle SQL, so you could use the DUAL table (LINK)
    3. Remove any commas that shouldn’t be in your query
Henning's avatar
Henning
Valued Contributor II
10 months ago

Hi, this is an example from a Google search, though there are a variety of sources to be found on this error code (non-OneStream):

To resolve the ORA-00936 error:

  1. Check that your column names are all listed correctly in the SELECT clause
  2. Ensure you have a FROM clause in your SELECT statement. Even if you aren’t selecting from a table, you still need FROM in Oracle SQL, so you could use the DUAL table (LINK)
  3. Remove any commas that shouldn’t be in your query
Chandu509's avatar
Chandu509
New Contributor II
10 months ago

Hi,

SQL query is working fine wen I tried to pull the data from "Case Is = Get Data" but if I tried to pull the data from "Case Is = GetDrillBack" I am getting  that error