DBIF_RSQL_INVALID_RSQL
Hi All,
We are getting below mentioned runtime error while executing some tcodes. Also we could find sm21 dump as Database error -901 at INS access to table ARFCSDATA> SQL system error. MSGID= Job=037811/DEV05/WP01. Earlier we had some issue with workprocess going onto private mode we resolved it by increasing parameter em/initial_size_MB. We are using kernel release 701 pacakage level 66. Please advice
Runtime Errors DBIF_RSQL_SQL_ERROR
Exception CX_SY_OPEN_SQL_DB
Date and Time 27.07.2010 10:23:18
Short text
SQL error in the database when accessing a table.
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.
How to correct the error
Database error text........: "SQL system error. MSGID= Job=037400/DEV05/WP01"
Internal call code.........: "[RSQL/INSR/ARFCSDATA ]"
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_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"
"SAPLARFC" or "LARFCU03"
"END_TRANSACTION_NONE_LOCAL_UPD"
If you cannot solve the problem yourself and want to send an error
notification to SAP, include the following information:
1. The description of the current problem (short dump)
To save the description, choose "System->List->Save->Local File
(Unconverted)".
2. Corresponding system log
Display the system log by calling transaction SM21.
Restrict the time interval to 10 minutes before and five minutes
after the short dump. Then choose "System->List->Save->Local File
(Unconverted)".
3. If the problem occurs in a problem of your own or a modified SAP
program: The source code of the program
In the editor, choose "Utilities->More
Utilities->Upload/Download->Download".
4. Details about the conditions under which the error occurred or which
actions and input led to the error.
The exception must either be prevented, caught within proedure
"END_TRANSACTION_NONE_LOCAL_UPD" "(FORM)", or its possible occurrence must be
declared in the
RAISING clause of the procedure.
To prevent the exception, note the following:
System environment
SAP-Release 701
Application server... "SYSDEV"
Network address...... " "
Operating system..... "OS400"
Release.............. "6.1"
Hardware type........ "00060004BD15"
Character length.... 16 Bits
Pointer length....... 64 Bits
Work process number.. 1
Shortdump setting.... "full"
Database server... "SYSDEV"
Database type..... "DB400"
Database name..... "DEV"
Database user ID.. "R3DEVDATA"
Terminal.......... "sap-dsds"
Char.set.... "C"
SAP kernel....... 701
created (date)... "Oct 25 2009 21:54:57"
create on........ "AIX 2 5 00CB5A5B4C00 (IBM iSeries with OS400)"
Database version. "DB4_53"
Patch level. 66
Patch text.. " "
Database............. "V5R3, V5R4, V6R1"
SAP database version. 701
Operating system..... "OS400 3 5, OS400 4 5, OS400 1 6"
Memory consumption
Roll.... 16192
EM...... 12569544
Heap.... 0
Page.... 40960
MM Used. 5998912
MM Free. 2377984
User and Transaction
Client.............. 300
User................ "OCCADMIN"
Language key........ "E"
Transaction......... "PFCG "
Transactions ID..... "4C4E7BD97AA300D4E1008000C0050208"
Program............. "SAPLARFC"
Screen.............. "SAPLPRGN_TREE 0321"
Screen line......... 5
Information on where terminated
Termination occurred in the ABAP program "SAPLARFC" - in
"END_TRANSACTION_NONE_LOCAL_UPD".
The main program was "SAPLPRGN_TREE ".
In the source code you have the termination point in line 389
of the (Include) program "LARFCU03".
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "END_TRANSACTION_NONE_LOCAL_UPD" "(FORM)", but it was neither handled
locally nor declared
in the RAISING clause of its signature.
The procedure is in program "SAPLARFC "; its source code begins in line
40 of the (Include program "LARFCU03 ".
Source Code Extract
Line SourceCde
359 * Wenn keine Outbound tRFC/qRFC mehr vorhanden.
360 IF sendstate[] IS INITIAL.
361 PERFORM database_commit.
362
363 PERFORM trfc_dequeue_all.
364
365 * ARFC_END_VB muss getriggert werden um die gesperrten BGRFCs
366 * nach der Verbuchung wieder frei zu schalten.
367 IF kanal = verbucher AND vb_called = space AND bgrfc_active <> space.
368 vb_called = 'X'.
369 CALL FUNCTION 'ARFC_END_VB' IN UPDATE TASK
370 EXPORTING
371 vbkey = vbkey.
372 ENDIF.
373
374 IF write_qin <> space.
375 READ TABLE qin_qname INDEX 1.
376 IF qin_qname-qstate <> qs_noexec.
377 CALL FUNCTION 'QIWK_SCHEDULER_ACTIVATE_GROUP'
378 TABLES
379 name_queue = qin_qname.
380 ENDIF.
381 write_qin = space.
382 REFRESH qin_qname.
383 ENDIF.
384 ENDIF.
385
386 * Wenn noch tRFC/qRFC vorhanden.
387 IF sendstate[] IS NOT INITIAL.
388 * Wenn tRFC/qRFC-Daten vorhanden sind diese in DB schreiben
>>> INSERT arfcsdata FROM TABLE senddata.
390 IF sy-dbcnt = 0.
391 MESSAGE a502(sy).
392 ENDIF.
393
394 INSERT arfcsstate FROM TABLE sendstate.
395 IF sy-dbcnt = 0.
396 MESSAGE a502(sy).
397 ENDIF.
398
399 * Referenz-TIDs für Receiver List
400 IF sqreftid[] IS NOT INITIAL.
401 INSERT qreftid FROM TABLE sqreftid.
402 IF sy-dbcnt = 0.
403 MESSAGE a502(sy).
404 ENDIF.
405 ENDIF.
406
407 * Queue-Daten abstellen
408 IF loc_queue[] IS NOT INITIAL.