KB0019347 – SQL Express has 10 gigabytes limit which can cause issues with Ephesoft.

Applies to: All versions of Ephesoft Transact

Issue

SQL Server Express edition only has a 10 GB limit and is causing issues with Ephesoft.

Solution

The following recommendations can be considered.

1. Customer need to make sure that the clean up is executing successfully so that it can keep the most used table sizes in check. Please see the link below on how to clean up the Activiti tables and reporting service.
link

2. Customer can point the reporting-archive database to a different database server or can execute a script to take a 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 you don’t need reporting data on UI older than 1 week, then they can set the purging cron to execute every weekend. This feature is only supported on Ephesoft v4.0.6.1 and above.