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
A professional and sleek image showcasing a modern office environment with a focus on Adobe Campaign Classic. In the center, a computer screen displays the Adobe Campaign Classic interface, surrounded by symbols of digital marketing challenges and solutions like flowcharts, graphs, and analytics data. The background features a dynamic office setting, emphasizing the fast-paced nature of digital marketing. Text overlays include key terms such as 'Strategies', 'Analytics', and 'Campaign Management', highlighting the essential elements of Adobe Campaign Classic.
Adobe Campaign, Marketing Automation

ACC Essentials: What You Need To Know

2 minutes read

When you go hiking, it’s crucial to always take essentials with you to stay prepared for any situation that may arise. This is similar to working with Adobe Campaign Classic or engaging in any other skill-requiring activity. Just as you wouldn’t hike in sweatpants in the middle of winter, like I once did, you’ll want […]

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 map enumeration with file extract
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

How to map enumeration with file extract

1 minute read

I was recently asked about the purpose of a checkbox, and believe it or not, it turned out to be the function I thought was missing in Adobe Campaign Classic – but it’s actually there. It’s the File Extract activity feature hidden in one of the final steps of the extraction wizard. It is simple […]

Continue reading
An interactive whiteboard in an educational setting displays a query expression builder, highlighting the use of variables in a complex query. A group of engaged learners discuss the color-marked variables. The room is equipped with data analysis and programming resources, enhancing the learning atmosphere.
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

Use variables in query expression builder

2 minutes read

When the time comes, you will find yourself in a situation where you would like to set up query builder condition expressions as dynamic values. We can achieve this and more with Adobe Campaign Classic. But what are those situations? For example, I had to build a reporting workflow for automated campaigns that was divided […]

Continue reading
Fork Bomb on Adobe Campaign A Controlled Test
Adobe Campaign, Marketing Automation

Fork Bomb on Adobe Campaign: A Controlled Test

3 minutes read

It was around 10 years ago when I first encountered the term ‘fork bomb’. I tried it, it worked, and it made me happy that my virtual server went down quicker than a lightning strike. And that was it – my fork bomb adventure back then. After all these years, I don’t know why I […]

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
Export data with no access to sftp
ACC Tips & Tricks, Adobe Campaign

Export data with no access to sftp

3 minutes read

There might be situations where you need to extract data in Adobe Campaign, but you don’t have access to SFTP or the application server itself to fetch the file. In such cases, I’ll guide you through what we can do. Original question has been posted on experience league where various options were mentioned from which […]

Continue reading