SQL error "SQL code: -911" occurred while accessing table

[mahabaleshwar_patil]

Hello Experts,

SQL error "SQL code: -911" occurred while accessing table "ZWMD_XF_PO_LOG".

I am getting the dump in the below line of code.

Here we are inserting values into the table.

INSERT INTO zwmd_xf_po_log VALUES zla_zwmd_xf_po_log.

Database error text: "SQL message: SQL0911N  The current transaction has been

rolled back because of a deadlock or timeout.  Reason code "2".

SQLSTATE=40001 row=1"

These are the some observation from ST22

What happened?

Database error text: "SQL message: SQL0911N  The current transaction has been

rolled back because of a deadlock or timeout.  Reason code "2".

SQLSTATE=40001 row=1"

What can you do?

Note which actions and entries caused the error to occur.

Consult your SAP administrator.

Error analysis :

An exception has occurred which is explained in more detail below. The

exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in

procedure

The termination occurred in ABAP program "SAPLZWMD_WXF_PO_UTILITIES", in

"WRITE_ZLOG".

In the source code, the termination point is in line program "LZWMD_WXF_PO_UTILITIESU05".

  The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure

[former_member210770]

Hi ABAPER P,

Are you writing open sql statement or native sql statement in abap aditor ?

IF it is native sql statement syntax should be :

INSERT INTO table_name

VALUES (value1,value2,value3,...);

If it is Open Sql Statement,

Insert Tablename From Table Internaltablename.

Hope this will work.

Regards,

Sagar

[thanga_prakash]

Hello,

Check in SM21 whether the object which you are trying to access was locked by other user during that time.

Regards,

Tp

[mahabaleshwar_patil]

i have checked it but i have found the entries in sm21 how to check who has locked it ?

[thanga_prakash]

Provide us the screenshot of the SM21 log. I will help you.

Regards,

Tp

[mahabaleshwar_patil]

[thanga_prakash]

WF-BATCH is the user id used..

[mahabaleshwar_patil]

mens this object is locked ? but system log shows even critical errors and dumps also

[thanga_prakash]

Yes it means that the object is locked, that is what log says...

[former_member201275]

Check SM12 for locks on this table.