SAP Knowledge Base Article - Preview

2182391 - SCM Infocube Realignment process chain running slow on SAP ASE due to incorrect statistics and indexes - SAP BW

Symptom

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.


Read more...

Environment

  • SAP Adaptive Server Enterprise  15.7.0.132 or higher
  • ODBC = 15.7.0.1314
  • SAP Kernel release = 741_REL, PL = 26
  • DBSL patch level = 013
  • SAP_BASIS = 740-0006
  • SAP_BW = 740-0006

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Supply Chain Management 7.0

Keywords

SCM, Infocube, process chain, slow, statistics, indexes , 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 ONE Support launchpad (Login required).

Search for additional results

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