SAP Knowledge Base Article - Public

3371547 - ERROR: "ERROR_BAD_REQUEST_TO_C4A" when trying to create an MS SQL Server 2016 connection in SAC.

Symptom

When trying to create a new MS SQL Server 2016 connection in SAP Analytics Cloud, the below error occurs:

"ERROR_BAD_REQUEST_TO_C4A "

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Login to SAC.
  2. Go to Connections.
  3. Click on the "+" icon.
  4. Choose SQL Datasources.
  5. Fill the necessary details, and then click on Create.
    >> Notice the below error: BAD_REQUEST_TO_C4A.

Cause

misconfiguration of the application server

Resolution

Follow the SAC help portal guide in order to add the Java option to the agent:

-DSAP_CLOUD_AGENT_PROPERTIES_PATH=<path_to_the_properties_file>

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/0d5ffbb6951b45778c1a90ffd0114f04.html

See Also

Microsoft JDBC Driver for SQL Server support matrix: https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16&source=recommendations

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, database, connect, establish, error , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0