Advanced Rebuild Utility Now Available for Sage 100
DSD Business Systems has created a new and improved way of rebuilding sort files in Sage 100!
With DSD’s LMRS Rebuild Sort Scheduler enhancement for Sage 100, you can now schedule your data rebuilds to occur after hours, with less chance of failure due to file & record locking. Additionally, you can choose which rebuilds need to be performed by Company Code, and you can see more detail on what data was fixed/rebuilt.
Standard Sage 100 already has “Rebuild Sort Files” for each Module, but there are a few constraints with these rebuilds:
1. The standard Sage 100 rebuilds must be run from a menu and cannot be added to the Sage 100 Task Scheduler to run after-hours. For those users that want to run the utilities on a daily basis while all users are out of the system, it requires that the user logs into Sage 100 each night to manually do the process.
2. The standard Sage 100 rebuilds lock files in order to do the process. If a user is logged into a maintenance or data entry program, the utilities cannot run since many files are locked. This requires that the user running the Sage utilities “kill” the processes that the other user is running in Master Console. This can cause data corruption.
3. The standard Sage 100 rebuilds do not show you what records were actually fixed/rebuilt, so you don’t really know if any data issues were repaired, and what those issues were.
4. The standard Sage 100 rebuilds must be run for each module separately.
The DSD LMRS Rebuild SortScheduler enhancement for Sage 100 solves many of these problems!
A new “DSD Rebuild Sort Data Setup Maintenance” menu item is added to Library Master / Utilities that allows setup of the rebuilds by Company Code. All rebuild tasks from all Sage 100 modules have been added to this setup, and you can choose which tasks can be performed for that Company Code. There’s an additional field that allows entry of an Email Address to email if any issues occur (such as locked records) when the utility is run.
Once you setup the Company Code, you can then add the utility as scheduled task, or you can run it immediately from the new menu option in Library Master / Utilities called “DSD Rebuild Sort Data.
To schedule the rebuild, you can access the Sage 100 Task Scheduler from the Library Master / Main menu and fill in the appropriate fields for the scheduled task, including the time of day to run the rebuild automatically. You have the option of having the scheduled task run for ALL company codes, or you can give it a list of companies.
As mentioned, the standard Sage 100 Sort Rebuild lock files prior to the rebuild, and this is an issue if a user has a maintenance or data entry menu option open.
The biggest benefit of the DSD Rebuild is that it does NOT lock data files to do the rebuild. Instead, the records of the file are read, and if a field needs to be recalculated for that record (such as the Open Order Amount for a Customer record), only then is the record EXTRACTED to make the change. If the record is in use by another process, the records will be skipped, and the log file that is generated will show a Warning that that specific record is locked. This valuable feature minimizes the chances of a failed rebuild.
As the rebuild runs, a Log file is generated that includes important information about the rebuild, including date/time of execution, what files were rebuilt successfully, what records were changed/updated, and what records had a failure do to records in use.
After the rebuild has completed all tasks, an entry into the Activity Log is written with the Log File attached.
For more information on the LMRS Rebuild Sorts enhancement, please visit our website.
