SAP Knowledge Base Article - Public

3440219 - Error "[2715] olap: join produced multi values" occurs for an Analytic Model

Symptom

The error below occurs when handling/managing/previewing Analytic Models in SAP Datasphere:

    "Messages": [
        {
            "Type": 2,
            "Number": 42014,
            "Text": "Caught exception : exception 70002048: column store error: search table error:  [2715] olap: join produced multi values;BwPopJoin3Inwards pop15(H00::SPACE_NAME:_SYS_SPLIT_TECH_NAME\\$CT~1en.FIELD)\u0000\u000a"
        }
    ]

Environment

 SAP Datasphere

Reproducing the Issue

This error can ocurs in multilpe ways, such as:

  • When opening Input Help (F4) for a Dimension in the Input Variables of the AM.

Cause

Wrong data. Performing an association join causes multiple entries, where it is expected to to have a 1:n mapping.

Resolution

Review the association mapping for the mentioned Dimension.

Datasphere's HANA Cloud expects a single entry resulting from the join, if two or more entries are returned the error will occur.

This should be rather a unexpected modelling issue (or even wrong data issue) rather than SAP Datasphere bug.

See Also

Keywords

text association, language, RACCT, SAKNR, KTOPL, key , KBA , DS-MD-VIW , Views , Known Error

Product

SAP Datasphere all versions