error "DBIF_RSQL_SQL_ERROR"

[Former Member]

Hi,

Please help me on this following abab runtime error.

"DBIF_RSQL_SQL_ERROR"

Error Details:

Category               Installation Errors                                                         
Runtime Errors         DBIF_RSQL_SQL_ERROR                                                         
Except.                CX_SY_OPEN_SQL_DB        

Short text                                                                                                SQL error 1205 when accessing table "TRFCQOUT".   

What happened?                                                                                            Error Text of the Database: "[Microsoft][SQL Server Native Client 11.0][SQL                           Server]Transaction (Process ID 56) was deadlocked on lock resources with                             another process and has been chosen as the deadlock victim. Rerun the                                transaction."           

What can you do?                                                                                          Note which actions and input led to the error.                                                                                                                                                              For further help in handling the problem, contact your SAP administrator                              .                                                                                                                                                                                                           You can use the ABAP dump analysis transaction ST22 to view and manage                                termination messages, in particular for long term reference.                                                                                                                                                Note which actions and input led to the error.                                                                                                                                                              For further help in handling the problem, contact your SAP administrator                              .                                                                                                                                                                                                           You can use the ABAP dump analysis transaction ST22 to view and manage                                termination messages, in particular for long term reference.  

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 "HANDLE_QUEUES" "(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:                                                                      Error Text of the Database: "[Microsoft][SQL Server Native Client 11.0][SQL                           Server]Transaction (Process ID 56) was deadlocked on lock resources with                             another process and has been chosen as the deadlock victim. Rerun the                                transaction."     

System environment                                                                                        SAP Release..... 702                                                                                  SAP Basis Level. 0011                                                                                                                                                                                       Application server... "GVAR3X04"                                                                      Network address...... "10.69.48.9"                                                                    Operating system..... "Windows NT"                                                                    Release.............. "6.1"                                                                           Hardware type........ "24x AMD64 Level"                                                               Character length.... 16 Bits                                                                          Pointer length....... 64 Bits                                                                         Work process number.. 6                                                                               Shortdump setting.... "full"                                                                                                                                                                                Database server... "GVAR3X04\SB2"                                                                     Database type..... "MSSQL"                                                                            Database name..... "SB2"                                                                              Database user ID.. "sb2"                                                                                                                                                                                    Terminal.......... " "                                                                                                                                                                                      Char.set.... "C"                                                                                                                                                                                            SAP kernel....... 720                                                                                 created (date)... "Feb 20 2012 19:16:38"                                                              create on........ "NT 5.2 3790 S x86 MS VC++ 14.00"                                                   Database version. "SQL_Server_9.00 "                                                                                                                                                                        Patch level. 200                                                                                      Patch text.. " "                                                                                                                                                                                            Database............. "MSSQL 9.00.2047 or higher"                                                     SAP database version. 720                                                                             Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows                        NT 6.0, Windows NT 6.1, Windows NT 6.2"                                                                                                                                                                    Memory consumption                                                                                    Roll.... 0                                                                                            EM...... 4189792                                                                                      Heap.... 0                                                                                            Page.... 0                                                                                            MM Used. 1083696                                                                                      MM Free. 3103424               

Thanks in advance

Srikanth

[ashish_vikas · Accepted solution]

Check if this is applicable to you..

Note 1606565 - Deadlock:DBIF_RSQL_SQL_ERROR on table trfcqout or arfcsstate

Regards

Ashish