You are running BW applications on SAP ASE.
The SCM Infocube Realignment process chain is running very slow. ST05 trace shows the offending SQL-statements to be long-running on the Infocube's F-fact tables.
Therefore you choose to check the statistics for the F-fact table via RSA1:
- > The cube statistics shows a yellow or red traffic light in transaction RSA1-> InfoCube Manage -> Performance tab
- > A refresh of the statistics via RSA1 does not work. The statistics check remains yellow.
The transaction RSRV->"All Elementary Tests" --> "Database" also shows red lights for the "Database statistics" and "Database Indices" profiles for this Infocube.
- SAP Adaptive Server Enterprise 22.214.171.124 or higher
- ODBC = 126.96.36.1994
- SAP Kernel release = 741_REL, PL = 26
- DBSL patch level = 013
- SAP_BASIS = 740-0006
- SAP_BW = 740-0006
SCM, Infocube, process chain, slow, statistics, indexes , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.