Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gianluca89
Contributor II
Contributor II

Unable to reload data after publish an app

Hi to All

I developed a simple app that read data from a small table in Cloudera Impala.

The data load worked well until I published the app (related stream). 

Now I am facing this error:

 

"Started loading data
 
Connecting to MID_Cloudera_Impala Failed to connect
 
The following error occurred:
Connector connect error: SQL##f - SqlState: S1000, ErrorCode: 1170, ErrorMsg: [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
 
The error occurred here:
ODBC CONNECT TO ***
 
Data has not been loaded. Please correct the error and try loading again."
 
I don't understand how to solve it.
May you help me please?
Thank you
 
Gianluca

 

 

Labels (3)
1 Solution

Accepted Solutions
henrikalmen
Specialist
Specialist

Is it the same Qlik Sense server, or do you have a development server (or qlik sense desktop) and then you moved the app for publishing on another server?

View solution in original post

14 Replies
henrikalmen
Specialist
Specialist

Could it be that the database server you are connecting to is having a temporary error so you can't connect to it at all just now, and it's not your fault (nor Qlik Sense's fault)?

gianluca89
Contributor II
Contributor II
Author

Hi Henri

No , the Impala service is up&running. The app works fine when it is not published yet.

When I publish it through QMC then, in the act to reload through Load Data Editor, then I face that error.

I think that something is happening when i publish the app. It seems that something is missing in the setting side.

Ideas?

Thank you !

 

henrikalmen
Specialist
Specialist

Is it the same Qlik Sense server, or do you have a development server (or qlik sense desktop) and then you moved the app for publishing on another server?

gianluca89
Contributor II
Contributor II
Author

It is a good question. In our production environment we have a cluster of 5 nodes(central, secondary, proxy engine 01, proxy engine 02 and Self service). I am not very skilled in it, but It seems that the app is moved into another server after publish action. I don't know I can check this.

Can I see it through QMC or logs?

Thank you

henrikalmen
Specialist
Specialist

I was thinking that it could be two different connector settings if the dev server and production server are in different clusters, but that doesn't seem to be the case. I hope somebody else has got some ideas for you...

One more wild guess though: is the odbc server you are trying to connect to IP-restricted? If so, maybe only the development node's IP address has been whitelisted and when reloading it's a different IP address that tries to connect.

gianluca89
Contributor II
Contributor II
Author

No infact, I am in production environment. I think that there is not a blacklist IP problem because the telnet from QlikSense cluster nodes to Impala are ok.

Thank you

Gianluca

neerajthakur
Creator III
Creator III

It happens sometimes, when you duplicate this published app and load data from Hub, it loads perfectly but does not load from qmc, check if there is restriction on no. of apps which can reload at one time generally it's 4 or they may timeout due to high size of app.

Thanks & Regards,
Please Accepts as Solution if it solves your query.
henrikalmen
Specialist
Specialist

There should have been another error message if the issue was too many reloads at once. And scheduled reloads are queued so that they will start when there is a slot available.

And if it is a timeout, wouldn't the error message state that? But the error message says "Unexpected response received from server".

Perhaps you can find a log file for the connector?

neerajthakur
Creator III
Creator III

This happens with me too I get this error Message from ReloadProvider: Reload failed in Engine. Check engine or script logs.

When loaded from hub it loads fine, I have scheduled this app to load after another app loads successfully i.e. similar to this with only access specified in the application.

In Script log it says Execution failed. Execution finished.

Thanks & Regards,
Please Accepts as Solution if it solves your query.