Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Pushpendra

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 Nikolaos Mäenpää 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

I have the same question (0)

All responses (12)

Answers (0)

Michal Krejza on at

Like (0)

Report

Hello Pushpendra,

Is it impacting all data entities you are trying to export ? Was the export working previously ?

Was this reply helpful? Yes No
Pushpendra 40 on at

Like (0)

Report

Hi Michal ,

Thank you for the reply . Yes this is happening for all the entity .

Thanks

Pushpendra singh

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Pushpendra 40 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pushpendra 40 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

Hi Pushpendra,

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

Was this reply helpful? Yes No
Pushpendra 40 on at

Like (0)

Report

Hi Christoph ,

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

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

Hi Pushpendra,

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

Was this reply helpful? Yes No