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
- Login to SAC.
- Go to Connections.
- Click on the "+" icon.
- Choose SQL Datasources.
- 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>
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