Finance | Project Operations, Human Resources, ...

DMF Error in Route Version V2

(0) Share

Report

Posted on by HY Kim

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.

Thanks

I have the same question (0)

All responses (5)

Answers (0)

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
HY Kim 25 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report

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

Was this reply helpful? Yes No
HY Kim 25 on at

Like (1)

Report

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

What's the problem? T,T

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No