KeyNotFoundException while bulk import leads RRS feed

  • Question

  • We use on premise CRM 2011. One user started to do data entry in an Excel table. Then the person saves as CSV and tries to import in the CRM. The imports keep failing with the error:

    Unhandled Exception: System.Collections.Generic.KeyNotFoundException:  The given key was not present in the dictionary.
       à System.Collections.Generic.Dictionary`2.get_Item(TKey key)
       à Microsoft.Crm.Asynchronous.ImportOperationTransform.AdjustLengthForNvarcharFields(ImportFileHelperData importFileHelperData)
       à Microsoft.Crm.Asynchronous.ImportOperationTransform.TransformData(Guid organizationId, Guid importId)
       à Microsoft.Crm.Asynchronous.ImportOperationTransform.ExecuteImportOperation(Guid organizationId, Guid importId, Int32 operationType)
       à Microsoft.Crm.Asynchronous.ImportOperation.InternalExecute(AsyncEvent asyncEvent)

    Then, the user sends me the CSV file (basic 5 fields, all text), I try to import it directly on the server where the CRM is installed and it imports without any problem. 

    This happens very often and causes us headhackes. Is there a solution? 

    Monday, November 4, 2013 4:42 PM