Skip to Content
0
Former Member
Oct 28, 2008 at 01:14 PM

ABAP/4 processor: DBIF_RSQL_SQL_ERROR

289 Views

Hi All,

I have scheduled a job in background.The job is taking a very long time than usual to process.After processing for around 5000 sec's the job is getting cancelled.Upon checking the job log it is found that the job is cancelled with the following error "ABAP/4 processor: DBIF_RSQL_SQL_ERROR " .

The bottleneck of the code is found at a select query retrieving all the records from a std.table.

Is there any way to solve this problem without changing the program now? Does this happen when the server is busy ?

SELECT BVBELN BPOSNR AFKART AKUNAG AKUNRG AERDAT B~MATNR

BPMATN BPRSDT BARKTX BFKIMG BMEINS BNETWR B~MWSBP

BABRBG BFBUDA BPRODH BAUBEL B~AUPOS

INTO TABLE I_VBRP

FROM VBRK AS A

INNER JOIN VBRP AS B

ON AVBELN = BVBELN

FOR ALL ENTRIES IN I_FINAL

WHERE ( B~AUBEL = I_FINAL-VBELN AND

B~AUPOS = I_FINAL-POSNR ) AND

A~ERDAT >= '20070101'.

IF SY-SUBRC EQ 0.

SORT I_VBRP BY VBELN POSNR ERDAT..

Kindly Advise.

Thanks.