SAP Knowledge Base Article - Public

3421846 - Error [403]: internal error: Cannot get remote source objects: Could not get tables while using Data Export Service API to extract planning data to BW/4HANA

Symptom

  • Using REST API to export SAC data to BW/4HANA
  • The following error message occurs in SAP HANA Smart Data Access (SDA) to establish a connection to a remote source to get planning data out of SAP Analytics Cloud to the BW/4HANA system: 
    • SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Could not get tables

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Open the SAC Tenant > Administration >  App Integration > Add a new OAUTH client
  2. Setup OAUTH client with Data Export Service
  3. Take the secret and token details from the configuration
  4. Creating remote source in HANA with this OAUTH configuration
  5. Remote source access: Remote source created successfully but cannot get to the connection

Cause

  • A configuration issue on the DPAgent side. The OAuth credentials are either expiring or incorrect.

Resolution

  • Ensure the OAuth credential is correct and valid.  

See Also

KBA 2496051 - How to change "Logging Level" (Trace level) of a Data Provisioning Agent - SAP HANA Smart Data Integration

Keywords

HTTP/1.1 401 Unauthorized{"error":"invalid_client","error_description":"Bad credentials"}, 403 - Forbidden, For more information about why the request was refused, see the server, Invalid odata connection! Getting odata metadata failed because of (403) Forbidden [HTTP/1.1 403 Forbidden] Context: Invalid odata connection! Getting odata metadata failed because of (403) Forbidden [HTTP/1.1 403 Forbidden]  , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

Product

SAP Analytics Cloud 1.0