Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Usually it shouldn't happens but you could avoid it by following the recommended best practice, like:
connect ...
sql ...
disconnect;
- Marcus
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.
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
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.