DateTime is less than minumum value supported by CrmDateTime

Question

DateTime is less than minumum value supported by CrmDateTime

hegdesuchi

Hall of Fame

Points: 3047
More actions
June 2, 2016 at 10:10 am

#316895

Hi All,
I am trying to pull the data from Dynamics CRM to OLE DB Destination. But while trying to pull I get below mentioned error.
[Dynamics CRM Source] Warning: An exception has encountered while querying data from Dynamics CRM.
The same query will be attempted again. System.ServiceModel.FaultException<KingswaySoft.DynamicsCrmServices.Soap2011.OrganizationService.OrganizationServiceFault>:
DateTime is less than minumum value supported by CrmDateTime. Actual value: 12/30/1899 00:00:00,
Minimum value supported: 01/01/1900 00:00:00
Any inputs here? I tried converting Date fields to Text and also through Derived columns by casting DT_TIMESTMAP.
I tried with Kingsway and also with Pragmatic TF task. Nothing seem to work.
Any help would be appreciated!
Thanks In Advance

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

This appears to be something related to the DynamicsCRMSource, which most here will not know how to help you with, as it's not core SSIS.

The error occurs on extraction, I think, and will therefore not be resolved by any data conversions, which occur after extraction.

Are you pulling dates from a column where one or more rows have entries before 1/1/1900?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

frederico_fonseca SSCoach Points: 16154 More actions · Answer 2

assuming that what you say is fully correct and that you are using the CRM SDK to extract the data from CRM then it would seem that someone managed to enter an invalid date to the entity you are extracting from - before gong any further I would query the respective view/table and check the lowest dates - any below 01/01/1900 will be invalid and should be fixed before extracting.

if the CRM process you have has been changed to allow those dates through a assembly/workflow then you may need to change the extract to use those.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

You may want to check the data type in the SSIS package pulling the data. If it is expecting a smalldatetime data type and the source isn't a smalldatetime column, this could be the cause of your problem.