Hi Gurus !
i m getting this dump .
Runtime Error DBIF_RSQL_SQL_ERROR
Occurred on 09.01.2008 at 10:59:31
Since the caller of the procedure could not have expected this exception
to occur, the running program was terminated.
The reason for the exception is:
How to correct the error
The exception must either be prevented, caught within the procedure
"(FORM)", or declared in the procedure's RAISING clause.
To prevent the exception, note the following:
Database error text........: "ORA-01555: snapshot too old: rollback segment
number 13 with name "PRS_11" too small"
Internal call code.........: "[RSQL/FTCH/VBAK ]"
Please check the entries in the system log (Transaction SM21).
You may able to find an interim solution to the problem
in the SAP note system. If you have access to the note system yourself,
use the following search criteria:
"ZVR04_PEND_SALES " or "ZVR04_PEND_SALES "
If you cannot solve the problem yourself, please send the
following documents to SAP:
1. A hard copy print describing the problem.
To obtain this, select the "Print" function on the current screen.
2. A suitable hardcopy prinout of the system log.
To obtain this, call the system log with Transaction SM21
and select the "Print" function to print out the relevant
3. If the programs are your own programs or modified SAP programs,
supply the source code.
To do this, you can either use the "PRINT" command in the editor or
print the programs using the report RSINCL00.
4. Details regarding the conditions under which the error occurred
or which actions and input led to the error.
SAP Release.............. "620"
Information on where terminated
The termination occurred in the ABAP program "ZVR04_PEND_SALES " in
The main program was "ZVR04_PEND_SALES ".
The termination occurred in line 661 of the source code of the (Include)
program "ZVR04_PEND_SALES "
of the source code of program "ZVR04_PEND_SALES " (when calling the editor
The program "ZVR04_PEND_SALES " was started as a background job.
Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "OPNSELDATA" "(FORM)" but was not handled locally, not declared in
RAISING clause of the procedure.
The procedure is in the program "ZVR04_PEND_SALES ". Its source code starts in
of the (Include) program "ZVR04_PEND_SALES ".
Source code extract
006310 IT_ITAB-BQTY = IT_ITAB-KWMENG - IT_ITAB-OLFIMG - IT_ITAB-DTLFIMG.
006340 IF IT_ITAB-VKORG = 'IC00'.
006350 IF IT_ITAB-VBELN NE ' '.
006360 IF IT_ITAB-OLFIMG GT 0 OR IT_ITAB-BQTY GT 5 .
006370 APPEND IT_ITAB.
006380 CLEAR IT_ITAB.
006420 IF IT_ITAB-VBELN NE ' '.
006430 IF IT_ITAB-OLFIMG GT 0 OR IT_ITAB-BQTY GT 0 .
006440 APPEND IT_ITAB.
006450 CLEAR IT_ITAB.
006510 SORT IT_ITAB BY VBELN.
006520 ENDFORM. "BLKSELDATA
006540 *& *
006550 *& Form OPNSELDATA
006560 *& *
006570 * text
006580 * *
006590 FORM OPNSELDATA.
> SELECT AVBELN AERDAT AAUART AKNUMV AVKORG BMATNR BKWMENG BUMZI
006620 INTO (IT_ITAB-VBELN, IT_ITAB-ERDAT, IT_ITAB-AUART, IT_ITAB-KNUMV,
006630 IT_ITAB-VKORG, IT_ITAB-MATNR, IT_ITAB-KWMENG, IT_ITAB-UMZIZ, IT_
006640 FROM ( VBAK AS A INNER JOIN VBAP AS B
006650 ON AVBELN = BVBELN INNER JOIN VBUK AS C
006660 ON CVBELN = BVBELN )
006670 WHERE A~VKORG IN SO_VKORG
006680 AND A~VKBUR IN SO_VKBUR
006690 AND A~KUNNR IN SO_KUNNR
006700 AND A~ERDAT IN SO_ERDAT
006710 AND A~AUART IN SO_AUART
006720 AND A~VTWEG IN SO_VTWEG
006730 AND B~WERKS IN SO_WERKS
006740 AND B~MATNR IN SO_MATNR
006750 AND B~ABGRU = ' '
006760 AND C~FSSTK = ' '
006770 AND C~LSSTK = ' '
006780 AND C~SPSTG = ' '
006790 AND A~AUART <> 'ZDSO'
006800 AND A~AUART <> 'ZTSO'