SAP Knowledge Base Article - Public

3585457 - Unable to Build a Query for Redshift database in SAC when using Generic JDBC

Symptom

Unable to Build a Query for Redshift database in SAC when using Generic JDBC, Freehand SQL query works.

Environment

  • SAP Analytics Cloud 2025.1.9 (Client)
  • SAP Analytics Cloud 2025.1.8 (Server)

Reproducing the Issue

  1. Create redshift import connection JDBC by https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/0d5ffbb6951b45778c1a90ffd0114f04.html?q=share+credential.
  2. Create model based on redshift connection and failed with build a query with below error: An internal server error occurred in the Data Acquisition Service. HAR trace as below:
    {
        "result": "{\"status\":\"Error\",\"error\":{\"code\":\"UNHANDLED_DAE_EXCEPTION\",\"rawError\":\"\\\"UNHANDLED_DAE_EXCEPTION\\\"\",\"params\":[]},\"httpStatus\":500}"
    }
  3. The issue does not happen when using freehand sql.

Cause

This issue is currently under investigation of development team.

Resolution

Your feedback is important to help us improve our knowledge base.

See Also

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, no data, warning, instead, incorrect

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, no data, warning, instead, incorrect , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0