DBIF_RSQL_SQL_ERROR while activating data in ODS

[Former Member]

Hi,

I'm getting the following error when I try to activate the data in ODS. This is happening for all the ODSs in the system.

SQL-ERROR: 603 ORA-00603: ORACLE server session terminated by fat al error

System error: RSDU_ANALYZE_TABLE_ORA/ ORACLE

ABAP/4 processor: DBIF_RSQL_SQL_ERROR

Job cancelled

Any suggestion is greatly appreciated.

Thanks,

Vish

[edwin_harpino]

hi,

if not help, 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".

769416

[Former Member]

Visu

One of the reason to get "DBIF_RSQL_SQL_ERROR

this error is table space. Ask DBA to increase table space. Most cases Increase table space will resolve this issue after doing this if still you have the same issue contact Basis people.

Thnaks

sat