SAP Knowledge Base Article - Public

3390326 - "INTERNAL_ERROR java.lang.IllegalStateException: Expected BEGIN_OBJECT but was BEGIN_ARRAY" when refreshing data for a BPC write-back model in SAP Analytics Cloud (SAC)

Symptom

The following error is received when we try to sync the data from the story for a BPC write-back model.

  • INTERNAL_ERROR java.lang.IllegalStateException: Expected BEGIN_OBJECT but was BEGIN_ARRAY at line 1 column 2 path $
  • An unhandled error occurred during writeback.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Open the SAC story.
  2. Version management panel.
  3. Click the Sync / Refresh button in the Version management panel.

Cause

Inconsistent data exists in the hierarchy of a BPC dimension between BW and BPC. For example, there are 7 hierarchies in BPC and only PARENTH1 exist in BW.

Resolution

Open the BPC web client and process the inconsistent dimensions.

Please also check the KBA 2665809 - Tools to Clear Cache and Buffer for Inconsistency Issue in Dimensions Member or Hierarchy in BPC.

See Also

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, SAC_FULL_LOAD_MODE, write back, BPC import , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Problem

Product

SAP Analytics Cloud 1.0