How to change the data retention in FlexiCapture Reporting Service?
Data retention times and other cleanup parameters can be specified in the "AppSettings" section of the appsettings.json file (the default location of this file is C:\inetpub\wwwroot\FlexiCapture12Reporting\). You can specify the following parameters:
- CheckPartitionsPeriodSec - How often the service should check for outdated partitions (in seconds). The default value is 6 hours. If this parameter is set to 0, no cleanup will be done.
- ReservedPartitionsCountMonths - The number of partitions to reserve. The default value is 6. When the database is first created, partitions will be reserved for the current month and for the 6 months following the current month.
- DataStorageIntervalMonth - How long the data should be retained (in months, including the current month). The default value is 2. No data will be deleted from the active partition currently accepting data.