2286824 - SUM: dbs-Error: Table SEA_DIMENSIONS could not be modified in database

While upgrading to Netweaver 7.4 or upgrading Netweaver 7.4 stack level, the following error can be seen in Software Update Manager (SUM):

• Trouble Ticket Report

Update to SAP NETWEAVER 7.4
SID................: n/a
Hostname...........: <Hostname>
Install directory..: /usr/sap/<SID>
SUM directory......: /usr/sap/<SID>/SUM/sdt
Database...........: n/a
Operating System...: n/a
JDK version........: n/a
Source release.....: n/a
Target release.....: 7.40
ABAP stack present.: n/a

An error occured during the execution of Deploy Software Components of action execute.
Service com.sap.sdt.jspm.service.JspmService failed with the following message:
Could not update components.
For more information, see the log file /usr/sap/<SID>/SUM/sdt/log/SUM/DEPLOY-COMPONENTS_XX.LOG.
Use the provided information to troubleshoot the problem. There might be a SAP note providing a solution to this problem. Search the SAP notes using the following search terms:
SUM,execute,component-deploy-710,deploy-components,com.sap.sdt.jspm.service.JspmService,class com.sap.sdt.jspm.service.JspmServiceException

• DEPLOY-COMPONENTS_XX.LOG

Deployment finished with error.
<Date> <Time> [Info  ]: Saving data model Jump.JSPM.DataModel.xml ...
<Date> <Time> [Info  ]: Data model Jump.JSPM.DataModel.xml saved.
<Date> <Time> [Info  ]: Saving data model JUP.J2EE.DataModel.xml ...
<Date> <Time> [Info  ]: Data model JUP.J2EE.DataModel.xml saved.
<Date> <Time> [Error ]: The following problem has occurred during step execution: com.sap.sdt.jspm.service.JspmServiceException: Could not update components.
Deployment of queue Queue_<Date> at <Time> completed with error Deployment finished with error. See Deploy Controller log /usr/sap/<SID>/SUM/sdt/log/SUM/deploy_api.0.log for details.

Deployment finished with error.
sap.com/SEA-CORE: Deployment of archive /usr/sap/trans/EPS/in/SPS12_NW74/SEACORE11_0-20010046.SCA for component sap.com/SEA-CORE aborted
Detailed message: 1. Already deployed component has version:1000.7.40.11.0.20150402183300
  1. Item is skipped because of failed deployment of item 'sap.com_tc~esi~sea~schema~ddic' and because the applied error strategy is OnErrorStop
  1. Contains Aborted deployment component: 
sap.com_tc~esi~sea~schema~ddic
Deployment of archive /usr/sap/trans/EPS/in/SPS12_NW74/SEACORE11_0-20010046.SCA --> tc~esi~sea~schema~ddic.sda for component sap.com/tc~esi~sea~schema~ddic aborted
Detailed message: 1. [ERROR CODE DPL.DBC.901] Deploy operation finished with ERROR code.
The following messages were collected by DBModificationController during deployment:
<Time> <Date> dbs-Info:  <<< Modify SEA_DIMENSIONS >>>

E R R O R ******* (DbSqlStatement dev <Date> <Time>)
<Time> <Date> dbs-Error:  Exception caught during SQL execution ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
 
 OpenSQLExceptionCategories: [] 
 SQL STATEMENT: 
 CREATE UNIQUE INDEX "SEA_DIMENSIONS_IDX" 
ON "SEA_DIMENSIONS"
(
"DIM_CODE"
)

• Software Update Manager (SUM)
• SAP Netweaver 740
• Dual stack system, Java system, Enhancement Package Installation, Release upgrade, SPS update

SUM, Upgrade, EHP7, SEA_DIMENSION, ORA-01452, CREATE UNIQUE INDEX, dbs-Error, SAP NETWEAVER 740 , KBA , BC-UPG-TLS-TLJ , Upgrade tools for Java , BC-SRV-ASF-MDS , Web Service for Meta Data , Problem