topic Re: On Demand - unable to connect to server in Qlik NPrinting

On Demand - unable to connect to server

danielgargiulo — Sat, 16 Nov 2024 03:34:59 GMT

@Frank_S see below for the question in a new thread

Issue: When we put selections in the Qlik App and no filters in NPrinting then we get the error (see images below). Note: When we have filters set up in NPrinting on the report and User and NO selections are made in the Qlik App then it runs fine

Qlik Sense Enterprise: Nov 2018 - Secure Site

Qlik nPrinting: April 2019 - Unsecured Site

Any thoughts are appreciated.

NPrinting Pop Up ErrorDev Tools Error Message

Re: On Demand - unable to connect to server

Frank_S — Tue, 14 May 2019 22:06:59 GMT

Thanks @danielgargiulo

This is great info and appreciate that you started this new separate thread.

1. Make sure that your Qlik Sense hub address is added as a trusted origin in the NPrinting web console under Admin>Settings>On Demand>Trusted origins

make sure to add your Qlik Sense server address to the trusted origin list

2. Check the connection string in the On Demand report object in your Qlik Sense app. You will need to re-associate your NP server connection to the NP App. If a / is not appended to the end of the server connection string, please add it.

ie: ttps://NPrintingServer:4993/

For more information on point 2, check this article https://support.qlik.com/articles/000065283

Refreshing the connection inside the On Demand object should fix it.

Re: On Demand - unable to connect to server

danielgargiulo — Tue, 14 May 2019 22:23:50 GMT

Hey,

Point 1: we have added it to the trusted origins however the address keeps shortening to their friendly name eg removes the hub part.

Point 2: we have now added the '/' however are still experiencing the same issue.

Dan

Re: On Demand - unable to connect to server

Frank_S — Tue, 14 May 2019 22:30:20 GMT

Try adding and configuring a second On Demand object.

It may be necessary to replace the object entirely to get it to work normally.

If replacing the object works, then simply remove the original object and continue with the new one.

If that doesn't work, then you will need to contact the Qlik Support desk or your Qlik Support partner to look into it further. Hopefully my final suggestion to add a new object and replace the original will work for you however.

Re: On Demand - unable to connect to server

danielgargiulo — Tue, 14 May 2019 22:36:58 GMT

Hi Frank,

Thanks for the support to date. We have tried adding a new object and get the same error. We have a case logged with Qlik support.

The link you sent had a further link to this article: https://support.qlik.com/articles/00006055

- This article has the section below. The authentication providers is OKTA (Saml), could that cause an issue? It seems strange if it is the issue as it works fine when no filters are applied in the Qlik App.

Un-supported authentication methods are as follows:

JWT and QS NP On Demand
SAML and QS NP On Demand

NOTE: Windows NTLM auth is the only supported authentication method with Qlik Sense with NPrinting On-Demand. Remove any 3rd party or Qlik On-Demand Extension before installing new version.

Thanks,

Dan

Re: On Demand - unable to connect to server

Frank_S — Tue, 14 May 2019 22:50:48 GMT

Ok...you just gave me another clue.

"It seems strange if it is the issue as it works fine when no filters are applied in the Qlik App".

I missed this point in your original description above.

If it is working with no selections but fails with selections, you need to follow this article I just wrote today:

How to manage Qlik Sense NPrinting On Demand "Request Failed" message https://support.qlik.com/articles/000074356

Otherwise, we'll have to help you directly in the support case that you submitted if this latest suggested solution doesn't work for you.

Re: On Demand - unable to connect to server

danielgargiulo — Tue, 14 May 2019 22:53:17 GMT

HI Frank,

I have just checked again and we have no filters on the report or user.

The support case is: 01644711

Thanks,

Dan

Re: On Demand - unable to connect to server

Frank_S — Tue, 14 May 2019 22:59:45 GMT

Ok...I've left a comment on the case for my APAC colleagues regarding this thread and advised them to review this thread as well.

Best...fs

Re: On Demand - unable to connect to server

mehdibassam — Tue, 14 May 2019 23:34:56 GMT

Hi @Frank_S ,

Mehdi here from the Acumen BI team. Further to this conversation, can you please give us the recommended specs for an NPritning SSL Cert?

Regards

Re: On Demand - unable to connect to server

Frank_S — Wed, 15 May 2019 13:40:29 GMT

Hi @mehdibassam

Please start a new thread to ask your question about SSL certificates and or check Qlik Help which contains your answer.

https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/DeployingQVNprinting/Platform-security.htm

Re: On Demand - unable to connect to server

danielgargiulo — Thu, 30 May 2019 10:55:33 GMT

We (our team and Qlik) have found the cause of the issue: The On-Demand Extension, when a selection is made, appears to have an upper limit on the number of distinct values from an originating field (10,000). Qlik can see a similar case and bug which was reported earlier this month, and the R&D team have since made changes to the extension to resolve this upper limit issue. This is expected to be fixed in the next June 2019 release of Qlik Sense Enterprise.

Re: On Demand - unable to connect to server

anindya_manna — Wed, 24 Jul 2019 09:20:23 GMT

Other than upgrading June Qlik 2019 no other solution is there?

Re: On Demand - unable to connect to server

danielgargiulo — Wed, 24 Jul 2019 09:24:42 GMT

you are able to take the On demand Extension from June 2019 and import this into an earlier version of Qlik (it will depend on how early). Please note this may then be an unsupported configuration so please check with your Partner Provider first.

Re: On Demand - unable to connect to server

MChapp — Thu, 19 Sep 2019 19:24:49 GMT

I'm having the Unable to connect to server as well. I'm using a Qlik Sense app connected to Salesforce with a Bulk API and my app does not include a pivot table. I'm using the April 2019 version of NPrinting. My Qlik Sense app only has one filter object, Account.Name, and if I do not select a value before clicking the on-demand button, my NPrinting report produces.

But if i select my test account and then click the on-demand button, I get the Unable to connect to server error.

Re: On Demand - unable to connect to server

danielgargiulo — Thu, 19 Sep 2019 19:40:56 GMT

Hi, do you have the field you are making a selection on included in your nPrinting report?

Re: On Demand - unable to connect to server

Frank_S — Thu, 19 Sep 2019 19:48:52 GMT

Hi @MChapp

Your issue sounds similar to the issue with 10,000 plus filters. This issue has actually been resolved in the June 2019 release of Qlik Sense as describe in the following article:

https://support.qlik.com/articles/000081362

If you have the same number of filter/selection values in your data, this could be the same issue that your are experiencing.

I suggest that if possible, that you upgrade Qlik Sense in order to update the NPrinting On Demand custom objects used in your QS apps.

Kind regards...

Re: On Demand - unable to connect to server

MChapp — Thu, 19 Sep 2019 19:52:20 GMT

Is the 10,000 values a count of all values in the database or is it a count of values that are exported to NPrinting after the filter value has been selected

Re: On Demand - unable to connect to server

Frank_S — Thu, 19 Sep 2019 19:53:59 GMT

If the dimension has 10 K plus values in the database itself.

Hope this helps to clarify...

Re: On Demand - unable to connect to server

MChapp — Thu, 19 Sep 2019 19:57:38 GMT

yes, Account.Name, which is my filter, is an object on my NPrinting Report.

I do not have a NPrinting filter set on this report.

Re: On Demand - unable to connect to server

MChapp — Thu, 19 Sep 2019 20:00:14 GMT

Your response does clear things up. I have 68,438 unique values in my Account.Name filter object.