Qlik Sense May 2022: failing to load a field type NCLOB or CLOB when connecting to Oracle DB
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).