topic Re: Runtime Errors DBIF_RTAB_SQL_ERROR in Application Development and Automation Discussions

Runtime Errors DBIF_RTAB_SQL_ERROR

Former Member — Fri, 31 Oct 2008 11:12:20 GMT

Hi All,

Our user is geiing short dump while saving Sales Order through VA01/VA02.

The short dump says ' SQL error occurred in the database when accessing a table.'

Database error text........: "SQL0911N The current transaction has been rolled

back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1"

Internal call code.........: "[RTAB/INS /VBDATA ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RTAB_SQL_ERROR" " "

"SAPLSTXD" or "LSTXDU06"

"COMMIT_TEXT"

Can anyone help on this?

Thx in advance.

Avishek

Re: Runtime Errors DBIF_RTAB_SQL_ERROR

Former Member — Fri, 31 Oct 2008 11:14:46 GMT

Hi,

Have you activated any user-exit, or enhancement, where you are performing some kind of database updation. Since this error occurs when there is any problem with datanase operation. Please check. Also try to check values you are giving in VA01/VA02.

Thanks & Regards,

Navneeth K.

Re: Runtime Errors DBIF_RTAB_SQL_ERROR

Former Member — Fri, 31 Oct 2008 11:18:49 GMT

Thx for the reply,but this is nothing like that.

I hope this is very much related with basis.Related to table space.

Can someone tell me from short dump how to find the Table Name where the Tablespace is less.

Regards,

Avishek.

Re: Runtime Errors DBIF_RTAB_SQL_ERROR

Former Member — Fri, 31 Oct 2008 11:20:14 GMT

Check transaction Se14, it tells about table space and indexes.

Sometimes when the load is higher and many so being created/changed, this dump may come. So try to create again after some time, If same thing persists search for sap notes.

Edited by: Navneeth Bothra on Oct 31, 2008 12:20 PM