News and Announcements icon

Dynamics 365 CommunityForums Finance forum Cannot create a record...

Finance forum

Suggested answer

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

(1) Share

Report

Report

Posted on by M.Hammam

24

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

Categories:

Financial Management

Administration and Setup

All responses Img

All responses (3)

Answers Img

Answers (0)

M.Hammam 24 on at

Like (0)

Report

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

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 invistagation.

Best regards,

M.Hammam
Suggested answer

Judy Microsoft Employee on at

Like (1)

Report

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

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.
Suggested answer

André Arnaud de Cal... 284,860 Super User on at

Like (1)

Report

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

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.

Helpful resources

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter

Community forum and blog attachments are now available!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,860 Super User

#2

Martin Dráb 225,398 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans