INSERT INTO "D342L"

[Former Member]

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.

[Former Member · Accepted solution]

  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 )

May be this due to error in design of application ZGINMU_EXPORT_TO_GESINMU_V2. How often do you encounter this problem? Please detect exactly what SQL statements are involved in deadlock and ABAP source of this statements.

Regards

Roman

[Former Member]

Hi Victor,

I recommend you apply the latest kernel patch;

Note 1608273 - Deadlock on D342L and D345T

Best regards,

Orkun Gedik

[Former Member]

Thanks Orkun, revise this note.

[Former Member]

Hello Orkun,

I have this kerne, this note not apply

kernel release                640

kernel make variant           640_REL

DBMS client library           OCI_920

DBSL shared library version   640.00

compiled on                   HP-UX B.11.23 U ia64 for "hpia64"

compiled for                  64 BIT

compilation mode              Non-Unicode

compile time                  May 19 2012 10:06:42

update level                  0

patch number                  404

source id                     0.404

---------------------
supported environment
---------------------

database (SAP, table SVERS)   610
                              620
                              630
                              640

DBMS server
   ORACLE 8.1.7.*.*
   ORACLE 9.2.0.*.*
   ORACLE 10.1.0.*.*
   ORACLE 10.2.0.*.*
   ORACLE 11.2.0.*.*

operating system
HP-UX B.11

Can you help me???

Thanks