topic SSE not working from QMC in Integration, Extension & APIs

SSE not working from QMC

jheasley — Sat, 16 Nov 2024 04:12:12 GMT

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!

Re: SSE not working from QMC

rbecher — Thu, 31 Oct 2019 14:55:17 GMT

Hi,

what does mean "works from QMC"?

- Ralf

Re: SSE not working from QMC

RichB — Thu, 31 Oct 2019 15:43:30 GMT

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: ***)

Re: SSE not working from QMC

jheasley — Thu, 31 Oct 2019 16:12:20 GMT

@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.

Re: SSE not working from QMC

rbecher — Thu, 31 Oct 2019 16:26:41 GMT

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

Re: SSE not working from QMC

jheasley — Thu, 31 Oct 2019 16:51:45 GMT

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.

Re: SSE not working from QMC

konrad_mattheis — Fri, 01 Nov 2019 07:01:17 GMT

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

Re: SSE not working from QMC

jheasley — Sat, 02 Nov 2019 23:20:03 GMT

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!