Unable to allocate sequence numbers for TableID:%1,CurrentNextVal:%2,NewNextVal%3

Finance and Operations/AX Technical Forum
1

Dear all,

An user got an issue while doing project invoicing

Unable to allocate sequence numbers for TableID:%1,CurrentNextVal:%2,NewNextVal%3

An error occurred while obtaining new Recid value for the table.

Please let me know how to fix with the above error.

I got an article saying that to update in the systemsequences table next value with the Max(recid) of the TAbid Table.But in my case te recid is showing blank.

Thanks…

2

Hello Sindhu,

Have you ever been able to resolve this issue?

We’re getting the same error message: Unable to allocate sequence numbers for tableID%1, …

Also, only one user is able to login on the system. When a second user tries to login, a white screen is shown untill the first user logs out :s

Any help or info would be great!

Thanks.

Bert

3

it might be issue of the admin rights

both the user should provide full access or if the problem with num seq then please check the module parameter to solve the issue of define or create number sequence there

4

Sequence numbers are stored in the table SystemSequences .

To start, I made a request to check whether the value NEXTVAL is equal or very close to MAXVAL tables for the company that I want to duplicate. If this is the case, the sequence number allocation system fails:

SELECT * FROM systemsequences WHERE dataareaid = ‘dat’ ORDER BY nextval DESC

SELECT * FROM sqldictionary WHERE fieldid = 0 and tableid = 9

SELECT MAX ( RECID ) FROM bankchequelayout WHERE dataareaid = ‘dat’

UPDATE systemsequences SET nextval = 5637144830 WHERE dataareaid = ‘dat’ and tabid = 9