SAP Knowledge Base Article - Preview

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

Symptom

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"
)


Read more...

Environment

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

Product

SAP NetWeaver 7.4

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.