Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

0EC_PCA_3 : Short Dump

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question