SAP Knowledge Base Article - Public

3286450 - "Cannot be saved due to a concurrent lock violation" when exporting data from SAP Analytics Cloud (SAC) to BPC 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)

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 occurs 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 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 250,000 rows into a maximum of 5 jobs at a time. If you have more than that number of data, it repeats the division every 250,000 rows of records.

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, an enhancement to introduce parameters so that users can choose to disable parallelization was inctroduced.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

Your feedback is important to help us improve our knowledge base.

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.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://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 1.0