Print Release database is taking up too much disk space

Issue description

The Print Release database may consume higher than usual disk space. Checking the disk space used per table, it is observed that the REPORT_USER_JOBTYPE and REPORT_PRINTER_JOBTYPE tables take the most space.

Explanation

• The bloating of the REPORT_ tables is usually due to multiple report aggregators sending data to the same database.
• This usually happens in systems where there are multiple workgroup installations that are configured to utilize the same database backend.

Solution

To resolve this issue, the following procedures will need to be performed:

1. Stop all instances of the Lexmark Reports Aggregator service. Check on all of the server machines if the service exists and then stop it.

   


2. Clear the REPORT_ tables. To do this, run the SQL commands below (tested on MSSQL):

   • TRUNCATE TABLE REPORT_COLOR_MONO;
   • TRUNCATE TABLE REPORT_DUPLEX_SIMPLEX;
   • TRUNCATE TABLE REPORT_JOBTYPE;
   • TRUNCATE TABLE REPORT_PRINTED_DELETED;
   • TRUNCATE TABLE REPORT_PRINTER_JOBTYPE;
   • TRUNCATE TABLE REPORT_USER_JOBTYPE;

   These commands will clear the tables. They will be repopulated as soon as an instance of the aggregator is started.



3. To prevent duplicate entries and bloating the reports tables in the future, there should only be one instance of the Lexmark Reports Aggregator Service that is running. Set one instance of the aggregator to start automatically on boot and disable all other instances.

   Set the Startup Type to Automatic on one server, and the rest to Disabled.