Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aslam19965
Contributor II
Contributor II

Qlik SharePoint365 Connector Whitelist error

Dear Community,

I am trying to Load data from the Qlik Web Connectors SharePoint365 connector but when I tried to load the  data, the application failed with and Internal Server ErrorThis error appears only when the load uses Scheduler from a RIM node and works fine when the scheduler node is Central.  When I checked the Web Connector Logs, I found out the the load failed because the Request is from a non Whitelisted IP and the UserIP was that of a RIM node that we use. 

<Message>Request from non whitelisted IP address</Message> 

Therefore I added the IP address to the llowed IP List in the WebConnector Settings. But I still get the Internal Server Error.

What could be the reason? Please Help.

Thanks and Regards,

Aslam

13 Replies
Aslam19965
Contributor II
Contributor II
Author

I logged in with admin privileges and added the IP on the QWC Allowed IP settings. I am not sure how I can Allow IP Address for a specific QWC business user. 

chrisbrain
Partner - Specialist II
Partner - Specialist II

I think you need the business user who is logging in to the QWC web UI to also set that IP address for themselves.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Aslam19965
Contributor II
Contributor II
Author

Wow! That Worked! Thanks a lot for your Guidance Chris! I never knew each QWC users had to whitelist the IPs. I guess this is the case only with form authentication. We very recently implemented it.

Thank You for the solution!

chrisbrain
Partner - Specialist II
Partner - Specialist II

Great! Glad you got it solved.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense