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

[Bathrinath]

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 

[john_wang]

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.

[Bathrinath]

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

[Bathrinath]

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

[john_wang]

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.

[Bathrinath]

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.

[john_wang]

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.

[john_wang]

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.