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: 
jheasley
Luminary Alumni
Luminary Alumni

SSE not working from QMC

Good Morning

We have a Python SSE built for geocoding that works in our Dev environment from both the QMC and the Hub, and in prod, it works from the Hub, but not the QMC.  

Has anyone seen an issue like this before?

 

Thanks for your help in advance!

 

Labels (5)
1 Solution

Accepted Solutions
jheasley
Luminary Alumni
Luminary Alumni
Author

We got to the bottom of the issue, and it was a very weird confluence of the sometime strange results (lack of specificity) when using an include script AND an Oracle Connector issue all happening 2 lines prior to where we were seeing SSE errors during design. 

It was also our first time using SSE's so as a team were are still novices...

 

thanks for trying to help us!

View solution in original post

7 Replies
rbecher
MVP
MVP

Hi,

what does mean "works from QMC"?

- Ralf

Astrato.io Head of R&D
RichB
Contributor II
Contributor II

When the load data button is hit from within the actual application Qlik sends the data to the SSE. We can see the server is executing a function because the script prints it to the terminal. The server will then respond to the request sent and return the geocoded coordinates to the application. This works in both our stage environment and our production environment. 

 

The trouble occurs when we create a task to do the reload of this app or when we start the reload of the app from within the QMC. It works for our stage environment  but when running from the QMC in production the SSE server does not appear to see the request. We never see that a function is getting executed and the server does not return anything. 

As a result we are getting a message:

Error: Connector is not responding (System error: ***)

 

jheasley
Luminary Alumni
Luminary Alumni
Author

@rbecher  - thanks for responding.  @RichB  is the actual designer from my team who built and deployed the extension. We really appreciate any insight you have. 

rbecher
MVP
MVP

Hard to say from a distance. Could be a rights problem of the user running the task or related to security rules?

Astrato.io Head of R&D
jheasley
Luminary Alumni
Luminary Alumni
Author

so we are running the task from the QMC as sa_scheduler, all INTERNAL users have access (through a security rule) to all Analytics Connections, in the Virtual Proxy Setup, we have all servers open to each other.  

konrad_mattheis
Luminary Alumni
Luminary Alumni

Hi,

be honest I have no clue. We developed for Sense Excel Reporting also an SSE to start things from tasks and it was always running like charm from script and also triggered from the server.

Do you have a single node or a cluster installation?

If you have a cluster, can it be the the reload node have no access to the SSE?

bye

Konrad

jheasley
Luminary Alumni
Luminary Alumni
Author

We got to the bottom of the issue, and it was a very weird confluence of the sometime strange results (lack of specificity) when using an include script AND an Oracle Connector issue all happening 2 lines prior to where we were seeing SSE errors during design. 

It was also our first time using SSE's so as a team were are still novices...

 

thanks for trying to help us!