Symptom
You are running Solution Manager 7.1 on the SAP ASE database. You have ATM set up for updating statistics on the Solution Manager Extractor Framework (EFWK) tables on a regular basis.
Despite ATM setup, you find Early Watch Alert (EWA) reports to run very slow from time to time.
In SM50, you notice long-running sequential reads on the F-fact tables belonging to the following EFWK Infocubes:
- 0SMD_PEH1
- 0SMD_PEH2
- 0SMD_PED2
- 0CCMAWDH2
- 0CCMAWDH1
- 0CCMAWDD1
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Business Warehouse - All versions
- SAP Solution Manager (SOLMAN) 7.1, 7.2
Product
Keywords
EWA, infocubes, reads, refresh, statistics, sampling, RSSYBREFRESHINFOCUBESTATISTICS, EFWK, , 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.