topic Re: QlikSense May 2023 Patch 3 - Rest Connection returns error using "WITH CONNECTION" in Management & Governance

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

andregas — Fri, 21 Jul 2023 10:53:16 GMT

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

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

Benoit_C — Tue, 25 Jul 2023 07:16:20 GMT

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-connection-error-quot/ta-p/2096170

Regards,
Benoit

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

andregas — Tue, 25 Jul 2023 13:41:04 GMT

Good @Benoit_C.

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

Regards

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

blaise — Tue, 05 Sep 2023 12:08:13 GMT

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.

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

stascher — Tue, 19 Sep 2023 11:09:32 GMT

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

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

andregas — Mon, 25 Sep 2023 07:55:08 GMT

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.