SAP Knowledge Base Article - Public

3475227 - 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)

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

SAP Analytics Cloud Version:  2024.8.10
Connection - Import to SQL Database.

Reproducing the Issue

  1. Login to SAC.
  2. Go to "Modeler".
  3. Create new "Model".
  4. Select "Start with Data".
  5. Select data source "SQL Database".
  6. Select "Connection Type > Sybase Adaptive Server Enterprise 16.0.
  7. Click on Next.
  8. 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

Product

SAP Analytics Cloud all versions