Skip to Content
0
Former Member
Jul 04, 2012 at 04:58 PM

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

59 Views

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

Attachments