The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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...
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:
- Check that your column names are all listed correctly in the SELECT clause
- 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)
- Remove any commas that shouldn’t be in your query
Henning
OneStream Employee
OneStream EmployeeHi, 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:
- Check that your column names are all listed correctly in the SELECT clause
- 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)
- Remove any commas that shouldn’t be in your query
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