Skip to main content
Topics#Email MarketingDomanda di Guilherme Nascimento
Guilherme Nascimento ha fatto una domanda in #Email Marketing
4 nov 2025, 20:30

Automation failed due to system error.

Hi everyone, all good? I need some help with Automation Studio/Query Studio. I'm trying to create a column break for specific columns. Here's the SQL code I wrote: 

 

SELECT SubscriberKey, [Individual-Id], EmailAddress, FormattedE164PhoneNumber, CountryId, 

JSON_VALUE(SalesOrder, '$[0].ConfirmationDate') AS ConfirmationDate, 

JSON_VALUE(SalesOrder, '$[0].Name') AS Name, 

JSON_VALUE(SalesOrder, '$[0].[RetailStore_Id]') AS [RetailStore_Id] 

FROM CONVITES_05E06_CONVITES_05E06_1sgU60000007Pw9IAE_85RU6000000AFozMAG 

 

It's giving me "Automation failed due to system error." Even though I followed all the rules, could you please help me? Thank you! 

 

@* Marketing Cloud Intelligence *

#Email Marketing

3 risposte
  1. Mithushal Kandula (CJ Affiliate)
    27 nov 2025, 11:44

    I'm seeing the same kind of error. Someone, please help me fix it. 

    Automation failed due to a system error.

     

    SELECT 

    rlc.Id

    , 

    rlc.FirstName, 

    rlc.LastName, 

    rlc.Email, 

    COALESCE(ls.Preferred_Language__c, rlc.Preferred_Language__c) AS Preferred_Language__c, 

    COALESCE(rca.AccountName, rlc.Company, ls.Company) AS Company, 

    COALESCE(rca.AccountType__c, ls.AccountType1__c) AS AccountType__c, 

    rlc.HasOptedOutOfEmail 

    FROM [Refreshed Leads and Contacts] rlc 

    LEFT JOIN [Refreshed Contacts and Accounts] rca 

    ON rca.ContactId =

    rlc.Id

     

    LEFT JOIN [Lead_Salesforce] ls 

    ON

    ls.Id = rlc.Id

     

    WHERE 

    (rca.AccountType__c IN ('Advertiser/Merchant','Agency') 

    OR ls.AccountType1__c IN ('Advertiser/Merchant','Agency')) 

    AND(rlc.HasOptedOutOfEmail = 'False' 

    OR rlc.HasOptedOutOfEmail IS NULL) 

    AND(rlc.Do_Not_Email_ContactStatus__c = 'False' 

    OR rlc.Do_Not_Email_ContactStatus__c IS NULL)

Scrivi una risposta...
0/9000