SAP Knowledge Base Article - Preview

2875273 - SQL code: 2048, 4 DBSQL_SQL_INTERNAL_DB_ERROR in PP/DS Planning Processes

Symptom

PP/DS, APO Integration transactions or reports end up with a shortdump: /SAPAPO/CDPSB0,  /SAPAPO/RRP_NETCH,  /SAPAPO/BACKGROUND_SCHEDULING.

The shortdump examples carry the following traits:

Category External Error
Runtime Errors DBSQL_SQL_INTERNAL_DB_ERROR

Short Text
SQL error "SQL code: 2048" occurred while accessing table "/SAPAPO/MATLOC".

 Active Calls/Events

7 FUNCTION /SAPAPO/SAPLDM_MATERIAL /SAPAPO/LDM_MATERIALU06 130
/SAPAPO/DM_MATLOC_GET
6 FUNCTION /SAPAPO/SAPLMMPUR_SOS /SAPAPO/LMMPUR_SOSU04 631
/SAPAPO/SOS_GET
.
1 EVENT /SAPAPO/CIF_DELTAREPORT3 /SAPAPO/CIF_DELTAREPORT3 398
START-OF-SELECTION

ABAP Code

*--> Read DB ...
IF NOT lt_matloc_id[] IS INITIAL.
SELECT *
FROM /sapapo/matloc
APPENDING TABLE et_matloc
FOR ALL ENTRIES IN lt_matloc_id
WHERE matid = lt_matloc_id-matid
AND locid = lt_matloc_id-locid.

*****

Category External Error
Runtime Errors DBSQL_SQL_INTERNAL_DB_ERROR

Short Text
SQL error "SQL code: 4" occurred while accessing table "/SAPAPO/MATLOC".

Active Calls/Events

12 FUNCTION /SAPAPO/SAPLDM_MATERIAL /SAPAPO/LDM_MATERIALU93 3
/SAPAPO/DM_MATLOC_READ
11 FUNCTION /SAPAPO/SAPLDM_MATERIAL /SAPAPO/LDM_MATERIALU71
/SAPAPO/DM_MATLOC_PREREAD
10 FUNCTION /SAPAPO/SAPLDM_PEGAREA /SAPAPO/LDM_PEGAREAU07 1
/SAPAPO/DM_PEGID_PREREAD
9 FORM /SAPAPO/SAPLRRP_HEUR_MRP /SAPAPO/LRRP_HEUR_MRPF12
FILL_GLOBAL_FIELDS
8 FUNCTION /SAPAPO/SAPLRRP_HEUR_MRP /SAPAPO/LRRP_HEUR_MRPU01 1
/SAPAPO/HEU_MRP_PLANNING
7 FUNCTION /SAPAPO/SAPLCDPS_HEURISTICS /SAPAPO/LCDPS_HEURISTICSU12 2
/SAPAPO/HEUR_DO_HEURISTICS
6 FUNCTION /SAPAPO/SAPLCDPS_BATCH_PRESENT /SAPAPO/LCDPS_BATCH_PRESENTU01 7
/SAPAPO/BTCH_PRESENTATION_CALL
5 FUNCTION /SAPAPO/SAPLCDPS_EXT_INTERFACE /SAPAPO/LCDPS_EXT_INTERFACEU06
/SAPAPO/EINT_PRESENTATION_CALL
4 FUNCTION /SAPAPO/SAPLCDPS_EXT_INTERFACE /SAPAPO/LCDPS_EXT_INTERFACEU23 1
/SAPAPO/EINT_DPS_BATCH_CALL
3 FORM /SAPAPO/BACKGROUND_SCHEDULING /SAPAPO/BACKGROUND_TIME_PTS 2
%_SEL_SCREEN
2 MODULE (PAI) /SAPAPO/BACKGROUND_SCHEDULING /SAPAPO/BACKGROUND_SCHEDULING 1
%_END_OF_SCREEN
1 EVENT /SAPAPO/BACKGROUND_SCHEDULING <SYSINI>
SYSTEM-EXIT

 


Read more...

Environment

from SAP S/4 Hana 1709 onwards

Product

SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020

Keywords

*SELECT /* FDA WRITE */* , FDA, , KBA , SCM-APO-MD-PR , Product , SCM-APO-PPS , Production Planning and Detailed Scheduling , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.