Skip to content
logo Knowledgebase

Error: "External component has thrown an exception..." after product upgrade

Created on  | Last modified on  Highlight Matches

Summary

After upgrading, Sage HRMS payroll fails to migrate the vault and store database. The system returns the error: "External component has thrown an exception. Unable to connect to Payroll database".

Resolution

Run this resolution only with Sage HRMS payroll Q1‑2024. Other versions don’t use this process.
Update payroll security files

Follow these steps on each affected client workstation.

  1. Close Sage HRMS if it’s running.
  2. Locate Abra.Payroll.Security.DLL on the client workstation. By default, it's in the C:\Program Files (x86)\Sage\Sage HRMS Client folder.
  3. Rename Abra.Payroll.Security.DLL to Abra.Payroll.Security.DLL.old.
  4. Copy the new Abra.Payroll.Security.DLL and UpdateSecurityUsers.exe files to the same folder.
  5. Right‑click UpdateSecurityUsers.exe and run it as administrator.
  6. Enter and confirm the same strong password when prompted.
  7. Launch Sage HRMS.

NOTE:

You can delete UpdateSecurityUsers.exe after the update completes.

 The error occurs for Windows users with non-administrator rights

  • Assign the Creator and Security Admin server roles to the SQL user account
  • Run Sage HRMS as administrator at least once after updating SQL roles

 Users receive the error "Your password has expired. Ask your administrator to change it"

Local Security Policy settings prevent automatic overrides.
  • IT staff needs to use the HRMSUpdateSecurityUsers utility to reset the Sage 300 Admin password before it expires
  • Track the password expiration date and reset it before expiration

Need more help?

Chat now