Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Not Able to Export the...
Finance forum
Suggested answer

Not Able to Export the Data from D365 finance and operations using Data management

(0) ShareShare
ReportReport
Posted on by Pushpendra 40

Hi All , 

Hope u all are doing good !!

There is a strange issue i been facing  while exporting the data from D365 finance and operations.

Platform on :- Update32 (7.0.5493.35497)

I am getting this error highlighted below 

Microsoft.WindowsAzure.Storage.StorageException: The remote server returned an error: (403) Forbidden. ---> System.Net.WebException: The remote server returned an error: (403) Forbidden.
at System.Net.HttpWebRequest.GetResponse()
at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext)
--- End of inner exception stack trace ---
at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext)
at Microsoft.WindowsAzure.Storage.Table.CloudTable.Exists(Boolean primaryOnly, TableRequestOptions requestOptions, OperationContext operationContext)
at Microsoft.WindowsAzure.Storage.Table.CloudTable.CreateIfNotExists(TableRequestOptions requestOptions, OperationContext operationContext)
at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.PerformOperation(CloudStorageAccount storageAccount, String tableName, Func`1 operation)
at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.AddRecord[T](CloudStorageAccount storageAccount, String tableName, T record)
at Microsoft.DynamicsOnline.Infrastructure.Components.SharedServiceUnitStorage.SharedServiceUnitStorage.CreateData(SharedServiceUnitStorageData data, Boolean setDirectPathWhenAvailable)
at Dynamics.AX.Application.DmfDataPopulation.`getBlobWriteUrlInCategory(Guid _fileId, String _fileName, Boolean getDirectBlobLinkWhenAvailable, String category) in xppSource://Source/ApplicationFoundation\AxClass_DmfDataPopulation.xpp:line 153
at Dynamics.AX.Application.DmfDataPopulation.getBlobWriteUrlInCategory(Guid _fileId, String _fileName, Boolean getDirectBlobLinkWhenAvailable, String category)
at Dynamics.AX.Application.DmfDataPopulation.`getAzureBlobWriteUrl(Guid _fileId, String _fileName, String category, Boolean @category_IsDefaultSet) in xppSource://Source/ApplicationFoundation\AxClass_DmfDataPopulation.xpp:line 111
at Dynamics.AX.Application.DmfDataPopulation.getAzureBlobWriteUrl(Guid _fileId, String _fileName, String category, Boolean @category_IsDefaultSet)
at Dynamics.AX.Application.DmfDataPopulation.getAzureBlobWriteUrl(Guid _fileId, String _fileName)
at Dynamics.AX.Application.DMFGenerateSSISPackage.`generateFileDataV2(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution, String _defGroupName, DMFFileFormat _fileFormat, DMFDelimiter _rowDelimiter, DMFDelimiter _columnDelimiter, String _codePage, String _locale, NoYes _isFirstRowHeader, NoYes _unicode, String _source, String _textQualifier, DMFXMLStyle _style, String _rootElement, String _filePath, Map _entitySyncVersion, Int32 _previewCount, Boolean @_entitySyncVersion_IsDefaultSet, Boolean @_previewCount_IsDefaultSet) in xppSource://Source/ApplicationFoundation\AxClass_DMFGenerateSSISPackage.xpp:line 1070
Request Information
RequestID:2d87d9c1-7002-0006-12f9-12594c000000
RequestDate:Wed, 15 Apr 2020 07:44:44 GMT
StatusMessage:Forbidden
ErrorCode:AuthorizationFailure

 

I have tried to flow this blog written by  to resolve my issue 

 https://community.dynamics.com/365/financeandoperations/b/365foroperationstechnical/posts/error-s-while-uploading-the-file--after-installing-10-0-8-pu32-on-local-vm 

And try to install the  latest azure storage emulator and perform the steps and all went successfully but when after all i tried to run the export of customer group i am again getting the same error .

Thanks 

Pushpendra singh 

Categories:
Other
Administration and Setup
  • Suggested answer
    Community member Profile Picture
    Community member 4 on at
    Not Able to Export the Data from D365 finance and operations using Data management

    I had same error:

     
       at System.Net.HttpWebRequest.GetResponse()
       at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext)
       --- End of inner exception stack trace ---
       at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext)
       at Microsoft.WindowsAzure.Storage.Table.CloudTable.Create(TableRequestOptions requestOptions, OperationContext operationContext)
       at Microsoft.WindowsAzure.Storage.Table.CloudTable.CreateIfNotExists(TableRequestOptions requestOptions, OperationContext operationContext)
       at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.PerformOperation(CloudStorageAccount storageAccount, String tableName, Func`1 operation, String callingMethod) in D:\dbs\sh\l23t\1211_210841\cmd\2\Source\Frameworks\DynamicsOnline\ClxServicesWrapper\Infrastructure\TableStorageAccess\TableStorageAccessor.cs:line 172
       at Microsoft.DynamicsOnline.Infrastructure.Components.TableAccessor.TableStorageAccessor.AddRecord[T](CloudStorageAccount storageAccount, String tableName, T record) in D:\dbs\sh\l23t\1211_210841\cmd\2\Source\Frameworks\DynamicsOnline\ClxServicesWrapper\Infrastructure\TableStorageAccess\TableStorageAccessor.cs:line 41
       at Microsoft.DynamicsOnline.Infrastructure.Components.SharedServiceUnitStorage.SharedServiceUnitStorage.CreateData(SharedServiceUnitStorageData data, Boolean setDirectPathWhenAvailable) in D:\dbs\sh\l23t\1211_210841\cmd\2\Source\Frameworks\DynamicsOnline\ClxServicesWrapper\SharedCSUStorage\SharedServiceUnitStorage.cs:line 270
       at Dynamics.AX.Application.DmfDataPopulation.`getBlobWriteUrlInCategory(Guid _fileId, String _fileName, Boolean getDirectBlobLinkWhenAvailable, String category)
       at Dynamics.AX.Application.DmfDataPopulation.getBlobWriteUrlInCategory(Guid _fileId, String _fileName, Boolean getDirectBlobLinkWhenAvailable, String category)
       at Dynamics.AX.Application.DmfDataPopulation.`getAzureBlobWriteUrl(Guid _fileId, String _fileName, String category, Boolean @category_IsDefaultSet)
       at Dynamics.AX.Application.DmfDataPopulation.getAzureBlobWriteUrl(Guid _fileId, String _fileName, String category, Boolean @category_IsDefaultSet)
       at Dynamics.AX.Application.DmfDataPopulation.getAzureBlobWriteUrl(Guid _fileId, String _fileName)
       at Dynamics.AX.Application.DMFGenerateSSISPackage.generateFileDataV2Inner(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution, String _defGroupName, DMFFileFormat _fileFormat, DMFDelimiter _rowDelimiter, DMFDelimiter _columnDelimiter, String _codePage, String _locale, NoYes _isFirstRowHeader, NoYes _unicode, String _source, String _textQualifier, DMFXMLStyle _style, String _rootElement, String _filePath, Map _entitySyncVersion, Int32 _previewCount, Boolean _updateOnError)
    Request Information
    RequestID:a324fcb0-9de1-41a2-bb84-a96f07422ab6
    RequestDate:Thu, 25 Jan 2024 19:27:35 GMT
    StatusMessage:Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
    ErrorCode:AuthenticationFailed
    ErrorMessage:Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
    RequestId:a324fcb0-9de1-41a2-bb84-a96f07422ab6
    Time:2024-01-25T19:27:35.2242497Z
     

    After long troubleshooting I came up with this solution which worked for me:

     
    • I'm using local onebox VM
    • First I tried Data Management: "Error(s) while uploading the file-" solution. I'm not sure why but for me it looks like D365FO doesn't recognize AzureStorageEmulator or can not access it. 
      • From error code looks like it tries to create storage table (CreateIfNotExists) but was not able to do so. 
    • Next step I Installed Azure Storage Explorer - to check if I can connect there using this tool. 
      • There I tried to connect to "Local storage emulator" - But get error that can not access it because "Azurite" is not running.
      • At this stage I expected that AzureStorageEmulator - should be running. 
    • Then Installed Azurite emulator
      • npm install -g azurite
      • Created c:\azurite folder
      • Disabled AzureStorageEmulator service - (We need to shut it down, because we will not be able to start azurite)
      • azurite --silent --location c:\azurite --debug c:\azurite\debug.log
    • After that Azure storage explorer was able to connect to local azure storage emulator
    • And D365FO DMF started to work for me as well. 
      • I'm able to import or export Data entities
    • Additional things:
      • To start azurite automatically We need open "Task Scheduler" and disable DynamicsStartAzureStorageEmulator
      • Create new task with this command "azurite --silent --location c:\azurite --debug c:\azurite\debug.log"
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Ah, perhaps this is related to the expired SSL certificate on the system. If this is the case, you should definetely see some warning also when logging in the system via browser. But so far you didn't mention about such warnings. To rotate the secrets, go to environment details in LCS, choose Maintain and Rotate secrets.

  • Suggested answer
    Christoph Thaler Profile Picture
    Christoph Thaler 5,442 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Hi Pushpendra,

    sounds really strange and not Dynamics related. I suggest to follow the advice from Nikolaos to deploy a new environment.

  • Pushpendra Profile Picture
    Pushpendra 40 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Hi Christoph ,

    Yes i am having system administrator as well as all the permission .

  • Suggested answer
    Christoph Thaler Profile Picture
    Christoph Thaler 5,442 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Hi Pushpendra,

    your role is "System administrator"? Just to check if you have all permissions....

  • Pushpendra Profile Picture
    Pushpendra 40 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Hi Chirstoph ,

    This is my cloud hosted environment and LCS deployed environment .

    I have check that SSL certification is not expire .

    I didn't not get any error while performing the other work in the enviroment.

    Everything is been working fine

    I just get an error while exporting the data and info also

    The remote server returned an error: (403) Forbidden

    Thanks

    Pushpendra singh

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Perhaps you can just deploy a new system. It's most likely the quickest and cheapest way to get rid of the problem.

  • Pushpendra Profile Picture
    Pushpendra 40 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Hi nikolas ,

    Thank you  for the reply .

    I didn't make any  changes. This my new dev environment ,  earlier it was been working , it suddenly from past one week we are facing this issue .

    When i am try export any data i been getting the below mentioned error as as info and the above error when i see the execution  log .

    The remote server returned an error: (403) Forbidden.

    This is my cloud housed environment .

    I have noticed one more thing that is the record is inserting in the staging table but getting failed while export .

    Thanks

    Pushpendra singh

  • Suggested answer
    Christoph Thaler Profile Picture
    Christoph Thaler 5,442 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Hi Pushpendra,

    Is this problem on your downloaded local VM or on a cloud hosted and LCS deployed VM? During this week there where some troubles for a lot on environments because of SSL certification expiration. Maybe your certificates are expired too? Do you get an error or warning when you try to use D365?

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Not Able to Export the Data from D365 finance and operations using Data management

    Did it work before? What changes were made in the environment before it stopped working? For example database restore, change admin, install MS update...

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,137 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans