Loading

Marketing Cloud Next - Data Stream Refresh Status Error Troubleshooting

Publiceringsdatum: Oct 21, 2026
Beskrivning

Sometimes data streams used by Marketing Cloud Next will fail to refresh and you may notice the following symptoms:

  • Data Streams status on the Marketing Cloud -> Assisted Setup -> Basic Settings page is in Error state, especially when trying to update the data kits after major releases. 
  • Insufficient records in your Data Cloud segments due to contact/lead/prospect data streams not refreshing. 
  • Out of date information in your data graphs.

 

Viewing the error for Data Stream Status

  • To view the error on the data stream, navigate to Data Streams tab in Salesforce and find any of the streams with an Error value in the Data Stream Status column.
  • Open up the Refresh History sub tab.
  • Click on the error icon and it should display the error.

 

One of the more frequent causes for a failure to refresh a data stream is due to missing field or objects. The error looks like No such column 'FieldName' on entity 'ObjectName'. For Marketing Cloud Next, this is typically a result of one of the following scenarios.

  1. Salesforce Admin has deleted a field
  2. Salesforce Admin has changed the API Name of the field on the CRM object. 
  3. Data Cloud Salesforce Connector permission set missing permissions
  4. A previously available standard field on the CRM object no longer exists in Salesforce

See below for resolution steps. 

Lösning

[1] Salesforce Admin has deleted a field

The quickest fix would be to undelete the field in Setup -> Object Manager.

If that's not possible (if the field has been permanently deleted), then you will want to recreate the field with the same API Name. Please note that Salesforce automatically appends '__c' to the Field Name to create the API Name of any custom field. So if you are dealing with an error that states No such column 'Test__c' on entity 'ObjectName', then when creating the field in Setup -> Object Manager, you must only put Test in the Field Name. Once you save, Salesforce will automatically append '__c' and produce 'Test__c' as the final API Name.

Another option is to use the Disable a Data Stream Field feature to disable the corresponding data stream field if it is no longer needed.

 

[2] Salesforce Admin has changed the API Name of the field on the CRM object

If an admin changes the Field Name of a field in Setup -> Object Manager, this will alter the API Name of the field. The quickest fix would be to change the Field Name back to the original field name.

If that's not possible, then you will need to create a new field with the same API Name (similar to the above section). 

Another option is to use the Disable a Data Stream Field feature to disable the corresponding data stream field if it is no longer needed.

 

[3] Data Cloud Salesforce Connector permission set missing permissions

The Data Cloud Salesforce Connector permission set drives the visibility that Data Cloud has into your Salesforce CRM data. Double check that this permission set has the proper visibility to the field or object (read only is sufficient). 

 

[4] A previously available standard field on the CRM object no longer exists in Salesforce

  • Sometimes features or other licenses in CRM unrelated to Marketing Cloud Next introduce standard fields to the CRM objects used by Marketing Cloud Next. These fields are by default added to the DLOs during the data kit deployment, especially for data kits like the Sales Data Kit that uses widely used CRM objects like Lead, Contact, Accounts, Campaign, List Email etc.
  • At a later date, you may find that the features or licenses are turned off or removed from your Salesforce org, which will in turn remove those standard fields from your CRM objects.
  • This will also produce the same No such column 'FieldName' on entity 'ObjectName error because if the field is not present in CRM, it isn't possible for Data Cloud to query it.
  • You may find your data stream(s) with a "Failure" status in the "Last Run Status" field and show a No such column 'FieldName' on entity 'ObjectName error in the "Refresh History" tab of the data stream. Below are some sample data streams and fields that we have seen with this issue in the past.

 

Lead, Contact, Account, and Opportunity data streams

  1. ActivityMetricRollupId
  2. ActivityMetricId

 

Messaging Channel data stream

  1. LinkingPreference
  2. IsLinkedRecordOpenedAsSubTab

 

List Email data stream

These fields were added to List Email data stream by previously available Sales Engagement feature:

  1. ActionCadenceStepId
  2. TotalOpens

These fields were added to List Email data stream by previously available Marketing Cloud Account Engagement integration. These fields are commonly seen in the No such column 'FieldName' on entity 'ListEmail' error after a Salesforce org's license for Marketing Cloud Account Engagement expires while switching to a Marketing Cloud Next license. 

  1. ClickThroughRate
  2. ClickToOpenRatio
  3. DeliveryRate
  4. OpenRate
  5. OptOutRate
  6. ProgramName
  7. SentVia
  8. SpamComplaintRate
  9. TotalDelivered
  10. TotalHardBounced
  11. TotalOpens
  12. TotalOutOfOffic
  13. TotalReplies
  14. TotalSoftBounced
  15. TotalSpamComplaints
  16. TotalTrackedLinkClicks
  17. Type
  18. UniqueClickThroughRate
  19. UniqueOpens
  20. UniqueOptOuts
  21. UniqueReplies
  22. UniqueTrackedLinkClicks

 

Campaign data stream

These fields were added to Campaign data stream by previously available Marketing Cloud Account Engagement integration. These fields are commonly seen in the No such column 'FieldName' on entity 'Campaign' error after a Salesforce org's license for Marketing Cloud Account Engagement expires while switching to a Marketing Cloud Next license. 

  1. HierarchyTotalEmailsDelivered
  2. HierarchyTotalFormSubmissions
  3. HierarchyTotalFormViews
  4. HierarchyTotalLandingPageFormSubmissions
  5. HierarchyTotalLandingPageViews
  6. HierarchyUniqueEmailOpens
  7. HierarchyUniqueEmailTrackedLinkClicks
  8. HierarchyUniqueMarketingLinkClicks
  9. TenantId
  10. TotalEmailsDelivered
  11. TotalFormSubmissions
  12. TotalFormViews
  13. TotalLandingPageFormSubmissions
  14. TotalLandingPageViews
  15. UniqueEmailOpens
  16. UniqueEmailTrackedLinkClicks
  17. UniqueMarketingLinkClicks

 

Resolution for unavailable fields

To resolve this issue, use the Disable a Data Stream Field feature to disable the corresponding data stream field. If you notice more than one of the field above fields on your stream (especially if your Marketing Cloud Account Engagement license recently expired), you can start by disabling one by one the fields that show up in Data Stream error messaging that looks like No such column 'FieldName' on entity 'ObjectName'. Each time you attempt to refresh, the error message should update to let you know if there are any remaining fields causing issues. 

Ytterligare resurser

Check out this knowledge article for more detailed specific Data Cloud content on this subject. 

Knowledge-artikelnummer

003962315

 
Laddar
Salesforce Help | Article