Error during JSPM (cannot validate (SAPEPDDB.SYS_C006297) - primary key)

[Former Member]

Hi all,

I am applying support pack from 7.0 sp22 to sp24 and while the deployment i am getting the following error as follows

################################################################################

Jul 4, 2012 9:24:09 PM   Info: 21:24:08 2012-07-04 dbs-Info:  No action required for table

Jul 4, 2012 9:24:09 PM   Info: 21:24:08 2012-07-04 dbs-Info:  Runtime XML of KMC_UWL_ITEM_ATTAC successfully written

Jul 4, 2012 9:24:09 PM   Info: 21:24:08 2012-07-04 dbs-Info:  Runtime XML of KMC_UWL_ITEM_ATTAC successfully written

Jul 4, 2012 9:24:09 PM   Info: 21:24:08 2012-07-04 dbs-Info:  Runtime XML of KMC_UWL_ITEM_ATTAC successfully written

Jul 4, 2012 9:24:09 PM   Info: 21:24:08 2012-07-04 dbs-Info:  Runtime XML of KMC_UWL_ITEM_ATTAC successfully written

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  Next archive object : KMC_UWL_ITEM_ATTR.gdbtable

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  Next archive object : KMC_UWL_ITEM_ATTR.gdbtable

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  <<< Analyze table KMC_UWL_ITEM_ATTR >>>

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  <<< Analyze table KMC_UWL_ITEM_ATTR >>>

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  predefined action is: >>>null<<<

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  predefined action is: >>>null<<<

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  Action: ALTER

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:  Action: ALTER

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:    ALTER TABLE "KMC_UWL_ITEM_ATTR"

Jul 4, 2012 9:24:09 PM   Info: ADD PRIMARY KEY ("ITEM_ID", "ATTRIBUTE_NAME")

Jul 4, 2012 9:24:09 PM   Info: NOT DEFERRABLE INITIALLY IMMEDIATE ENABLE VALIDATE

Jul 4, 2012 9:24:09 PM   Info:

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Info:    ALTER TABLE "KMC_UWL_ITEM_ATTR"

Jul 4, 2012 9:24:09 PM   Info: ADD PRIMARY KEY ("ITEM_ID", "ATTRIBUTE_NAME")

Jul 4, 2012 9:24:09 PM   Info: NOT DEFERRABLE INITIALLY IMMEDIATE ENABLE VALIDATE

Jul 4, 2012 9:24:09 PM   Info:

Jul 4, 2012 9:24:09 PM   Info:

Jul 4, 2012 9:24:09 PM   Info: E R R O R ******* (DbObjectSqlStatements)

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Error:  Exception caught during SQL execution ORA-02437: cannot validate (SAPEPDDB.SYS_C006297) - primary key violated

Jul 4, 2012 9:24:09 PM   Info:  ALTER TABLE "KMC_UWL_ITEM_ATTR" ADD PRIMARY KEY ("ITEM_ID", "ATTRIBUTE_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE ENABLE VALIDATE

Jul 4, 2012 9:24:09 PM   Info:

Jul 4, 2012 9:24:09 PM   Info: E R R O R ******* (DbObjectSqlStatements)

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Error:  Exception caught during SQL execution ORA-02437: cannot validate (SAPEPDDB.SYS_C006297) - primary key violated

Jul 4, 2012 9:24:09 PM   Info:  ALTER TABLE "KMC_UWL_ITEM_ATTR" ADD PRIMARY KEY ("ITEM_ID", "ATTRIBUTE_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE ENABLE VALIDATE

Jul 4, 2012 9:24:09 PM   Info:

Jul 4, 2012 9:24:09 PM   Info: E R R O R ******* (DbModificationManager)

Jul 4, 2012 9:24:09 PM   Info: 21:24:09 2012-07-04 dbs-Error:  Statements could not be executed successfully

#########################################################################################

kindly suggest any suitable solutions to my problem.I have attached the whole logs for analysis

Regards,

Revanth

sdmcl20120704155033.txt.zip

[sunny_pahuja2 · Accepted solution]

Hi,

Check SAP note 653111 ( this note is not for your release but describe same problem and it will give you an idea how to solve the error)

Thanks

Sunny

[former_member189725 · Accepted solution]

Please check the solution section of the SAP note below

Note 1527061 - Deployment problem due to change in KMC_UWL_ITEM_ATTR

This should help you .

Regards

Ratnajit

[Former Member · Accepted solution]

HI Sunny,

I have solved the error using this note

Note 1527061 - Deployment problem due to change in KMC_UWL_ITEM_ATTR

thanks for your help.

Regards,

Revanth