Wikis - Page

Project repository does not reduce in size

0 Likes

In some cases the file repository for an ALM project does not reduce in size as users delete entities in the GUI.
This might be due to a failure in the Smart Repository GC (Garbage Collection) job performed by the server.

To diagnose:

Issue the followin query to the ALM site administation db/schema...

select * from projects;

Identify the record in the results which aligns with the project in question

Examine the value of the field PR_SR_GC_LAST_RUN_TIME

To correct:

If the value in the field PR_SR_GC_LAST_RUN_TIME the table PROJECTS is 0, is it OK to update this value to the current epoch time at the site admin database...

select * from projects where PR_SR_GC_LAST_RUN_TIME = 0

update projects set PR_SR_GC_LAST_RUN_TIME = (select cast(datediff(ss,'1970-1-1 08:00:00',getdate()) as varchar) + '000') where project_id=178;

The Smart Repository GC job should now reduce the size of the file repository

Labels:

How To-Best Practice
Comment List
Related
Recommended