Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
Hi,
what does mean "works from QMC"?
- Ralf
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: ***)
Hard to say from a distance. Could be a rights problem of the user running the task or related to security rules?
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.
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
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!