topic Qlik Sense Enterprise Native Sharepoint Connection Issue in Connectivity & Data Prep

Qlik Sense Enterprise Native Sharepoint Connection Issue

Rehan — Thu, 13 Feb 2025 01:45:55 GMT

We are currently using Qlik Sense Enterprise May 2024 Release Patch 10. Qlik Native sharepoint connector requires encryption keys to be set on the server. We set up the same encryption keys on all three environments (QA, Dev and Prod). The issue we are facing is that the sharepoint connection works fine in QA and Dev but in Prod it only works by loading manually in the workspace. In Prod QMC it fails with the below error. Prod is a cluster environment with 2 nodes and the same key is set in both nodes.

We are trying to resolve this issue ASAP since its a prod issue.

20250212T202203.962-0500 0028 FROM [lib://ABC Connection/Qlik 1 and 2 Trainings /Info.xls]
20250212T202203.962-0500 0029 (biff, embedded labels, table is _Info$)
20250212T202304.105-0500 Error: noFileSize
20250212T202304.105-0500 noFileSize
20250212T202304.105-0500 Execution Failed

Re: Qlik Sense Enterprise Native Sharepoint Connection Issue

Vegar — Thu, 13 Feb 2025 07:24:39 GMT

Could it be that when you run the task manually then you run it from ServerA, and when the QMC execute the task it runs it on ServerB?

If so, then it could be a network/firewall issue blocking the traffic between ServerB and sharepoint on the required ports.

This would be the first thing I would try to verify if I where to troubleshoot such an issue.

Re: Qlik Sense Enterprise Native Sharepoint Connection Issue

Rehan — Fri, 14 Feb 2025 14:27:27 GMT

Thanks for the response but I just tried accessing the URL from both nodes and it works so I guess permissions or access is not an issue