While i am trying upgrade to PI 7.1 it's getting error out at DEPLOY_ONLINE_DB phase. Below is error where it start failling.
Description:'1. [ERROR CODE DPL.DBC.204] failed to deploy dbschemacontainer : com.sap.xi.dbschema.ibdir.sda Y:\usr\sap\NPI\DVEBMGS00\j2ee\cluster\server0\temp\deploy\work\deploying\com.sap.xi.dbschema.ibdir.sda1241504976194\com.sap.xi.dbschema.ibdir.sda. Return code from dictionary library is ERROR.
-> [ERROR CODE DPL.DBC.901] Deploy operation finished with ERROR code.
The following messages were collected by DBModificationController during deployment:
E R R O R ******* (DbSqlStatement)
23:29:44 2009-05-04 dbs-Error: Exception caught during SQL execution 'PK__XI_DIRCACHEERROR__215A6EF1' is not a constraint. declare @pkName varchar(128)
select @pkName = so1.name from sysobjects so1 where so1.parent_obj = object_id(user + '.' + 'XI_DIRCACHEERRORS') and so1.xtype = 'PK'
if @pkName is not null exec ('ALTER TABLE [XI_DIRCACHEERRORS] DROP CONSTRAINT [' + @pkName + ']')
Please help me how do fix this problem.