topic Re: QlikSense throws error in query that works just fine in SQLDev in Connectivity & Data Prep

QlikSense throws error in query that works just fine in SQLDev

Sofichina — Thu, 19 May 2022 18:24:49 GMT

Hi!

I put together a query in SQL Developer that works just fine but when I paste it in QlikSense (like I always do) it throws the error: "ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00936: missing expression"

I've already checked commas, select and from statements.

Like I said, the exact same query runs just fine in SQL Developer. Its the first time something like this happens and I couldn't find anyone that has the same problem.

Thank you in advance!

Re: QlikSense throws error in query that works just fine in SQLDev

danielrozental — Fri, 20 May 2022 21:19:47 GMT

Can you paste your query?

Re: QlikSense throws error in query that works just fine in SQLDev

Sofichina — Tue, 24 May 2022 12:23:08 GMT

The query is:

Re: QlikSense throws error in query that works just fine in SQLDev

danielrozental — Mon, 23 May 2022 21:09:58 GMT

You're query seems ok.

Have you tried starting with a more simple version and build it up to see when you start getting the error?

For example, does something like this work?

SELECT
SUM (r.cambio ) AS STOCK

FROM sigsa.cambiohistorico r

Re: QlikSense throws error in query that works just fine in SQLDev

Sofichina — Tue, 24 May 2022 12:22:41 GMT

Thank you for your answer! I did as you said and it turns out the "date(today())" was crushing the query in Qlik. I solved it by defining a variable vDate = date(today()) in Main and calling it out as "$vDate"