Hi All,
I have upgraded my Ax 2012 R3 instance CU9 to CU10 anf after merge,compile,CIL , I ve done a DB synchronization which resulted me in below error.
Cannot edit a record in Datatype number sequence properties (NumberSequenceDatatype).
The record has never been selected.
Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type ‘Microsoft.Dynamics.Ax.Xpp.ErrorException’ was thrown.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)
at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.update(IntPtr table)
at Dynamics.Ax.Application.NumberSeqDatatype.Create(Boolean _saveParameterConfigurationChanges, Boolean ) in NumberSeqDatatype.create.xpp:line 160
at Dynamics.Ax.Application.NumberSeqDatatype.Create()
at Dynamics.Ax.Application.NumberSeqApplicationModule.Create(NumberSeqDatatype _datatype) in NumberSeqApplicationModule.create.xpp:line 27
at Dynamics.Ax.Application.MCRNumberSeqModuleOrderManagement.Loadmodule() in MCRNumberSeqModuleOrderManagement.loadModule.xpp:line 56
at Dynamics.Ax.Application.NumberSeqApplicationModule.Load() in NumberSeqApplicationModule.load.xpp:line 11
at Dynamics.Ax.Application.NumberSeqApplicationModule.loadAll() in NumberSeqApplicationModule.loadAll.xpp:line 60
at Dynamics.Ax.Application.NumberSequenceModuleSetup.Loaddata() in NumberSequenceModuleSetup.loadData.xpp:line 6
at Dynamics.Ax.Application.SysSetupInstaller.Writealldata() in SysSetupInstaller.writeAllData.xpp:line 19
at Dynamics.Ax.Application.SysSetupInstaller.Run() in SysSetupInstaller.run.xpp:line 7
at Dynamics.Ax.Application.SysSetupInstaller.loadPartitionData(Object[] _c) in SysSetupInstaller.loadPartitionData.xpp:line 3
at SysSetupInstaller::loadPartitionData(Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at Microsoft.Dynamics.Ax.Xpp.PredefinedFunctions.runAsInvoke(String className, String staticMethodName, Object[] parms, Object[]& exportInfolog)
I tried deleting records in NumberSequenceDatatype table → No luck
Ive tried NumberSeqApplicationModule:LoadAll() which went fine without errors,
Ive synchronized only NumberSequenceDatatype table from AOT and that went fine without errors.
This issue only occurs when I run a full DB synchronization.
any help to solve this issue is greatly appreciated!
Thanks.