Qlik Replicate and Hadoop target endpoint: UUID not found

[john_wang]

The Hadoop target endpoint (Hortonworks Data Platform (HDP)) functioned correctly in Replicate 2022.11. However, after upgrading to 2023.11, the "Test Connection" operation fails, displaying the error "UUID not found." Consequently, we are unable to test the connection successfully. Additionally, the Replicate Server restarts unexpectedly each time the endpoint ping test is performed.

The error message displayed in the Manage Endpoint Connections window is as follows:

BTW, If "Hive access" in the endpoint is temporarily disabled (Set to "No Access") Test connection is succeeded.

Resolution:

1. Adding "/lib64" in the beginning of environment variable LD_LIBRARY_PATH in the login script file "/opt/attunity/replicate/bin/site_arep_login.sh". For example:

   export LD_LIBRARY_PATH=/lib64:/opt/attunity/replicate/lib:/opt/cloudera/hiveodbc/lib/64:$LD_LIBRARY_PATH

2. Execute "arep_login.sh":  

   $ cd /opt/attunity/replicate/bin
   $ source arep_login.sh

3. Startup Replicate Service:

   $ ./areplicate start

Internal Investigation ID(s):

#00166187, #00155938, Jira QB-2724

Environment:

• Qlik Replicate 2023.11
• Hadoop: Hortonworks Data Platform (HDP) 3.1
• Cloudera ODBC Driver for Apache Hive 64-bit v2.6.9