Skip to content
logo Knowledgebase

Lists refresh indefinitely or take a long time to load

Created on  | Last modified on 

Summary

Transaction lists refresh indefinitely, don’t load, or take a long time to load in Sage 50 Accounting.

Resolution

CAUTION: 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.

 

Enable "Do not save last selected Date Range in List Views"

See How do I stop transaction lists from defaulting to the last date range selected?.

Damaged Userpref.dat file

Note: This process resets all customized screens and preferences back to the system default. You’ll need to reapply any options or dashboard changes that you made.

  1. Locate your company directory. See How to locate company directories.
  2. Close Sage 50 on all machines.
  3. Press the Windows key + E to open the File Explorer.
  4. Browse to your company's directory.
  5. Rename Userpref.DAT to OLDUserpref.DAT.
  6. Close File Explorer.
  7. Reopen Sage 50 and the company.
  8. Verify the list loads correctly.

All Transactions in a large company

Change the Date Range selection to a shorter time frame.

  1. Select Date Range.
  2. From the list, select This Period, This Quarter, or This Year.
  3. Verify the list loads with no issues.

When opening a transaction list window with a timeframe set to All Transactions, the program will display every transaction in the company in that area. This can take some time to load if there’s many transactions in this area. Use filter criteria whenever selecting All Transactions in the list windows and selecting a shorter time frame such as This Period before closing out of the window. This issue can affect one user login while not impacting others.

Check company size and number of records

  1. Select Help, Support Utilities, File Statistics.
  2. Scroll to the bottom to find Grand Total.
  3. If Grand Total is 300,000 KB or higher, a purge may help to reduce the overall data size. See How to Purge data.
  4. Close File Statistics.
  5. Open the list that’s slow and set the Date Range to All Transactions.
  6. Allow the list to load, which can take a while.
  7. Check the number of transactions listed, given at the bottom left of the screen.
    • If there are many transactions, run a purge to remove the older data and improve performance, even if the file size of the company isn’t over 300,000 KB

Antivirus

  1. Disable antivirus.
  2. Configure antivirus not to scan your data path and program path on server and workstations. See How to find data path and program path.
  3. Configure antivirus not to scan the C:\Program Files (x86)\Actian folder or the C:\Program Files\Actian folder.

IPv6 enabled

Configure Windows OS to prefer IPv4 addresses over IPv6. See How to set Windows 10 to prefer IPv4 over IPv6.

Create a clean data folder

See Create a clean data folder and expendable file cleanup.

On a network the workstation data path is pointed locally instead of to the server

If on a network and the workstation's data path is pointed locally rather than to the server, this can cause these symptoms.

See How to change the data path to change the data path to go to the network.

Damaged files in the program path

  1. Uninstall Sage 50. See How to manually remove the program.
  2. Reinstall Sage 50. See Installation Instructions - Sage 50—U.S. Edition.
  3. Verify when run a list, it opens with no issues.

Restore a backup

If the Maintenance drop-down list is empty, restore a backup. Refer to How to restore a backup.

Actian is running as an auto-load rather than as a service

  1. Close Sage 50 on all computers.
  2. Press Ctrl+Shift+Esc on your keyboard to open the Task Manager.
  3. Select the Details (or Processes) tab and look for w3dbsmgr.exe (on 2023.0 and later, zenengnapp.exe).
  4. Right-click that process and select End task and then End Process.
  5. Browse to the Services tab at the top, sort by name, and look for psqlWGE (on 2023.0 and later, zenengine).
  6. Right-click psqlWGE and select Start.

Damaged positions key

See a Task window opens minimized or cannot be seen and follow Section 2.

Asterisk fields selected

  1. Select Settings at the top of the list window.
  2. On the Selected Columns list, remove any items selected with *.
    Note: Items with an * at the end of the name will also cause the list to load indefinitely. For each of these items added to this list, Sage must perform additional database calls to pull the information.

 

Need more help?

Chat now