topic Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022 in Qlik Replicate

UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

Bathrinath — Tue, 28 May 2024 04:19:05 GMT

We upgraded our Qlik Replicate CDC from Nov 2022 to Nov 2023 , after the upgrade Source to log stream task are running as expected whereas log stream to target (Hadoop) is not progressing. While tested the Target end point (Hadoop Hartonworks) , received message as UUID Not found

Before upgrade all these were working fine. Pls share what could be the issue and how to fix

Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

john_wang — Tue, 28 May 2024 04:59:50 GMT

Hello @Bathrinath ,

Welcome to Qlik Community forum and thanks for reaching out here!

I'd like to narrow down the issue by steps:

1. Please make sure the correct ODBC Driver version Hive 2.06.09.1009 is installed, and also the Replicate services are restarted

2. Let's disable the Hiav Access temporarily (set to "No Access") to see if the issue caused by ODBC Access

3. In Replicate UI Go to Server Tab --> Logging --> Server Logging Levels and keep the COMMUNICATION and SERVER logging component to Verbose during the troubleshooting.

When testing the endpoint connection, these log entries will be in the repsrv.log file rather than the task log. Please elevate the logging and test the connection, then check the log.

4. Please check article as well How to troubleshoot Hadoop connectivity issues

5. If the problem persists, please share the Hadoop platform and version information, and also Replicate version/build number. If you want to share the server log file or task log file, please open a support ticket and attach the files to the case.

Hope this helps.

John.

Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

Bathrinath — Tue, 28 May 2024 07:10:34 GMT

Hi @john_wang

Thanks quick jump in and shared the detailed step to troubleshoot.

1. Please make sure the correct ODBC Driver version Hive 2.06.09.1009 is installed, and also the Replicate services are restarted

Yes, ODBC Driver version is ClouderaHiveODBC-2.6.9.1009-1

2. Let's disable the Hiav Access temporarily (set to "No Access") to see if the issue caused by ODBC Access

We disabled the Hive Access and test connection successful

does this mean, issue with ODBC connectivity ? How to resolve this ?

Thanks

Bathrinath

Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

Bathrinath — Tue, 28 May 2024 07:10:37 GMT

Hi @john_wang

Thanks quick jump in and shared the detailed step to troubleshoot.

1. Please make sure the correct ODBC Driver version Hive 2.06.09.1009 is installed, and also the Replicate services are restarted

Yes, ODBC Driver version is ClouderaHiveODBC-2.6.9.1009-1

2. Let's disable the Hiav Access temporarily (set to "No Access") to see if the issue caused by ODBC Access

We disabled the Hive Access and test connection successful

does this mean, issue with ODBC connectivity ? How to resolve this ?

Thanks

Bathrinath

Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

john_wang — Tue, 28 May 2024 07:21:21 GMT

Hello @Bathrinath ,

Good news! I'm not sure what's the Qlik Replicate server platform. Let's continue the troubleshooting by create a new 64-bit (instead of 32-bit) ODBC DSN then test the DSN Access by any 3rd party ODBC Test Tool to see if it works.

In Windows platform you may use the 64-bit ODBC Manager, and in Linux you need to create the "/etc/odbc.ini" file manually and use the "isql" to test the connectivity.

Hope this helps.

John.

Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

Bathrinath — Tue, 18 Jun 2024 03:51:08 GMT

The issue has been fixed with the help of support by setting LD_LIBRARY_PATH=/lib64:<<REPLICATE_LIB_LOCATION>>:<<HIVE_LIB_LOCATION>>:$LD_LIBRARY_PATH .

Seems the qlik is crashing when test connection established, Every time its generate new Process ID , this is witnessed in the server log file by enabling logging level as trace. Qlik unable to locate libraries given in the previous LD_LIBRARY_PATH variable

Added /lib64 in the env variadble LD_LIBRARY_PATH to resolve the issue

Thanks all for your help.

Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

john_wang — Tue, 18 Jun 2024 04:00:52 GMT

Hello @Bathrinath ,

Thanks for the update. Yes , this is the exact solution. I will summarize the steps and share the public article shortly.

Thank you so much for your great support!

John.

Re: UUID Not found Error while connecting Hadoop Target after Nov 2023 Upgrade from NOv 2022

john_wang — Tue, 18 Jun 2024 06:57:48 GMT

Hello @Bathrinath ,

This is the detailed article: Qlik Replicate and Hadoop target endpoint: UUID not found.

BTW, I'm linking the article to your support case as well.

Thank you,

John.