Symptom
After upgrading to SAP HANA Revision 70 the number of records
retrieved by a BW query is incorrect when you do not use a filter
condition on certain columns
Other Terms
BWA index, FEMS, mode 3, BW on HANA, wrong results
Reason and Prerequisites
* You are running SAP HANA Revision 70
* The record count is wrong when there is no filter condition applied on a column, but is correct when it is applied
* The column that is being filtered on contains NULL values
* The record count is wrong when there is no filter condition applied on a column, but is correct when it is applied
* The column that is being filtered on contains NULL values
Solution
The wrong results are caused by a programming error in the OLAP
engine of HANA introduced in SAP HANA Revision 70 and was fixed in SAP
HANA Revision 71. The wrong results are likely to occur when a query
search pattern matches all values found in a column and there are NULL
values in the column. This error is unlikely occur if there is a filter
on the OLAP result set (e.g. HAVING constraints).
The workaround is to execute below SQL statement in HANA:
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') SET ('olap_parallel_result', 'use_compact_column') = 'no' WITH RECONFIGURE;
DISCLAIMER:
The SAP HANA configuration parameter [olap_parallel_result] use_compact_column is an internal parameter and may only be used in the context of this SAP Note. Using such a parameter requires that the SAP HANA system has the revision specified in the SAP Note, the described error situation has occurred, and that SAP support or services has instructed the customer to set/change the parameter. Using internal parameters outside of this given scope is not supported.
The workaround is to execute below SQL statement in HANA:
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') SET ('olap_parallel_result', 'use_compact_column') = 'no' WITH RECONFIGURE;
DISCLAIMER:
The SAP HANA configuration parameter [olap_parallel_result] use_compact_column is an internal parameter and may only be used in the context of this SAP Note. Using such a parameter requires that the SAP HANA system has the revision specified in the SAP Note, the described error situation has occurred, and that SAP support or services has instructed the customer to set/change the parameter. Using internal parameters outside of this given scope is not supported.
Header Data
| Released On | 16.10.2014 07:48:20 | ||
| Release Status | Released for Customer | ||
| Component | HAN-DB SAP HANA Database | ||
| Other Components |
| ||
| Priority | Recommendations / Additional Info | ||
| Category | Program error |
No comments:
Post a Comment