Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Getting error when exp...
Finance | Project Operations, Human Resources, ...
Suggested answer

Getting error when exporting data in data management customer v3 entity

(1) ShareShare
ReportReport
Posted on by Karuna Dogra 128
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.
  • Layan Jwei Profile Picture
    Layan Jwei 7,345 Super User 2024 Season 2 on at
    Getting error when exporting data in data management customer v3 entity
    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
     
  • Karuna Dogra Profile Picture
    Karuna Dogra 128 on at
    Getting error when exporting data in data management customer v3 entity
    Please help
  • Karuna Dogra Profile Picture
    Karuna Dogra 128 on at
    Getting error when exporting data in data management customer v3 entity

    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

  • Karuna Dogra Profile Picture
    Karuna Dogra 128 on at
    Getting error when exporting data in data management customer v3 entity

    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"

  • Karuna Dogra Profile Picture
    Karuna Dogra 128 on at
    Getting error when exporting data in data management customer v3 entity
    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)

  • Karuna Dogra Profile Picture
    Karuna Dogra 128 on at
    Getting error when exporting data in data management customer v3 entity
    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. 
  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,686 Most Valuable Professional on at
    Getting error when exporting data in data management customer v3 entity
    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

  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Getting error when exporting data in data management customer v3 entity
    Hi,

    Best regards,
    Kevin

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans