SQL error 1205 ATP_RESB When Product Confirmation

[former_member212713]

Hello Dear Experts,

I get shortdump at PP modüle when product confirmation.

Are there any experts, come across and solved this issue?

Maybe  there SAP note for this issue at SAP Note.

Best regards.

Error details is below:

Error created at LATP2FR1 -> ENHANCEMENT-SECTION     RESB_DB_READ_05

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                     CX_SY_OPEN_SQL_DB

Date and Time          17.01.2016 23:07:03

SQL error 1205 when accessing table "ATP_RESB".

[thanga_prakash]

Hello Melih,

Check for any deadlocks in the system, there might be a deadlock in the system for table RESB or ATP_RESB which is blocking for the access to other applications.

Check in transaction SM12 for the lock entries.

Also refer to the below OSS note which might help you on the same.

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

Regards,

Thanga

[former_member212713]

Hello Thanga,

Your link didnt open.

Can you send oss number?

[thanga_prakash]

565710 - Deadlock analysis for SQL Server (known issues)

[former_member195402]

http://service.sap.com/sap/support/notes/1838897

Hi,

please check the following SAP note:

1838897 -  SQL Error 1205 during ATP check

Regards,

Klaus