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.