Qliksense keeps throwing me this error.... ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00936: missing expression. I've used SQL Developer to test the query but don't see any issue with the query. Any idea how I'd go about resolving this? I've tried breaking the query down to something more similar but also getting the same issue as well. Thinking if i should consider doing CTE to help resolve this or would it still be the same.
Qlik doesn't execute any SQL else just transferred the query per driver to the data-base and get on this way back the results. If the query worked within the data-base but not by calling it per external driver it makes it very likely that the driver couldn't handle anything properly (unsuitable configuration, wrong driver, too old, ..).
Therefore take a look for another one and/or create (for a testing purpose) a view from the query and query then this view (it will exclude any causes in regard to resolve the query and limit the causes to data-quality or data-type stuff). Also a look within the data-base log may give some valuable hints.
