Error: “An unexpected error occurred: Exception has been thrown by the target of an invocation”

Products

  • Sage Business Cloud Enterprise Management (formerly Sage X3)
  • Sage 50—Canadian Edition
  • Sage 50—U.S. Edition
  • Sage 100 Contractor
  • Sage 100
  • Sage 300
  • Sage Intelligence
  • Sage 500 ERP

Description

An error occurs during report run and opening Excel.
Error: “An unexpected error occurred: Exception has been thrown by the target of an invocation”

https://support.na.sage.com/Platform/Publishing/images/29524.png

Operating System Warning

This solution requires advanced knowledge of your computer’s operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions.

Cause

The user does not have the correct permissions needed to register components to allow the Report Designer Add-in Taskpane to load correctly.

Resolution

Modify the permissions of the Users group of the following registry key to Full Control or Read/write.
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\

https://support.na.sage.com/Platform/Publishing/images/29524-1.png