Problem : How do I change the default duration of TRITON AP-DATA archive partitions, for example for a high volume of incidents?

Resolution : TRITON AP-DATA incidents are archived in partitions. From version 7.8.x, each created partition contains records for a 91-day interval by default.

Support can re-configure this interval for customers in the SQL Server management database. Partitions can be created as frequently as once per day if required.
1. On the TRITON management server/SQL Server (If the database is on remote server), open Microsoft SQL Server Management Studio.
2. Open the wbsn-data-security database.
3. Locate the PA_CONFIG_PROPERTIES table.
4. Find the property PARTITION_DURATION_DAYS
5. Use the update script to change the property's value. For example, this script would set the partition duration to 2 days:
Update PA_CONFIG_PROPERTIES set value = 2 where NAME = 'PARTITION_DURATION_DAYS'
6. Save the changes you make to the database.
7. Restart the Data Security manager service to deploy your changes.