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
- SAP Help Create an Association
- SAP Help Create a Text Association
Keywords
text association, language, RACCT, SAKNR, KTOPL, key , KBA , DS-MD-VIW , Views , Known Error