You’re offline. This is a read only version of the page.
Announcements
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
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!
I am also getting same error.
@Sanjay: Did you got the solution for this.?
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,382
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
