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
- Create redshift import connection JDBC by https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/0d5ffbb6951b45778c1a90ffd0114f04.html?q=share+credential.
- 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}"
} - The issue does not happen when using freehand sql.
Cause
This issue is currently under investigation of development team.
Resolution
- 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.
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