Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

error creating Record in Table

(1) ShareShare
ReportReport
Posted on by 55
Hi we do have a strange error when we create a customer.
There comes up a message (I think it is from the database) that the customer cannot be created because it already existing. BUT it is not.
 
When I do a full CIL and try it again I can create the customer BUT only 1. with the next one I get the same error back again...doing another fullCIL I can create again 1 customer.
 
 
Any idea how I can get rid of this strange behaviour?
 
 
Categories:
  • CU31101249-0 Profile Picture
    CU31101249-0 55 on at
    error creating Record in Table
    I already did and it crashes on super() call in the insert method.
     
    but there are no violations of indexes (no matter which table is touched)
     
    I checked everything 100 times, checked the SystemSequences table in SQL server

    Everything is fine.
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 9,710 Super User 2024 Season 2 on at
    error creating Record in Table
    Hi,
     
    You must debug this process to know the issue and then share with us.
     
    BR,
    Mohamed Amine MAHMOUDI
  • CU31101249-0 Profile Picture
    CU31101249-0 55 on at
    error creating Record in Table
    yes there are customizations but this like a all time request. who cares about because it is working once after a full cil and then stops until the next fullCIL. 
    AND in 2 other systems, having the same code it works without any problems.
     
    It occurs for ALL users in this system...doesn't matter if Admin or not
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,349 Super User 2024 Season 2 on at
    error creating Record in Table
    Hi,
     
    Can you tell us if there are customizations and what exact settings you have for the customer account and global address book number sequences? 
    Do you also have this issue when someone with a system administrator role performs this task?

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

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,351 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans