Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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

100% helpful (14/14)
cancel
Showing results for 
Search instead for 
Did you mean: 
Benoit_C
Support
Support

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

Last Update:

Oct 16, 2023 11:33:39 PM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 21, 2023 7:02:23 AM

Attachments

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

Labels (1)
Comments
afujikawa
Partner - Creator
Partner - Creator

Hi @Benoit_C ,

Thanks for the quick reply.

Best regards,
afujikawa

willtech93
Partner - Contributor
Partner - Contributor

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
Partner - Creator III
Partner - Creator III

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
Support
Support

Hello @sis,

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

Regards,
Benoit

sis
Partner - Creator III
Partner - Creator III

Hi @Benoit_C  ,

Thanks for the quick reply.

Qlik_FZ
Partner - Creator
Partner - Creator

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
Contributor
Contributor

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
Contributor II
Contributor II

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
Digital Support
Digital Support

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

Version history
Last update:
‎2023-10-17 02:33 AM
Updated by: