Comment is removed from Oracle SQL queryArticle Number: 000059656 | Last Modified: 2019/08/26
Qlik Sense app, a SQL query to Oracle database contains optimizer hint in a comment (https://docs.oracle.com/cd/E11882_01/server.112/e41573/hintsref.htm#PFGRF005). The comment is wrapped in -- ... -- or /* ... */ . Connection to Oracle database is made with built-in Oracle connector (Qlik ODBC Connector Package).
When reloading in Qlik Sense September and November 2018 (ODBC Connector Package 5.8.1 and 5.12.0), the comment is removed before the SQL query is sent to Oracle although system variable StripComments is already set to 0. The issue doesn't happen in earlier versions of Qlik Sense.
Qlik Sense September and November 2018
Fixed in:This has been addressed in Qlik Sense February 2019. See the relevant Release Notes for details on item QVXODBC-1515.
Workaround:Use a generic ODBC connection on an ODBC driver provided by Oracle (such as Oracle OraClient12Home1)
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.