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

[peter_nbc]

Hi @Albert_Candelario and @Sonja_Bauernfeind 

I have attached to pictures to this post about regarding the error.

The first one is my script I am trying to load. First I get an access token (this part works fine). Then I store that access token in a variable and use it in the next rest connector using  "With connection". The reason I need this, is because the access token is only valid for 1 hour, so I need to do it this way in order to make it dynamic and make it fetch a new token every time I run the script. 

The second picture is the error message I get, when I try to run it.

Do you have any ideas on how to fix this?

Best,
Peter

[Sonja_Bauernfeind]

Hello @peter_nbc Please provide the screenshot of your connector settings in the post as requested by Albert and communicate there. Link back to your  post: Dynamic token handling - "With connection" failing 

All the best,
Sonja 

[Albert_Candelario]

@peter_nbc 's issue has been resolved after marking the proper setting on the connection.

Cheers,

Albert