When working with Data Gateway - Direct Access, odbc drivers can have unexpected behaviors that can lead to crashes.
Note: For more information about how to enable dump file creation and Isolation capability for Data Gateway - Direct Access, please review the links included in the "Related Content" at the end of this article.
One known reason to cause crashes is the use of malformed SQL query statement.
Resolution
After configuring the dump file generation and Process Isolation, dump files will be created under the folder configured during the setup.
Once a crash occurs the file will include the process id associated to the reload:
dotnet.exe.XXXXX.dmp
Where XXXX will be the process id.
With that process id and looking for the date and time when the file was created, in the odbc connector log, is possible to find the ProcessId associated to the Id of the dump file and get the reload ID.
Once the reload id was identified, in order to get the query there are two options:
1. From the QMC get the reload script associated to the reload id to verify the query that was triggered.
2. Enable ODBC debug level in the configuration.properties located under C:\ProgramData\Qlik\Gateway\ folder
ODBC_LOG_LEVEL=DEBUG
The change requires restart of the DAG service.
This will record in the odbc-connector logs the queries, it will be necessary to search for the reload id and the last "GetTableMetadata" recorded for the given reload, a sample of this entry in the logs would be:
