2286824 - SUM:dbs-Error: Table SEA_DIMENSIONS could not be modified in database | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

During SPS  update of NW 7.4 or release upgrade to NW 7.4, SUM reports below error:

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.
Feb 17, 2016 6:51:23 AM [Info  ]: Saving data model Jump.JSPM.DataModel.xml ...
Feb 17, 2016 6:51:24 AM [Info  ]: Data model Jump.JSPM.DataModel.xml saved.
Feb 17, 2016 6:51:24 AM [Info  ]: Saving data model JUP.J2EE.DataModel.xml ...
Feb 17, 2016 6:51:26 AM [Info  ]: Data model JUP.J2EE.DataModel.xml saved.
Feb 17, 2016 6:51:27 AM [Error ]: The following problem has occurred during step execution: com.sap.sdt.jspm.service.JspmServiceException: Could not update components.
Deployment of queue Queue_2016.02.16 at 12:00:57 completed with error Deployment finished with error. See Deploy Controller log /usr/sap/MID/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:
6:47:59 2016-02-17 dbs-Info:  <<< Modify SEA_DIMENSIONS >>>

E R R O R ******* (DbSqlStatement dev 30.07.2013 13:00:00)
6:47:59 2016-02-17 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

  • 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.