PI 7.1 Upgrade errror - DEPLOY_ONLINE_DB phase

36 Views

hi Team,

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.

Thanks

Sekhar