serving the solutions day and night


Wednesday, April 17, 2013

XRM Data Transfer Error

Error 1
System.InvalidOperationException: Sequence contains no matching

PickList or OptionSet value is missing or Number  not matched

Error 2
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.

Add DNS.dbml -> DNS.designer.cs -> DNSDataContext method
partial void OnCreated()
    //Set the timeout value to 300 = 50 Min.
    base.CommandTimeout = 3000;
Error 3
System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: A validation error occurred.  The value of 'leadsourcecode' on record of type 'contact' is outside the valid range. (Fault Detail is equal to Microsoft.Xrm.Sdk.OrganizationServiceFault).

sourcecode is our of range, for example if option value prefix (From Publisher entity) is started from 8000 and sourcecode valud contains 7000, crm will throw error.

Error 4
System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: DateTime is less than minumum value supported by CrmDateTime. Actual value: 08/30/1878 00:00:00, Minimum value supported: 01/01/1900 00:00:00

 DateTime minDT = new DateTime(1900, 01, 01);
  if (ft.ProcessDate > minDT)
    food.dns_ProcessDate = vt.ProcessDate;

No comments: