File Repository Size Query
When I check the attach folder by running the query below, it returns a value of 12737251383 bytes (11.9GB), but when I navigate to the folder location on the NAS and manually check the properties, the total file repository size is only 11.4GB.
SELECT SUM(CAST(SRLF_SIZE AS NUMBER))
WHERE SRLF_PARENT_PATH LIKE '%.\attach\%'
How can this be?
We know there could be some mistmatch information between DB and the repository, I haven't tested the query you provided but I will try to run it in one of my projects.
Also remember that when you delete items in the project, ALM still keep those files until the cleaning job runs.
One alternative is to run the "Align Repository" from the site admin, this option will sync the information from your repository with the database, of course before doing this the best is to do a backup.
HP QC/ALM support team
Ariel, thanks for your reply.
Do you have any more details on the frequency and duration of the clean-up job you mention. Does this happen weekly at a specific time?
Take a look at this thread.
And you might want to look at this knowledge base article:
(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
It keeps on growing and does not show the actual size even though the file is deleted and the space is empty.
You need to perform a reindexing or some time even a GUI copy of the project to show the actual size.