web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Error while importing Product Master with DIEF

(0) ShareShare
ReportReport
Posted on by

Hi Team,

Following error is coming at event viewer while importing Product Master with DIEF(Data Import Export). in AX 2012 R3 CU13.

<?xml version="1.0"?><Errors><Error><ErrorCode>-1071636471</ErrorCode><SubComponent>OLE DB Destination [8]</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: "Unspecified error".
</Description></Error><Error><ErrorCode>-1071607780</ErrorCode><SubComponent>OLE DB Destination [8]
</SubComponent><Description>There was an error with OLE DB Destination.Inputs[OLE DB Destination Input].
Columns[Copy of DISPLAYPRODUCTNUMBER] on OLE DB Destination.Inputs[OLE DB Destination Input].
The column status returned was: "The value violated the integrity constraints for the column.".
</Description></Error><Error><ErrorCode>-1071607767</ErrorCode><SubComponent>OLE DB Destination
[8]</SubComponent><Description>SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. 
The "OLE DB Destination.Inputs[OLE DB Destination Input]"
failed because error code 0xC020907D 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" (8) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (241).
 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>

Please find in above error log

Columns[Copy of DISPLAYPRODUCTNUMBER] on OLE DB Destination.Inputs[OLE DB Destination Input].
The column status returned was: "The value violated the integrity constraints for the column.".

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    fatihgork Profile Picture
    3,817 on at

    Hi,

    Please check if you have any empty or recurring values in this column.

  • Sunil Dharmani Profile Picture
    210 on at

    I am also getting same error.

    @Sanjay: Did you got the solution for this.?

  • Suggested answer
    jeyjey344 Profile Picture
    10 on at

    Hi,

    This error appears where data that you have in a column DISPLAYPRODUCTNUMBER are not what system expects.

    In this case, all of your records require unique sequence - no empty values are allowed.

    Also please check your file/database if there are any empty rows below the data. This is very common mistake I experienced while working with clients, that below the proper data, there was some empty rows - that also can cause this error, stopping the whole import process.

    I know it's kinda late answer but maybe someone will have this problem :) Cheers!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans