Error while activating PA

[Former Member]

Hi,

We are getting below error while trying to activate a Planning Area.

E - An error occurred when the database procedure /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLAREA  was called. Potentially, the procedure /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLAREA  was called by another database procedure. The method called from ABAP is /IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLAREA  Database connection used: "" (default connection if empty)  SQL error on the database: "301"  SQL message on the database: "unique constraint violated: [301] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLAREA#stb2#20160529145709": line 8 col 3 (at pos 184): [301] (range 3) unique constraint violated exception: unique constraint violated:  [301] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPDM=>SOPDM_ACTIVATEPLAREA": line 159 col 11 (at pos 9679): [301] (range 3) unique constraint violated exception: unique constraint violated:  [301] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPCM=>SOPCM_CALC_SCENARIO_DEF_GEN": line 1096 col 3 (at pos 79552): [301] (range 3) unique constraint violated exception: unique constraint violated:  [301] "SAPHANADB"."/IBP/CL_SAP_SFND_SOPCM=>SOPCM_CALC_SCENARIO_NODE_ADD": line 282 col 9 (at pos 17434): [301] (range 3) unique constraint violated exception: unique constraint violated: TrexUpdate failed on table 'SAPHANADB:/IBP/CMJSONINP2' with error: unique constraint violation on pos=0 for table SAPHANADB:

E -  Error at: /IBP/CL_SAP_SFND_SOPDM========CP, /IBP/CL_SAP_SFND_SOPDM========CM001:1

Request to provide the expected reasons for the same.

regards,

Mohit

[Former Member]

Hi Mohit,

The table for which it shows unique constraint violation, is basically for input KFs of the calculation. Try activating one more time, if it fails again, raise an OSS.

Best regards

Rinju Mukherjee

[sourojit_pal]

Hi Mohit,

As per the shared Error script, the issue is due to Unique constraint violation exception.

Could you please try to re-activate your planning area with MDT option checked?

This could provide an elaboration of the root cause of the issue.

Regards,

Sourojit