How to reset the package hash for all software distribution packages in sql database.
Use the following script to run a query for the package_files_hash which will reset all the package hashes to null.
NOTE: Please make sure you backup your database prior to running the query.
1. New query
UPDATE PACKAGE_FILES_HASH SET HASH = null WHERE PACKAGE_FILES_HASH_IDN > 0
2. F5 to execute
Once executed the PACKAGE_FILES_HASH table will reset all HASH to NULL. Schedule a task and start, the HASH will update with a new HASH code.