When an ODBC connector crash occurs in Qlik Data Gateway — Direct Access, other concurrent reloads may be impacted following the original crash. This will specifically be the case if Process Isolation is not enabled.
To verify if there are ODBC connector crashes:
- Go to the DAG (Direct Access Gateway) folder: C:\Program Files\Qlik\ConnectorAgent\data\logs\
- From there, use any file search tool and search for “has exited” entries in the DirectAccessAgent log files, an example:
[Manager ] [WARN ] ODBC process (2172) has exited (exit code: 0), going to restart it...
Multiple connector crashes can have a big impact on the stability of the Direct Access Gateway.
Resolution
Enable Process Isolation as documented in Mitigating connector crashes during reload.
Cause
Some crashes can occur due to malformed queries, refer to the Data Gateway - Direct Access. Initial validation for ODBC crashes article.
If there are other crashes without traces that could explain their nature, enable dump file creation, collect the dump files and necessary information for DAG cases and contact Qlik Support.
Environment
- Qlik Cloud
- Qlik Data Gateway - Direct Access
