Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
