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

Connection Dataproc

Bonjour, 

Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate. 

ELHARRAS_0-1711467658369.png

Erreur veut dire que l'adresse host et le numéro du port  pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK . 

Cordialement.

Cordialement. 

1 Solution

Accepted Solutions
john_wang
Support
Support

thank you so much for your great support Yassine @ELHARRAS !

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

View solution in original post

8 Replies
john_wang
Support
Support

Google translate:

Connection Dataproc
Good morning,

I can't connect to the Dataproc cluster from Qlik replicate.

More Details
SYS-E-HTTPFAIL, RetCode: SQL_ERROR SqlState: HY000 NativeError: 1110
Message: [Cloudera][DriverSupport] (1110) Unexpected response received
from server. Please ensure the server host and port specified for the
connection are correct and confirm if SSL should be enabled for the
connection..
SYS,GENERAL_EXCEPTION,RetCode: SQL_ERROR SqlState: HY000 NativeError:
1110 Message: [Cloudera][DriverSupport] (1110) Unexpected response
received from server. Please ensure the server host and port specified for the
connection are correct and confirm if SSL should be enabled for the
connection.

Error means that the host address and the port number to connect to Hive which blocks the config for cloud Storage is OK.

Sincerely.

Sincerely.

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 @ELHARRAS ,

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

Looks to me this is a pure connectivity issue. Would you please troubleshoot the issue by:

1. Define a 64-bit ODBC DSN in Qlik Replicate Server and test the connectivity by using the DSN

    Make sure the proper server IP Address/ Hostname and port number are correctly input.

2. have you checked with the Cloudera Hadoop support?
    I have googled the below knowledge base articles regarding to the same error from Cloudera but I don't have Cloudera access, so I don't have a view. Hope you can check.

    ERROR: "Unexpected response received from server" when connection from an ODBC client fails

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

Hi @john_wang , 

thank you for your answer, how can i define a 64-bit ODBC DSN in Qlik Replicate Server ?

Yassine. 

john_wang
Support
Support

Hello @ELHARRAS ,

In Windows, you may use "ODBC Data Source Administrator (64-bit)" program.

john_wang_0-1711531579274.png

 

In Linux, need to define the "/etc/odbc.ini" and "/etc/odbcinst.ini" manually, here is a sample.

Regards,

John.

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

Hello @john_wang

I have the same error in the Replicate server with ODBC Data Source Administrator (64-bit) for Hive. 

ELHARRAS_0-1711535311986.png

 

Yassine. 

john_wang
Support
Support

Hello @ELHARRAS ,

Would you please make sure you input the "Host(s)" correctly? it seems "your_hive_server" is not a correct one.

BTW, you may try both "host name" and "IP Address" to see if it's DNS issue.

Personally I strongly suggest you work with your DBA and Cloudera Hadoop support to manage it to work.

thanks,

John.

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

Hi @john_wang , 

That what i'm gonna do, thank you for your help. 

Yassine. 

john_wang
Support
Support

thank you so much for your great support Yassine @ELHARRAS !

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