Note 790223 - DBIF_RSQL_INVALID_RSQL when filling aggregates

Summary

Symptom

The system issues a DBIF_RSQL_INVALID_RSQL error message while you are filling aggregates. The error occurs in the CUBESTATISTIC_GET_2 subroutine of the RSDDK2 function group.

Other terms

Aggregate, request, fill, change run, STATEMENT_TOO_LARGE

Reason and Prerequisites

This is a program error in the RSDDK2 function group.
The error occurs when an InfoCube is not compressed while it contains a large number of requests. Since the requests are all listed in one SELECT statement, this scenario may lead to an overlarge SQL statement.

Solution

Consider to compress the requests. Otherwise, performance problems may alos occur. (Refer to note 590370 for more information.)

• BW 3.0B

           Import Support Package 25 for BW 3.0B (BW3.0B Support Package 25 or SAPKW30B25) into your BW system. The Support Package will be available once note 0723254 with the short text, "SAPBWNews BW3.0B Support Package 25", which describes the Support Package in more detail, is released for customers.

• BW 3.10 Content

           Import Support Package 19 for BW 3.10 (BW3.10 Support Package 19 or SAPKW31019) into your BW system. The Support Package will be available once note 0723261 with the short text, "SAPBWNews BW 3.1 Content Support Package 19", which describes the Support Package in more detail, is released for customers.

• BW 3.50

           Import Support Package 10 for BW 3.5 (BW3.50 Support Package 10 or SAPKW35010) into your BW system. The Support Package will be available once note 0763336 with the short text, "SAPBWNews BW Support Package 10 NetWeaver'04 Stack 10", which describes the Support Package in more detail, is released for customers.

In urgent cases, you can use the correction instructions.
To provide information in advance, the notes mentioned above may already be available before the Support Packages are released. In this case, the short text will contain the words Preliminary version".

Header Data

Release Status:	Released for Customer
Released on:	10.11.2004  13:09:12
Master Language:	German
Priority:	Correction with medium priority
Category:	Program error
Primary Component:	BW-BEX-OT-AGGR Aggregates (Definition and Filling)
Secondary Components:	BW-BEX-OT OLAP Technology

Affected Releases

Software Component Release From Release To Release And subsequent SAP_BW 30 30B 30B   SAP_BW 310 310 310   SAP_BW 35 350 350   SAP_BW_VIRTUAL_COMP 30 350 30B 30B

Correction delivered in Support Package

Support Packages Release Package Name SAP_BW 30B SAPKW30B25 SAP_BW 310 SAPKW31019 SAP_BW 350 SAPKW35011 SAP_BW_VIRTUAL_COMP 30B SAPK-30B30INVCBWTECH

Corrections Instructions

Correction Instruction Valid from Valid to Software Component Last Modifcation 685857 30B 30B SAP_BW_VIRTUAL_COMP 09.11.2004  15:14:52 685857 310 310 SAP_BW 09.11.2004  15:14:52 685857 30B 30B SAP_BW 09.11.2004  15:14:52 685857 350 350 SAP_BW 09.11.2004  15:14:52

Related Notes

	763336 - SAPBWNews BW Support Package 10 NW '04 Stack 10 RIN
	723261 - SAPBWNews BW 3.1 Content Support Package 19
	723254 - SAPBWNews BW 3.0B Support Package 25
	590370 - Too many uncompressed request (f table partitions)