Basis Errors and Solutions

Symptom
When executing “Consistency Check” program for a cube in BIA short dump – COMPUTE_BCD_OVERFLOW – occurs for the following tests: RSDDBIAMON-> goto > consistency check Totals in BIA
Totals in BIA and DB
Other terms
BWA index, BW Accelerator, Consistency Check, RSRV, AGGREGATE_ROW, COMPUTE_BCD_OVERFLOW
Reason and Prerequisites
programm error: catch missing
Solution
SAP NetWeaver BI 7.00
Import Support Package 22 for SAP [...]

Symptom
Through the consistency check from RSDDBIAMON on “existence”, the system gets always one “green” message. All the same whether the index active or Inactive or not at all exist. Mail is not sent away, also not if the index does not exist.
Other terms
BWA index check TREX
Reason and Prerequisites
programm error
Solution
SAP NetWeaver BI 7.00
Import Support [...]

Symptom
You encounter incorrect results for a BW query using FEMS logic
Other terms
BIA, BWA, Accelerator, wrong data, different result
Reason and Prerequisites
Prerequisites:
SAP NetWeaver BW Accelerator Revision 51 or previousThe index for the F-table is not splitThe BWA OLAP index is located on a different TREX index server than the F-table indexYou are running a query that uses [...]

Symptom
You obtain incorrect query results but if you execute the query again the result is correct.
Other terms
BIA, BWA, Accelerator, wrong result, different, rollup, commit, changerun
Reason and Prerequisites
Prerequisites:
SAP NetWeaver BW Accelerator Revision 51 or previousThe query is running on a BWA index when a rollup for that index is activeThe query is running when the commit [...]

Symptom
You experience incorrect query results.
Other terms
BIA, BWA, Accelerator, different, wrong result, kidsel, inconsistent
Reason and Prerequisites
Prerequisites:
SAP NetWeaver BW Accelerator Revision 51 or previousThe fact table index used for the query is not splitThe fact table index is located on the same TREX index server as the OLAP indexAn intermediate internal result exceeds 5 million entries
Reason:Due to [...]

Symptom
You encounter incorrect results for a BW query using FEMS logic
Other terms
BIA, BWA, Accelerator, wrong data, different result
Reason and Prerequisites
Prerequisites:
SAP NetWeaver BW Accelerator Revision 51 or previousThe index for the F-table is not splitThe BWA OLAP index is located on a different TREX index server than the F-table indexYou are running a query that uses [...]

Symptom
When executing RSRV- or rsddbiamon2- Consistency Check program occurs short dump – COMPUTE_BCD_OVERFLOW .
Other terms
BWA index, BW Accelerator, Consistency Check, RSRV, AGGREGATE_ROW, COMPUTE_BCD_OVERFLOW
Reason and Prerequisites
The summation of the figures reaches more than 1.000.000.000.000.000 which can’t be stored in a field of type packed with a length of 9 and 2 decimals field. The [...]

Symptom
You receive incorrect data for queries where the F-table has attributes of type DATE or TIME. You find the following entry in the trace of TREXIndexServer: “Attribute engine function not implemented (index attribute flags ) getAggregateMeasures”
Other terms
BWA, BIA, Accelerator, wrong result, date, time, not implemented
Reason and Prerequisites
Prerequisite: SAP NetWeaver [...]