Announcements
No record found.
Hi, All.
When we add new revision line on project revision and save or refresh, we get below error. TmpProjBudgetRevisionLine table is in memory table. Also this table is not available for the systemsequence reference. I am not sure why got this this error. After debug the issue, i found when enter and save the record in Projbudgetrevision form it calls the write method of the projbudgetrenlinecosttmp. After that it calls ttsnotifypostbegin method, then its directly call the info method and brings this error. As per standard this should call ttsnotifyprecommit method after postbegin method but in my case it is not calling precommit. I cannot found the root cause of the issue.
Have anyone experienced this issue?. Pls help.
Good morning UK257,
Have you already checked LCS for available hotfixes?
Especially if you operate on an older AX2012, I would recommend having a look at the hotfixes listed on LCS.
Best regards,
Ludwig
Hi UK257,
The RecId sequence for tables is stored in SystemSequences table and can get out of sync due to some reasons.
To fix this error, we need to reset the NextVal field in SystemSequences table. NextVal field should be set to a value greater than the max RecId of the table.
See the link:
community.dynamics.com/.../cannot-create-a-record-the-record-already-exist
Hi, Ludwig.
Thanks for the reply.
I have not checked for hotfix and this is not an older ax 2012. Anyhow i will if any hotfix available for this or not.
Thanks for the suggestion, Will.
I have already check given link. But in my case it is a In memory table(tmpprojbudgetrevisionline). So this table has no nexval recid in the systemsequence table.
Hi Uk257,
This issue has not been reported to MS support as well as it is not reproduced in clean standard vanilla environment. There is a feature enhancement that changed Projbudgetrevision form. That is the only update in 2012 R3 CU12:
https://fix.lcs.dynamics.com/Issue/Details?kb=3199741
you could double check same scenario in Vanilla environment to see different behavior and compare differences. Also you could log in a MS support request whether you reproduced the issue in standard Vanilla environment too.
Best Regards
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 478 Super User 2026 Season 1
Syed Haris Shah 258 Super User 2026 Season 1
