SAP Knowledge Base Article - Preview

2955913 - SAPAPO program produces dump - Db2 SQL code: -1224" while accessing table "/SAPAPO/TREQIRES"

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

SAP NetWeaver all versions ; SAP Supply Chain Management 7.0

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.