SAP Knowledge Base Article - Preview

2676005 - Queries with large result sets maybe very slow or hang - SAP Business Suite and BW ASE

Symptom

  • On SAP systems running on SAP ASE, queries involving large result sets may be very slow and may not complete.
  • On SAP BW systems, affected jobs are Infoprovider loads from DSOs or Infocubes
  • Required BW/ASE configuration is set per SAP Note 1680803
  • Required latest version of the BW Correction Collection note is implemented (see related SAP Basis Note numbers in the "See Also" section below)
  • The offending slow query has limited filter criteria but the entire table is scanned during query processing.
  • In the sp_sp/sp_showplan output for a running spid, the abstract plan shows the "group_hashing" criteria is being used
  • The showplan output indicates the following:

| |HASH VECTOR AGGREGATE Operator (VA = 5)
| | GROUP BY
| | Evaluate Grouped SUM OR AVERAGE AGGREGATE.
| | Using Worktable2 for internal storage.
| | Key Count: 10
| |


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Warehouse
  • SAP NetWeaver (all releases)

Product

SAP Supply Chain Management 7.0

Keywords

group_hashing, group hashing , DSO, Infoprovider, "Data Load", slow, hang, 811933, CR 811933 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.