Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Dear All, My system normally using with users, howerver, when you users posting journals, invoices, SO, PO, and so all. the system show this messages below: "Unable to allocate number for TableId %1, CurrentNextVal%2, NewNextVal%3. An error occured while obtaining new RecId value for the table." ALthough, I requested Technical's VOTIVA Software Consultant check and fix but can't not. My AX still has errors until now, so we can't not process for the next step transactions. So, I send you this email with your support. Kindly, give instructs, email me firstname.lastname@example.org, or skype: vancvcafe Best regards, Van PM
Were you able to get the support team to look into this? I have had this issue in the past (AX 2012 R2) and was able to resolve it by following below steps -
1. Query "SELECT * FROM systemsequences WHERE dataareaid = 'dat' ORDER BY nextval DESC;"
2. Check for 'TabId' for records that have 'NextVal' close to 'MaxVal'
3. Reset the nextval by using "UPDATE systemsequences SET nextval = <xxx> WHERE dataareaid = 'dat' and tabid = <xxx>;"
Note: The data area id in update statement must be 'dat'.
I am stuck at the same problem again and our full CIL is not compiling. In fact following the above steps and then doing the full CIL gets the NextVal counter for TabId 101297 (SYSCOMPILEILTABLE) next to MaxVal again.
Any solution / resolution / thoughts would be much appreciated.
Business Applications communities