Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Duplicate key error when importing not showing exact records failing

(0) ShareShare
ReportReport
Posted on by 308

Hi,

I got the below error while importing to a table and I found it's because there were 7 duplicate records in the file.

My question is, why D365 didn't show the exact duplicate records in the error? Why it said PII data removed?

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_45676STAGINGIDX'. Cannot insert duplicate key in object 'dbo.DUMMYTABLESTAGING'. The duplicate key value is [PII data removed].".

  • Martin Dráb Profile Picture
    Martin Dráb 230,962 Most Valuable Professional on at
    RE: Duplicate key error when importing not showing exact records failing

    No, I mean a feature as a normal word; not in any meaning specific to F&O.

    I don't know any details about it, including whether there is something related to it in feature management workspace.

  • DELDYN Profile Picture
    DELDYN 308 on at
    RE: Duplicate key error when importing not showing exact records failing

    Hi Martin,

    You mean there is a feature that I should find in feature management form?

  • Martin Dráb Profile Picture
    Martin Dráb 230,962 Most Valuable Professional on at
    RE: Duplicate key error when importing not showing exact records failing

    This seems to be a feature to protect Personally Identifiable Information (PII). Unfortunately I have no more details about it.

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…

Vahid Ghafarpour – Community Spotlight

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

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans