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