VERIFIED SOLUTION i

Resolve error 'An Unhandled error has occured in the application' on trying to edit/create new message in EngageOne Content Author Client


 

Issue

On trying to edit message in Content Author client, following error occurs on newly created/restored environment.

User-added image

Microsoft.ApplicationBlocks.ExceptionManagement.G1ApplicationException: RasiGetImage() returned error code InternalError at Message1.DataFacade.GetResourcesForMessage(Int32 messageId, Int32 campaignId, EditorLicenceInfo licenceInfo, Boolean usedResourcesOnly, Boolean restrictedAccess, String& resourceXML, String& messageContent) at MessageProperties_UserControls_Editor.DisplayEditor() at MessageProperties_UserControls_Editor.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Cause

This could occur due to insufficient privilege or reset of privilege associated with 'ResourceServer' database or the 'ResourceServerUser' login that is created with 'ResourceServer' database.

Resolution

UPDATED: June 7, 2017
Possible steps to resolve are:

1. Open the SQL Server Management Studio and log into SQL Server hosting Content Author  'ResourceServer' DB.
2. Drill down to Instance>Databases>ResourceServer>Security>Users.
3. Delete the 'ResourceServerUser' user.
4. Drill down to Instance>Security>Logins.
5. Delete the 'ResourceServerUser' login.
6. Right-click the server instance and restart the server.
7. Open the CCM (Content Author Configuration Manager) Configuration Tool.
8. On each page, click the Apply button. This will recreate the 'ResourceServerUser' login in SQL.
9. Go back to the SQL Server Management Studio.
10. Drill down to Instance>Security>Logins.
11. Right-click 'ResourceServerUser' and select Properties.
12. Ensure the Enforce Password Policy is unchecked and sysadmin
privilege is enabled.
13. Select OK. Close the SQL Server Management Studio.
14.Try to edit the message.

.