Description |
|
| Unable To Export Large Objects To Excel After Upgrading to November 2017 due to additional configuration parameters. After upgrading to QlikView November 2017 release or newer, attempting to use Excel Export by right-clicking > "Send to Excel", the export will fail or file will bring only 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 time limit of 180 seconds, and memory limit of 0 MB. Environment:
|
|
Cause |
|
| November 2017 introduces additional configuration parameters for Data Export. See article QlikView November 2017 Export to XLSX for more information. | |
Resolution |
|
Edit or add the following config parameters in C:\ProgramData\QlikTech\QlikViewServer\Settings.ini and Restart Services: QvExportTimeLimitSec=-1 QvExportMemoryLimitMB=0 Description: QvExportTimeLimitSec (Use -1 if you don't want time limit; Default Values:-->On Server: 180 Desktop: -1) Time limit for exporting object to Xlsx. Integer number in seconds. QvExportMemoryLimitMB (Use 0 if you don't want memory limit;) Memory limit for exporting object to Xlsx. Integer number in MB. |
Unable To Export Large Objects To Excel After Upgrading to November 2017
Comments
0 comments
Please sign in to leave a comment.