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
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
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
Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

How to bulk change data extension fields

less than a minute read

As a Salesforce Marketing Cloud admin, you will learn that certain operations on data extensions are better handled via Email Studio, while others are more suited for Contact Builder. Today, I will explain when to use each method for adding or changing fields in a data extension. My preferred way to add or change fields […]

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

How to add indexes to the data extensions

1 minute read

Maybe the title got you a bit curious because there is no such thing as adding indexes in Salesforce Marketing Cloud data extensions. But what can be done instead? If the indexes cannot be managed by the admins and cannot be requested from support we can try to apply one of the following workarounds. Filtered […]

Continue reading
How to redo hot clicks report in workflow
Adobe Campaign, Marketing Automation

How to redo hot clicks report in workflow

3 minutes read

In the world of email marketing, tracking recipient activity is essential to understanding the effectiveness of your campaigns. One valuable report that marketers often rely on is the “Hot Clicks Report,” which provides insights into recipient interactions, such as email clicks. The report is included with the Adobe Campaign Classic installation, and you can simply […]

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

How to use MD5 in SQL and AMPScript

1 minute read

Message Digest 5 (MD5) is a hash function used for data integrity, but it is not suitable for security-critical applications. It has found use for various applications, one of which is to create an encrypted contact subscriber key. MD5 takes any string and produces a fixed-size (128-bit) hash value, that cannot be easily decrypted. To […]

Continue reading
split-screen comparison: one side displays a user typing a SQL query in uppercase, while the other side shows the same query in lowercase, both leading to identical database results. The design emphasizes equivalence through elements like equal signs or arrows and features a digitally inspired background with matrix-style code or abstract tech imagery.
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

WOW! SQL queries are case insensitive

1 minute read

I recently discovered that when querying data views, case sensitivity in column names doesn’t make a difference; it consistently picks up the column when named correctly. Let’s explore where else column case sensitivity doesn’t play a significant role. First let’s create a data extension with some columns so we can test following in Query studio, […]

Continue reading
Adobe Campaign Classic tips
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

How to copy query conditions to another split

1 minute read

Perhaps you’ve encountered an unusual occurrence while attempting to copy complex query conditions to your clipboard. In some instances, only a portion of the content was copied, while in others, nothing was copied at all. I’ve personally faced similar situations over the years but never delved deeper into the matter. However, one day, I reached […]

Continue reading