web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by 98

Hi All,

after restoring production to UAT and Dev, the below error is appearing on Dev only on some screens while saving, it was showing on UAT as well but then i set the axdbadmin schema to axdbadmin user and the error is gone, however i did the same for Dev and the error still persists

An error occurred while obtaining new RecId value for the table.
session 1059 (Admin)
{call GetRecIdRange (?,?,?)}
below is the event viewer log
+ System

- Provider

[ Name] Microsoft-Dynamics-AX-SystemRuntime
[ Guid] {B518FD3F-6D6F-46D3-BC51-F765226A4FE2}

EventID 262

Version 0

Level 3

Task 161

Opcode 0

Keywords 0x8000000400000204

- TimeCreated

[ SystemTime] 2021-08-03T10:24:50.596664000Z

EventRecordID 40050229

- Correlation

[ ActivityID] {0BEEBF1C-A541-4F89-9C40-2F6334059A08}

- Execution

[ ProcessID] 10424
[ ThreadID] 8236

Channel Microsoft-Dynamics-AX-SystemRuntime/Admin

Computer MININT-5REKJI3

- Security

[ UserID] S-1-5-20


- EventData

databaseServer MININT-5REKJI3
databaseName AxDB
errorMessage [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'SEQ_24553'.
callStack at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.Interop.GetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* ) at [aoskernel.dll]Microsoft.Dynamics.Ax.Services.AOSAppDomainHelper.callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* ) at callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* ) at cqlCursor.kc_insert(cqlCursor* , interpret* ) at cqlCursor.kc_insert(cqlCursor* , interpret* ) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.insert(IntPtr table) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.NativeCommonImplementation.Insert() at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.Common.__Insert_IntImpl__() at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.Common.Insert() at [Dynamics.AX.NetwaysProcurement365.dll]Dynamics.AX.Application.NW_PurchContractTable.`insert() at [Dynamics.AX.NetwaysProcurement365.dll]Dynamics.AX.Application.NW_PurchContractTable.insert() at NW_PurchContractTable::Insert(Object , Object[] , Boolean& ) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.CommonImplementationHelper.InvokeXpp(KernelCallReturnVal thisObj, String methodName, Int32 n) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.InvokeCallILHandler(KernelCallReturnVal thisObj, String methodName, Int32 n) at call_ILFunc(interpret* ip, CICursor* c, Char* tszMethodName, Int32 n, Byte* ok) at cqlCursor.DBOpInTransaction(cqlCursor* , interpret* , Byte ) at cqlCursor.DBOpInTransaction(cqlCursor* , interpret* , Byte ) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.dbOpInTransaction(IntPtr table, Boolean isWriteOperation) at NW_PurchContractTable::dbOpInTransaction(Object , Object[] , Boolean& ) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.DictTable.Callobject(String _methodName, Common _Called, Object[] varArgs) at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.FormDataUtil.`DBOpInTransaction(Common _record, Boolean _isWriteOperation) at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.FormDataUtil.DBOpInTransaction(Common _record, Boolean _isWriteOperation) at FormDataUtil::DBOpInTransaction(Object[] , Boolean& ) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters) at callILClassMethod(interpret* ip, Char* method, UInt32 chdl, cqlClass* c) at cqlClass.callEx(cqlClass* , Char* , interpret* ) at cqlClass.callEx(cqlClass* , Char* , interpret* ) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes) at [Microsoft.Dynamics.AX.Server.Core.dll]Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs) at [Microsoft.Dynamics.AX.FormsEngine.dll]Dynamics.AX.Application.FormDataSource.__write_IntImpl__() at [Microsoft.Dynamics.AX.FormsEngine.dll]Dynamics.AX.Application.FormDataSource.write() at NW_PurchContractTable::write(Object , Object[] , Boolean& ) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) at [Microsoft.Dynamics.AX.FormsEngine.dll]Microsoft.Dynamics.Ax.Xpp.FormNestedElementsCoCSubscriptionsManager.MakeInstanceCall(Object instance, String methodName, String nestedElementName, String rootName, Object[] parameters) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.KernelToXppInstanceCallCoC(Object instance, String methodName, String nestedElementName, String rootName, Object[] parameters) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlClassIL.InvokeInstanceCallHandlerCoC(Object instance, String MethodName, String NestedElementName, String RootName, Object[] parameters) at callILClassMethodCoC(interpret* ip, Char* method, Char* nestedConceptName, Char* rootName, UInt32 chdl, cqlClass* c) at cqlClass.callEx(cqlClass* , Char* , interpret* ) at cqlClass.callEx(cqlClass* , Char* , interpret* ) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes) at [Microsoft.Dynamics.AX.Server.Core.dll]Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs) at [Microsoft.Dynamics.AX.FormsEngine.dll]Dynamics.AX.Application.FormDataSource.leaveRecord(Object[] parameters, Type[] types) at [Microsoft.Dynamics.AX.FormsEngine.dll]Dynamics.AX.Application.FormDataSource.leaveRecord(Boolean _forceUpdate) at NW_PurchContractTable::leaveRecord(Object , Object[] , Boolean& ) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) at [Microsoft.Dynamics.AX.FormsEngine.dll]Microsoft.Dynamics.Ax.Xpp.FormNestedElementsCoCSubscriptionsManager.MakeInstanceCall(Object instance, String methodName, String nestedElementName, String rootName, Object[] parameters) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.KernelToXppInstanceCallCoC(Object instance, String methodName, String nestedElementName, String rootName, Object[] parameters) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlClassIL.InvokeInstanceCallHandlerCoC(Object instance, String MethodName, String NestedElementName, String RootName, Object[] parameters) at callILClassMethodCoC(interpret* ip, Char* method, Char* nestedConceptName, Char* rootName, UInt32 chdl, cqlClass* c) at cqlClass.callEx(cqlClass* , Char* , interpret* ) at cqlClass.callEx(cqlClass* , Char* , interpret* ) at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes) at [Microsoft.Dynamics.AX.Server.Core.dll]Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs) at [Microsoft.Dynamics.AX.FormsEngine.dll]Dynamics.AX.Application.xFormRun.task(Int32 _taskId) at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.FormRun.`task(Int32 _p1) at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.FormRun.task(Int32 _p1) at NW_PurchContractForm::task(Object , Object[] , Boolean& ) at [Microsoft.Dynamics.AX.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) at callILClassMethod(interpret* ip, Char* method, UInt32 chdl, cqlClass* c) at [aoskernel.dll]Microsoft.Dynamics.Client.ServerForm.Interactions.InteractionManager.ProcessPendingOperations(Boolean useSnapshot) at [aoskernel.dll]Microsoft.Dynamics.Client.ServerForm.Interactions.InteractionManager.ProcessMessages(Object stateinfo) at [Microsoft.Dynamics.Client.InteractionService.dll]Microsoft.Dynamics.Client.InteractionService.Communication.Reliable.ReliableExecutionWrapper.ExecuteParametrizedFunction(Object FuncParamTuple) at [mscorlib.dll]System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at [mscorlib.dll]System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at [mscorlib.dll]System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at [mscorlib.dll]System.Threading.ThreadHelper.ThreadStart(Object obj)
statement {call GetRecIdRange (?,?,?)}
errorCode 208
errorSeverity 16
idleTimeInSec 0
lastConnectionStatus true
sqlConnectionUniqueID 524111
sqlSPID 86
sqlClientConnectionID {98B206EF-88C0-434E-8CC7-9046392E2F1A}
connectionType Application
I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    101,172 Moderator on at

    Hi,

    did you run database sync after importing the database to the target environment? If not, please do.

  • MDeeb Profile Picture
    98 on at

    Thank you Nikolaos,

    yes i have did successfull synch,

    is there any steps needed on the security level to be done after importing the production database ? since this solved the same issue on UAT that we were facing before

    Thank you,

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 660

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 654 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 489

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans