topic Re: Rest connector error with connection on load script in App Development

Rest connector error with connection on load script

NVG_egodinho — Thu, 20 Jul 2023 15:46:50 GMT

Good afternoon, I installed the qlik sense May 2023 version and when doing tests with the rest connector I got the following error.

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

I looked in the help and there it says that there is a property in the connection that we have to activate.

"Select Allow "WITH CONNECTION" to use the “WITH CONNECTION” keyword in load statements. If your load statement includes “WITH CONNECTION” and this option is not selected, an error will occur."

But I can't find this setting when creating or changing the connection!!!

Can anyone help.

Best regards, Élio Godinho

Re: Rest connector error with connection on load script

Chetan_MN — Thu, 20 Jul 2023 16:25:40 GMT

Could you please try installing May 2023 Patch2.

Re: Rest connector error with connection on load script

NVG_egodinho — Thu, 20 Jul 2023 16:33:44 GMT

At the moment i have installed

Do you suggest installing patch 2 again?

Re: Rest connector error with connection on load script

NVG_egodinho — Thu, 20 Jul 2023 16:34:24 GMT

At the moment i have installed

Do you suggest installing patch 2 again?

Re: Rest connector error with connection on load script

Chetan_MN — Thu, 20 Jul 2023 16:37:29 GMT

We are currently investigating this issue.

Below is the current work around, Can you please try it and let us know if it works?

Steps:

1. Delete this file: (take a backup in case)
C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector\qsdfw_qsefw_qlikview.qliksourceconfig

2. Uninstall Patch 3.

3. Install Patch 3 again

Re: Rest connector error with connection on load script

NVG_egodinho — Thu, 20 Jul 2023 16:49:31 GMT

How to uninstall patch 3?

Re: Rest connector error with connection on load script

Chetan_MN — Thu, 20 Jul 2023 17:11:14 GMT

Hi @NVG
https://community.qlik.com/t5/Official-Support-Articles/Installing-and-uninstalling-Qlik-Sense-Patches/ta-p/1812001

Re: Rest connector error with connection on load script

p_verkooijen — Fri, 21 Jul 2023 12:07:29 GMT

Have the exact same issue.

Following the steps (including a mandatory reboot between remove an reinstall Patch 3) results in broken REST connector libraries stating that QvRestConnector.exe is an Unknown connection type

Ultimately removed Patch 3 and restored the file qsdfw_qsefw_qlikview.qliksourceconfig

Issue resolved, you need to reinstall Patch 2

WITH CONNECTION is a setting that already exists in SaaS

SaaS is currently REST Connector version 2.201.0

QSEW May2023 with patch2, connector is version 2.183.0 (Patch 3 = 2.195.0)

The latest version for download is 2.183.0 (used for QlikView environments)

Re: Rest connector error with connection on load script

NVG_egodinho — Fri, 21 Jul 2023 08:47:40 GMT

Thanks for your feedback.

just one more note, the version of the rest connetor,The rest connector version in patch 3 is

Regards.

Re: Rest connector error with connection on load script

LDR — Fri, 21 Jul 2023 10:03:45 GMT

Hello,

I have the same issue. I have QS Enterprise release May'2023 Patch 3 installed.

@Chetan_MN , please, as soon as it's fixed please let us know.

Regards

Re: Rest connector error with connection on load script

NVG_egodinho — Fri, 21 Jul 2023 11:38:59 GMT

A last question, Did you install the connector manually or was it installed by qlik sense update?

regards

Re: Rest connector error with connection on load script

p_verkooijen — Fri, 21 Jul 2023 12:06:29 GMT

Hi @NVG_egodinho the connector comes with QS.

I see patch includes the updated connector (opened the patch file with WinRAR)

Re: Rest connector error with connection on load script

p_verkooijen — Fri, 21 Jul 2023 12:15:55 GMT

If patch 3 fixed something you really need, maybe you can manually downgrade the connector

Create a backup of the folder C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector
Use the attached .zip containing the full QvRestConnector folder content of version 2.183.0

Re: Rest connector error with connection on load script

p_verkooijen — Fri, 21 Jul 2023 14:56:35 GMT

See the official fix here: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-May-2023-Patch-3-causes-REST-connection-error-quot/ta-p/2096170

Re: Rest connector error with connection on load script

Chetan_MN — Wed, 08 Nov 2023 04:44:38 GMT

Hi @LDR This has been fixed in Aug 2023 and later releases