Run time error: SQL error "SQL code: 133" occurred while accessing table "LAGP"

[sanjay_deshpande4]

Dear All,

FOllowing are the details of deadlock runtime error occuring.

What happened?

    Database error text: "SQL message: transaction rolled back by detected

     deadlock: TrexUpdate failed on table 'SAPSR3:LAGP' with error: transaction

     rolled back by detected deadlock: Deadlock detected while executing

     transaction (TRANSACTION_ID=27, UPDATE_TRANSACTION_ID=431841463"

error at following line:

SELECT SINGLE FOR UPDATE * FROM LAGP
WHERE LGNUM = KEY_LAGP-LGNUM
AND LGTYP = KEY_LAGP-LGTYP
AND LGPLA = KEY_LAGP-LGPLA.

Now what i know is their are two progs simultaneously trying to access same LAGP table record.However which two programms are trying to access is not known.

The progrm not available in dump log.

Can any body guide me how to find these programmes?

Regards,

SD

[SimoneMilesi]

Did you updated LAGP before doing the read?

[sanjay_deshpande4]

The curser is on standard code.