0

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.