SAP Knowledge Base Article - Preview

2141196 - Common performance issues occurring while executing Queries and Web Templates in Java Web


  • Symptom 1: Query is taking a long time to execute.
  • Symptom 2: You are using replacement path variable and the query is taking long time to execute.
  • Symptom 3: Templates containing charts takes a long time to execute or while displaying query as a chart in Java BEx it takes a long time to execute
  • Symptom 4: You are using BI application with a BI Consumer Services (BICS) connection to database and if you are using large amount of data in result set and doing zero suppression for hiding rows and columns containing value zero.
  • Symptom 5: You are using query or Web Templates which create a large number of user messages (information, warnings, etc.). With increasing number of messages the system performance reduces.
  • Symptom 6: You are executing Web Template with ODOC functionality and performance is slow.
  • Symptom 7: Performance is slow when executing SQL triggered from BICS_PROV_GET_MEMBERS
  • Symptom 8: During execution of Query or Web Template you notice that more time is spent of member calls which results in slow performance.

    "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • SAP Business Warehouse 7.00
  • SAP Business Warehouse 7.01
  • SAP Business Warehouse 7.02
  • SAP Business Warehouse 7.30
  • SAP Business Warehouse 7.31
  • SAP Business Warehouse 7.40


SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0


Performance, Web Templates, Query, Read Mode,replacement path, variable, pre-query, Java Web, RSRT, regenerate query, metadata, IGS, zero suppression, ODOC functionality, BICS, BICS_PROV_GET_MEMBERS, user messages, information, warnings, charts, optimizations , KBA , BW-BEX-ET-WJR , BEx Web Java Runtime , 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.