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

When running a BW query you face an error message such as outlined below (on the indexserver traces or in the query output):

Could not execute 'SELECT "_SYS_BIC"."package/CALC_OR_ANALYTIC_VIEW"."COL1", "_SYS_BIC"."package/<HANA CV>"."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/<HANA CV>

olap: merging multi value dicts is not implemented, please make sure the following join cardinality is modeled correctly (did you use 1:1 ...
Error when the data really is 1:N or N:M?);olap: merging multi value dicts is not implemented, please make sure the following join cardinality is modeled ...
Error correctly (did you use 1:1 when the data really is 1:N or N:M?);BwPopJoin1Inwards pop96(***::****:/BIC/X<INFOOBJECT>en.S__<ATTRIBUTE> ...
Error to .$/BIC/Y<INFOOBBJECT>$/BIC/<INFOOBBJECT>$): calcEngine search on olapIndex failed.,QueryId: ***/[Request Info: ...
Error Object Name = "<***>"."0BW:BIA:<PROVIDER>", FM Name = TREX_DBS_AGGREGATE]

Image /data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP HANA, platform edition
• SAP Netweaver on HANA
• SAP BW/4HANA

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