Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Bathrinath
Contributor II
Contributor II

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

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 

 

Bathrinath_0-1716869740280.png

 

Labels (1)
7 Replies
john_wang
Support
Support

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

john_wang_0-1716871982026.png

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Bathrinath
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Bathrinath
Contributor II
Contributor II
Author

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
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
john_wang
Support
Support

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.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!