Finance | Project Operations, Human Resources, ...

Getting error when exporting data in data management customer v3 entity

(1) Share

Report

Posted on by Karuna Dogra

Hi Team,

i have added 4 fields in customersv3 entity and full build and synch everything is done and those fields are visible in generate mapping as well. However when I am attempting to export data, it is throwing two errors.
1. export execution failed for entity customer v3 : export failed while copying data from staging to target.

2. Error labelid:

please guide me how i can fix this and if debug is needed that then how can I debug it.

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

Hi,

Best regards,

Kevin

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,107 Most Valuable Professional on at

Like (1)

Report

In addition to Kevin's advice, you should refresh the entity list and retry the export.

Data management > Framework parameters > Entity settings > Refresh entity list.

If this helped you, I would appreciate it if you would mark this as a Verified Answer, which may in turn help others as well

Was this reply helpful? Yes No
Karuna Dogra on at

Like (0)

Report

Hi Kevin and Komi,

Thanks a lot for responding.

I have tried all these steps and checked the things you suggested. but still getting the same error.

I am attaching the event los can you pls help me by suggesting what I should perform next.

Was this reply helpful? Yes No
Karuna Dogra on at

Like (0)

Report

Event logs: 1-

System

- EventData executionID originator entityName batchHeaderld batchTaskld

test customer1-2023-11-08T00:59:39-FC48FBBCAA84B008FDC8583016131E2

DMFExportTaskScheduler

Customers V3

5655618073

5662150848

diagnosticsMessage Error: Execution failed: Export failed while copying data from staging to target:

Event log 2: -

EventiName

executionID

dataProject

source

entityName

targetEntityName

message

error labelld:

test customer1-2023-11-08T00:59:39-FC48FBBC4AA84B008FDC8583016131E2

DMFGenerateSSISPackage.generateFileDataV2Inner

Customers V3

a Microsott.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.LogAndThrowNonByodException

(Exception ex) at Microsoft. Dynamics.AX. Framework. Tools. DMF.SSIS Helper. DMFEntity. ExportDatalmpl0y at

Microsott.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ExportData0at

Microsoft.Dynamics.Ax.Framework.lools.DMF.SSISHelperService.Service.ServiceHelper.ExportData

(DMFEntity Contract entityContract)

Was this reply helpful? Yes No
Karuna Dogra on at

Like (0)

Report

EventName executioniD dataProject source entityName

ServiceCallerError test customer1-2023-11-08T00:59:39-FC48FBBCAA84B008FDC8583016131E2 test customer

DMFGenerateSSISPackage.getDescription

Customers V3

targetEntityName message executionContext

exceptionDetails Source: Microsoft.Dynamics.AX. Framework.Tools. DMF ServiceProxy HResult: 0x80131500 Details:

System.Exception at

Microsott.Dynamics.Ax.Framework.Tools.DMF.ServiceProxy.DmfEntitySharedTypesProxy.DoWork[TI(Func'1

work) at Dynamics.Ax.Application.DMFGenerateSSISPackage.generateFileDataVZInner (DMFDefinitionGroupExecution_dmfDefinitionGroupExecution,String_detGroupName,DMFFileFormat _fileFormat, DMFDelimiter _rowDelimiter, DMFDelimiter _columnDelimiter, String _codePage, String _locale, NoYes _isFirstRowHeader, Noves _unicode, String _source, String _textQualifier, DMXMLStyle _style, String _rootElement, String _tilePath, Map _entitySyncVersion, Int32 -previewCount, Boolean _updateOnError) in xppSource://Source/ApplicationFoundation\AxClass_DMFGenerateSSISPackage.xppline 1504

SqlQuery details parameters

( "Company": "40", "ErrorCode": "DMF2009", "OperationMode": "Batch" 1 ["labelld":

**', "localizedErrorMessage", "error labelld: " "_timeOut": 12000, "_timeOutName": "Sq| command

timeout non-BYOD (in seconds) ,

"staging Table": "CustCustomerV3Staging"

Was this reply helpful? Yes No
Karuna Dogra on at

Like (0)

Report

EventiName executioniD dataProject source entity Name

ExportioFile test customer1-2023-11-08100:59:39-FC48FBBC4A84B008FDC8583016131E2 test customer

DMFGenerateSSISPackage.generaterileDataveinner customers V3

targetEntity Name message executionContext

exceptionDetails Source: HResult: 0x80131604 Details: System. Reflection.TargetInvocationException: Exception has been

thrown by the target of an invocation. --- System.Exception at

Microsoft.Dynamics.AX.Framework.Tools. DMF.ServiceProxy.DmfEntitySharedTypesProxy.DoWork[TI(Func1 work) at Dynamics.AX.Application. DMFGenerateSSISPackage.generateFileDataV2Inner (OMFDefinitionGroupExecution_dmfDefinitionGroupexecution,String_detGroupName,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) in xppSource://Source/ApplicationFoundation\AxClass_DMFGenerateSSISPackagexpp:line 1504 ---Endof inner exception stack trace --- Source: Microsoft.Dynamics.AX.Framework.Tools. DMF.ServiceProxy HResult:

Qx60131500 Detalls: System.exception at

Microsoft.Dynamics.AX.Framework.Tools. DMF.ServiceProxy.DmfEntitySharedTypesProxy.DoWork[TI(Func'1 work) at Dynamics.Ax.Application.DMFGenerateSSISPackage.generateFileDataV2Inner (DMFDetinitionGroupExecution_dmtDefinitionGroupExecution, String _defGroupName, DMFFileFormat

-fileFormat, DMFDelimiter _rowDelimiter, DMFDelimiter _columnDelimiter, String _codePage, String_locale, NoYes _isFirstRowHeader, NoYes _unicode, String _source, String _textQualifier, DMXMLStyle_style, String _roottlement, String _filePath, Map _entitySyncVersion, Int32 -previewCount, Boolean _updateOnError) in xoDSource://Source/Abolicationfoundation\AxClass DMFGenerateSSISPackagexonline1504

Was this reply helpful? Yes No
Karuna Dogra on at

Like (0)

Report

Please help

Was this reply helpful? Yes No
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi Karuna,

If we take it step by step. Before you added those fields was the export working?
you can shelve your code, remove the fields build and sync and try to export and see what happens. If it works, then maybe add just one field and see what happens etc..

Thanks,
Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No