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

book

Article ID: 5394

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

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)  

Cause

There is an incorrect field mapping in the destination field. 

Environment

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

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.