There is a bug in Data Import Export Framework (AX2012 R2) custom object generation wizard in the part where it is cleaning up table relations of the entity table. One example of the problem is when creating a new entity for CustGroup, it will generate an error. (Details can be found here:)
In the CustGroup example, DefaultDimension is imported as String (e.g. MainAccount-Department-CostCenter) and not an Int64 value. Hence the relation between the Dimension field (a RefRecId) and the reference table (DimensionAttributeValueSet) no longer applies and should be deleted. That is where the bug hits.
In the DMFGenerateEntityTable.modifyRelations method, the cursor which is suppose to traverse through all relations is accidentally discarded when deleting the table relation. Make the following changes to fix it:
In the CustGroup example, DefaultDimension is imported as String (e.g. MainAccount-Department-CostCenter) and not an Int64 value. Hence the relation between the Dimension field (a RefRecId) and the reference table (DimensionAttributeValueSet) no longer applies and should be deleted. That is where the bug hits.
In the DMFGenerateEntityTable.modifyRelations method, the cursor which is suppose to traverse through all relations is accidentally discarded when deleting the table relation. Make the following changes to fix it:
This posting is provided "AS IS" with no warranties, and confers no rights.
Great help!
ReplyDeleteThanks,
Peter
i added the code but still getting same issue :(
ReplyDeleteThis post was quite a while ago and it was against the beta version of DIXF I think. I suggest you remove any changes you have made and:
ReplyDelete1) Create new entity for CustGroup. If there's no errors, then this bug doesn't exists in your environment.
2) If the errors prompted in step 1, apply the code in this post and generate CustGroup entity again. It should work now.
3) Now retry creating the desire entity. If the error persists, then it is another issue.