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

Notifications

Announcements

Season of Giving Solutions is Here!
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 494

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,272 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 494 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,272 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

News and Announcements

Season of Giving Solutions is Here!

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…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 836 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 452 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 349 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans