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

SAP Error Message - Details

• 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 not have included all necessary objects or data.
  
  Solution
  To resolve the error, you can follow these steps:
  
  
  Check Table Contents: Use transaction code SE11 to check the contents of the table RS2HANA_AUTH_STR. Ensure that it has the necessary entries and that they are correctly filled.
  
  
  Repopulate the Table: If the table is empty or incorrectly filled, you may need to repopulate it. This can often be done by executing the relevant BW data load processes or by using specific SAP notes that provide instructions for repopulating the table.
  
  
  Run Authorization Checks: Use transaction code SU53 to check for authorization issues. This will help you identify if there are any missing authorizations for users trying to access the data.
  
  
  Check for SAP Notes: Look for any relevant SAP Notes that address this specific error. SAP frequently releases notes that provide fixes or workarounds for known issues.
  
  
  System Configuration: Review the system configuration settings related to BW and HANA to ensure that everything is set up correctly.
  
  
  Consult Documentation: Refer to the official SAP documentation for BW on HANA for any specific instructions or guidelines related to authorization structures.
  
  
  Contact SAP Support: If the issue persists after trying the above steps, consider reaching out to SAP Support for further assistance.
  
  
  Related Information
  
  Transaction Codes: SE11 (Data Dictionary), SU53 (Authorization Check), RSA1 (Data Warehousing Workbench).
  SAP Notes: Always check the SAP Support Portal for the latest notes related to your specific version of SAP BW and HANA.
  Documentation: Review the SAP Help Portal for BW on HANA for detailed information on authorization management and troubleshooting.
  
  By following these steps, you should be able to identify and resolve the issue related to the RS2HANA_AUTH_STR table and the associated error message.