Hi,
I would like to set up on-going extraction for 365 Marketing Insights into Blob Storage.
I have set up the Azure storage account and container for this purpose following the online guidance, and provided the access URL for the CRM connector.
I wasn't sure if necessary (as it was not requested in documentation), but I provided blob contributor role to the Azure CRM accounts- in case this was an issue.
CRM produces an error (Business Process Error: We were unable to start the connector). I have also provided log below.
Can anyone assist/point me in the right direction please..?
at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.CreateInternal(Entity entity, InvocationContext invocationContext, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, Dictionary`2 optionalParameters)
at Microsoft.Crm.Extensibility.OData.CrmODataExecutionContext.CreateOrganizationResponse(Entity entity)
at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.CreateEdmEntity(CrmODataExecutionContext context, String edmEntityName, EdmEntityObject entityObject, Boolean isUpsert)
at Microsoft.Crm.Extensibility.OData.EntityController.PostEntitySetImplementation(String& entitySetName, EdmEntityObject entityObject)
at Microsoft.Crm.Extensibility.OData.CrmODataUtilities.<>c__DisplayClass10_0`2.<InvokeActionAndLogMetric>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()
Activity Id: bdb8f7f4-afbd-4a30-814e-0f38e79d9465
Update: This morning, the blade error message stopped, and I followed exactly the same sequence and it worked... Not sure now what the underlying issue was , and can't really offer much advice for anyone following. It would certainly be useful to have the online steps explicitly state the accounts that are used on the Azure and CRM side, and the permissions that are required. Thanks
Hi Saurabh,
Yes, I selected all those permissions. I have also been assuming the issue is with permissions, and have also now been given admin access to the CRM Marketing Insights App- so I have used the same AAD account for both CRM and Azure. Still getting same error. In fact this evening I have had a new erro (Storage failed initialising) from from Storage Explorer (When selecting: Get SAS on the Container) which is new today..!
The blade Extension/Microsoft_Azure_Storage/Blade/StorageExplorerBlade failed to supply all the required parameters. The missing the required parameter(s) 'context'.
Essentially I need a crib sheet, to understand what account I should be using at both sides (Azure , and CRM) when following the instructions... Also, I Was unsure what to put in the [Allowed IP Addresses] area.
Would really appreciate any help
Could you confirm you have setup all the permissions on the Azure Blob storage when generating the SAS token (specifically read, write, delete, list) -
docs.microsoft.com/.../custom-analytics
If the problem still continues after making sure you have setup the right permissions on blob storage then I suggest you open up a support ticket.
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156