Environment
- App Control Server: 8.0.x - 8.6.x
- FilePath_Pruning_Scope_AllVersion.sql script
- FilePathNamePruningBat_X.X.X.zip: All Versions
Question
When do I run the DeleteOrphanedNames_x.x.x.bat from the FilePathNamePruningBat_X.X.X.zip?
Answer
The DeleteOrphanedNames_x.x.x.bat (part of the FilePathNamePruningBat_X.X.X.zip package) should be used to clear orphaned filename and pathnames when the system has a high percentage of orphaned entries as determined by the 'FilePath_Pruning_Scope_AllVersion.sql'.
Additional Notes
- A code change was added in Server version 8.7 to reuse unused rows. As such this script is not supported on 8.7 and Higher
- So the' FilePath_Pruning_Scope_AllVersion.sql' script does NOT reveal anything in regards to the need for Reseed operation. This will show the number of orphaned filenames and pathnames in the DAS database tables only.
Related Content