3145226 - Segmentation Models Application Throwing Error Message When Creating a New Model

When creating a new segmentation model based on the "All Interactions" segmentation profile, the following error message shows up:

SAP Marketing Cloud

1. Open Segmentation Models app.
2. Click on 'Create'.
3. Select "All Interactions" profile.
4. Notice the error message.

This error message shows up due to a technical limitation related to the underlying data types in the application coding when the returned count of interactions for the initial segment doesn't fit a INT4 type (INT4 should be in the interval of -2,147,483,648 to +2,147,483,647).

In short, the error message means that there are more than 2,147,483,647 interactions on the SAP Marketing Cloud system.

There are two recommended actions to keep using the "All Interactions" segmentation profile due to this limitation:

• Deleting old interaction data which is not really relevant anymore (potentially only related to less relevant interaction types like EMAIL_OUTBOUND as these do not really reflect the customer's behavior).
• Applying one or more profile filters to the "All Interactions" segmentation profile in order to "pre-filter" the results and thus reducing the root segment count. This procedure is done on the "Segmentation Configuration" app.

SAP Help - Segmentation Profiles Filters

all interactions, segmentation modeling, result set adbc, database error, numeric overflow , KBA , CEC-MKT-SEG , Segmentation , Problem