- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
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.
- Labels:
-
Data Integration
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week 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:
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
Looks like the Error is raised from the Oracle side. Are you able to share the query?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week 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:
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week 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
- External REST API Authentication via URL returned via DashBoard Webcomponent in Workflow and Data Integration
- How can I retrieve in a cube view the assigned workflow for every entity ? in Reporting
- Flat file loads reverting back to the Validate step in Workflow and Data Integration
- Complex Expression in Transformation Rule - How to exit rule? in Application Build
