Notifications
Announcements
No record found.
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?
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
mystiquesmemory.blogspot.com/.../a-save-operation-on-table.html
dynamicaccounting.net/.../
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/
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.
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.
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.
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.
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
This thread was resolved through a support case. Thank you.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 559 Most Valuable Professional
André Arnaud de Cal... 464 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
