Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Sage 100 ERP Secret System File Rebuild Utilities

August 7, 2013 by Wayne Schulz

sage100rebuild

If you’ve ever encountered an issue with Sage 100 ERP having and issue and you suspect that a system file (user names, company master file, etc) could be at fault then you probably already know that there is a hidden utility to help you rebuild those files.

For versions 4.05 and LOWER the utility is accessed by selecting:

Rebuild system file(s) with SVXBLD.

  1. Have all users exit Sage MAS 90 now Sage 100 ERP
  2. Open Windows Explorer and go to ..\Mas90\Home
  3. Double-click PVXWIN32.EXE (or right-click the file and select ‘Open’).
  4. Click the ‘Ok’ button on the splash screen. A blank screen with a ‘Greater Than’ ( > ) prompt should appear.
  5. Type RUN “SVXBLD” (with the quotes) and press ‘Enter’. SVXBLD should open.

Beginning with version 4.10 you use a new hidden utility – sy_rebuildsystem.m4p

  1. Get all users out of Sage ERP MAS 90 or MAS 200. (And for MAS 200, the Service or Application must be stopped).
  2. Via Windows Explorer, access the live “..\MAS90\Home” directory on the server where MAS 90 or 200 is installed.
  3. Double-click on the Pvxwin32.exe program to access a command line window.
  4. Type in the following command and press the Enter key: run “sy_rebuildsystem.m4p
  5. At the User Logon prompt, enter your user logon and password.
  6. Once past the warning prompt, a Rebuild Key Files window will appear, displaying the available system files that can be rebuilt.

 

If neither of the above (depending upon your respective Sage 100 ERP version) does the trick – you can try the UFAR utility which is a character based tool used as a last chance effort to rebuild system files (BACKUP ANYTHING YOU ARE TRYING TO REPAIR BEFORE USING):

 

Use UFAR as a last resort after other methods have failed to restore or repair the file. No log file is created and it is impossible to determine what records are deleted.
Steps to run UFAR:

  1. Make a backup of the file to be repaired and have all users exit MAS 90
  2. On the server double click the file ..\mas90\home\PVXWIN32.EXE
  3. At the command prompt type: RUN “*UFAR”
  4. At ‘Name of KEYED/DIRECT/EFF file’ type: SY0CTL.SOA and press ‘Enter’
  5. If rebuilding a ‘non-system’ file the path is required.
  6. At the prompt for the temporary file name, accept the default backup name (for example: Sy0ctl.b00), and press ENTER.
  7. At the “Recover for Highest Active Index or Physical End of Record” message, select the desired option and press ENTER.
  8. the default ‘Highest Active Index’ is the correct choice for SY0CTL.SOA
  9. Using the cursor keys select ‘D Wrong’ then select ‘E Wrong’ then select Yes and Yes again.
  10. Type BYE to return to the command prompt.

Share this:

Filed Under: Sage 100 ERP, slider Tagged With: mas200, repair, sage 100, Sage 100 ERP, sy0ctl, ufar, utilities

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)
  • What Are My Sage 100 Mobile Sales Options?

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in