SAP Knowledge Base Article - Preview

2662964 - DBSQL_DUPLICATE_KEY_ERROR in CL_RSSH_HIERARCHY_BASE during hierarchy load

Symptom

Loading a hierarchy via Data Transfer Process (DTP) or Infopackage, fails with the following dump:

"DBSQL_DUPLICATE_KEY_ERROR" CX_SY_OPEN_SQL_DB
"CL_RSSH_HIERARCHY_BASE========CP" bzw. CL_RSSH_HIERARCHY_BASE========CM00G
"SAVE_HIERARCHY"

The dump can happen in any of the following lines in the SAVE_HIERARCHY method:
INSERT rshiedirt FROM TABLE p_sx_htabs-t_hiedirt.
INSERT rsmhiernode FROM TABLE p_sx_htabs-th_hiernode.
INSERT rsthiernode FROM TABLE p_sx_htabs-th_hiernodet.
INSERT rshielvt FROM TABLE p_sx_htabs-t_level.


Read more...

Environment

  • SAP NetWeaver 7.3
  • SAP NetWeaver BW 7.31   (SAP NW BW 7.3 EnhP 1)
  • SAP enhancement package 1 for SAP NetWeaver 7.3
  • SAP NetWeaver BW 7.40
  • SAP NetWeaver 7.40
  • SAP NetWeaver 7.50

Product

SAP NetWeaver 7.4

Keywords

CL_RSSH_HIERARCHY_BASE, duplicate, double, duprec, , KBA , BW-WHM-DBA-HIER , Hierarchy Processing , BW-WHM-DST-DTP , Data Transfer Process , 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.