SAP Knowledge Base Article - Public

1724708 - java.lang.nullpointer exception received in Xcelsius using QAAWS.

Symptom

  • Data is not getting retrieved in Xcelsius using QAAWS.
  • java.lang.nullpointer exception is received in Xcelsius.

Environment

Xcelsius 2008.

Reproducing the Issue

  1. Create a query in QAAWS (New > Query).
  2. Publish the query and copy to clipboard.
  3. Launch Xcelsius and add a new QAAWS connection in Data Manager.
  4. Import the query in QAAWS.
  5. Set the refresh option for QAAWS to 'Refresh Before Components are loaded'.
  6. Map all the rows with the cells in Excel sheet.
  7. Preview the dashboard.

Cause

This issue occurs when QAAWS tries to get huge amount of data.

Resolution

  1. Launch Tomcat Configuration
  2. Switch to Java tab.
  3. Increase the heap size under Maximum memory pool (for example if it is 256 make it double as per requirement).

Keywords

Exception,java,Xcelsius. , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008