Symptom
The Data Preview is not working for SQL Script - Table function.
Error Internal Server Error
In the network trace, the following error can be found:
{
"error": {
"code": "500",
"message": "Internal Server Error",
"correlationId": "xyz"
}
}
Environment
SAP Datasphere
Reproducing the Issue
- Open the SQL View in the Data Builder
- Data Preview
Resolution
The fix is planned to be available with SAP Datasphere release 2025.04. For updated deployment information, please see SAP Note 2984828 - SAP Datasphere Release & Delivery Schedule. As global deployment usually takes 24 hours, you may plan to test the fix one day later.
As a workaround, the line break can be removed at the end of comments in SQL script.
Keywords
KBA , DS-MD-ODATA , Modeling oData Service , DS-DI-VIW , View Persistency and Runtime , Known Error