SAP Knowledge Base Article - Public

3392248 - Deployed SQL view shows blank Details section

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