98Hi All,
i have restored database from production to UAT and Dev, on production and UAT there is no error, however while saving on some screens on Dev am getting the below errors on ERP.
it gave same error before on UAT and it was solved by assining the axdbadmin schema to the axdbadmin user
but on dev it is still giving the below error "
An error occurred while obtaining new RecId value for the table.
session 1059 (Admin)
{call GetRecIdRange (?,?,?)}
below is the event viewer logs
+ 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
- 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
Thank you,
