Symptom
The following erroroccurs in SAP Analytics Cloud (SAC) when you export data from SAC to BPC MS:
- Members ... of dimensions .... cannot be saved due to a concurrent lock violation
Environment
SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Open a model
- Go to the Data Management workspace.
- Run an export job that exports data from SAC to BPC for Microsoft
Cause
This error rises because SAC starts multiple jobs to process the data when you export a large amount of data to BPC and parallel processing could result in lock conflicts.
Regarding details of the parallel processing, when dividing data into packages for parallelization, it is not specifically optimized for a particular dimension like Time or Category. The goal of the division is actually to split the data evenly. To get that, it iterates over the dimensions and collects the members of each and then calculates the package size if the data is split by this dimension. In the end, it chooses the one that can mostly evenly distribute the data into the number of jobs (max: 5).
Also, the system only processes at most 250000 rows into a maximum of 5 jobs at a time. If you have more than that number of data, it repeats the division every 250000 rows of records.
Besides, if the default logic is triggered, it can also be an uncontrollable factor contributing to the lock issue.
Resolution
For the export to the BPC Netweaver version, the development team did provide an enhancement to introduce parameters so that users can choose to disable the parallelization. See SAP Note 3164460.
However, we do not have similar settings for the BPC MS version.
If you want to get the export job executed successfully, please manually split the export into several jobs by setting up filters.
See Also
Keywords