Skip to Content
0
Dec 08, 2011 at 10:14 PM

RSBKCHECKBUFFER job scheduled twice and both canceling suddenly with two er

1227 Views

Hello,

This job RSBKCHECKBUFFER is scheduled to run two times in production system starting at same time 12:00 pm and it was running fine till 12.04.11 but both the jobs started failing suddenly since 12.05.11 with two different sql errors at times

DBIF_RSQL_SQL_ERROR

CX_SY_OPEN_SQL_DB

1. Database error text........: "SQL1224N The database manager is not able to

accept new requests, has terminated all requests in progress, or has

terminated the specified request because of an error or a forced interrupt.

SQLSTATE=55032 row=1"

2. Database error text........: "SQL0911N The current transaction has been rolled

back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1"

Also both the job is scheduled to run with two different parameters

Parameters

&0000000000001

&0000000000000

Can anyone let me know what could be the reason of sudden failure since 12.05.11.

Also if I schedule the job to run only once in the system will it solve the problem ?