Symptom
Job execution of program '/SAPAPO/SAPLDM_ATPTREE' produces the following short dump:
Category Installation Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 31.07.2020 07:15:20
---------------------------------------------------------------------------------------------
Short Text
SQL error "SQL code: -1224" occurred while accessing table "/SAPAPO/TREQIRES".
---------------------------------------------------------------------------------------------
With the Netweaver system log reporting the following sql DELETE query as the cause:
C Fri Jul 31 07:15:20:150 2020
C *** ERROR in DB6Execute[/bas/749_REL/src/dbs/db6/dbdb6.c, 5452] CON = 0 CACHEID = 80 (BEGIN)
C &+ DbSlModifyDB6( SQLExecute ): [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests,
C &+ has terminated all requests in progress, or has terminated the specified request because of an error or a forced i
C &+ nterrupt. SQLSTATE=55032 row=1
C &+
C &+ DELETE FROM "/SAPAPO/TREQIRES" WHERE "MANDT" = ? AND "TRGUID" = ? AND "SLGUID" = ? WITH CS
C &+ cursor type=NO_HOLD, isolation=RC, cc_release=YES, optlevel=5, degree=1, op_type=8, read_only=0
C &+ ABAP location info: '/SAPAPO/SAPLDM_ATPTREE', 8258
Read more...
Environment
- Netweaver AS ABAP any version.
- Db2 (DB6) any version.
- SCMAPO Back Order Processing 713 sp12. Other release levels and SPs of SCMAPO may be affected as well.
Product
Keywords
TREQUIRE ADM1542W ADM1823E DIA8309C SQL0964C , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , SCM-APO-ATP-BOP , Backorder Processing , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.