DTM3102: Failed to connect to the underlying database

Problem

Hyper-Q reports the error message DTM3102: Failed to connect to the underlying database.

Cause

Hyper-Q was unable to connect to the backend database using the ODBC drivers.

The error message contains details from the error provided by the ODBC stack. For example, a complete error message may appear as:

DTM3102: Failed to connect to the underlying database: "[unixODBC][Driver Manager]Can't open lib '/usr/lib64/psqlodbcw.so' : file not found SQLSTATE IS: 01000 Connection to database failed." (odbc_beta:285)

The detailed error message provides additional information about the problem.

Solution

Ensure that:

• The ODBC driver for the downstream database is working correctly on the host running Hyper-Q.
• The system odbcinst.ini file has been copied to the Hyper-Q config directory.
• The connection_string property in the Hyper-Q configuration file (dtm.ini) matches the driver.
• The credentials provided in the client application are valid on the backend database.