Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ABAP/4 processor: DBIF_RSQL_SQL_ERROR

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.

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question