SAP Knowledge Base Article - Public

3563822 - The Data Preview of SQL Script is failed

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

  1. Open the SQL View in the Data Builder
  2. 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

Product

SAP Datasphere all versions