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

@Sonja_Bauernfeind Could you please confirm if these bug have been fixed? In the release notes of may 2023 patch6 and august 2023 release notes there is no info about the fix of QB-20735.

Thanks in advance.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Serkan I am actively in talks with our support agents on this. Will hopefully have an update today.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Serkan @Skage @EAQLIKSUPPORT 

While our developers are still investigating the possibility of mitigating the issue automatically, our resolution at this point is to either:

  • upgrade to August 2023 (which is not affected)
  • or deploy the manual workaround

The article was updated to reflect the advise.

All the best,
Sonja 

Skage
Partner - Contributor III
Partner - Contributor III

@Sonja_Bauernfeind 

For some reason I can't get the fix with the replaced config to work with May 2023 so I tried to upgrade to August 2023+P2 and it still doesn't work.

Skage_0-1696257174478.png

 

The current qsdfw_qsefw_qlikview.qliksourceconfig is updated with the same timestamp as all other files in the folder.

/lars

Skage
Partner - Contributor III
Partner - Contributor III

@Sonja_Bauernfeind 

I apologize now I found the new checkbox. It works as designed...

/lars

afujikawa
Partner - Creator
Partner - Creator

Hi @Benoit_C,

Is it ok to run Resolution 1-4 in an environment that does not use REST connection?
We have a customer who is unable to confirm whether or not a REST connection is used.

Best regards,
afujikawa

Benoit_C
Support
Support

Hi @afujikawa,
If they have no issue it's not needed to do it, in another hand it does hurt to apply the resolution. It's up to you.

Regards,
Benoit

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Skage Thank you for confirming! 

afujikawa
Partner - Creator
Partner - Creator

Hi @Benoit_C ,

Thank you for your reply.
Is there any negative impact of running Resolution 1-4 in an environment that does not use the REST connection?

Best regards,
afujikawa

Benoit_C
Support
Support

Hi @afujikawa
You're welcome, there is no negative impact.

Regards,
Benoit

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