SAP Knowledge Base Article - Public

3702083 - Error "ERROR_BAD_REQUEST_TO_C4A" when creating Databricks connection in SAC

Symptom

Connection to Databricks as a JDBC datasource in SAC is never successful and gives an error "ERROR_BAD_REQUEST_TO_C4A ".

Environment

  • SAP Analytics Cloud
  • Databricks

Reproducing the Issue

  1. Edit DriverConfig.properties file for the Cloud Agent to add location of Databricks JDBC driver
  2. Restart the Cloud Agent
  3. In SAC, select Connections -> Add SQL Databases
  4. Select the new Databricks option
  5. Populate the correct values and click Create

Cause

Support for Databricks as a datasource was only added as of version 1.0.423 of the Cloud Agent.  There was a subsequent update as of version 1.0.439.

Resolution

In order to use Databricks as a datasource in SAC, the Cloud Agent should be on the latest version.  

If it's on a version earlier than 1.0.423, Databricks will not work.  It is recommended to keep the Cloud Agent current as changes are made for various data sources periodically.

See Also

Please visit https://me.sap.com/softwarecenter and search for SAP ANALYTICS CLOUD AGENT 1.0 (SUPPORT PACKAGES AND PATCHES) to find the latest versions.

Keywords

Databricks, SAC, Cloud, Agent, version, Tomcat, Connector , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0