PDF Archive cleanup

Hi ​@MCIPSTEV 

I assume there are no error messages in Heavy Cleanup job. Do You have any customized reports? How many records do You have in Print Manager window?

Regarding IFS Cloud I only noticed problems with xml_report_archive_tab table.

There are no error messages, and I cannot understand the process of cleanup.

As you can see the expire date is last year, but the reports are still present in the database and the blob
 

Is there any week to remove the blobs older than a given date ?

Expire date is set based on Report Life time. Each report has its own value. There can be problem with printouts which are stayed in other state than Complete(Print Manager page) or there is an also hidden flag but I do not know on which table. There are few tables related to this.

Check also this query. How many rows there are?

        SELECT count(1)
         FROM   archive_tab
         WHERE result_key NOT IN (SELECT result_key FROM  archive_distribution_tab);

Hi ​@MCIPSTEV 

Please check the background job for Heavy cleanup task and see if you find any warnings related to Archive_API.Cleanup__

Regards,

Damith

The output of the following query : 0

SELECT count(1)
         FROM   archive_tab
         WHERE result_key NOT IN (SELECT result_key FROM  archive_distribution_tab);

What is the normal process when the Report Life time has passed, and where is it defined ?

How many rows do You have in: archive_tab, archive_distribution_tab, print_job_contents_tab tables?