topic Re: Export to excel QV May 2023 SR2 in new environment in QlikView

Export to excel QV May 2023 SR2 in new environment

PaulinaWanago — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

In new environment the export data to excel is not possible (export is in hung state). On testing environment with one node the issue has been fixed by installing QV plugin. On production multi-node environment I've installed QV plugin on main server in cluster (distribution server), but export to excel is still not possible. Looks like there is missing communication between distribution server and AP server. The dashboard reloaded on QMC are visible on AccessPoint, so perhaps there is something missing in configuration files related to QVplugin.

How to fix it? What should be checked?

Re: Export to excel QV May 2023 SR2 in new environment

Chip_Matejowsky — Thu, 09 Jan 2025 17:14:44 GMT

Hello @PaulinaWanago,

The QlikView server alternative temp folder is a designated directory used to store temporary files when a QlikView server is part of a cluster or load-balanced environment, allowing the server to utilize a shared temporary file location accessible by all servers within the cluster, ensuring smooth data processing and avoiding potential conflicts arising from individual temporary file locations on each server. The directory has to be accessible to all nodes in the QlikView server cluster environment.

Do you have the Alternate Temporary Files Folder Path configured in QlikView Management Console (QMC) > System > Setup > QlikView Server > QVS@ > Folder tab?

Best Regards

Re: Export to excel QV May 2023 SR2 in new environment

PaulinaWanago — Fri, 10 Jan 2025 08:07:10 GMT

Hi Chip,

Yes, the Alternate Temporary Files Folder Path is configured and located on Distribution server.

Re: Export to excel QV May 2023 SR2 in new environment

Chip_Matejowsky — Fri, 10 Jan 2025 13:06:00 GMT

Okay. Try exporting to Excel and immediately check the alternate temp folder to see if a temp file is generated. Also, check the QlikView Server Events log for any entries regarding export to Excel and upload log here.

Best Regards

Re: Export to excel QV May 2023 SR2 in new environment

PaulinaWanago — Fri, 10 Jan 2025 13:45:54 GMT

The alternate temp folder is empty during the export.

In Event log I've found error:

Error System: XlsxExport: can't close workbook with error: Error creating output xlsx file. Usually a permissions error..

Re: Export to excel QV May 2023 SR2 in new environment

Chip_Matejowsky — Fri, 10 Jan 2025 13:55:12 GMT

Okay, check the Settings.ini file of each QVS node (default is %ProgramData%\QlikTech\QlikViewServer) for the Alternate Temp Folder location to ensure they are correct. If yes, try configuring a different location that is accessible for both QVS nodes.

Best Regards

Re: Export to excel QV May 2023 SR2 in new environment

PaulinaWanago — Fri, 10 Jan 2025 14:25:28 GMT

Hi Chip,

The issue resolved.

On the server there was missing Temp folder. I've create it and it works now 🙂

Thank you for directions.