SAP Knowledge Base Article - Public

3494080 - View Persistency fails with error message "anonymous block returned not exactly one row"


The view persistency, which was previously functioning correctly, is now experiencing issues. Specifically, it is failing with the error message "anonymous block returned not exactly one row".


SAP Datasphere Wave 2024.14


The error occurs when there is an SQL artifact named DUMMY that exists as a Local Table in the space schema.


  • The fix is planned to be deployed with SAP Datasphere Wave 2024.15.
  • As workaround delete the dummy table in the affected space.

See Also

The planned deployment schedule for the upcoming SAP Datasphere delivery waves and the underlying SAC platform wave is provided below.

2984828 - SAP Data Warehouse Cloud Release & Delivery Schedule


view persistency, view analyzer, dummy, anonymous, block , KBA , DS-DI-VIW , View Persistency and Runtime , DS-DI-RT , Remote Tables , Problem


SAP Datasphere all versions