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
