Translate

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
SAP_BW
310
SAP_BW
350
SAP_BW_VIRTUAL_COMP
30B
Corrections Instructions
Correction
Instruction
Valid
from
Valid
to
Software
Component
Last
Modifcation
30B
30B
SAP_BW_VIRTUAL_COMP
09.11.2004  15:14:52
310
310
SAP_BW
09.11.2004  15:14:52
30B
30B
SAP_BW
09.11.2004  15:14:52
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)

No comments:

Labels

sap hana hana database aws s4 hana hana db s4hana conversion steps sap hana azure bw4hana hana migration s4hana migration sap cloud migration steps sap hana migration steps sap hana migration to azure s4hana sap fiori fiori performance fiori erp s4 hana fiori sap fiori app sap fiori client sap fiori launchpad sap s4 hana fiori cisco ecc AI SAP AI abap dumps hana sap S/4HANA S/4HANA Conversion best sap ui5 & fiori training configuration database fiori tutorial on webide free sap ui5 & fiori training s/4 hana sap dumps sap fiori tutorial sap ui5 sap ui5 & fiori sap ui5 & fiori tutorial sara ui5cn 2367245 - Troubleshooting performance issues with SAP BPA Amazon free tier for SAP AWS setup Experience CALL_FUNCTION_NOT_FOUND CCMS Configuration and Use Create New Data Class in SAP (Oracle) Critical top SAP Abap dumps DHCP Clients Not Receiving IP Addresses Download Stack.xml HAN-DB HAN-DB-ENG High CPU Usage Due to Excessive Process Switching How To How to Start and Stop SAP Hana Tenant Database How to change SAP Hana Sql Output results are limited to 5000 Records How to perform SAP Dual Stack Split - Netweaver Inactive Objects in SAP Intercompany transactions in SAP AP / AR : Cross Company Code Transaction Interface Flapping Due to Duplex Mismatch KBA LOAD_PROGRAM_LOST MSSQL shrinking transaction log file Migrating to SAP hana database NAT Overload Causing Internet Access Failure Note 500235 - Network Diagnosis with NIPING OSPF Adjacency Not Forming PRINCE2 Foundation Sample Questions Preparing for S/4HANA Conversion and the MUST know items Push to Download Basket S/4HANA Migration Cockpit S/4JANA SAP BI Support Data Load Errors and Solutions SAP BI/BW Landscape SAP BPA SAP Basis SAP Basis Automation SAP Business Objects SAP CPS SAP Certification SAP FI Certification SAP FI Certification Sample Questions SAP HANA Admin - Cockpit SAP HANA DB Engines SAP HANA Database SAP HANA terminate session connection disconnect cancel kill hang stuck SAP Hana DB restore SAP Hana Numeric Error Codes SAP Landscape SAP Language installation SAP MM and Purchase Order Tables SAP Maintenance Planner SAP Note 500235 SAP R/3 Glossary SAP Readiness Check SAP S/4HANA 1709 Installation Files SAP S/4HANA 2023 SAP S/4HANA 2023 Installation SAP S/4HANA 2023 running SAP S/4HANA Installation SAP Scheduling SAP Solman 7.2 CHARM: SAP Support Package Stack Strategy SAP Support package SAP Upgrade SAP support stack upgrade SP stacks STORAGE_PARAMETERS_WRONG_SET SUSE/SLES/Kernel versions Setup of S/4hana 2023 TSV_TNEW_PAGE_ALLOC_FAILED TSV_TNEW_PAGE_ALLOC_FAILED error Transaction ID Unable to download an SAP Note Unix/Linux Command That Are Helpful For SAP Basis Upgrading SAP Kernel Without Downtime Upgrading windows server 2008 to windows server 2019 What is OSS Notes? SAP SNOTE Tutorial accounting agile ale idoc ale/edi archive FI documents audit auditing auditor aws aws cloud basic type bluefield approach ccms ccmsidb charm copilot datavard dbacockpit download sap note download snote edi idoc electronic data interchange enable sap archiving objects erpprep ffid firefighter fraud functional hana admin how to apply sap security note https://www.erpprep.com/ idoc install install sap fiori installation interfaces intermediate document internal control license key linux version materials management messsage niping test order type port prince2 agile prince2 agile practitioner purchasing quick info s4 hana sap abap dumps sap abbreviations sap activate certification sap activate project manager sap authorization sap aws sap brownfield sap ccms sap ccms configuration sap erp sap error sap grc sap greenfield sap internet demo system sap license sap maintenance certificate sap material management sap meaning sap mm sap mm consultant sap monthly security note sap netweaver sap network diagnostic sap niping sap note sap oss sap patch day sap performance sap performance issue sap purchase order sap s/4hana sap sales and distribution sap sap otc sap sd sap sd certification training sap sd course sap sd jobs sap sd module sap sd online training sap sd training sap sd tutorial sap sd tutorial for beginners sap security sap security note sap snote sap snote tutorial sap solution manager sap sql segregation of duties separation of duties sles slicense smc snote snote in sap system sod conflict solution manager solution maneger stop start hana database suse linux techie trex two step upgrade required waterfall