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

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

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

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.

This issue is currently under investigation of development team.

• How to find User Assistance for SAP Analytics Cloud?
• Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

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

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

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