Error loading null value to ActualEnd date in Microsoft Dynamics CRM

ATTENTION: This forum is no longer active. Please navigate to our new support site at https://support.starfishetl.com/
Viewing 3 posts (of 3 total)
afreeling
User - Author
Post count: 1
#1

Hi,

I was trying to clear some incorrectly loaded Actual End dates on Tasks in Microsoft Dynamics CRM. I created a Starfish job to update ActualEnd with a null field, and turned of "Skip Blank Writes", but when I ran this I received the following error:

System.Exception: UPDATE [Task] SET [ActualEnd]=NULL WHERE [Id]='60175dba-2868-e511-baae-782bcb6d0c4e'
System.Data.RSSBus.DynamicsCRM.DynamicsCRMException (0x80004005): [500] Could not execute the specified command: The propertyname, propertytype, propertyvalue attribute's count is not equal, or the count is 0.

What does this mean? Is it possible to load null values into this field?

Thanks,
Andrew

Comments (3)

Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#2

Thats kind of a weird message. As a test, could you try setting an additional field in the mapping to a value? So the resulting SQL would be something like:

UPDATE [Task] SET [SomeField]='ABC', [ActualEnd]=NULL WHERE [Id]='60175dba-2868-e511-baae-782bcb6d0c4e'

I'm wondering if the driver thinks that because the only field being set is a NULL that it doens't have to update the record..

Log in to post comments
afreeling's picture afreeling
User - Author
Post count: 1
#3

Thanks! This has resolved the error; unfortunately it seems like it is still not possible to load a NULL into this date field (the job ran successfully but the field value did not change), but I think that is just a limitation of Dynamics CRM.

Thanks,
Andrew

Log in to post comments
Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#4

Yes I have a feeling CRM won't allow a NULL date value, but let me look into this & get back to you.

Log in to post comments
Viewing 3 posts (of 3 total)

Forum Login

Login or sign up for our forums to connect to the user community.

Reply

You must log in to post.

Not a Member? Register.