an image of an IT employee carrying otu an epicor database health check

Database Health Check

Database Health Check: Epicor Data Scrubber Utility It’s good practice to check that your database health is at an appropriate

Database Health Check: Epicor Data Scrubber Utility

It’s good practice to check that your database health is at an appropriate level on a periodic basis. Over time, it’s 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:

  • The 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 as 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 maybe asking themselves questions.

About Encompass Solutions

Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers and Distributors. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.

David Cranshaw
Latest posts by David Cranshaw (see all)

About David Cranshaw

Dave has been supporting Epicor EDI implementations since 2007 and has a full understanding of both the standard transactions supported by the Epicor product, and due to his technical background has assisted with multiple non-standard transactions that require custom solutions to be built for unique industries. Dave also manages our internal development resources and high profile technical projects, and, as such, has had extensive experience managing Epicor projects over the last five years.