SAP Knowledge Base Article - Public

3838440 - Validation rule disaggregation to all Sociedad members leads to multi-currency slash cells in tables – SAP Analytics Cloud

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

  1. Open a planning story on a model where validation rules are active.
  2. Ensure data locking is open and user has appropriate Data Access Control rights.
  3. 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

  1. Stop the process that is generating the UpdateDAC jobs in the queue.
  2. Wait until the existing UpdateDAC and subsequent validation rule update jobs fully clear from the queue.
  3. 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.
  4. 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

Product

SAP Analytics Cloud all versions