I am getting a sync error during my build and sync of ProjectCategoryEntity.ProjAX(Extension of standard entity ProjectCategoryEntity).
This is the error i am getting during build and sync of my project.I tried to build all models and sync then it is working fine but during project sync i am getting the error.I have also tried to delete one of the custom fields added to this entity and tried to regenerate staging table but still getting the same errors.Please let me know your inputs.Thank you.
Severity Code Description Project File Line Suppression State Error at Microsoft.Dynamics.Ax.Xpp.NativeCommonImplementation.Insert() 0 Error The record already exists.' on category 'Error'. 0 Error at Dynamics.AX.Application.DmfDataPopulation.syncEntityCreate(DictDataEntity dictDataEntity, Boolean useTargetEntityName, Boolean @useTargetEntityName_IsDefaultSet) in xppSource://Source/ApplicationFoundation//AxClass_DmfDataPopulation.xpp:line 1356 0 Error Log level - Error | Infolog diagnostic message: 'Cannot create a record in Entity (DMFEntity). Entity: Project category, ProjectCategoryStaging. 0 Error at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.insert(IntPtr table) 0 Error Log level - Error | Infolog diagnostic message: 'Error synching entity metadata for entity - ProjectCategoryEntity. Message - at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, interpret* ip) 0 Error at Microsoft.Dynamics.Ax.Xpp.Common.__Insert_IntImpl__() 0 Error at Dynamics.AX.Application.DMFEntity.insert() 0 Error at Dynamics.AX.Application.DmfDataPopulation.syncEntityUpdate(DMFEntity _dmfEntity, DictDataEntity _dictDataEntity, Boolean _useTargetEntityName, Boolean @_useTargetEntityName_IsDefaultSet) in xppSource://Source/ApplicationFoundation//AxClass_DmfDataPopulation.xpp:line 1405 0 Error at Dynamics.AX.Application.DMFEntity.`insert() in xppSource://Source/ApplicationFoundation//AxTable_DMFEntity.xpp:line 438 0 Error at Microsoft.Dynamics.Ax.Xpp.Common.Insert() 0 Error at Dynamics.AX.Application.DmfDataPopulation.syncEntityUpdate(DMFEntity _dmfEntity, DictDataEntity _dictDataEntity) 0 Error Database synchronization failed. You may have to do a full build of the package 'ProjAX' and all of its dependent packages. 0 Error at Dynamics.AX.Application.DmfDataPopulation.syncEntityCreate(DictDataEntity dictDataEntity, Boolean useTargetEntityName) 0 Error at Dynamics.AX.Application.DmfDataPopulation.`syncEntityMetadata(StringCollection dataEntityViewCollection, StringCollection compositeEntityList) in xppSource://Source/ApplicationFoundation//AxClass_DmfDataPopulation.xpp:line 1248.' on category 'Error'. 0
Can you try deleting the data in staging from SSMS?
And are you getting this error when doing import also?
Was this reply helpful?YesNo
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.