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

[Benoit_C]

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)

1. On each Qlik Sense Server node, navigate to: C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector\
2. Locate qsdfw_qsefw_qlikview.qliksourceconfig
3. Replace qsdfw_qsefw_qlikview.qliksourceconfig with the file attached to this article. 
4. 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

Qlik Sense Enterprise on Windows May 2023 Patch 3 and later 

Does not affect August 2023 and later releases.

Internal Investigation ID(s) 

QB-20735

[afujikawa]

Hi @Benoit_C ,

Thanks for the quick reply.

Best regards,
afujikawa

[willtech93]

Hello everyone, just to let everyone know the file replacement indeed worked!!. In my case, I have recently upgraded from Nov 2021 to May 2023, and this was one of our problems. Most precisely with the App Metadata Analyzer.

Many Thanks @Benoit_C  and @Sonja_Bauernfeind  for the workaround.

[sis]

Hi @Benoit_C 

We are currently operating in a multi-node configuration with three units.
Does the node to replace qliksourceconfig include all nodes containing Qlik Sense?
I have one node that is operated exclusively for reloading, is this also a node subject to replacement work?

This document says "1.On each Qlik Sense Server node, navigate to", so all nodes are certified, is it correct?

[Benoit_C]

Hello @sis,

You need to perform it in all nodes, also the reload node.

Regards,
Benoit

[sis]

Hi @Benoit_C  ,

Thanks for the quick reply.

[Qlik_FZ]

Hi 

I am using May 23 Patch (5) but the issue still exit. I think it is resolved in Aug 23.

But for now I have resolved the issue with following :

1. On each Qlik Sense Server node, navigate to: C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector\
2. Locate qsdfw_qsefw_qlikview.qliksourceconfig
3. Take backup of this file on another location 
4. edit and add the following code 
   <Property>
   <Name>allowWithConnection</Name>
   <DisplayName>Allow "WITH CONNECTION"</DisplayName>
   <Description>Allow "WITH CONNECTION"</Description>
   <InputType>checkbox</InputType>
   <GroupName>Additional request parameters</GroupName>
   </Property>
   
5. issue fix.

[MarcinS]

We have updated Qlik to version November 2023 Patch 1, and unfortunately, there is still no checkbox in the connector settings. We are using the CM version. Does anyone have any ideas?

[peter_nbc]

Hi @Benoit_C 

Is there a solution for this in Qlik Cloud?
I am getting the same 'With connection' error, as you mention in this post.

But this solution is only for Qlik Sense Enterprise, right?

Thanks,

Peter

[Sonja_Bauernfeind]

Hello @peter_nbc 

Seeing this in Qlik Cloud would be a different root cause that should be investigated. This article is only valid and applicable for the on-premise version. Please post about the issue you are seeing in detail (with error messages) in the appropriate forum.

All the best,
Sonja 

[Albert_Candelario]

Hello @peter_nbc,

I have also provided additional information on your original post.

https://community.qlik.com/t5/Qlik-Cloud-Data-Integration/Dynamic-token-handling-quot-With-connectio...

Cheers,

Albert