3203445 - DPAgent insufficient privilege error

• During creating the connection between DPAgent and SAP Datasphere (DS) the following error is observed:
  • DPAgent error: SQLException: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '123456789AB1234BCD0FG1234A0E12QW'" (guid can be different)
• When running Replication flow through a HDB user, the same error may also occur.

SAP Datasphere

Missing permissions for SAP HANA Database user.

1. Run the following command on HANA SQL console (replace the guid with your unique one from the error message)
   • CALL GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS('123456789AB1234BCD0FG1234A0E12QW ', ?)  
2. Check the result. Some important parameters in the output:
   1. PRIVILEGE  /* the type of the missing privilege: SELECT, INSERT, UPDATE, DELETE, TRIGGER ... */
   2. IS_MISSING_ANALYTIC_PRIVILEGE /* FALSE means no missing analytic privilege */
   3. IS_MISSING_GRANT_OPTION /* FALSE means no missing grant privilege */
   4. OBJECT_NAME /* the object name which's missing the privilege stored by parameter PRIVILEGE  */
   5. OBJECT_TYPE /* the object type which's missing the privilege stored by parameter PRIVILEGE  */
   6. ...
3. Ensure that the permissions are assigned according to the SAP Help Portal Documentation: User Permissions.

• KBA 2938870 - Errors when connecting DP Agent with DWC
• SAP Help Portal Documentation: Troubleshooting the Data Provisioning Agent (SAP HANA Smart Data Integration)

DS, DPAgent, insufficient privilege, guid , KBA , DS-DI-CON , Connections , Problem