Finance | Project Operations, Human Resources, ...

data management import/export not working after updating to

(0) Share

Report

Posted on by Community Member

Hi,

I have upgraded D365 to version 10.0.8. After the upgrade completed, data management import/export functionality stopped working. Whenever I try to export out of the box or custom entities, I get an error stating "Error(s) while uploading the file-" as shown in the screenshot below. There is no information regarding this error in the staging table, execution log, infolog, and windows event log.

I tried different export file format but still got the same error. It looks like there is a bug with this version of dynamics. Can someone please confirm or assist me in debugging this issue as I have been trying to fix it for 2 days now with no success

Any help is much appreciated. Thanks!

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi George,

Give this a try to see if your problem gets resolved.

docs.microsoft.com/.../dm-error-descriptions

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Satish. I have updated Azure Storage Emulator but now I am getting a different error pasted below. Should I configure Azure Storage Emulator to connect to the proper AxDB (which is on the same VM in my case) or just upgrade Azure Storage Emulator?

Microsoft.WindowsAzure.Storage.StorageException: Unable to connect to the remote server ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:10002

at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)

--- End of inner exception stack trace ---

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:

RequestDate:

StatusMessage:

Was this reply helpful? Yes No
Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi George,

You can try with DB option first. I haven't tried these options. Let's see if any other volunteers can add to the details.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I think the issue is that the storage emulator is not running. Do you know if it runs through a service? If yes, what is the name of that service? I went through all services but couldn't figure it out. I even googled it and everyone said to start the emulator but when i run the emulator start command, I get an error stating that the emulator couldn't start

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

Like (0)

Report

What type of system is this? Prod, sandbox tier 2+, cloud hosted VM, local VM?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is a local VM that hosts both dynamics and the sql database

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Are you sure you updated all components on the VM?

community.dynamics.com/.../issues-after-installing-binary-updates-to-local-dev-machine

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

and also check on security access for the account being used to for export/import to SQL from D365FO

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Finally I managed to get it to work. My guess is that the Azure Storage Emulator did not get updated during the Dynamics 365 upgrade process.

Download the latest Azure Storage Emulator: go.microsoft.com/.../

Navigate to the installation path: C:\Program Files (x86)\Microsoft SDKs\Azure\Storage Emulator

Run the following commands on cmd after running it as administrator:

• AzureStorageEmulator.exe stop

• AzureStorageEmulator.exe clear

• AzureStorageEmulator.exe init –server [VMServerName]

• AzureStorageEmulator.exe start

Was this reply helpful? Yes No
mhdshb1 1,250 on at

Like (0)

Report

Hi George,

I faced the same issue after updating the Dev VM from 10.0.5 to 10.08 PU32

I was trying to Export a project from Data management.

The error was "Error while uploading the file"

After trying your solution, the error disappeared.

Thanks George.D

Regards,

M

Was this reply helpful? Yes No