SAP Knowledge Base Article - Public

3442730 - View persistency fails with Data Access Control (DAC)

Symptom

Under Data Integration Monitor the view persistency log contains the following error message:

{"correlationId":"xxx","errorMessage":"View 'xxx' cannot be persisted because the structure of one or more of its Data Access Controls(DAC) does not support view persistency."}

Environment

SAP Datasphere

Reproducing the Issue

  • Deploy a view where DAC is used
  • Try to persist the data

Cause

Some Data Access Control structures are not supported by persisted views.

Resolution

You can persist a view if a data access control with structure "Values Only" is assigned to it.
Data Access Control structures "Operator and Values" and "Hierarchy" are not supported by persisted views. 

More detailed information in SAP Help Portal Documentation: Persisted Views and Data Access Control.

Keywords

operator DAC view  , KBA , DS-DI-VIW , View Persistency and Runtime , DS-SEC-DAC , Security – Data Access Control , How To

Product

SAP Datasphere all versions