Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Duplicate Key error on...
Finance | Project Operations, Human Resources, ...
Suggested answer

Duplicate Key error on employee

(1) ShareShare
ReportReport
Posted on by reneeb 60

We have created a new Facility, assigning new employee IDs to existing employees we have moved over from another Facility. Most of the employee data has been imported from tables but there are a few remaining details such as the licenses that need to be input. When attempting to do so the following error populates:

"A Save operation on table 'CLM_License_MSTR' has created a duplicate key"

In looking at that table the license number is there but only under the "old" employee ID. How might we successfully save under the new employee/Facility? Is it an issue because the "old" employee ID is still active?

Categories:
Microsoft Dynamics GP
  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Duplicate Key error on employee

    This thread was resolved through a support case.  Thank you.

  • reneeb Profile Picture
    reneeb 60 on at
    RE: Duplicate Key error on employee

    I have disabled MEM (Binary stream) in the customization window and attempted to input the license number on the employee license entry window again still receiving the error

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Duplicate Key error on employee

    If you have taken SmartConnect out of the equation, then the issue remains by MEM and at this point you'd need to reach out to BinaryStream.

  • reneeb Profile Picture
    reneeb 60 on at
    RE: Duplicate Key error on employee

    I have reached out to eOne, awaiting response. My dilemma is that even if we attempt to input the license data directly on the employee within GP that error still populates having taken Smartconnect out of the equation.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Duplicate Key error on employee

    Thank you Renee for confirming the details.

    At this point I'd open a support ticket with eOne and/or Binary Stream, as I'm not conviced that importing data thru eConnect/SmartConnect works well with Binary Stream's MEM product.

    The product is known to be very particular when it comes to handle new entities and if you do so by importing data thru the backdoor that is non-MEM aware, you may just cause other problems.

    I don't work/use the MEM product, so I can't speak for the details.. but that's my experience from past discussions with others that have used it.

  • reneeb Profile Picture
    reneeb 60 on at
    RE: Duplicate Key error on employee

    Hi Beat,

    We created a new facility/entity (MEM/Binary Stream) within the same company DB. I believe the employee data was than imported via smartconnect thru multiple excel files.

    yes CLM00200 is where is was able to find the license record associated to the initial employee ID, but no records listed under the new employee ID so I'm unclear why the Duplicate key error is occurring as it should create under a new row in the table.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Duplicate Key error on employee

    Hi Renee,

    When you say "created a new Facility" what do you mean with that ?

    Did you created a new GP Company with GP Utilities ? or did you create a whole new SQL instance to re-install GP ? Or is this within the same GP company ?

    When you say "moved over Employees from another Facility", how did you do that ?

    Did you run any SQL scripts to alter data from the back-end of GP's tables or was everything done from the front-end ?

    I believe that the table you're looking for is this one here : https://gptables.azurecurve.co.uk/products/certification-manager-4933/payroll/clm-license-master-clm00200/

  • Anrini Profile Picture
    Anrini on at
    RE: Duplicate Key error on employee

    I hope this will be helpful

    support.microsoft.com/.../you-receive-an-error-message-when-you-try-to-access-to-enter-to-save-t

    community.dynamics.com/.../a-save-operation-on-table-pm_transaction_open-has-created-a-duplicate-key

    support.microsoft.com/.../you-receive-an-error-message-when-you-try-to-access-to-enter-to-save-t

    mystiquesmemory.blogspot.com/.../a-save-operation-on-table.html

    dynamicaccounting.net/.../

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans