Symptom
- An 'Unexpected program error' occurred while creating the dataset from the S/4 HANA import connection in SAC.
- Giving error: 'rawError': 'An error occurred while fetching data: Response from the external server returned a status code of 400.
Environment
SAP ANALYTICS CLOUD 2025.8.5
Reproducing the Issue
- Log in to SAP Analytics Cloud.
- Navigate to the "Datasets" section.
- Click on the "From Data Source" option.
- In the "Acquired Data" section, select "SAP S/4 HANA."
- Choose the connection.
- Select the desired query named, along with all measures and dimensions.
- Check "Select entire table " option click on next.
- Set Query batch size to 50,000 and click on create.
- Click on Save dataset.
- Notice the "unexpected program error"
Cause
When using OData services with parameters, creating the query option using "Build a Query" is not supported in SAP Analytics Cloud.
Resolution
Use the "free hand query" option to create query instead of "build a query" option.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
dataset, query, SAC, model, datasource , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public