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.