Process Chain Failed05/01/2006 02:47:21 ABAP/4 processor: DBIF_RSQL_SQL_ERR

[Former Member]

Hi Experts,

Today My Process Chain Failed With Error Code

ABAP/4 processor: DBIF_RSQL_SQL_ERROR .

What Could be the Problem . Appreciate your Help.

Advance thanks

[Former Member]

Hi Anil

As said by Ashish and other's this issue is related to table table.

Another situation when this error comes is .. Say if your updating the ODS with more than one source system simultaneously Here the data packets from more than one request contain one or more common records. This gives rise to deadlock while updating inserting records into the ODS table and subsequently a short dump is encountered leading to the failure of one request

The solution is to cancel the loads and run them serially. A possible long term solution is to load the data up to the PSA in parallel and then load the ODS table from the PSA in serial. (Here change the InfoPackage to option ‘PSA only’ and tick ‘Update subsequent data targets’).

Hope the above solution helps you..

bye

Shu Moh

[Former Member]

Hi Anil,

This problem comes with Table space, check in transaction DBO2

Please check this link for the other possible cause of this error

-Ashish

[Former Member]

Anil

This is a database (tablespace ,extents) issue . Contact your Basis person and get it resolved.

Regards

Pradip

[Former Member]

Anil

This is a database (tablespace ,extents) issue . Contact your Basis person and get it resolved.

Regards

Pradip

[Former Member]

Anil

"DBIF_RSQL_SQL_ERROR" this error relates to memory issues and ask your DBA team to look at this error probably they will increase some memory space in the server.

Hope this helps

Thnaks

Sat