Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
andregas
Partner - Creator II
Partner - Creator II

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

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

Labels (2)
1 Solution

Accepted Solutions
Benoit_C
Support
Support

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

View solution in original post

5 Replies
Benoit_C
Support
Support

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
Partner - Creator II
Partner - Creator II
Author

Good @Benoit_C.

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

Regards

blaise
Partner - Specialist
Partner - Specialist

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

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

andregas
Partner - Creator II
Partner - Creator II
Author

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.