3704184 - Insufficient privilege error in HANA DB Explorer when DB Analysis user performs Retry/Ignore exceptions in Remote Source

• Database Analysis User encounters "SQL Error: insufficient privilege: Detailed info for this error can be found with guid 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'" in HANA DB Explorer.
• Error occurs when performing a "Retry" or "Ignore" action in Exceptions of a Remote Source.

• SAP Datasphere

1. Access HANA DB Explorer as a Database Analysis User.
2. Navigate to Exceptions in a Remote Source.
3. Attempt to perform a "Retry" or "Ignore" action.
4. Observe the "SQL Error: insufficient privilege" message with detailed information linked to guid 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'.

Misuse of Database Analysis User.

1. Database Analysis User is not intended to perform such actions in Datasphere's database level.
2. Ensure that the "Retry" is performed via the designated user interface (UI) instead of directly in HANA DB Explorer.
   This can be done once you find the respective Remote Table with the failed Real-time replication.
3. See SAP Help Resuming Real-Time Replication After a Fail.

insufficient privilege, hana db explorer, retry exceptions, ignore exceptions, remote source, sql error, database analysis user, privilege error, hana database , KBA , DS-SM , Space Management , Known Error