1500+ locks, 3000 + "DBIF_RSQL_SQL_ERROR" dumps and " ORA-01403: no data fo

[Former Member]

Hi Guru's,

We recently faced a issue with our production system. It started off with with us getting dumps on one of the app server "IND0D" constantly. Along with that the locks on SM21 was increasing constantly. In a few hours time there were about 3000 + "DBIF_RSQL_SQL_ERROR" dumps

and over 1500+ locks.

The below log was continously repeating on the app server on which it was dumping.

Run-time error "DBIF_RSQL_SQL_ERROR" occurred

> Short dump "080702 030754 IND0D_PP1_60 " generated

Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR 20080702030754IND0D_PP1_60 PRBATCH 010 )

Database error -2 at PRE access to table VBERROR

> ORA-01403: no data found

DB function INSERT failed, return code 000001

> Table: VBERROR

Update terminated

> Update key: 486A533D682D006DE10080000AA00D05

Database error -2 at PRE access to table T100

> ORA-01403: no data found

Database error -2 at PRE access to table T100

We eventually bounced the app server and the dumps stopped coming. But we are still to find out what caused the problem in the first place.

Any one who can give their feedback by looking at the log or if they have faced a similar problem. please let me know. Also I can provide more info if required.

Useful answers will be rewarded.

[Former Member]

Hi,

ORA-01403 no data found can cause due to :-

Apllication server tried one of the following:

You executed a SELECT INTO statement and no rows were returned.

You referenced an uninitialized row in a table (T100).

You read past the end of file with the UTL_FILE package.

Resolution for this oracle error is to terminate the processing of the data.

Regarding Table T100 :-

-

---

You send messages in the logon language of the current user using the ABAP statement MESSAGE. The statement specifies the message class, number, and type of the message.

The message class and number are used to identify the message in table T100. The message type is one of A, E, I, S, W, or X, and defines how the ABAP runtime should process the message.

I hope this message will help you in assesing what happened.

Rgds

Radhakrishna D S