SAP Knowledge Base Article - Public

3011069 - Checkpoints: Sync between BPC and SAC

Symptom

  1. Data is not sync between BPC and SAC for same BPC model.
  2. Import Job, Export Job failed with error in SAC. 
  3. no data imported 
  4. wrong data exported

Environment

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

SAP Cloud for Analytics

Resolution

  1. Need same data filter to display data in Listcube in BW/BPC system
     
  2. Need same data filter to display data in SAC Story 
     
  3. Before the import:
    1. Some restrictions:
      1. BPC imports does not support the WEEK Property level yet. 
      2. importing BPC data into SAC dimension is not a supported feature
         
    2. SAC Help Document:
      1. Prerequisites
      2. Importing SAP BPC Data to a New or Existing Model
      3. Import Data Connection to an SAP BPC System

  4. SAC: Import Job
    1. Check if  the SAC import job has been refreshed and without error
       
    2. Check if  the BPC user which SAC used to query the data has all the access to BPC master data[environment/model/dimension/ data access profile].
       
    3. Check if  the BPC time dimension has the base period maintained
       
    4. Check query engine in UJO_PARAM via SM30 or SE16: 
      1. CL_UJO_QUERY_MDXPTD2_MBRSET
      2. CL_UJO_QUERY_MDXPTD2
      3. see note: 1858257 - How to enable SQE to support MDX member set functions
      4. related issues:
        1. "0/0 lines imported" in SAC
           
    5. Check if there is any error in BPC system:
      1. Error log hints in SAC: "BPC plugin error: read fact data with new json format ends in exception from BPC!"
        1. SLG1
        2. ST22
        3. SM21 
        4. Incase of UJHANA error, please check HANA SQL
          1. 2663090  - Temporary problems during parsing/unexpected characters in an MDX statement”
             
  5. SAC: Export Job

    1. RSPM_MONITOR:  filter the data target with aDSO name, if there is any process in yellow, set it to red.
      Go to check requests of the aDSO, if there is any yellow or red requests, delete them accordingly.

    2. SBGRFCMON: check inbound unit with name RSBPC_ODATA_EXPORT. Make sure there is no red light. Delete the unit if it has a red light.
       
    3. check if there is a red light with T-code SBGRFCMON indicating 'No more memory available to add rows to an internal table'.
      If so, it will cause the export job pending and running longer than before, as a solution, please apply SAP Note 2913078 - Support "Clean and Replace".
       
  6. Trouble Shooting in BW/BPC system:
    1. SBGRFCMON
    2. /n/IWFND/TRACES
    3. SBGRFCCONF
    4. /n/IWBEP/TRACES
    5. 3026199 - Tips and Tricks of Analyzing BW Data Integration with SAC Issues
       
  7. BPC: Optimization Process [for BPC 11.x version for BW/4HANA and BPC 10.1 version on BW 750. ]
    1. Check if the BPC model has optimized process when you have the data issue
    2. If there is inconsistency, please use full load mentioned in following note:
      1. 2915785 - How to Optimize BPC Standard Model when it's integrated into SAP Analytics Cloud Planning Model with Write-Back Mode
        If your BPC model ( BW cube) process the compress requests every day, this may cause data in the compressed requests NOT synced to write back model.
        In this case, you will need to apply the solution in above note. 
      2. 2913942 - Switch to Full Load mode when export data from BPC to SAC
         
  8. System memory:
    1. Check heap memory and extended memory for the dialog sessions
    2. Check if data loading is too much for the memory

  9. Bug Fix: Please make sure following notes are applied:
    1. 2730872 - SAP Analytics Cloud and Business Planning and Consolidation 11.0 data integration with delta service fails due to hierarchy deletion of BPC dimension
    2. 2755379 - Support new json format when export data to SAC
    3. 2913078 - Support "Clean and Replace"
    4. 2936269 - No memory during export
       
  10. To submit a BPC/SAC Sync issue: Please provide
    1. BPC system ID
    2. BPC Environment/Model 
    3. SAC Tenant Link
    4. SAC Model Link
    5. SAC Story Link
    6. The BPC user used in SAC connection
    7. A SAC support user to trouble shoot

See Also

2915785 - How to Optimize BPC Standard Model when it's integrated into SAP Analytics Cloud Planning Model with Write-Back Mode
2969947 - Planning functionalities supported in SAC live connection to BPC Embedded Model
1858257 - How to enable SQE to support MDX member set functions
3026199 - Tips and Tricks of Analyzing BW Data Integration with SAC Issues
2998919 - Tips and Tricks of Analyzing S/4HANA Data Integration with SAC Issues

Keywords

UJO_READ_EXCEPTION 054, Delta Load, request_tsn, timestamp, AQ, AT, request status, rspmrequest, BPC11, SAC, DATA Integration, Dimension, Hierarchy, DELTA SERVICE, "The job failed due to an unexpected internal server error" "0/0 lines imported , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC,S/4,IBP...) , Problem

Product

SAP Analytics Cloud 1.0