Export to excel QV May 2023 SR2 in new environment

[PaulinaWanago]

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?

[Chip_Matejowsky]

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

[PaulinaWanago]

Hi Chip, 

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

[Chip_Matejowsky]

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

[PaulinaWanago]

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..

[Chip_Matejowsky · Accepted solution]

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

[PaulinaWanago]

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.