If you have recently performed an upgrade to Agile PLM and noticed that your attachment sizes have a 0 file size, don’t panic. Thanks to a useful utility shipped with Agile 9.3.x you can update your database to get the correct sizes to show, here are the instructions on how to do it yourself:

1. Unzip FixVault.zip which can be found in <AGILE_HOME>agileDomaintools
2. Navigate to the extracted directory <AGILE_HOME>agileDomaintoolsFixVault
3. I chose to create a batch file (fix.bat) to avoid entry mistakes. The contents are:

   java -jar FixFileSizeUtility.jar -dburl srvagiledb:1521:agile9 -dbuserid agile
           -dbpassword tartan -ifsuser ifsuser -ifspassword agile -log  > fixvault_output.txt

4. Open a command window to <AGILE_HOME>agileDomaintoolsFixVault
5. Execute fix.bat
6. Our test vault had over 65,000 files in it and it took approximately 25-30 minutes to run
7. Now look at your part’s attachment again to verify the file size was updated