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

sanjay_deshpande4 — Fri, 09 Sep 2016 13:35:11 GMT

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,

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

SimoneMilesi — Fri, 09 Sep 2016 14:30:40 GMT

Did you updated LAGP before doing the read?

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

sanjay_deshpande4 — Fri, 09 Sep 2016 15:43:01 GMT

The curser is on standard code.

topic Re: Run time error: SQL error "SQL code: 133" occurred while accessing table "LAGP" in Application Development and Automation Discussions

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

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

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