2195647 - Duplicate entries in RSHIETXTTMP while loading Hierarchy data

When executing an Infopackage, extracting hierarchy data from different data source, a dump is generated:

Category ABAP Programming Error
Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLRSAI
Application Component BW-WHM-DST

Short Text
Open SQL array insert produces duplicate records in the database.

"SAPSQL_ARRAY_INSERT_DUPREC" CX_SY_OPEN_SQL_DB
"SAPLRSAI" bzw. LRSAIU18
"RSAR_HIER_FILL_TEMPTABLES"

213 IF NOT l_t_commhtx IS INITIAL.
>>> INSERT rshietxttmp FROM TABLE l_t_commhtx.
215 ENDIF.

14 FUNCTION SAPLRSAI LRSAIU18 214
RSAR_HIER_FILL_TEMPTABLES
13 FORM SAPLRSAI LRSAIU02 307
PROGRAM_CALL
12 FUNCTION SAPLRSAI LRSAIU02 142
RSAR_DATA_RECEIVED
11 FORM SAPLBD20 LBD20F0A 476
IDOCS_PASS_TO_APPLICATION
10 FORM SAPLBD20 LBD20F0B 72
IDOCS_PROCESS
9 FUNCTION SAPLBD20 LBD20U05 290
IDOC_INPUT
8 FUNCTION SAPLEDIR LEDIRU02 184
IDOC_START_INBOUND
7 FORM SAPLEDIN LEDINF07 189
IDOC_TO_APPLICATION_PASS
6 FORM SAPLEDIN LEDINF08 100
IDOC_INBOUND_PROCESS_40
5 FUNCTION SAPLEDIN LEDINU08 66
IDOC_INBOUND_SINGLE
4 FUNCTION SAPLRSAP LRSAPU15 81
RSAP_IDOC_SEND
3 FORM SAPLRSAP LRSAPU15 1
RSAP_IDOC_SEND
2 FORM SAPMSSY1 SAPMSSY1 296
REMOTE_FUNCTION_CALL
1 MODULE (PBO) SAPMSSY1 SAPMSSY1 35
%_RFC_START

Read more...

• SAP NetWeaver 2004
• SAP NetWeaver 7.0
• SAP NetWeaver 7.3
• SAP NetWeaver 7.4
• SAP enhancement package 1 for SAP NetWeaver 7.0
• SAP enhancement package 1 for SAP NetWeaver 7.3
• SAP enhancement package 2 for SAP NetWeaver 7.0
• SAP enhancement package 3 for SAP NetWeaver 7.0

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

hierarchy, hierarchies, dump, RSHIETXTTMP, RZ11, RZ10, SCP_ALLOWED_LANGUAGES, RSAR_HIER_FILL_TEMPTABLES, SAPSQL_ARRAY_INSERT_DUPREC, CX_SY_OPEN_SQL_DB, SAPLRSAI, LRSAIU18, zcsa/installed_languages, ZCSA, installed_languages, l_t_commhtx, TCP0I, internal, table, temporary, duplicate, entry, entries, language. , KBA , BW-WHM-DST , Data Staging , BW-WHM-DBA-HIER , Hierarchy Processing , Problem