Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
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
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.