Symptom
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.
Read more...
Environment
- SAP HANA, platform edition
- SAP Netweaver on HANA
- SAP BW/4HANA
Product
Keywords
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.