Sometimes data streams used by Marketing Cloud Next will fail to refresh and you may notice the following symptoms:
Viewing the error for Data Stream Status
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.
See below for resolution steps.
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.
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.
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).
These fields were added to List Email data stream by previously available Sales Engagement feature:
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.
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.
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.
Check out this knowledge article for more detailed specific Data Cloud content on this subject.
003962315

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.