SAP Knowledge Base Article - Preview

2626359 - Solution Manager system grows large and E2E housekeeping does not work or is slow - SAP ASE

Symptom


Any one or all of the following problems are observed on Solution Manager system running on SAP ASE database:

  • Unprecedented growth is seen on the Solution Manager' SID database

  • Tables grow very large and the system runs out of space frequently

  • TIME_OUT dumps and disconnects during runtime, are frequent

  • E2E Housekeeping jobs, compression jobs, UPDATE STATISTICS jobs do not run at all or are very slow 
  • Selective deletion, maintenance of aggregates jobs are also slow

  • stacktrace errors are seen in the ASE errorlog referencing the function: LePtnScanOp::_LapoSetupAPScan()


Following conditions are met:

  • 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

  • Per RSSYBPARTMON / SAP_BWTOOLPGM_SYB reports collected via t-code SE38: there are several cubes with more than 1000 partitions.


Read more...

Environment

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

Product

SAP Solution Manager 7.2

Keywords

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", SQL702,  large, growing, Housekeeping, "E2E Housekeeping", "running out of space", growth , 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.