Thursday, 5 July 2012

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

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


Solution:

No comments:

Post a Comment