I have a Qualified table where the Non qualifier is a Lietaral Date field.
Qualified Update -> Update
New links -> Create
Existing Links -> All mapped Fields
MDIS unmapped values -> ADD
All is working well,When the Incoming file has exactly the same NOn qualifier as in Data manager, But when the incoming file has some New non-qualifers then it fails with a value Exception...
1166657856 2011/09/27 16:29:16.326 GMT Importing: 'Samplee_27sep.xml.MDM_DATA' Table --> 'CostCentre.CostCentre' Table.
1166657856 2011/09/27 16:29:16.341 GMT Could not create lookups. Source record number: -10, error message : Type mismatch. Invalid field values.
1166657856 2011/09/27 16:29:16.346 GMT Import failed. Could not create lookups. Source record number: -10, error message : Type mismatch. Invalid field values.
Import action: Update (All Mapped Fields)
Source record no: 1
But ideally it should NOT fail as the MDIS Unmapped fields are set to ADD..
I would expect it to Add any new NON qualfiers to QT and add that Link to that Record.
But it is throwing error...
Did anyone face this issue till date???
Why is this behaviour..