Symptom
- Input cells in input-ready tables become randomly blocked for data input
- Different cells may be blocked for different users
- Issue may resolve itself after several minutes, and re-occur later or for other cells
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Open a planning story on a model where validation rules are active.
- Ensure data locking is open and user has appropriate Data Access Control rights.
- One or more cells shows a “/” (multi-currency) and is not editable.
Cause
A “teams update” API call or other similar call that generates an UpdateDAC job is executed with very high frequency due to a configuration error.
Each UpdateDAC job may take 30 seconds or more to execute depending on model and DAC complexity.
If the API call is executed with a higher frequency then the UpdateDAC jobs the backlog of jobs will continue to grow and never fully complete.
This results in a data inconsistency in the validation rule state due to a large backlog in the job queue (many UpdateDAC jobs generated by frequent “teams update” API calls), which prevented the validation rule from being applied correctly.
Resolution
- Stop the process that is generating the UpdateDAC jobs in the queue.
- Wait until the existing UpdateDAC and subsequent validation rule update jobs fully clear from the queue.
- After the queue is clear, deactivate the affected validation rule on the model, then reactivate it to restore a consistent state. Note: The deactivate/reactivate action may not be available while jobs are pending.
- If the behavior persists, delete the validation rule and recreate it.
See Also
Keywords
validation rule, disaggregation, multi-currency, slash cell, read-only cell, table slash, currency aggregation, data inconsistency, UpdateDAC, job backlog, API, teams update, planning model, dimension mapping, data locking open , KBA , LOD-ANA-PL-VAL , Planning Validation , Problem
SAP Knowledge Base Article - Public