SAP Knowledge Base Article - Preview

1866135 - Error: merging multi value dicts is not implemented, please make sure the following join cardinality is modeled

Symptom

You are running a query on top of SAP HANA analytic/calculation view and you face the following error message (on the indexserver traces or directly on the SQL editor console output):

Could not execute 'SELECT "_SYS_BIC"."package/CALC_OR_ANALYTIC_VIEW"."COL1", "_SYS_BIC"."package/CALC_OR_ANALYTIC_VIEW"."COL2", ...' in 1.573 seconds .
SAP DBTech JDBC: [2048]: column store error: search table error: [2712]
Error executing physical plan: olap: merging multi value dicts is not implemented, please make sure the following join cardinality is modeled correctly (did you use 1:1 when the data really is 1:N or N:M?);
BwPopJoin2Inwards pop30(SCHEMA:TABLEen.JOIN_COLUMN_1, .JOIN_COLUMN_1 to .JOIN_COLUMN_2),in executor::Executor in cube: _SYS_BIC:package/CALC_OR_ANALYTIC_VIEW


Read more...

Environment

SAP HANA Database

Product

SAP HANA, platform edition all versions

Keywords

join, cardinality, referential, merging, column store error, 2712, Corrupt value index at udiv, integrity, corrupted, uniqueChecker, RSRV, master data, characteristic, , KBA , HAN-DB , SAP HANA Database , BW-BEX-OT , OLAP Technology , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.