Cannot update asset with the data importer: Web Service threw exception System.FormatException: Failed to convert parameter value from a String to a Int32.

Document ID : KB000005394
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

My import fails to update any of the assets in my data import file.

The log file shows the error:  

Web Service threw exception System.FormatException: Failed to convert parameter value from a String to a Int32. ---> System.FormatException: Input string was not in a correct format. 
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) 
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) 
at System.String.System.IConvertible.ToInt32(IFormatProvider provider)  

Environment:
CA Asset Portfolio Management 14.1, any patch levelCA IT Asset Manager 14.1, any patch level
Cause:

There is an incorrect field mapping in the destination field. 

Resolution:

Make a copy of the import.  Edit the import map file and remove one field at a time to locate the field in error. 

There is likely a string field in the data file (source field) that is mapped to a destination field that is type Integer.