Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Aug 24, 2023 4:08:14 AM
Aug 24, 2023 4:08:14 AM
Using the default connector, a reload task fails when connecting to an Oracle database:
Error: SQL##f - SqlState: IM004, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
The above error is not a Qlik error, but an error received by Qlik from the data source. The issue is typically due to missing or incorrect privileges assigned to the Qlik service account or is returned due to a faulty driver installation.
The error can be resolved by assigning the correct rights on the database side to the account attempting the connection and reload.
If the error is caused by a faulty driver install, the driver will need to be uninstalled and re-installed.
SQLSTATE IM004, SQLAllocHandle on SQL_HANDLE_ENV failed, when connecting via an ODBC application
Qlik Sense Enterprise on Windows
QlikView
Qlik ODBC Connector Package