Qlik Sense SharePoint Connector: noFileSize, getConnectionInfo failures and extremely slow performance

[NicklasGårdh]

Environment

• Qlik Sense Enterprise on Windows
• Qlik Sense May 2025 Patch 20 
• SharePoint Online via Web Storage Provider Connector
• Windows Server 2019

Symptoms

We started experiencing several seemingly unrelated issues when accessing files stored in SharePoint Online:

In the Data Load Editor

• SharePoint connections became extremely slow to open.
• The connection dialog would sometimes spin indefinitely.
• Creating a new SharePoint connection occasionally failed with:

Could not get connection info from server

Browser Console

The browser console showed repeated errors similar to:

connector: error executing connector method getConnectionInfo,
retrying: QvWebStorageProviderConnectorPackage.exe

Reload Scripts

Reloads using SharePoint files failed intermittently with:

Error: noFileSize

Example:

LOAD *
FROM [lib://SharePoint (...)/Test.xlsx]
(ooxml, embedded labels, table is Test);

The error often occurred after approximately 60 seconds.

Reload Performance

Reloads that previously completed in around 30 seconds suddenly required several minutes, and some reloads failed while others succeeded.

Initial Investigation

We verified:

• SharePoint Online accessibility
• DNS resolution
• TLS connectivity
• Microsoft Graph connectivity
• Qlik Sense patch level
• Web Storage Provider Connector version
• Security rules
• Scheduler permissions
• Service account permissions

We also compared the environment against another Qlik Sense server running the same version where SharePoint connections worked normally.

Nothing obvious was found.

Important Observation

During troubleshooting we discovered that the following folder had stopped updating around the same time the issue started:

C:\ProgramData\Qlik\Custom Data\QvWebStorageProviderConnectorPackage

Specifically, the log folder contained no recent updates even though the connector was actively being used.

On a healthy server, new log files continued to be generated.

Resolution

We stopped the relevant Qlik services and renamed the connector state folder:

C:\ProgramData\Qlik\Custom Data\QvWebStorageProviderConnectorPackage

to:

C:\ProgramData\Qlik\Custom Data\QvWebStorageProviderConnectorPackage_old

After restarting the services, Qlik recreated the folder automatically.

Immediately afterwards:

• SharePoint connections opened normally.
• getConnectionInfo errors disappeared.
• New connector log files were generated.
• Reload performance returned to normal.
• Reload tasks started succeeding again.

Root Cause (Suspected)

We were not able to identify the exact file responsible, but the evidence suggests corruption in the Web Storage Provider Connector's local state, cache, token store, or logging data under:

C:\ProgramData\Qlik\Custom Data\QvWebStorageProviderConnectorPackage

The connector executable itself was not replaced and connector versions were identical between the working and non-working environments.

Lessons Learned

If you experience any combination of:

• Could not get connection info from server
• getConnectionInfo errors
• noFileSize
• Extremely slow SharePoint connections
• Intermittent SharePoint reload failures

check the following folder before spending too much time on SharePoint, OAuth, network, TLS or connector reinstalls:

C:\ProgramData\Qlik\Custom Data\QvWebStorageProviderConnectorPackage

Renaming the folder and allowing Qlik to recreate it may resolve the issue.

Notes

Before deleting the old folder, keep it for a few days to verify that all reloads continue to run successfully.