Qlik Data Gateway - Direct Access: Reloads failing with Please check the values for Username‚ Password‚ Host and other properties

[NadiaB]

A reload using Qlik Data Gateway - Direct Access may fail with the following error in the script logs:

Please check the values for Username‚ Password‚ Host and other properties.

Environment

• Qlik Data Gateway - Direct Access (1.6.2 and earlier)
• ODBC Package

Resolution

The issue is not necessary related with the username, password, or host values. The full description of the error can be obtained from the odbc-connector log, usually located in C:\Program Files\Qlik\ConnectorAgent\data\logs and can be identified by the reload id.

1.6.3 version introduces a configuration ShowErrorDetailMessage that can be added to the data connection Advanced properties with a value of true or false (no quotes):

Cause 

This behavior is currently working as designed for the Odbc Package, it was decided to remove some sensitive information (user ids, ports, host information). The odbc package will show a generic error in order to protect sensitive data.

Internal Investigation ID(s)

JIRA QB-19072