topic Re: Failed to describe table using ODBC in Qlik Replicate

Failed to describe table using ODBC

Dhanunjaya — Wed, 18 May 2022 18:47:12 GMT

Hi Teaam,

While reload the task we are getting below error,Please help us.

we have installed valied ODBC drivers.

ERROR :

Failed to describe table using ODBC. [1000100] (hadoop_metadata.c:436)
Failed to describe table 'exec_analytics_db'.'ma_card_meas_summ_bymonth_pivot_final' [1000100] (hadoop_load.c:421)
Handling new table 'exec_analytics_db'.'ma_card_meas_summ_bymonth_pivot_final' failed [1000100] (endpointshell.c:2733)

Re: Failed to describe table using ODBC

Hordy_Beauzile — Wed, 18 May 2022 18:52:04 GMT

Hi @Dhanunjaya ,

What source endpoint are you replicating from, which version? What ODBC drivers are you using?

Best,

Hordy

Re: Failed to describe table using ODBC

Michael_Litz — Wed, 18 May 2022 18:53:15 GMT

Hi Dhanunjaya,

This looks like it may be more involved than a chat session.
I am thinking that yo should open a case for this and when you do please include the task diagnostics package and the log file that has this error.

One of our support team will take the case and work with you on it.

Thanks
Michael

Re: Failed to describe table using ODBC

Dhanunjaya — Wed, 18 May 2022 18:59:49 GMT

Hi Hordy,

The source connection is for SQL Server and ODBC Driver 11 for sql server. version : 2014.120.5543.11

Regards,

Dhanunjaya

Re: Failed to describe table using ODBC

john_wang — Thu, 19 May 2022 13:15:17 GMT

Hello @Dhanunjaya ,

From the error messages:

2022-05-18T09:25:05 [TARGET_LOAD ]E: Failed to describe table using ODBC. 2022-05-18T09:25:05 [TARGET_LOAD ]E: Failed to describe table 'exec_analytics_db'.'ma_contindays_covg_final'

Looks to me it's likely a privileges issue. The user you used in the Hadoop endpoint connection cannot access the Hive table, or database.

You may follow bellow steps to confirm that:

1. IN Hadoop target endpoint --> Hive Access --> Access Hive using, set it to "No Access"

If the problem disappeared and the records can be write to HDFS, then it's a pure ODBC issue.

2. Logon to Hive/beeline Client (by the same account as the endpoint) then execute SQL:

describe formatted ma_contindays_covg_final

Probably you will get the similar error. Fix the error then try it again by Replicate task.

Hope this helps.

Regards,

John.