Skip to main content

 

Hello,

We are concerned about the PDF_ARCHIVE_TAB blobs not being cleaned up by the daily “Heavy Cleanup” Database task. Despite the expiry date passing for the PDFs, the blobs remain in the database.

Given that storage costs are a significant factor, how can we effectively manage the continuously growing database due to these blobs?

By using following query, we discovered the yearly increase of 3TB

SELECT EXTRACT(YEAR FROM created) AS year,
SUM(DBMS_LOB.GETLENGTH(PDF)) / 1048576 AS total_size_mb_PDF_ARCHIVE
FROM PDF_ARCHIVE
GROUP BY EXTRACT(YEAR FROM created)
ORDER BY year;

Anyone experience with the appropriate settings in IFS Cloud ?

Besr Regards

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?

Terms & ConditionsCookie settingsAccessibility statement