I am importing huge amount of asset data but there are some field which are showing error as the length of some source field data is greater than the destination field max size.As for example, PO Number in source csv is more than 20 characters but the maximum acceptable value in destination field is 20. So its showing error:- Web Service threw exception CA.Common.Utilities.Exceptions.ValidationException: 1. The Purchase Order ID contains data with an invalid type or size. The expected data type (size) is string(20), and the actual data is ***********
at WebService.Service.SaveWithNormalization(Byte RequestStream)
For some other fields ,I am facing the same issue as for example for Room Location.It takes max 30 string but the data we have in this field is greater than 30 character. I can not change these values as these are customer provided and they dont want to change these values as well. So how can I resolve this issue?
Someone please help me to get it resolved.