Error: "An error occurred attempting to retrieve lookup data" in Sage Intelligence

Summary

You see this error while trying to run any Sage Intelligence Reports (BI Reports) in Sage 300

Description

You are trying to run any Sage Intelligence reports and:

  • You see the error, “An error occurred attempting to retrieve lookup data. This error does not prevent you from running the report but may cause the lookup feature to be unavailable. The error was” [followed by an internal message from the SQL Server
  • Excel does not have the BI add-in menu bar
  • In Excel > Add-Ins, when you try to add the BI Generator, it fails or does not respond

Possible Resolution

  • Enabled TLS 1.0 & TLS 1.1 and Reboot the Server