Alexander's Blog

 Upon previewing email content in Azure Web App, one could get the following error: 9668 03:27:56 ERROR Exception: Sitecore.EmailCampaign.Model.Web.Exceptions.NonCriticalException Message: Failed to download string content, URL: https://testazure-cm.azurewebsites.net/?sc_itemid=%7B229384AB-6279-42BC-925F-1D28C0227C03%7D&sc_lang=en&sc_device=%7BFE5D7FDF-89C0-4D99-9AA3-B5FBD009C9F3%7D&ec_database=master&ec_id=96F0189C036942DDA62BCE8D68C6D1C7&ec_message_id=583137BAD51D4491AD8D07451BCC9000, Use IIS Credentials: True, UserAgent: ECM Dispatch Source: Sitecore.EmailCampaign    at Sitecore.Modules.EmailCampaign.Core.WebContent.DownloadString(String url, Boolean useIisCredentials, String userAgent)    at Sitecore.Modules.EmailCampaign.Messages.WebPageMail.GetMessageBody(Boolean preview)    at Sitecore.EmailCampaign.Cm.MessageInfo.FillContentEditorInfo() Nested Exception Exception: System.Net.WebException Message: The remote server returned an error: (403) Forbidden. Source:

If you are setting up a Sitecore Publishing Service, sooner or later you would most likely need to execute the script: Sitecore.Framework.Publishing.Host.exe schema upgrade --force There is a chance that the following issue would occur when you run that script. C:\inetpub\wwwroot\alextestPublishingService42>Sitecore.Framework.Publishing.Host.exe schema upgrade --force [23:48:16 INF] Schema Upgrade [23:48:16 INF] Upgrading all databases to version [ 2 ] [23:48:16 ERR] One or more errors occurred. System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'XP0.930_Core' .    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) ... omitted ... at Sitecore