error creating Record in Table

Like (2) Share

Report

Posted on 19 Dec 2024 21:47:34 by CU31101249-0

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:

Microsoft Dynamics AX

All responses (4)

Answers (0)

CU31101249-0 65 on 20 Dec 2024 at 11:39:14

Like (0)

Report

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 21,424 Super User 2025 Season 1 on 20 Dec 2024 at 10:56:01

Like (0)

Report

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 65 on 19 Dec 2024 at 22:18:25

Like (0)

Report

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 Cal... 293,973 Super User 2025 Season 1 on 19 Dec 2024 at 22:03:33

Like (0)

Report

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?