Cannot create a record in Audit trail (TransactionLog). The record already exists

(3) Share

Report

Posted on by M.Hammam

Hi all,

After using data migration toolkit to move the data from D365FO On-Premises to D365FO cloud and starting UAT with a very good results for 2 days, we started to face the error Cannot create a record in Audit trail (TransactionLog). The record already exists

We searched for this error and found customization solution as in “Can not create a record in Audit trail (transactionLog). Dynamics Ax 2012 R3

Any idea for a reason and a solution without customization?

Thanks in advance

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

André Arnaud de Cal... 304,932 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi M. Hammam,

Thanks for your question. There are two system fields that are filled with internal kernel logic or SQL sequences. These fields are the RecId and createdTransactionID. In case you don't have customizations, I suspect that a wrong value for one of these fields is taken, causing a duplicate. Then the error can occur. I would suggest creating a support ticket for Microsoft Support to get some help where they can check the background if it was due to e.g. the data migration from on-premises to the cloud.

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi, may I know if you have encountered any issues following the mentioned blog. It is recommended that you submit an SR to Microsoft for further solutions without customization.

Was this reply helpful? Yes No
M.Hammam 41 on at

Like (1)

Report
Copy link

Link copied!

Hi Andre/Jody,

Thanks a lot for your advise,

I submitted a SR with Microsoft and their initial checking pointed to the limited performance of UAT environment and they promised to do a further investigation.

By the way Jody, I did not follow the mentioned blog https://community.dynamics.com/blogs/post/?postid=113821c4-f8aa-4cf0-9692-429f6dea7997 as it involves customization and I look for a solution without customization.

Best regards,

M.Hammam

Was this reply helpful? Yes No
FAC.Ansel 1,632 on at

Like (0)

Report
Copy link

Link copied!

Has this issue been resolved? Did Microsoft ever resolve this issue for you?
I'm currently facing this issue but a year after Go Live. I have submitted a Microsoft ticket but they are taking a long time to get back to me, it would be great to hear if there is something I can do to get this resolved for the users.

Was this reply helpful? Yes No
Verified answer

M.Hammam 41 on at

Like (2)

Report
Copy link

Link copied!

Yes, issue has been resolved. Microsoft solved the issue in UAT and Ptoduction environments.

Was this reply helpful? Yes No