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.
SAP Knowledge Base Article - Preview