on 05-11-2006 2:38 PM
Hello frnds,
We are facing Critical Dataloading issue with datasource 0EC_PCA_3, This takes a lot hours to load and goes to short dump saying
ABAP Processor : DBIF_RSQL_SQL_ERROR ,
Can anyone help suggesting some OSS Notes for this issue,
We have couple of OSS , I am trying to find some OSS specifically for Short Dump,
Any help is highly appreciated,
Thanks for your help
Raky
Hi,
This DBIF_RSQL_SQL_ERROR comes due to lack of table space .. If you package didn't finish yet, please execute ST22 and SM21 and look for errors and dumps.
U can catch the error in ur program. this error occurs whenever database access exceeds some limit & the error is fired.
This should point you to the DB issue... frequently a table space issue.
Also take a look on the note :590370
check oss note
840552
Symptom
On BW tables that belong to an InfoCube, statistics are calculated (COMPUTE) instead of estimated with the set percentage (ESTIMATE). This results in high runtimes.
Other terms
InfoCube, database, Oracle statistics
Reason and Prerequisites
In the Oracle-specific RSDU_ANALYZE_TABLE_ORA BW function, in some situations an estimation is made as to how many records are in the table to be analyzed. A SELECT in the USER_TABLES table is specifically used for this. If there is no value there now, 0 is returned and a COMPUTE is carried out. COMPUTE is considerably fasterer than ESTIMATE on small tables (under 10000 approximately).
However, if the table is too big and if the statistics were deleted by a brconnect run that ran shortly beforehand, the above situation of long runtimes mentioned above can occur.
Solution
BW 3.0B
Import Support Package 27 or 3.0B (BW3.0B Patch 27 or SAPKW30B27) into your BW system. The Support Package will become available oncenote 723258 with the short text, "SAPBWNews BW3.0B Support Package 27", which describes this Support Package in more detail, is released for customers.
BW 3.10 Content
Import Support Package 21 for 3.10 (BW3.10 Patch 21 or SAPKW31021 ) into your BW system. The Support Package will become available once <Z1>note 723263 with the short text, "SAPBWNews BW3.1 Content SP 21", which describes this Support Package in more detail, is released for customers.
BW 3.50
Import Support Package 13 for 3.5 (BW3.50 Patch 13 or SAPKW35013) into your BW system. The Support Package will become available oncenote 783254 with the short text, "SAPBWNews BW SP12 NetWeaver'04 Stack 13", which describes this 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 may already be made available before the Support Packages are released. However, the short text in this case will still contain the words "Preliminary version".
-Shreya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rakesh
One of the reason to get this error is memory issues so talk to your Basis team and they suggest some solutions regarding memory. Also check in ST22 for more details of the error.
Thnaks
Sat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.