QlikSense May 2023 Patch 3 - Rest Connection returns error using "WITH CONNECTION"

[andregas]

Hello Community,

After update QlikSense May 2023 to patch 3 I've found an error during reload using REST connector and "WITH CONNECTION" method.

The error is the following:

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

Unfortunately this flag it's hidden. To enabled it you must edit the file "C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector\qsdfw_qsefw_qlikview.qliksourceconfig" in all QlikSense nodes adding the following line.

Between the property queryHeaders and PaginationType add the following:

<Property>
<Name>allowWithConnection</Name>
<DisplayName>Allow "WITH CONNECTION"</DisplayName>
<Description>Allow "WITH CONNECTION"</Description>
<InputType>checkbox</InputType>
<GroupName>Additional request parameters</GroupName>
</Property>

Example:

...
<Property>
<Name>queryHeaders</Name>
...
</Property>
<Property>
<Name>allowWithConnection</Name>
<DisplayName>Allow "WITH CONNECTION"</DisplayName>
<Description>Allow "WITH CONNECTION"</Description>
<InputType>checkbox</InputType>
<GroupName>Additional request parameters</GroupName>
</Property>
<Property styleName="mediumselect">
<Name>PaginationType</Name>
...
</Property>
...

You could find the file alredy edited here as attached.

Otherwise, if cannot edit the file you could add "allowWithConnection=true;" to your connection string.
To edit the connection string: go into QMC, enter in Data connection section, search and select your connection, press edit, modify the Connection string.

I hope it could be useful.

Regards

[Benoit_C · Accepted solution]

Hi @andregas,

Many thanks for this initiative. 

For your information, this is a known defect and we have published an article with the workaround:

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-May-2023-Patch-3-causes-REST-conn...

Regards,
Benoit

[andregas]

Good @Benoit_C.

We came to the same solution, I proud of mine 😁

Regards

[blaise]

Hi @andregas 

I did not succeed with altering the connection string in QMC - where did you place it? Im thinking if the order of the different settings is important.

[stascher]

Also did not work for me. I wonder if the server needs to be restarted after the modification.

[andregas]

Sorry, I haven't no more instance with that patch to retest the solution 2. Maybe I tried to edit the string after I edited the file and it worked because I had already added the support.

Sorry.

I suggest you to update to the latest patch.