SAP Knowledge Base Article - Preview

2626359 - Solution Manager Infocube maintenance jobs are slow - SAP ASE for BW

Symptom

  • Selective deletion, maintenance of aggregates, E2E Housekeeping jobs, compression, UPDATE STATISTICS jobs are very slow on SAP Solution Manager running on SAP ASE database.
  • Sometimes, ASE Error 702 is received accompanied by a stacktrace in the ASE errorlog referencing the functions:

    Error: 702, Severity: 20, State: 1
    Memory request for 19020 bytes exceeds the size of single page of 16384 bytes.

    memalloc()
    LeAPScanContext::LeAPScanContext(LeAPScanOp*, LePlanFragContext*)
    LePtnScanContext::LePtnScanContext(LePtnScanOp*, LePlanFragContext*)
    LePtnScanOp::_LeOpAcquire(ExeCtxt&)
  • The latest version of the following notes, for the respective SAP Basis release is implemented:

    BW Correction Collection
    DBA Cockpit Correction Collection
    DDIC patch collection
    Solution Manager Technical Monitoring Patch Collection
  • The Infocubes are of different types - for eg: Extractor Framework, DVM, UPL, CCM

  • Specific example Infocubes include: 0SM_UPL, 0SMD_EAH2, 0SMD_CA02, 0SM_SIZES, 0SM_STAT

  • Per RSSYBPARTMON / SAP_BWTOOLPGM_SYB reports collected via t-code SE38: there are several hyper-partitioned cubes on the system. That is, cubes containing more than 1000 partitions

Note: For Error 702 encountered on SAP BW systems during migration, see:
SUM DMO - SAP KBA 2624531
Migration Import/R3load - SAP KBA 2097527


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.1 / 7.2

Product

SAP Solution Manager 7.2

Keywords

702, memory, partitions, Infocube, "Solution Manager", "/BI0/F0SM_UPL", 0SM_UPL, 0SM_STAT, 0SM_SIZES, DVM, EFWK, compression, compressed, E2E_HK_CONTROLLER, "E2E BI HOUSEKEEPING", CR 769607, hyper-partitioned, "update statistics" , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.