Symptom
- In Data Builder after opening an already deployed SQL View, the Details section is blank
- Use the SQL Validate button then the syntax error is shown in the Editor section and the Details / Model Properties section is filled with wrong information like system generated technical name and business name, semantic usage is Relational Dataset and Status is 'Not Deployed'
- Search for the SQL view in Repository Explorer, the correct information is displayed like Status is Deployed
- Try to open the SQL view several times then the Details section is displayed with the correct information
Environment
SAP Datasphere
Reproducing the Issue
- Open the SQL view in Data Builder several times
- Use Validate SQL button
- Search for the object in Repository Explorer
Resolution
The fix is planned to be available on 14th November 2023 with SAP Datasphere release 2023.24.
For updated deployment information, please see SAP Note 2984828. As global deployment usually takes 24 hours around this date, you may plan to test the fix one day later.
Keywords
Fact view, invalid SQL, Inconsistent behavior , KBA , DS-MD-VIW , Views , Known Error
Product
SAP Datasphere all versions