06-14-2024 10:21 AM
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
Solved! Go to Solution.
06-14-2024 10:38 AM
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:
06-14-2024 10:27 AM
Looks like the Error is raised from the Oracle side. Are you able to share the query?
06-14-2024 10:43 AM
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
06-14-2024 10:38 AM
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:
06-14-2024 10:46 AM
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