How To Fix RS2HANA_CHECK072 - Database table RS2HANA_AUTH_STR is not correctly filled

RS2HANA_CHECK072 - Overview

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message RS2HANA_CHECK072 - Database table RS2HANA_AUTH_STR is not correctly filled ?

  The SAP error message RS2HANA_CHECK072 indicates that the database table RS2HANA_AUTH_STR is not correctly filled. This table is related to the authorization structure for SAP BW (Business Warehouse) and HANA. When this error occurs, it typically means that there is an issue with the authorization settings or the data in the table that is necessary for the proper functioning of BW on HANA.
  Cause
  The error can be caused by several factors, including:
  
  Incomplete or Incorrect Data: The table may not have been populated correctly during the migration or upgrade process from a previous version of SAP BW to BW on HANA.
  Authorization Issues: There may be missing or incorrect authorizations for users or roles that are supposed to access the data.
  System 
  Configuration Issues: There may be configuration issues in the BW system that prevent the table from being filled correctly.
  Transport Issues: If the system has recently undergone a transport of changes, it may