topic Re: SQL error "SQL code: -911" occurred while accessing table in Application Development and Automation Discussions

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

ABAPER_P — Fri, 28 Nov 2014 10:50:43 GMT

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

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

former_member210770 — Fri, 28 Nov 2014 11:25:48 GMT

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

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

ThangaPrakash — Fri, 28 Nov 2014 11:31:40 GMT

Hello,

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

Regards,

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

ABAPER_P — Fri, 28 Nov 2014 13:35:31 GMT

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

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

ThangaPrakash — Fri, 28 Nov 2014 14:28:53 GMT

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

Regards,

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

ABAPER_P — Fri, 28 Nov 2014 14:34:40 GMT

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

ThangaPrakash — Fri, 28 Nov 2014 14:43:20 GMT

WF-BATCH is the user id used..

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

ABAPER_P — Fri, 28 Nov 2014 15:16:40 GMT

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

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

ThangaPrakash — Fri, 28 Nov 2014 15:18:21 GMT

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

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

former_member201275 — Fri, 28 Nov 2014 15:24:22 GMT

Check SM12 for locks on this table.