Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

DMF Error in Route Version V2

(0) ShareShare
ReportReport
Posted on by 25

Hi, everyone,

I want to upload 'Route Versions V2' by DMF.

So I exported the file by DMF and I impoted in DMF.

But it was faild to import.

For your reference, I send the screen.

Please check and let me know the way to upload ASAP.

pastedimage1681263692265v1.png

pastedimage1681263811805v2.png

Thanks

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: DMF Error in Route Version V2

    Hi, The issue will be in your file as the duplicate is detected in staging table not route version  table. Please check index of this staging table and verify if your file has duplicate records.

    pastedimage1681273397349v1.png

  • HY Kim Profile Picture
    HY Kim 25 on at
    RE: DMF Error in Route Version V2

    There is no data in Route Version table..So I think there is no duplicated data..

    What's the problem? T,T

  • Suggested answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at
    RE: DMF Error in Route Version V2

    By looking at the log, there's a duplicated record causing failure. Can you fix that in data and try again?

  • HY Kim Profile Picture
    HY Kim 25 on at
    RE: DMF Error in Route Version V2

    Here is the Execution log.

    <?xml version="1.0"?><Errors><Error><ErrorCode>-1071636471</ErrorCode><SubComponent>OLE DB Destination [82]</SubComponent><Description>SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "The statement has been terminated.".

    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "Violation of PRIMARY KEY constraint 'I_9199STAGINGIDX'. Cannot insert duplicate key in object 'dbo.ROUTEVERSIONV2STAGING'. The duplicate key value is (5637144576, ROUTEALL, ROUTEALL-2023-04-11T23:13:16-A14D2B0B77AC4BA5860F0F5654893C14, 0.000000, Jan  1 1900 12:00AM, VD11_1301419, , , 1100, , , , 35834642100DG, 0).".

    </Description></Error><Error><ErrorCode>-1071607767</ErrorCode><SubComponent>OLE DB Destination [82]</SubComponent><Description>SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "OLE DB Destination.Inputs[OLE DB Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.

    </Description></Error><Error><ErrorCode>-1073450974</ErrorCode><SubComponent>SSIS.Pipeline</SubComponent><Description>SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "OLE DB Destination" (82) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (95). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.

    </Description></Error></Errors>

    Thanks

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: DMF Error in Route Version V2

    Hi, Do you have any logs in View Execution log?

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans