The following error or similar could be generated when loading data of type NCLOB or CLOB from an Oracle Data Source.
ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00942:the table or view does not exist
Only fields of data type NCLOB or CLOB are affected.
- Qlik Sense Enterprise May 2022 and other earlier versions.
August 2022 Patch 1
May 2022 Patch 7
February 2022 Patch 10
November 2021 Patch 15
and any later releases.
A workaround could be a downgrade of Qlik ODBC connector package to the previous working version. Alternatively, you can reach out to Qlik Support in order to get a temporary fixed ODBC connector package version 6.191 (a new official patch will be provided soon).
See How to upgrade the Qlik Sense Enterprise on Windows ODBC Connector Packages for instructions on how to swap out the ODBC Connector Package for Qlik Sense Enterprise on Windows.
Product Defect ID: QB-10789