WCF Method failed on Server

Owned by Thomas Speekenbrink
Jan 25, 2021

Overview

What to do when you receive the following kind of error in the logfile of one of your DataBridge jobs

WCF Method failed on Server. Service call Contact.SaveContactEntity failed with exception
Contact.SaveContactEntity. The value assigned to the 'date' field Invoice date with udeffield id xyz in udef is out of range [1/1/1970 --> 1/19/2038]; got 1/1/1900; maybe you're thinking of an UnlimitedDate field instead?. WCF Method failed on Server

How to

Each time the job runs companies fail to be imported because of this error. Assuming this date 1/1/1900 represents an empty date this can be easily fixed by applying a Replace transformation.

You can use this for each column that is mapped to a udef of type date with settings:

  • If value matches = 01-01-1900 00:00:00

  • Then replace with = leave empty