Why am I getting a system error with this Query Activity in Automation Studio?

, o.JobID
, o.SubscriberKey
, o.EventDate
, o.isUnique
, o‌​.Domain
, o.Subscriber‌​ID
, o.OYBAccountID
, o.‌​ListID
, o.BatchID,
from _Open as o 
where DATEDIFF(hour, o.EventDate, GETDATE()) <= 0

Typically if Query Activities fail, it's one of these 6 things:

  1. Primary key violation -- your query results in duplicate rows not allowed by the primary key
  2. Inserting a null value into a non-nullable field
  3. Inserting a value too long for the field (truncation)
  4. Timeout -- if your query doesn't complete within the 30-minute timeout window, it'll error out.
  5. Your target Data Extension no longer exists
  6. Data type conversion -- trying to insert a $12.34 string into a Decimal field

SFMC Support can tell you the exact error from the server log.


This is a common error when the structure of the target data extension does not match the incoming data.

You can work around this by checking your Text/Date/Number data types, and making all fields NULLABLE.

If you still have problems, double check the source data format matches the Data extension you've made: Data View: Open

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.