SAP Note 540593 - Short dump when updating with DBIF_DSQL2_SQL_ERROR in APO

Component : Sales - Check against Product Allocations

Solution : https://service.sap.com/sap/support/notes/540593 (SAP Service marketplace login required)

Summary :
During the qRFC data transfer from SAP R/3 to APO, a short dump—marked by error DBIF_DSQL2_SQL_ERROR and SQL code 600—occurs in the APO system due to simsession handling conflicts. To resolve this, create the database table /SAPAPO/CIFLUWPA via SE11 and define appropriate fields. Additionally, develop new function modules /SAPAPO/CIF_SIMSESS_MODE_SET, /SAPAPO/CIF_SIMSESS_MODE_GET, and /SAPAPO/CIF_LUWPAR_FLAG in transaction SE37 to control and query simsession usage. Implement and source code corrections as outlined to mitigate the issue.

Key words :
mandt mandt                 ext_tid arfctid_d                 crdate crdate                 nosimsess xfeld               select, database table called /sapapo/cifluwpa, function module called /sapapo/cif_simsess_mode_set, function module called /sapapo/cif_simsess_mode_get, function module called /sapapo/cif_luwpar_flag, /sapapo/cif_gen function group, function group /sapapo/cif_gen, text 'setting luw indicators', importing parameter called iv_receiver_tid, transactional simulation reason

Related Notes :

613844'RETRY' problem for SD documents with product allocation
610704Composite SAP note: Performance of SD document update
601523
543202APO application log displayed in several languages
517889Product allocations: SQL error -28530 when executing EXEC
512175Product allocations: SQL error -28530 when you execute EXEC
509632Product allocations: Runtime error DBIF_RSQL_SQL_ERROR
508757
434474Allocations: SQL error 600 during execution of EXEC SQL