SAP Knowledge Base Article - Public

3286450 - "Cannot be saved due to a concurrent lock violation" when exporting data from SAC to BPC8 for Microsoft

Symptom

The following error occurs 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) 2022

Reproducing the Issue

  1. Open a model
  2. Go to the Data Management workspace.
  3. 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 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

  • KBA 3073231Concurrent lock violation when sending data
  • Note 3164460 - Customize system options for SAC exporting data to BPC

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, data locking, locks
, KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , EPM-BPC-MS , Microsoft Version , Problem

Product

SAP Analytics Cloud all versions