SAP Knowledge Base Article - Public

2690011 - Errors using Mass Data Entry - Process aborted due to error in query execution. Refer to the console log for more details in SAP Analytics Cloud

Symptom

When you use the Mass Data Entry (MDE) feature in SAP Analytics Cloud (SAC) the following errors occur after you select the "Process & Exit" button:

  • Process aborted due to error in query execution. Refer to the console log for more details.
  • An Error occurred while processing.

This error also occurs in Chrome Developer Tools:

  • MassDataEntry query execution error: Code-42722, The updated cell cannot be changed as it is not input enabled : The target version 0 is not a plan version.

Environment

  • SAP Analytics Cloud 2018.15.3

Cause

The formula link function is used in the underlying model.

Resolution

This issue is scheduled to be addressed in version 2018.20.

However, this is on a best endeavour basis and not a guarantee of delivery in this release. 
The targeted release may change without prior notification.

Workaround:

The error only happens after the second use of the MassDataEntry or after using the Revert changes feature of data version in the version management panel.
Once you use those features above, refresh the SAC client (press F5 on keyboard OR press the Reload this page button in chrome) before the user is going to enter values or use the Mass Data Entry (MDE) feature again.

If you are not using the Mass Data Entry feature and attempt to edit a public version, the error may occur and the data entry will fail with the reported error message, you can safely ignore the error.
Any subsequent data entries will work. This workaround has to be applied per public version, i.e. once for every public version Actual, Plan etc.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0