SAP Knowledge Base Article - Public

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

Symptom

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".

Environment

SAP Datasphere Wave 2024.14

Cause

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

Resolution

  • 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

Keywords

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

Product

SAP Datasphere all versions