Maybe it has something to do with the use of double quotes. I've not experienced it myself (yet), but a colleague of mine did.
In previous versions of Qlik Sense the following statement worked like a charm:
SQL SELECT field
But he had to change it to FROM "Data"."Pub"."AA-01" ; for it to work properly after upgrading to the September version.
Maybe this works for you too.
Thanks for the info Tamara. My situation is a bit different in that it's specific to calling a stored procedure. This is using a Sql Server OLE DB connection.
Here's a simple script to duplicate:
That's the entire script.
When I run that, I get an error message in Qlik
Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '/'.
I can see via Sql Server Profiler that what's being sent includes more than my script:
Interestingly, if I change @Param1 = N'18', things work fine:
Of course since that stored procedure does not exist, there's an error about that, but that's to be expected. The point is what is being sent to sql server is not always correct in that it includes too much of the Qlik script. This was working fine before the Sept 17 upgrade.