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

Products

• CA IT Asset Manager
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management

Issue/Introduction

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 and higher

CA IT Asset Manager 14.1 and higher

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.