Hello,
I am using Excel add in to import some data. Upon publishing the data, system failed to publish and reported me some errors as below:
From the error, i understand that i need to enter value in the field based on the supported char limit. so i went back to my worksheet and tried changing the value. As soon as i update the field value and move to next field (or press tab), excel reverts back to old value and i am unable to publish.
so i tried to use "Refresh-> Clear current" so i can enter afresh, system allowed me to enter correct value now. But when i try to publish, system is giving me the same error message even though i have given correct value in the field.
It appears to me that Publish function tries to publish old data from cache/memory instead of reading current data from excel sheet. If i use new excel sheet, it works fine.
Any thoughts?
Error message:
Invalid document schema. The following error was returned: The 'http://schemas.microsoft.com/dynamics/2008/01/documents/DirPartyTable:NameAlias' element is invalid - The value 'xxxx' is invalid according to its datatype 'http://schemas.microsoft.com/dynamics/2008/01/sharedtypes:AxdExtType_NameAlias' - The actual length is greater than the MaxLength value. The actual length is greater than the MaxLength value.
I use AX 2012 R2 CU7
Thanks
Venkatesh