Database table RS2HANA_AUTH_STR is not correctly filled

Message type: E = Error

Message class: RS2HANA_CHECK - RS2HANA Check Report

Message number: 072

Message text: Database table RS2HANA_AUTH_STR is not correctly filled



What causes this issue?

An exception "CX_SY_ITAB_DUPLICATE_KEY" occured while filling internal
buffers for processing selected checks. Processing cannot be continued
unless this issue is solved.
At least two entries in table RS2HANA_AUTH_STR are invalid. The field
"BWUSER" is not filled, for example where field "INFOPROVIDER" is equal
to &V1& and field "USERNAME" is equal to &V2&.


System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.



How to fix this error?

Database table RS2HANA_AUTH_STR contains all filter strings generated by
the SAP HANA Model Generation framework, which SAP HANA users need in
order to access generated SAP HANA attribute views using SQL analytic
privileges.
The corresponding SAP HANA user and BW user are stored for each filter
string in this table. Currently there are entries in table
RS2HANA_AUTH_STR, where the field "BWUSER" is initial. This is due to BW
authorizations, which have been replicated before specific changes were
made to table RS2HANA_AUTH_STR.


Procedure for System Administrators

Check table RS2HANA_AUTH_STR for entries where the field "BWUSER" is
initial. Trigger the BW authorization replication for all InfoProviders
again where the field "BWUSER" is initial.

Error message extract from SAP system. Copyright SAP SE.