SAP Knowledge Base Article - Public

3158431 - Import Connection to Salesforce is successfully established, but it throws the error Connection Failed when creating a Model based on Import Connection to Salesforce in SAP Analytics Cloud.

Symptom

  • Import Connection to Salesforce succeeds, but it throws the error Connection Failed when creating a Model based on Import Connection to Salesforce 
  • Chrome HAR trace shows: 

              message: "Connection to host failed: OAuth2 Access Token request error: invalid_client, description: invalid client credentials."
              messageId: "CONNECTION_FAILED"

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Import Data Connection to Salesforce using OAuth2 Authentication is successfully established as per Product Guide
  2. When you create a Model based on the above import connection, it throws the error: Connection Failed

Resolution

Uncheck the checkbox Require Secret for Refresh Token Flow in Salesforce setup page.

Keywords

Acquired, SAC , Client ID, Client Secret , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions