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 with Data Access Control set up.
- You can't persist a view consuming a view with Data Access Control set up.
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
SAP Knowledge Base Article - Public