SAP Knowledge Base Article - Preview

2195647 - Duplicate entries in RSHIETXTTMP while loading Hierarchy data

Symptom

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...

Environment

  • 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

Product

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

Keywords

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

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.