AX inserts a record prompt table record already exists, but the record does not actually exist.

There was a situation when doing the test "AX inserts a record that the table record already exists, but the record does not actually exist." ”

Check to the table (TABLE_ABC) that all the keys are allowduplicate,

Continue to check the table properties found Createdrecidxidx is set to Yes, RecId is enabled as a unique key.

So it is supposed that the NextValue data of the table's recid is wrong.

Try to refresh the recid.

In the SQL background

1. Calculate TABLE_ABC's current largest recid

DECLARE @maxRecId Int64

Select @maxRecId = max (RECID) from sml_gitlistreceived with (NOLOCK)

2. System record RecId table systemsequences

Update systemsequences
Set nextval = @maxRecId +10000
where TabID = TableID of 35223//table_abc

3, you must restart all AOS for ax at this time, and the problem is resolved after re-login

　　

AX inserts a record prompt table record already exists, but the record does not actually exist.