Attempting to export a large table from a document on the QlikView AccessPoint fails.
Right-clicking on the object and selecting Send to Excel will either fail or only export partial data.
The following line will be registered in the QlikView Server Events log file:
System: XlsxExport: Exception(29803) is caught. Normally this is caused by over-sized excel file. Please check the Cpu time and Memory Limit for excel export feature. Now we have a default time limit of 180 seconds, and a memory limit of 0 MB for QlikView Server.
In this case, 0MB means no limit on the size of the Excel export.
QlikView 12.20 (November 2017) and later
Edit or add the following config parameters in C:\ProgramData\QlikTech\QlikViewServer\Settings.ini and then restart the services.
QvExportTimeLimitSec is the time limit in seconds. Use -1 if you do not want to apply a limit. The default values are 180 on the QlikView Server and -1 on Desktop.
QvExportMemoryLimitMB is the memory limit for exporting objects in MB. Use 0 if you do not want to apply a memory limit.
The setting needs to be applied in the settings.ini file in as a [Settings 7] property.
Please note that if the setting is added under the [Authentication] property, it will not be read by the QlikView Server Service.
Also note that this issue can be caused by an issue with the customer's Alternate Temporary Files Folder Path in the QMC under QMC > System > Setup > QVS > Folders. If the path isn't correct or points to a folder that no longer exists, all Excel exports will fail. You will see entries in QVS event logs regarding the bad path.