Message type: E = Error
Message class: RS2HANA_CHECK - RS2HANA Check Report
Message number: 099
Message text: User &1: Number of results differs: InfoProvider view &2, Query view &3
The number of results retrieved from the generated external SAP HANA
view for query &V4& and the generated external SAP HANA view for its
underlying InfoProvider are different.
As there are no filter conditions defined for the external query SAP
HANA view which restrict the result set, the number of results retrieved
should be equal.
The generated SAP HANA SQL analytic privilege for external SAP HANA
query views contains a static filter condition which is always built
like in the following example. There is always a LIKE '%' condition:
Abstract example: "<Random view column>" LIKE '%'
Concrete example: "0CALDAY" LIKE '%'
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
Because of the randomly selected view column for the external SAP HANA
view for query &V4&, the results are further restricted. This is a
severe error and has to be analyzed by SAP directly.
Please open an incident ticket on component BW-WHM-MTD-HMOD and mention
this message number RS2HANA_CHECK099.
Error message extract from SAP system. Copyright SAP SE.
RS2HANA_CHECK099
- User &1: Number of results differs: InfoProvider view &2, Query view &3 ?The SAP error message RS2HANA_CHECK099 typically indicates a discrepancy between the number of results returned by an InfoProvider view and a query view in SAP BW/4HANA or SAP BW on HANA. This error can occur during the execution of a query when the data returned from the InfoProvider does not match the expected results defined in the query.
Cause: Data Inconsistency: The data in the InfoProvider may have changed after the query was defined, leading to a mismatch in the expected number of results. Query Filters: Filters applied in the query may not align with the data available in the InfoProvider, resulting in different result counts. Aggregation Issues: If the InfoProvider is aggregating data differently than the query expects, this can lead to discrepancies. Data Model Changes: Changes in the underlying data model (e.g., changes in the InfoObject or InfoProvider structure) can lead to inconsistencies. Query Design: The query may be designed in a way that
Get instant SAP help. Sign up for our Free Essentials Plan.
RS2HANA_CHECK098
InfoProvider &1 is a query. No filter strings required.
The system issues an error message and will not allow you to continue with this transaction until the error is resolved. Procedure for System Adminis...
RS2HANA_CHECK097
BW analysis authorizations are always replicated: No
What causes this issue? You have enabled the setting <ZH>BW analysis authorization replication only via report or process chain</>. This ...
RS2HANA_CHECK100
Maximum filter string length: &1 characters
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
RS2HANA_CHECK101
Privilege type of SAP HANA view(s)
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
Click on this link to search all SAP messages.