How to replace the data dictionary files in Sage 100 ERP

Summary

How to replace the data dictionary files in Sage 100 ERP

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

These steps require knowledge of database engines and application databases (DBs) used by your Sage product (including Microsoft/Transact SQL, Pervasive SQL, or MySQL, etc.)

Cause

Some or all portions of the Data Dictionary files have become corrupted or unusable

Resolution

Warning: Data dictionary files are critical to data integrity. Due consideration should be made before deciding to proceed with any of the three methods outlined below. Before attempting any of them, make sure you have a full backup set safely aside.

Method One

Rename the data dictionary folder and files, and Copy the files/folder from a backup (made before the problem began occurring) and paste them into the program. (Note: User-defined fields (UDFs) created or updated since the time of the backup will have to be updated again to the data dictionary files, or there may be errors with lookups, reports, etc.)

  1. Via Windows Explorer, go to the “..\MAS90” location where Sage 100 ERP is installed.
  2. Rename the following files and folder:
    • ..\MAS90\Providex.* (all Providex.* files files directly under “..\MAS90”)
    • ..\MAS90\SOA\SY0DCT.soa
    • ..\MAS90\DDicts\ (the entire folder)
  3. Access the backup, locate the files listed above and copy them (Note: The files should all be from the same backup set)
  4. Place the backup copies into their respective locations in the current, live installation.

Method Two

Rename the data dictionary folder and files, and Copy the files/folder from a new installation of your version of Sage 100 ERP (including same Product Update, third party enhancements if any, etc.) (Note: If there are user-defined fields (UDFs), they must be updated again to the data dictionary files, or there may be errors with lookups, reports, etc.)

  1. Via Windows Explorer, go to the “..\MAS90” location where Sage 100 ERP is installed.
  2. Rename the following files and folder:
    • ..\MAS90\Providex.* (all Providex.* files files directly under “..\MAS90”)
    • ..\MAS90\SOA\SY0DCT.soa
    • ..\MAS90\DDicts\ (the entire folder)
  3. Access the new installation of Sage 100 ERP, locate the files listed above and copy them (Note: The new installation must be the same version of Sage 100 ERP, same Product Update, same individual program fixes or hot fixes (if any), and same third-party enhancements)
  4. Place the new copies into their respective locations in the current, live installation.

Method Three

Rename the data dictionary folder and files, and reinstall the Sage 100 ERP program into the same location (including same Product Update, third party enhancements if any, etc.) (Note: If there are user-defined fields (UDFs), they must be updated again to the data dictionary files, or there may be errors with lookups, reports, etc.)

  1. Via Windows Explorer, go to the “..\MAS90” location where Sage 100 ERP is installed.
  2. Rename the following files and folder:
    • ..\MAS90\Providex.* (all Providex.* files files directly under “..\MAS90”)
    • ..\MAS90\SOA\SY0DCT.soa
    • ..\MAS90\DDicts\ (the entire folder)
  3. Re-install Sage 100 ERP to the same location, selecting the Repair option when prompted.
  4. The renamed files and folder should be replaced via the re-intall process.