Troubleshooting issues in automation studio

Automation studio, Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks
2 minutes read

Another series of troubleshooting automations in Salesforce Marketing Cloud. I will regurarly add any new additions that I have already resolved and spend great deal of time and life energy. So hope it will help resolve someones issues.

I will try to add, throughout my daily life as an SFMC consultant, all the errors that I have experienced and resolved. Many resolutions can be found on the Salesforce help page. For those not listed there, I’ll make a point to list them out, sharing my hands-on experiences and solutions to help others facing similar challenges.

The value is too long to store into a data type.

This error often lacks specific information about which field to examine, and even Salesforce support may not provide a direct answer initially. However, they usually identify the issue upon further investigation. The error could arise from two main scenarios: when attempting to save records to the database or due to a problem in your SQL query or code.

Attempting to save records to the database

It seems like the field values you have selected are out of range for their corresponding fields in the database. To resolve this, try adding restrictions to fields or increasing field lengths or their types that you think may cause this issue. In my case, the issue was with the language field, which was set to accept only two characters, but often we received language values that were more than two characters in length.

Another issue I recently encountered was when I tried to save a numeric string into a number field in a data extension. This numeric string was outside the integer boundaries, causing an syntax error. In such cases, it’s important to ensure that the data types and their limits in the data extension match the actual data being inputted.

#for any field string that is of lenght 255 to make sure we will save the same lenght
LEFT(255)
Problem in your SQL query or code.

This occurred directly in my SQL query, where I was creating a compound field out of an integer and a numeric string, and somehow it was interpreted as a number that was way beyond the length of the integer field.

It’s likely due to the way SQL handles data types in operations. When you try to create a compound field using an integer and a numeric string, SQL might automatically attempt to convert all operands to a common data type. If this common type is a numeric type and the resulting value exceeds the maximum size that can be stored in that type, it results in a data overflow error or a syntax error. By explicitly converting the number to a string, you can control the data type and avoid these errors.

SELECT CAST(your_integer_column AS VARCHAR) AS converted_string
FROM your_table;
A visually engaging image representing 'SFMC Essentials: What You Need To Know' through digital and futuristic themes, tailored for Salesforce Marketing Cloud. The artwork includes symbols of marketing like graphs, analytics, and communication icons, combined with cloud computing motifs such as cloud shapes and digital network patterns. The color palette features dark blues and blacks, emphasizing the concept of advanced technology. The design is sleek, professional, and tailored to appeal to a tech-savvy audience, with a focus on clarity and visual appeal.
Marketing Automation, Salesforce Marketing Cloud

SFMC Essentials: What You Need To Know

3 minutes read

Let me show you the essentials I use in my day-to-day adventures with Salesforce Marketing Cloud. As we dive into this blog, I’ll share key insights and strategies that have been integral to my journey. I’ll provide you with practical advice for maximizing your experience with this marketing automation platform. Documentation Who wouldn’t guess this […]

Continue reading
Digital-themed graphic illustrating the extraction of data deltas from a data extension, featuring a computer screen with a data analysis interface, flowing data streams, and abstract digital patterns and circuitry in the background.
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Extract data deltas from the data extension

5 minutes read

Exporting data deltas from a marketing automation platform like Salesforce Marketing Cloud has been a widely discussed topic. I’ve seen numerous approaches to tackling this challenge. In this post, we’ll explore various methods for extracting data deltas and delve into my personal favorite. Stay tuned to uncover practical strategies that could revolutionize your data management […]

Continue reading
How to fetch code snippet with AMPScript
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

How to fetch code snippet with AMPScript

1 minute read

If you have ever experienced troubles when referring to your content block within another resource, either an email template or a cloud page, using ContentBlockBy AMPScript functions, I will show you a hopefully better way to include your snippets in your content. Dynamic content creation and personalization within Salesforce Marketing Cloud, can often grapple developers […]

Continue reading
Exploring the Dynamic World of Email Marketing: Diverse Template Designs in Salesforce Marketing Cloud
Salesforce Marketing Cloud, SFMC Tips & Tricks

Proof multiple template variants in SFMC

2 minutes read

When working with dynamic email templates that can generate multiple unique variants of the email, you are most probably tasked to proof all the variants to your stakeholder for review. Create data extension When proofing email templates, traditionally, we select subscribers from production or testing data extensions used in the actual send. This process involves […]

Continue reading
A futuristic server room with a central server labeled 'WS Proxy,' showcasing data streams passing through various filters labeled with data values like 'URL,' 'Protocol,' 'Payload Size.' Some filters display red warning signs indicating limitations. The background is filled with intricate networks of cables and lights, depicting a complex web server environment.
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

WS proxy retrieve filter value limitations

2 minutes read

I have discovered that when using the WS Proxy Retrieve method in Salesforce Marketing Cloud, the Filter’s Value property has limitations. Let’s find out how we can mitigate them. After dedicating a couple of hours to debugging, I found that half of the records are lost and never queried from the database using the WS […]

Continue reading
Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Error: Not all items were deleted

1 minute read

Yet another subtle error message, this one with a shy demeanor, may catch you off guard, particularly when you’re in the process of deleting a data extension. Its reserved nature might leave you hanging, wondering about the outcome and seeking further clarification. In such instances, it becomes crucial to decipher the message carefully to ensure […]

Continue reading
Salesforce Marketing Cloud Tips
Journey builder, Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Refresh Delivery in Transactional Journey

1 minute read

The process might seem straightforward at first glance—simply refreshing the email delivery content in Salesforce Marketing Cloud should suffice to receive the updated email contents. However, there’s more to consider. Salesforce Marketing Cloud utilizes server-side caching, which may display outdated content. Understanding when the cache refreshes isn’t always clear. In scenarios where immediate changes are […]

Continue reading
Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

How to refresh data extension records

1 minute read

You might have noticed that records are not refreshed automatically, which makes sense. However, there is no refresh button. Here are some helpful tips I’ve discovered on how to refresh records within the data extension while it’s open. Email studio In email studio it is failry easy you simply navigate to another folder and return […]

Continue reading
Top 5 SFMC tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

The Top 5 Stress-Busting Tips I have Learnt

3 minutes read

Working with any marketing automation platform, especially Salesforce Marketing Cloud, can provide a great user experience and a sense of accomplishment. However, it can also entail many stressful hours dedicated to solving seemingly easy issues. Here are my top 5 tips that made my daily work less stressed and saved me lots of cursing this […]

Continue reading