Symptom
While trying to create a model using Freehand query for the Sybase Adaptive Server Enterprise 16.0 connection then it is throwing the error "An internal server error occurred in the Data Acquisition Service" in SAP Analytics Cloud (SAC)
Environment
Reproducing the Issue
- Login to SAC.
- Go to "Modeler".
- Create new "Model".
- Select "Start with Data".
- Select data source "SQL Database".
- Select "Connection Type > Sybase Adaptive Server Enterprise 16.0.
- Click on Next.
- Select Freehand Query.
Notice that it will throw the error : An internal server error occurred in the Data Acquisition Service.
Cause
Missing authorization.
Resolution
Give 'Full Administrator' rights to the DB user in the SQL side.
Keywords
sybase connection, new model, model, connection, freehand query , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-DES , Story Design & Visualizations , Problem