Starting from Qlik Sense November 2017, the Qlik Sense Repository Service removed any soft deleted items.
One of the impact of that is the table ExecutionResult gets cleaned out of the task execution result after reaching a certain amount of historical data.
This amount is configurable and below are some explanation on how it works and how to configure it.
Note: Changing this setting can have a negative impact on overall performance so recommend not touching this setting if possible.
If you want to keep more historical data of the ExecutionResult table we would instead recommend to load this table in a Qlik Sense and eventually store it into a QVD so that it can be reused.
Anyway to change this setting you need to edit the file C:\ProgramFiles\Qlik\Sense\Repository\Repository.exe.config (Please make sure to take a backup first and to stop the Qlik Sense services)
In this file you will find the parameter ExecutionResultsAmountKept. (Default is 3)
NOTE: In the most recent version, you may not have the row 'ExecutionResultsAmountKept', but should have a new one : MinNumberOfExecutionResultsToKeepPerTask |
The setting is used the following way:
- When reloading an app for the first time, logs are kept for the first ExecutionResultsAmountKept x 3 - 1 reloads.
- At reload number ExecutionResultsAmountKept x 3, the log files for the 2 x ExecutionResultsAmountKept - 1 oldest reloads are deleted.
- The deletion leaves the log files for the ExecutionResultsAmountKept + 1 latest reloads.
- With further reloads of the app, every 2 x ExecutionResultsAmountKept reload deletes the log files for the 2 x ExecutionResultsAmountKept oldest reloads.
- The deletion leaves the log files for the ExecutionResultsAmountKept + 1 latest reloads.
Replacing ExecutionResultsAmountKept with the default setting (3) gives the following:
- When reloading an app for the first time, logs are kept for the first 3 x 3 - 1 = 8 reloads.
- At reload number 3 x 3 = 9, the log files for the 2 x 3 - 1 = 5 oldest reloads are deleted.
- The deletion leaves the log files for the 3 + 1 = 4 latest reloads.
- With further reloads of the app, every 2 x 3 = 6th reload deletes the log files for the 2 x 3 = 6 oldest reloads.
- The deletion leaves the log files for the 3 + 1 = 4 latest reloads.
Environment:
Qlik Sense November June 2018