I have a simple query that is erring out. I cannot figure out why, as it is so simple.

The target data extension has a primary key on contact_key.

Both fields (unsubscribe & newsletter) from the source DE are bool fields.

    from preference_center
    where unsubscribe = 'true' 
      or newsletter = 'false'
  • Maybe it is just me but I think that this post is really difficult to understand. Commented Jan 15, 2019 at 21:30
  • @JohannesSchapdick edited down to cut down on confusion. Commented Jan 15, 2019 at 21:33
  • Does it time out? or does it error fairly quickly? Commented Jan 15, 2019 at 21:41
  • 5 seconds or leas Commented Jan 15, 2019 at 21:42
  • Less*. Sorry. On mobile. Commented Jan 15, 2019 at 21:42

1 Answer 1


If you run into this error, it's likely your data extension (source or target) that needs be modified.

In this case there was a sample record that did not meet the non-nullable criteria in the source data extension. Therefore, the target data extension needed to have nullable fields.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .