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 Connector remote query failed.
ORA-00936: missing expression
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
4 Replies
Looks like the Error is raised from the Oracle side. Are you able to share the query?
Hi,
SQL query is working fine wen I tried to pull the data from "Case Is = ConnectorActionTypes.GetData" but if I tried to pull the data from "Case Is = ConnectorActionTypes.GetDrillBack" I am getting that error
HenningOneStream Employee
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
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
