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, ... / Cannot create a record...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Cannot create a record in Employment detail (HcmEmploymentDetail).

(1) ShareShare
ReportReport
Posted on by sumanth kumar 9
Cannot create a record in Employment detail (HcmEmploymentDetail). Employment: 563/198606. The record already exists. 
 
I'm getting this error while terminating an employee and the error is so random and the error won't repeat also for the same employee Also, if i get fast replies to it , it will be so helpful. thanks, in advance. 
I have the same question (0)
  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 13,190 Most Valuable Professional on at
    Hi Kumar, 
     
    The error says such record already exists. You would go to employment history and confirm if the worker isn't already terminated. Moreover I do not expect the terminate button to be enabled on such employee after termination.
     
    Can you tell us the version of the application and share a screenshot of the error?
  • Suggested answer
    sumanth kumar Profile Picture
    sumanth kumar 9 on at
    @komi siabi i have crossed checked the employee history and he is not terminated and, but the termination button disables as soon as I get the error message. as u asked i ave attached the error message screen shot 
  • Komi Siabi Profile Picture
    Komi Siabi 13,190 Most Valuable Professional on at
    There are no screenshot added.
     
    Can you confirm the version of FO you are on? is this happening in USMF or on live entity.
  • Suggested answer
    CU05050618-0 Profile Picture
    CU05050618-0 10 on at

    some possible reasons and solutions for this issue:

    1. Concurrency Issues:

      • Check if there are multiple users or processes trying to terminate the same employee simultaneously. If there is a concurrency issue, you might want to implement a mechanism to handle concurrent requests more effectively.

    2. Database Integrity:

      • Verify the integrity of your database. There could be a chance that the database has become corrupted or inconsistent. Running a database integrity check or restoring from a clean backup might help.

    3. Logging and Debugging:

      • Implement detailed logging and debugging to capture the state and sequence of operations leading up to the error. This can help you identify the root cause of the issue.

    4. Unique Constraints:

      • Check if there are unique constraints or indexes on the fields being used for the termination. It's possible that the termination record is being duplicated due to constraints on certain fields. Ensure that the termination request is not trying to insert duplicate values.

    5. Caching:

      • If your system uses caching, ensure that the cache is cleared or updated after a termination is processed. Cached data might cause conflicts when creating new records.

    6. Transaction Isolation:

      • Verify the transaction isolation level in your database. In some cases, a lower isolation level might lead to anomalies. Consider using a higher isolation level if needed.

    7. Check for Asynchronous Processes:

      • Ensure there are no background or asynchronous processes that might be interfering with the termination process. These processes could be creating the record after the termination is processed.

    8. Consult System Logs:

      • Review system logs for any errors or warnings related to the termination process. This might provide additional insights into what is happening.

    9. Review Code:

      • Review the code responsible for handling terminations. Check for any logical errors or race conditions that might lead to the creation of duplicate records.

    10. Contact Vendor/Support:

      • If you are using a third-party software or a system provided by a vendor, it's advisable to contact their support for assistance. They might be aware of specific issues or have patches/updates to resolve such issues.

    Remember to backup your data before making any significant changes to your system. If the problem persists, you may need to involve your development or system administration team for a more in-depth analysis.

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... 545 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 408

#3
Adis Profile Picture

Adis 267 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