Skip to main content

Qlik Web Connector for Sharepoint 365 Internal Server Error in Script Editor for Qlik Sense

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Juli_K
Former Employee
Former Employee

Qlik Web Connector for Sharepoint 365 Internal Server Error in Script Editor for Qlik Sense

Last Update:

Mar 21, 2024 6:03:10 AM

Updated By:

Sonja_Bauernfeind

Created date:

Mar 11, 2021 8:45:46 AM

When attempting to connect to the Sharepoint 365 Qlik Web Connector in the Script Editor the following error is shown "Internal Server Error."

Juli_K_0-1615401426453.png

The URL can be accessed without issue outside of Qlik by other applications. The necessary ports have been opened and Server connectivity is stable.

This article is intended for the stand-alone installation of Qlik Web Connectors, rather than built in connectors. See Install connectors separately.

Environment

  • Qlik Sense;  multiple node environment
  • Qlik Web Connector March 2020;  December 2020

 

Resolution

Open the deploy.config located in the WebConnector folder

Locate DefaultAllowed IPAddresses and insert "Any" as seen below:

<DefaultAllowedIpAddresses>any</DefaultAllowedIpAddresses>

Locate AllowRemoteAccess and insert "true" as seen below:

<AllowRemoteAccess>true</AllowRemoteAccess>

The <AllowRemoteAccesss> set to true allows the following setting to be seen when selecting

My Settings in the Web Connector UI:

Juli_K_1-1615402077216.png

Add Allowed IP Addresses :  [any] in the Web Connector UI as seen above

 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

 

Labels (1)
Comments
Anil_Babu_Samineni

Really good, Thanks for this 🙂

AlexOmetis
Partner Ambassador
Partner Ambassador

Can you confirm if this is a bug where you have to set this to "any" rather than entering the IP addresses of the servers that will be loading data from QWC?

If it's a bug, can you confirm if it is resolved in versions following Dec 2020 (e.g. April 2022, June 2022)?

Sonja_Bauernfeind
Digital Support
Digital Support

Hello, @AlexOmetis I cannot locate this as a defect. If you believe that this is a defect, please log a ticket with support to have this fully investigated.

All the best,
Sonja 

 

aniket_patil
Partner - Contributor II
Partner - Contributor II

Thank you so much for sharing. It worked for me. 

@Juli_K 

joshishu
Contributor II
Contributor II

Where I can find WebConnector folder any help

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @joshishu 

This article specifically deals with an installed instance of the Web Connectors (Install connectors separately). You would manually choose this folder on install.

All the best,
Sonja 

Version history
Last update:
4 weeks ago
Updated by: