DIXF – Error when viewing target mapping

15 Jun

An issue comes up today when a client could not open “View target mapping”. This is R2 CU7. The stack trace error is shown like below

“Field ‘Position’ in table ‘DMFTargetXMLToEntityMap’ has not been explicitly selected“

It works for some entities but fails for some entities




After looking at stack trace I was able to find an issue with the select statement in table DMFEntity.generateXML() method. Position field was used but it was not part of Group by of the select statement; therefore, an exception was raised for missing field.

AOT > Table > DMFEntity > generateXML

I added ‘Position’ field to the select statement
while select mapping
group by MethodName, Position
where mapping.Entity      == _entity.EntityName
&& mapping.MappingType == DMFMappingType::Function
exists join sourceXMLFields
where sourceXMLFields.Entity == _entity.EntityName
&& sourceXMLFields.DefinitionGroup == _defGroup
&& mapping.EntityField == sourceXMLFields.EntityField


I’m now able to view the mapping. I found same issue with R3 CU8 and I haven’t tested with R3 CU9 yet.


Leave a comment

Posted by on June 15, 2015 in Development


Tags: , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: