Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Extracting into Blob Storage

(0) ShareShare
ReportReport
Posted on by 5

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

  • Ken M Profile Picture
    Ken M 5 on at
    RE: Extracting into Blob Storage

    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

  • Ken M Profile Picture
    Ken M 5 on at
    RE: Extracting into Blob Storage

    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

  • Suggested answer
    sbtron Profile Picture
    sbtron on at
    RE: Extracting into Blob Storage

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans