SAP Knowledge Base Article - Public

3758563 - "The query was stopped before it finished because the server was unable to complete the request. Please try filtering your data, or contacting your administrator." when creating measure input control in SAC

Symptom

  • "The query was stopped before it finished because the server was unable to complete the request. Please try filtering your data, or contacting your administrator." when creating measure input control in SAC

Environment

  • SAP Analytics Cloud 1.0

Reproducing the Issue

  1. Login SAC.
  2. Access a story based on import model.
  3. Add dimensions and measures in a table or chart.
  4. Add Measure Input Control.
  5. Select a measure.
  6. Save the New crated Measure Input Control.
  7. Below error message could be defected in Measure Input Control.
    "The query was stopped before it finished because the server was unable to complete the request. Please try filtering your data, or contacting your administrator."

Below error could be checked from har file.
{
    "Messages": [
        {
            "Type": 1,
            "Number": xxxxx,
            "Text": "A constraint of the dimension, which can't be aggregated, is violated : These dimensions must not be aggregated, but are not in drill or filtered by a single member: [Version]"
        },
        {
            "Type": 2,
            "Number": xxxxx,
            "Text": "Caught exception : exception 70006944: AttributeEngine: overflow in numeric calculation;exception 70006944: AttributeEngine: overflow in numeric calculation; \\$message\\$=aggregation failed MeasureName\\$sum\\$ 1 int(5)\u000a,Exception in executor plan11550925@ip-100-90-213-32:30003 while executing pop 3\u000a"
        }
    ]
} 

Cause

  • Sum of the measure is more than maximum value for an Integer data type is 2³¹ – 1 = 2,147,483,647.

Resolution

Change the measure Data Type in model from Integer to Decimal which maximum value is 2⁶³ – 1 = 9,223,372,036,854,775,807.

  1. Login SAC.
  2. Locate the model.
  3. Check the issue happened measure, in General, change the Data Type from Integer to Decimal.

Keywords

exceed, over , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0