Error: "This transaction could not be processed..."

Summary

There are several reasons why you receive the error 'This transaction could not be processed because the company database could not be found" in Sage 50 Accounting. The options below will assist you in troubleshooting the error.

Resolution

▼ The file is on a network
  1. Open the sample company to see if the same error comes up.
  2. If the sample company doesn’t open, review the steps in this article.
  3. If unable to reproduce the error in sample company, the cause is environmental or the network connection is unstable.
  4. Restart the connection manager service on the server computer.
▼ You share your data through Remote Data Access (RDA)
  1. Download the file again and give it a new name.
  2. Check that the new file doesn’t crash.
▼ The data is on a stand-alone computer

Check the Error log

  1. Locate the company file and open the SAJ folder.
  2. Open the errorlog.txt file and check for anything unusual such as a hex dump. (Refer to the picture below for a sample of a hex dump).
    Example of Errorlog.txt.
  3. If the "errorlog.txt" file shows something similar to the screenshot, then it’s a data corruption issue. Contact support at 1-888-522-2722 to check if you can send the data in for a chargeable data repair service.
  4. Run the Advanced Database Check. If you still receive the error, contact support at 1-888-522-2722 to see if you can send the data in for a chargeable repair.

Move the company file to a less restrictive location on the computer

  1. Select File, Save As.
  2. Under the C drive, create a new folder. (IE Named Accounting Data).
  3. Double-click on the newly created folder.
  4. Change the File name.
  5. Click Save.

Uninstall and reinstall Sage 50

  1. Uninstall and reinstall Sage 50.
  2. Create a folder on the C Drive.
  3. Move Sage 50 to the new folder.
▼ The file is on a USB

 NOTE: If data stored on a USB suddenly causes errors, the USB lost connection during a database write, resulting in a Hex dump or file damage. 

  1. Restore from a backup.
  2. Verify that you no longer receive the error.
  3. Call Sage Support at 1-888-522-2722 to have the file sent in to our Data Repair team for a chargeable repair.
▼ Looking Up Invoices
  1. You’ll find in the Search invoice window. The Start date is empty.
  2. Pick a start date to eliminate the error.
  3. But the invoice lookup date is still missing in the Support Utilities.
  4. To fix the issue permanently, go to Maintenance.
  5. Select Clear Data.
  6. Select Clear Lookup Data.
  7. Select Clear Purchase Invoice & Sales Invoice Lookup Data.
  8. Enter the date you set up the database. You can find the date in Setup, Settings, Company, Information, under the Historical Financial Year Dates section.
  9. Select OK.
  10. Make a Backup of your company file.
  11. Select Yes.
▼ When posting invoices
  1. Go to Windows Start, Control Panel, Administrative Tools, Event Viewer.
  2. On the left panel, click Windows Logs then under Name choose Application.
  3. Under Source look for a recent entry for an application error, check the detail and see if you have a Faulting module name: mysqladmin.exe, if yes proceed to the next step.
  4. Uninstall Sage 50, and all mysqlodbc connectors.
  5. Rename the winsim folder in C:\Program Files (x86)\winsim.
  6. Reinstall Sage 50.
  1. Go to Maintenance.
  2. Select Clear Data.
  3. Select Clear Inventory Tracking Data.
  4. Use the date when you set up this database. You can find the date in Setup, Settings, Company, Information, under the Historical Financial Year Dates section.
  5. Select OK.
  6. Make a backup at this point if you haven't.
  7. Select Yes.

Need more help?

Chat now

 

 

Solution Properties

Solution ID
221924750011903
Last Modified Date
Tue Jun 24 22:05:05 UTC 2025
Attributes
Product Details
Integrated Product: Blueprints
Views
0