Lists refresh indefinitely or take a long time to load

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

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

Section 2: Damaged Userpref.dat file

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

1. Locate your company directory. Refer to 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.

Section 3: All Transactions in 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.

Note: 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 is a large number of transactions in this area. Use filter criteria whenever selecting All Transactions in 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.

Section 4: 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 be beneficial to reduce the overall data size. See How to Purge data.
4. Close File Statistics.
5. Open the list that is slow and set Date Range to All Transactions.
6. Allow the list to load; this may take a while.
7. Check the number of transactions listed, given at the bottom left of the screen.
   • If there are a lot of transactions, run a purge to remove the older data and improve performance, even if the file size of the company is not over 300,000 KB

Section 5: Anti-virus

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

Section 6: IPv6 enabled

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

Section 7: Create a clean data folder

Refer to Create a clean data folder and expendable file cleanup.

Section 8: 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.

Section 9: Restore a backup

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

Section 10: 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.

Section 11: Damaged positions key

Follow Section 2 of Task window opens minimized or cannot be seen.

Section 12: 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.