data2

Data Scrubber Utility

It’s good practice, to check that your database is healthy on a periodic basis.  Over time, its possible to build up orphaned records, detail records that contain values that do not total to summary records, and other things that can cause performance, and data integrity issues.

As long as you are current on maintenance, Epicor supply a tool that lets you check that your database is in tip top condition, and will provide programs to resolve any issues that are uncovered.  This is recommended not only before an upgrade to ensure things go smoothly, but on a periodic basis for optimal database health.

The data scrubber utility is a collection of commonly applied data fixes, which the support technical team has gathered together into a package to do a “health check” of a customer’s system. They are continuously adding to it as they find additional opportunities.

The process:

  • Customer would log an issue requesting from support, we can do this under our customer’s site ID
    or Run the program against the database of choice
  • Each sub-routine will stop when it finds an invalid record and create an entry in a log file, then move on to the next routine (no tracking of the specific errors at this point)
  • Generates a log file which gets sent back to support.  Support will then send the relevant fix programs back to the customer
  • The customer runs each fix program, which will show all the relevant records and provide a chance to fix all, some or none of the records. This gives the customer enough information to troubleshoot the cause of the data problem and to fix it at source

This collection of assessment algorithms is new in the last few months, but the ‘fix it’ programs have been available individually for some time
now.

An assessment should be considered like a maintenance routine, and should be run for database health for all customers periodically, anyone going through a Business Process Review and anyone considering an Upgrade.

We will consider using this utility to get ahead of any E10 upgrades for database health and troubleshooting. We want to ensure that our customers upgrade with ‘good’ data. For larger databases, it may take a good couple of days, but it is really worth it!

The utility was discussed in several sessions at Epicor’s Insights 2015, so many of our customers will have heard about it and may be asking themselves questions.

Please Contact Us if you have any questions.

Pin It