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
- Open the SAC story.
- Version management panel.
- 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
- https://blogs.sap.com/2018/08/13/integration-between-sac-and-bpc/
- SAP Note 2914451 - Unjustified error message when export BPC data to SAC after the ADSO compressed
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, SAC_FULL_LOAD_MODE, write back, BPC import , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Problem