SAP Knowledge Base Article - Public

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:


Result Set ADBC error: A database error occured. The error message in the database was: "Numeric overflow for parameter/column (1) source type BIGINT, target type INT4, value '2155498735'". (GRES01/101)


SAP Marketing Cloud

Reproducing the Issue

  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.

See Also

SAP Help - Segmentation Profiles Filters


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


SAP S/4HANA Cloud 2111