KMC failed on DB2 - ALTER TABLE "KMC_UWL_ITEM_ATTR" while applying SP 26 on NW 7.0 Portal

[former_member186587]

We are getting below error while applying Support Pack 26 on our SAP NW Portal 7.0 SP 22.

NW Poartal 7.0 SP 22 --> Applying SP26

DB: DB2 v9.7.0.2

Log file: sdmcl20120530051344.log

 

May 30, 2012 8:07:52 AM Info: E R R O R ******* (DbObjectSqlStatements)

May 30, 2012 8:07:52 AM Info: 8:07:52 2012-05-30 dbs-Error: Exception caught during SQL execution DB2 SQL Error: SQLCODE=-673, SQLSTATE=23515, SQLERRMC=ITEM_ID..., DRIVER=3.59.81 ALTER TABLE "KMC_UWL_ITEM_ATTR" ADD PRIMARY KEY(ITEM_ID, ATTRIBUTE_NAME)

May 30, 2012 8:07:52 AM Info:

May 30, 2012 8:07:52 AM Info: E R R O R ******* (DbObjectSqlStatements)

May 30, 2012 8:07:52 AM Info: 8:07:52 2012-05-30 dbs-Error: Exception caught during SQL execution DB2 SQL Error: SQLCODE=-673, SQLSTATE=23515, SQLERRMC=ITEM_ID..., DRIVER=3.59.81 ALTER TABLE "KMC_UWL_ITEM_ATTR" ADD PRIMARY KEY(ITEM_ID, ATTRIBUTE_NAME)

May 30, 2012 8:07:52 AM Info:

May 30, 2012 8:07:52 AM Info: E R R O R ******* (DbModificationManager)

May 30, 2012 8:07:52 AM Info: 8:07:52 2012-05-30 dbs-Error: Statements could not be executed successfully

May 30, 2012 8:07:52 AM Info:

May 30, 2012 8:07:52 AM Info: E R R O R ******* (DbModificationManager)

May 30, 2012 8:07:52 AM Info: 8:07:52 2012-05-30 dbs-Error: Statements could not be executed successfully

Log file: JSPM_MAIN_1_01.LOG

May 29, 2012 11:16:23 PM [Error]: Deployment of archive /sapdvds/Supp_pack_June_2012/portal/EPBC226_0-10003489.SCA has been terminated. Aborted: software component 'EPBC2'/'sap.com'/'SAP AG'/'1000.7.00.26.0.20120127032009''/'2':No further description found.

May 29, 2012 11:16:23 PM [Error]: Deployment of archive /sapdvds/Supp_pack_June_2012/portal/KMCBC26_0-10003491.SCA has been terminated. Aborted: software component 'KMC-BC'/'sap.com'/'SAP AG'/'1000.7.00.26.0.20120127032319''/'2':No further description found.

May 29, 2012 11:16:23 PM [Error]: Deployment of archive /sapdvds/Supp_pack_June_2012/portal/KMCCM26_0-10003492.SCA has been terminated. Aborted: software component 'KMC-CM'/'sap.com'/'SAP AG'/'1000.7.00.26.0.20120127032423''/'2':No further description found.

May 29, 2012 11:16:23 PM [Error]: Deployment of archive /sapdvds/Supp_pack_June_2012/portal/KMCCOLL26_0-10003493.SCA has been terminated. Aborted: software component 'KMC-COLL'/'sap.com'/'SAP AG'/'1000.7.00.26.0.20120109075533''/'2':No further description found.

[former_member189725 · Accepted solution]

Please follow the instruction to resolve this issue

Note 1527061 - Deployment problem due to change in KMC_UWL_ITEM_ATTR

Regards

Ratnajit

[former_member186587 · Accepted solution]

We had OSS message opened and they also pointed to same SAP Note: 1527061.

Thanks for your help.