short dump DBIF_RSQL_SQL_ERROR

[Former Member]

Hi,

In BW 7.0 system there is a short dump DBIF_RSQL_SQL_ERROR with the user ALEREMOTE when loading the data.

Please advice.

Thanks,

Rajiv

[Former Member]

Thanks guys..I will try it...

Rajiv

[debasissahoo]

Hi Rajiv,

Check these threads, this might help.

Thanks,

Debasis.

[Former Member]

Hi,

Check out the sql statement of the particular dump of respective user.

there is corruption in an index or an data file, verify the database tables and index with cascade

Usuall this dump occurs when ever a user try to get data or read data from the table.

Correct me if i am wrong

regards

Suresh

[debasissahoo]

Hi Rajiv,

Please have a look at these notes, if this matches your situation.

Note - 631668

Note - 634458

Thanks,

Debasis.

[Former Member]

Here is the error analysis

The error is occuring from yesterday.

Error analysis:

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "WRITE_ICFACT" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

The database system recognized that your last operation on the database

would have led to a deadlock.

Therefore, your transaction was rolled back

to avoid this.

ORACLE always terminates any transaction that would result in deadlock.

The other transactions involved in this potential deadlock

are not affected by the termination.

Regards,

Rajiv

[Former Member]

Hi,

Did you have performed some database related activities? like upgrade the database or applied any database patch ?

Thanks,

Satyabrat

[Former Member]

Hi,

Since when you are getting the error?

Thanks,

Satyabrat

[Former Member]

Hi,

This is not sufficient to provide any recommendations. Do post the full dump.

[martin_juen2]

have look at st22 in bi and source system and analyze the problem.

there are hundreds of reasons for this short dump...

regards,

martin