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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Duplicate key error wh...
Finance | Project Operations, Human Resources, ...
Unanswered

Duplicate key error when importing not showing exact records failing

(0) ShareShare
ReportReport
Posted on by DELDYN 536

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].".

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 238,787 Most Valuable Professional on at

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

  • DELDYN Profile Picture
    DELDYN 536 on at

    Hi Martin,

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

  • Martin Dráb Profile Picture
    Martin Dráb 238,787 Most Valuable Professional on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 386

#3
Adis Profile Picture

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans