Last Updated on
KB Article #: KB0019347
Issue: Customer has SQL Server Express edition installed which only has a 10 GB limit and is causing issues with Ephesoft.
Steps to take:
Following recommendations can be considered.
1. Customer need to make sure that the clean up is executing successfully, so that it can keep the mostly used table sizes in check. Please see link below on how to clean up the activiti tables and reporting service.
2. Customer can point the reporting-archive database to a different database server or can execute a script to take timely backup of the report_archive database and clear the report_archive database.
3. Customer can increase the frequency of reporting purge operation by modifying the cron dcma.report.purging.cronExpression in dcma-reporting.properties which is by default set to execute after every 3 months. If customer does not need reporting data on UI older than 1 week, then they can set the purging cron to execute every week end. This feature is only supported on Ephesoft v220.127.116.11 and above.