Purge Info_services_rpt

Hi @paguin ,

Did you find a solution for this?

/Shanaka

Hi,

The rows in Info_services_rpt are supposed to be removed by the standard Heavy Cleanup job when it removes reports from the Report Archive.

/Krister

HI @Krister Liljedahl I’ll check this. for this customer  INFO_SERVICES_RPT table contains around 1 billion records and occupies around 780 GB.

/Shanaka

Best thing is to backup the records available in the archive_tab by using result key and then truncate the table.

After that reinsert the records which already in the backup.  

Hi @Krister Liljedahl ,

This is correct as the Heavy cleanup job removes the data in info_services_rpt
 

DELETE FROM INFO_SERVICES_RPT WHERE RESULT_KEY = :result_key

/Shanaka