topic Re: Qlik Sense does not recognize the end of sql statement? in Connectivity & Data Prep

Qlik Sense does not recognize the end of sql statement?

salmivaara — Tue, 06 Oct 2020 13:05:20 GMT

Hello!

Qlik Sense (Enterprise, September 2019 version) is throwing this error message

and this is where the error occurs

So, it looks like the drop statement is also handled as a part of the sql query, as if Qlik doesn't recognize the end of the sql statement. Any idea what could be the cause of this? I have had a similar issue once before, in both cases the query is quite long and has many subqueries. Could that have something to do with this? Usually it has not been a problem, though.

Thanks

Re: Qlik Sense does not recognize the end of sql statement?

marcus_sommer — Tue, 06 Oct 2020 13:22:50 GMT

Usually it shouldn't happens but you could avoid it by following the recommended best practice, like:

connect ...

sql ...

disconnect;

- Marcus

Re: Qlik Sense does not recognize the end of sql statement?

salmivaara — Tue, 06 Oct 2020 13:36:02 GMT

No success with that, either. Now I just get syntax error from the disconnect statement. It doesn't really matter what comes after the sql statement, it is handled as a part of the query anyway.

Re: Qlik Sense does not recognize the end of sql statement?

marcus_sommer — Tue, 06 Oct 2020 16:19:23 GMT

With this I would tend to say that your sql-statement isn't really valid - maybe any quoting or commenting within it prevents that the ending semi-colon is treated as it. I assume that your statement isn't really just:

select * from table;

else a bit larger. Just review it again - maybe reducing/removing some things to simplify the matter and after it you could extend the amount again.

- Marcus

Re: Qlik Sense does not recognize the end of sql statement?

salmivaara — Wed, 07 Oct 2020 07:01:16 GMT

Turns out you were on right track. The problem was a single quote mark in a row that was commented with -- notation, somehow that got Qlik all messed up. After removing it the query ran smoothly. Thanks for your tips.