ABAP/4 processor: DBIF_RSQL_SQL_ERROR
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..