Use this page to find out what DESelect Segment error messages mean and how to resolve them.
If you are facing an error that is not on this page, please make sure to create a support ticket and we'll be happy to help!
DESelect Segment error messages
Error Message | Meaning | Suggested Action |
Selected Data Extension [DE Name] cannot be found. Therefore, this selection cannot be opened. |
The cause of this error is that DESelect cannot locate one or more of the Data Extensions used in the selection. It can be due to:
|
The solution for this problem is to create a copy of the missing Data Extension in its original location, with the same fields and External Key as before. Then, DESelect will automatically fix the selection so you can access and modify it if needed. |
Cannot insert a NULL value into a non-nullable column. |
There is a nullable field mapped to a non-nullable field in the Target Definition step. |
Review the Target Data Extension fields looking for red or orange warning signs. Either change the source field mapped to that target field or modify the definition of the target field to match the field properties. In addition, you can also create an 'Is not empty' filter type on the corresponding field. |
You do not have access. |
This error is caused most likely because the browser is blocking the DESelect cookies from being used. |
You can follow the steps explained in this article. |
"API Permission Failed" when accessing DESelect or running preview/running a selection. |
The user does not have the necessary permissions inside SFMC to use DESelect or some of the DESelect features. |
To solve this issue either you or your Salesforce Marketing Cloud administrator needs to set the right permissions/roles for your user. Find out which are the needed permissions here. |
Error creating Preview DataExtension: Error saving the Query field.[data view name] is not a known data extension or system data view. You can only query existing data extensions or system data views. |
When building a query in DESelect that uses Data Views, you may get the said error. This error happens if you are querying Data Views that are not enabled in your Salesforce Marketing Cloud instance. |
You can get more information about this error and how to solve it here. |
Violation of PRIMARY KEY constraint. Cannot insert duplicate key. |
You may get this error after running a selection, even though you might have previewed it to validate your results. It happens when the records you are trying to store inside your Target Data Extension contain the same primary key value more than once. |
You can get more information about this error and how to solve it here. |
SFMC error messages shown in DESelect Segment
This section resumes the errors you may get from DESelect but inherited from SFMC. You can also check the error support page of Salesforce Marketing Cloud.
Error Message | Meaning | Suggested Action |
Automation/Query Failed due to system error.![]() |
Related to a system error in SFMC. |
SFMC's recommendation is to retry and open a support ticket if the error persists. This error can be caused by an incorrect Target DE configuration, such as mapping a field to a target field with a smaller length |
Time-out Error. |
Your selection has reached the maximum of 30 minutes allowed by Salesforce Marketing Cloud. |
SFMC's recommendation is to retry and if the error still persists, you may need to divide the selection into smaller selections. To facilitate this process, you can use Waterfall Selections. In addition, if you run into this error often enough, you can create a case with SFMC to extend your time-out limit. Read more about optimisation tips here. |
Error: Query activity terminated because it has exceeded the transaction log size limit. Reducing query complexity helps prevent this error in many cases. |
Your Selection is too complex for SFMC to process due to the high amount of data in your Selected Data Extensions. |
This error's cause and its solution are similar to a Timeout. You should try reducing the complexity of the query by splitting it into multiple steps. You can get more information about this error and how to solve it here. |
Query failed during execution. Error: Invalid object name '_Open_unfiltered._Open_unfiltered' |
Related to an SFMC system error. Also seen with _Sent, _Bounce, and _Click |
There's no workaround as it appears to be an internal error that happens from time to time. You should try to rerun your Selection and this should work. |
Error saving the Query field.'fn_' is a reserved word and may not appear in your query. |
This word "fn_" (among others) is part of the SFMC Reserved Word Exceptions table which unfortunately can't be removed.
The word pattern is reserved because SFMC does not support the use of user-defined functions as noted in the SQL documentation below: https://help.salesforce.com/articleView?id=mc_as_sql_reference.htm&type=5
|
The only workaround for this error is to either:
|
Comments
0 comments
Please sign in to leave a comment.