cancel
Showing results for 
Search instead for 
Did you mean: 

0EC_PCA_3 : Short Dump

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Shreya,

Thanks for your information ,

My short dump happened in sourcesystem anot in BW , your oss notes suggests for dummps in BW,

Can you help

Raky

Former Member
0 Kudos

Shreya,

Thanks for your very good information , Now i am able to move forward

Thank u v much,

raky

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello SAT,

Thanks but we have several loads runnig good for the fetching same number of records,

Please let meknow if we have any OSS regarding shortdump on the particalar datasource for shortdump

Thanks,

raky