Data Import Failed to convert parameter value from a String to a DateTime

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

I am running a Data Import from IT Asset Manager 14.1. The import is failing.
The message in the data import log shows:
Failed to convert parameter value from a String to a DateTime.

Environment

Release:
Component: ARGIS

Cause

This may be caused by the last field in the import being null. If the last field in the import is null, regardless of it being a non-required field, this error may occur.

Resolution

This has been fixed in the 14.1.05 Rollup patch.
If you are not yet on that patch you can either enter a value for the last field, or upgrade.