2452195 - Planning Area activation error: UNIQ_CONSTR_PLROOT_SOPDD_PLANOBJECT | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2452195 - Planning Area activation error: UNIQ_CONSTR_PLROOT_SOPDD_PLANOBJECT

Symptom

While activating the Planning Area you will receive the following exception:

E - An error occurred when the database procedure    /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLANOBJ  was called. Potentially, the procedure    /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLANOBJ  was called by another database procedure. The method called from ABAP is    /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET  Database connection used: "" (default connection if empty)  SQL error on the database: "129"  SQL message on the database: "transaction rolled back by an internal error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET#stb2#20170319085208": line 8 col 3 (at pos 196): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLSET": line 28 col 5 (at pos 1593): [129] (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error: search table error: "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIV_PLANOBJ": line 294 col 13 (at pos 19185): [129] (range 3): transaction rolled back by an internal error: cannot CREATE UNIQUE INDEX; duplicate key found:  [5] Several documents with the same ID exist in the index;SAPSOPG100:SOPDD_PLANOBJECT_<>.$uc_UNIQ_CONSTR_PLROOT_SOPDD_PLANOBJECT_<>$ content not unique, cannot define unique constraint. rowCount != distinctCount "E -  Error at: /IBP/CL_SAP_SFND_SOPDM========CP, /IBP/CL_SAP_SFND_SOPDM========CM009:294

Planning Area Activation Log:

E - Data validation for planning area PLANNING_AREA failed.
E - Unique constraint to be applied on table "SOPDD_TABLE_NAME" for PA PLANNING_AREA is not sufficient.
E - Activation failed.


Read more...

Environment

  • SAP Supply Chain Management (SCM)
  • SAP Sales and Operations Planning (SCM-SOP)
  • SAP Integrated Business Planning (SCM-IBP)

Product

SAP Integrated Business Planning 1608 ; SAP Integrated Business Planning 1611 ; SAP Integrated Business Planning 1702 ; SAP Integrated Business Planning 1705 ; SAP Integrated Business Planning 1708 ; SAP Integrated Business Planning 1711 ; SAP Integrated Business Planning 4.0 ; SAP Integrated Business Planning 5.0 ; SAP Integrated Business Planning 6.0 ; SAP Integrated Business Planning 6.1 ; SAP Integrated Business Planning 6.2

Keywords

UNIQ_CONSTR_PLROOT_SOPDD_PLANOBJECT, Activation failure, Unique Constrain, Activation Error , KBA , SCM-IBP-CNF-ACT , IBP Activation , 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.