When requesting an export to Excel or Print using the QlikView Ajax client, QlikView Server creates a temporary Excel file on the server. The file will be removed after one hour (3600s).
The time until deletion can be customized.
By default, QlikView Server scans through the temp folder once an hour and removes all the files that are at least one hour old. This means that a file is stored somewhere between 1 and 2 hours, depending on when the file was created in relation to when the latest scanning occurred.
The value you can change is ServerTempSecTimeout (default 3600) which changes both time values.
E.g. if the setting is changed to 1800 (30 minutes), QlikView Server will scan the temp folder every 30 minutes. Any file that is at least 30 minutes old will be removed.
The temporary folder can be found in \QlikTech\QlikViewServer\Temp Folder
Resolution
In our example, we configure the files to be deleted immediately after download.
- Stop the QlikView Server service
- In a Windows File browser, browse to: C:\ProgramData\QlikTech\QlikViewServer\
- Open the settings.ini (if necessary, with administrative permissions)
- Add the following entry in the [Settings 7] section:
[Settings 7]
RemoveExcelAfterDownload=1
Note: The setting references excel, but the setting also impacts HTML/PDF files.
Environment:
QlikView
