article Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed in Official Support Articles

Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Benoit_C — Tue, 17 Oct 2023 06:33:39 GMT

After an upgrade to Qlik Sense Enterprise on Windows May 2023 patch 3 or later, REST connections fail with the following error:

"WITH CONNECTION" is not allowed. To allow "WITH CONNECTION", select Allow "WITH CONNECTION" in the connector settings.

The Allow WITH CONNECTION option is not exposed in the REST Connector GUI and cannot be changed.

Qlik Sense Enterprise on Windows August 2023 and later are not affected.

Resolution

To resolve the issue, upgrade to August 2023.

To manually mitigate the issue in the May release branch, replace the qsdfw_qsefw_qlikview.qliksourceconfig file. Qlik is investigating a solution which does not require manual intervention.

Backup the affected file before continuing with the workaround. When taking the backup, do not keep the backed up file in the same folder. (see end notes)

On each Qlik Sense Server node, navigate to: C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector\
Locate qsdfw_qsefw_qlikview.qliksourceconfig
Replace qsdfw_qsefw_qlikview.qliksourceconfig with the file attached to this article.
This resolves the issue.

Subscribe to this article or monitor the release notes for information on an automated fix.

This change must be done on all nodes and schedulers.

End notes:

The folder C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector can only contain one qliksourceconfig file with correct name: qsdfw_qsefw_qlikview.qliksourceconfig

If there are two qliksourceconfig files (even with different names, such as a backup), the first one in alphabetical order will be chosen.

Cause

QB-20735

Environment

May 2023 Patch 3 and later

Does not affect August 2023 and later releases.

Internal Investigation ID(s)

QB-20735

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

molivier — Fri, 21 Jul 2023 14:29:26 GMT

Thanks!

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

moi — Wed, 30 Aug 2023 09:43:33 GMT

Hi,

Is this QB-20735 fix included in Patch 4?

Best regards,
Yutaka

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Benoit_C — Wed, 30 Aug 2023 09:49:30 GMT

Hi @moi,

No it's not fixed yet, therefore patch 4 hasn't the fix.

Regards,
Benoit

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

moi — Thu, 31 Aug 2023 00:20:13 GMT

Hi @Benoit_C

Thank you for your reply.
Will this fix be included in the next patch (patch5)?

Best regards,
moi

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

NVG_egodinho — Thu, 31 Aug 2023 11:00:30 GMT

Good afternoon, can you tell me if this problem also exists in patch 2?

Thanks

Élio Godinho

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Benoit_C — Thu, 31 Aug 2023 12:08:28 GMT

Hi @NVG_egodinho, issue is appearing from patch 3.

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

fmarvnnt — Thu, 31 Aug 2023 14:35:53 GMT

Wait for Patch 5: I guess we'll have the fix..

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

ssolli — Fri, 08 Sep 2023 06:59:34 GMT

Hi,

Is there a fix for this in patch 5?

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

fmarvnnt — Fri, 08 Sep 2023 09:55:56 GMT

In the May 2023 P5 FIX list is not included

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

LDR — Fri, 08 Sep 2023 10:01:18 GMT

Hi @fmarvnnt

Where can we check the list of current issues without solution and the Patch when they'll fixed? Is there a list available?

Thanks

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

fmarvnnt — Fri, 08 Sep 2023 13:25:57 GMT

Only Qlik Support can publish such a kind of list.

Sorry,

FMa

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Sonja_Bauernfeind — Mon, 11 Sep 2023 09:35:13 GMT

@fmarvnnt @LDR @ssolli

We are actively reviewing the status of the fix. I will update the article with news once I have it.

All the best,
Sonja

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Oliver_GER — Wed, 13 Sep 2023 11:15:29 GMT

@Sonja_Bauernfeind Is there an ETA for this fix? This issue became a blocker in one of our projects and now we have to make a final decision to wait or implement a timeconsuming workaround.

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

peter_turner — Fri, 15 Sep 2023 09:20:16 GMT

This affects SR5 also.

The workaround listed did resolve the problem for our customer's specific environment.

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Sonja_Bauernfeind — Mon, 18 Sep 2023 11:56:31 GMT

Hello @Oliver_GER

It is still actively being worked on and a path forward has been identified. I have no ETA just yet, but will update this article once we know more.

All the best,
Sonja

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Lech_Miszkiewicz — Mon, 18 Sep 2023 22:59:02 GMT

HI @Oliver_GER

Workaround provided here is working so there shouldn't be any blocker for you - just replace the file and you are good to go. It does not even require reboot or anything - just single copy/paste of the file as per instructions in this article.

cheers

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Skage — Wed, 20 Sep 2023 09:32:14 GMT

Does the May 2023 Patch 6 include a fix for this problem?

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Sonja_Bauernfeind — Wed, 20 Sep 2023 10:06:26 GMT

Hello @Skage

I will re-investigate for you, but I do not believe it is included in SR6. Once I know more, the article will be updated accordingly.

All the best,
Sonja

Re: Qlik Sense May 2023 Patch 3 causes REST connection error: "WITH CONNECTION" is not allowed

Eduardo_Monteiro — Thu, 21 Sep 2023 13:48:44 GMT

This issue is fixed on August 2023 Patch 2!

Regards,