
Hi,
I received two main errors which stop my data upgrade cockpit :
Error 1:
Cannot create a record in Legal entities (CompanyInfo). Company: DAT, Company accounts data.
The record already exists.
Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.DuplicateKeyException' was thrown.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)
at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.insert(IntPtr table)
at Dynamics.Ax.Application.DirPartyTable.Insert() in DirPartyTable.insert.xpp:line 16
at Dynamics.Ax.Application.CompanyInfo.Insert() in CompanyInfo.insert.xpp:line 28
at Dynamics.Ax.Application.ReleaseUpdateDB60_Basic.Updatecompanyinfo() in ReleaseUpdateDB60_Basic.updateCompanyInfo.xpp:line 30
at ReleaseUpdateDB60_Basic::updateCompanyInfo(Object , Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)
at Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String _methodName, XppObjectBase _Called, Object[] varArgs)
at Dynamics.Ax.Application.SysDictClass.invokeObjectMethod(XppObjectBase _object, String _methodName, Boolean _tryBaseClass, Boolean ) in SysDictClass.invokeObjectMethod.xpp:line 42
at Dynamics.Ax.Application.ReleaseUpdateDB.Run(String methodName, sysReleasedVersion scriptVersion, Boolean force) in ReleaseUpdateDB.run.xpp:line 49
at Dynamics.Ax.Application.ReleaseUpdateExecute.Run() in ReleaseUpdateExecute.run.xpp:line 41
at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54
at Dynamics.Ax.Application.BatchRun.runJobStaticWrapper(Object[] _args) in BatchRun.runJobStaticWrapper.xpp:line 16
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at Microsoft.Dynamics.Ax.Xpp.PredefinedFunctions.runas(String userId, Int32 classId, String staticMethodName, Object[] parms, String company, String language, String partitionKey)
at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 22
at BatchRun::runJobStatic(Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at BatchIL.taskThreadEntry(Object threadArg)
Error 2:
The main account 1-10-100-01 does not exist.
Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.
at Dynamics.Ax.Application.DimensionConversionHelper.getNativeDefaultAccount(String _account) in DimensionConversionHelper.getNativeDefaultAccount.xpp:line 76
at Dynamics.Ax.Application.ReleaseUpdateDB60_Ledger.Updateledgersystemaccounts() in ReleaseUpdateDB60_Ledger.updateLedgerSystemAccounts.xpp:line 46
at ReleaseUpdateDB60_Ledger::updateLedgerSystemAccounts(Object , Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)
at Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String _methodName, XppObjectBase _Called, Object[] varArgs)
at Dynamics.Ax.Application.SysDictClass.invokeObjectMethod(XppObjectBase _object, String _methodName, Boolean _tryBaseClass, Boolean ) in SysDictClass.invokeObjectMethod.xpp:line 42
at Dynamics.Ax.Application.ReleaseUpdateDB.Run(String methodName, sysReleasedVersion scriptVersion, Boolean force) in ReleaseUpdateDB.run.xpp:line 49
at Dynamics.Ax.Application.ReleaseUpdateExecute.Run() in ReleaseUpdateExecute.run.xpp:line 41
at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54
at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 13
at BatchRun::runJobStatic(Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at BatchIL.taskThreadEntry(Object threadArg)
I checked DirPartyTable and found records for companyinfo is there but there are duplicated multiple records with DAT and instancerelationtype=41, tried to delete them and re-run the script but no luck.
Could you please help how to solve these errors.
Regards,
*This post is locked for comments
I have the same question (0)