System errors AX 2009 & SQL Server 2007

(0) Share

Report

Posted on by Chau Van

610

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 van.chau@dadlinc.com, or skype: vancvcafe Best regards, Van PM

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

Hi,

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.

Was this reply helpful? Yes No