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

• SAP Netweaver - All versions

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