You may see one of the following errors in Orchestrate after an upgrade.
Unable to log in
⚠️Error: An unexpected error occurred. Please report this problem to your system administrator with the following information:
System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Plugins', database 'database_name', schema 'orc'.
Cannot import data
This error can also appear with either of the following import objects.
⚠️Error: An unexpected error occurred. Please report this problem to your system administrator with the following information:
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'Populate_FM_OrcStaging', database 'FMAST20', schema 'dbo'.
⚠️Error: An unexpected error occurred. Please report this problem to your system administrator with the following information:
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'SFDCSyncFrom', database 'Orc_Live', schema 'dbo'.
Resolve this error
This issue has been resolved in Orchestrate version 7.76 hotfix 30 and Orchestrate version 7.77. Upgrading to either of these versions or above will fix this error.
📌Note: If the error continues to occur after upgrading, please raise a new case online and reference the title of this article.