Skip to Content
0
Former Member
Nov 02, 2012 at 12:12 PM

INSERT INTO "D342L"

367 Views

Hello colleagues,

I have the system stop with wp for table D342L, my system is SAP ERP Central Component 5.0 kernel release 640 patch 404.

In the logs see,

DEADLOCK DETECTED

[Transaction Deadlock]

Current SQL statement for this session:

INSERT INTO "D342L" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 , :A8 )

The following deadlock is not an ORACLE error. It is a

deadlock due to user error in the design of an application

or from issuing incorrect ad-hoc SQL. The following

information may aid in determining the deadlock:

Deadlock graph:

---------Blocker(s)-------- ---------Waiter(s)---------

Resource Name process session holds waits process session holds waits

TX-00030012-0001e057 11 91 X 26 34 S

TX-00070018-00020ade 26 34 X 11 91 S

session 91: DID 0001-000B-00000008 session 34: DID 0001-001A-00000003

session 34: DID 0001-001A-00000003 session 91: DID 0001-000B-00000008

Rows waited on:

Session 34: no row

Session 91: no row

Information on the OTHER waiting sessions:

Session 34:

pid=26 serial=10 audsid=120245 user: 27/SAPSRD

O/S info: user: srdadm, term: , ospid: 19795, machine: sapdes

client info: 0

application name: ZGINMU_EXPORT_TO_GESINMU_V2, hash value=3561660742

action name: 2214, hash value=3204952035

Current SQL Statement:

INSERT INTO "D342L" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 , :A8 )

End of information on OTHER waiting sessions.

Regards.