1969188 - "The local repository upgrade was cancelled. (BODI-300056)" - Data Services

When upgrading a Data Services repository to a newer version, the upgrade fails with the following:

"Error or warning in executing the SQL statement <alter table AL_VARPARAM add PRIMARY KEY (PARENT_OBJID, PARENT_OBJTYPE, VP_NAME, VP_TYPE)>
The message from the underlying database is: <SQL submitted to ODBC data source <AGLSAPSBXARDDB1> resulted in error <[Microsoft][SQL Server Native Client 10.0][SQL Server]Table 'AL_VARPARAM' already has a primary key defined on it.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not create constraint. See previous errors.>.
The SQL submitted is <alter table AL_VARPARAM add PRIMARY KEY (PARENT_OBJID, PARENT_OBJTYPE, VP_NAME, VP_TYPE) >.>. (BODI-20004)
The local repository upgrade was cancelled. (BODI-300056)"

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Data Services 4.x

BODS , DS , Repository Manager , BODI-300056 , 300056 , can't upgrade , cannot , data base, upgrade, repository, error, "The local repository upgrade was cancelled" , KBA , EIM-DS , Data Services , EIM-DS-DEP , Deployment, Installation, Upgrade , Problem