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 *
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.IdLEFT JOIN [Lead_Salesforce] ls
ON
ls.Id = rlc.IdWHERE
(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)
