SAP Knowledge Base Article - Public

3011069 - Checkpoints: Import and Export Job for SAC model via SAP BPC connection type

Symptom

  1. User is using SAP BPC connection in SAC Tenant to import or export BPC data. 
    Using Import Data - SAP BPC connection in SAC Tenant:
    1. Connection Type: SAP BPC: 
      1. Sub Type: SAP BPC for SAP BW/4HANA
      2. Sub Type: SAP BPC 10.1 for SAP NetWeaver
         
  2. User gets following issue: 
    1. Data is not synchronized between BPC and SAP Analytics Cloud (SAC) models.
    2. The import or export jobs failed with an error in SAC. 
    3. No data is imported.
    4. THe wrong data is exported.
    5. "Error obtaining concurrency lock (foreign_lock)"
    6. "Error obtaining concurrency lock (enqueue_server_busy)"
    7. "BPC plugin error: read fact data with new json format ends in exception from BPC!"
    8. HTTP 400 EPM_SERVICE "Unable to retrieve the external data due to: EPM_SERVICE"
    9. "An internal server error occurred in Data Acquisition service" 
    10. PLUGIN_EXECUTION_ERROR
    11. Failed to execute client request
    12. HTTP 204 
    13. BPC plugin error
    14. An internal server error occurred in the Data Acquisition Service
    15. PLUGIN_EXECUTION_ERROR Failed to execute client request
       
  3. For other connection type, please visit:
    1. Odata Service: 3220729 Checkpoints: Import and Export Job for SAC model via OData Services

Environment

  • SAP Business Planning and Consolidation, version for SAP NetWeaver
  • SAP Business Planning and Consolidation, version for SAP BW/4HANA
  • SAP Analytics Cloud

Reproducing the Issue

1) Set up BPC connection in SAC
2) Run Import Job in SAC for BPC model
3) Run Export Job in SAC for BPC model

Cause

Missing Configuration or Product Limitation

Resolution

  1. Check Function Restrictions:
    1. WEEK Property level is not supported yet BPC connection
    2. Importing BPC data into SAC dimension is not supported yet BPC connection
    3. SAML2 is not supported yet in BPC connection

  2. Check if Data Import - SAP BPC Connection set up correctly. 
    1. Prerequisites
    2. Importing SAP BPC Data to a New or Existing Model
    3. Import Data Connection to an SAP BPC System

  3. Check BPC data
    1. get the BPC Infoprovider info: 
      1. SE16: Embedded Model: RSBPCA_APPL_IPRV
      2. SE16: Standard Model: UJA_APPL
    2. LISTCUBE in the BPC (NetWeaver) system:
      1. Display the BPC data using the same filter/mapping based on SAC import/export job
          
  4. Check BPC user [which used in the data import - SAP BPC connection type in SAC] 
    1. SU01
    2. if the BPC user has the access to BPC data: 
      1. Environment
      2. Model
      3. Dimensions
      4. Data Access Profile
    3. In case of HTTP 204 error during creating BPC connection in SAC, it may indicate the user has no authorization to BPC model.
       
  5. Check System Log in BPC system:
    1. Application Log: SLG1
    2. Shortdump: ST22
    3. System Log: SM21
    4. Work Process: SM66 
      1. Check heap memory and extended memory for the dialog sessions

  6. Check BPC dimension setting:
    1. Check if the BPC Time dimension has the base period properties maintained
    2. Check if the correct single hierarchy is selected for the Account dimension

  7. Check BPC Global/Environment/Model setting: 
    1. report SAP_RSADMIN_MAINTAIN 
    2. Check if the query engine in UJO_PARAM is set via SM30 or SE16:
      1. CL_UJO_QUERY_MDXPTD2_MBRSET 
      2. See SAP Note: 1858257 - How to enable SQE to support MDX member set functions
         
    3. In case of a UJHANA error, please check the HANA SQL statements:
      1. 2663090  - Temporary problems during parsing/unexpected characters in an MDX statement”
         
    4. In case of BPC Models: Optimization Process [for BPC 11.0 / BPC 11.1 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:
      3. 2915785 - How to Optimize BPC Standard Model when it's integrated into SAP Analytics Cloud Planning Model with Write-Back Mode
      4. 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.
      5. In this case, you will need to apply the solution in above note. 
      6. 2913942 - Switch to Full Load mode when export data from BPC to SAC
         
  8. Check if the BPC user has the full authorization:
    1. Check missing authorization object: SU53

  9. Check if the BPC service activated or not
    1. Check the URL used in the Data Import - SAP BPC connection in SAC. 
    2. Go to SICF and check the service is activated 
       
  10. Check if following notes are applied in BW/BPC system: 
    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
    5. 2550738 - SY_530 error raised when select 'Base Level' in EPM Add-in report or load BPC data to SAC
       
  11. Check SAC Log:
    1. Tenant Home Page > System > Monitor > Trace
       
  12. Check SAML setting in the SAC BPC Import connection.
    1. When the SAML2 is disabled, SAC uses "Basic Authentication" that is username and password. Users will get the pop only for the first time or after the user changes his/her password and SAC has a secure store to save the user and password for the connection per user.
       
  13. In case of SAC: Export Job:
    1. Parallization Scenario:
      1. As of SAC version 2022.07, use SAC Parallel Execution parameters in the BPC model to avoid concurrency lock and enqueue server busy errors/warnings:
      2. SAP Note 3164460 - Customize system options for SAC exporting data to BPC
      3. In case of parameter SAC_EXPORT_TASKS is not set, and record involved 50000+records, the SAC data export process will split the packages [50000 records per package] and run the packages in parallel.
      4. In case of parameter SAC_EXPORT_TASKS = 1 and record involved 50000+records, the SAC data export process will split the packages and run the packages [50000 records per package] one after another. 
      5. Reference note:
        1. 1960682 -BPC NW: Error obtaining concurrency lock (foreign_lock)
           
  14. Check Network HAR trace and Console
    1. 2280022 - How to collect a HTTP archive (HAR) file (Chrome developer tools network trace) in SAP Analytics Cloud
       
  15. Check Gateway Setting:
    1. SAP Gateway Error Log:  /n/IWFND/ERROR_LOG
    2. SAP Gateway Backend Error Log: /n/IWBEP/ERROR_LOG
    3. SAP Gateway Application Log Viewer: /n/IWFND/APPS_LOG
    4. Service Catalog: /n/IWFND/MAINT_SERVICE
    5. Gateway Client Test: /n/IWFND/GW_CLIENT
    6. /n/IWFND/IWF_ACTIVATE
       
  16. Enable Payload Trace in BW/BPC system:
    1. Transaction /n/IWBEP/TRACES SAP Backend Tracing Tools
    2. Transaction /n/IWFND/TRACES SAP Gateway: Tracing Tools
    3. Click the "add user" button.
    4. Add the user which is used in the data import connection[SAP BPC type] in SAC. 
      1.  
      2. Change Error Log Level to “Full” and tick the option “Payload Trace”.
      3. IWFND_TRACES.PNG
      4. With the trace enabled, the user can see the http communication details in the "Payload Trace" tab once the SAC user triggers any export or import jobs in SAC.
      5. Note that: the tracing time is valid for 2 hours only.

  17. To submit a BPC/SAC issue, please provide with following information: 
    1. BPC Side
      1. BPC system ID
      2. BPC Environment/Model ID
      3. A BPC user in the backend system to view the trace and system logs
      4. Open R/3 connection and maintain logon data
         
    2. SAC Side: 
      1. SAC Tenant Link
      2. SAC Model Link
      3. SAC Export/Import Job Name/ID
      4. The BPC user used in SAC connection [need this BPC user ID to enable the trace log in the BW/BPC system]
      5. Share the BPC connection to SAC support user
      6. Make sure SAC support user has the authorization to run Export/Import job
      7. Screen shots or Information of Error log/User ID/Date.Time of the error
         
    3. Select component:
      1. [Main] SAC Component: LOD-ANA-PL-PLI 
      2. BPC Components:
        1. BPC standard model: EPM-BPC-NW  
        2. BPC embedded model: BW-PLA-BPC
        3. BPC4HANA: EPM-BPC-BW4
      3. Gateway: OPU-GW-COR

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
  • 2540886 - How to export data from models in SAP Analytics Cloud?
  • 3220729 - Checkpoints: Import and Export Job for SAC model via OData Services

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, Writeback, OData, RSBPC, SBGRFCMON,gateway, gateway client, RSPM_MONITOR, Error obtaining concurrency lock, export, import, bpc, sac, PLANDATA_WRITEBACK; HTTP 400 EPM_SERVICE, HTTP 204, PLUGIN_EXECUTION_ERROR, SAC_EXPORT_TASKS, EPM_SERVICE, IWFND, IWFND , KBA , bpc import job failing in sac bpc import , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , EPM-BPC-NW , NetWeaver Version , BW-PLA-BPC , BPC 'embedded model' , OPU-GW-COR , Framework , Problem

Product

SAP Analytics Cloud 1.0