Problem upgrading from SP14 to SP15

[Former Member]

Hello,

I am trying to upgrade my local WAS to SP15. I am getting the following error during the installation (excerpt from callSdmViaSapinst.log file):

Feb 15, 2006 10:32:01... Info: Creating connections to database "J2E".

Feb 15, 2006 10:32:01... Info: Creating vendor connection to database.

Feb 15, 2006 10:32:01... Info: Vendor connection created successfully.

Feb 15, 2006 10:32:01... Info: Creating openSQL connection to database.

Feb 15, 2006 10:32:03... Info: OpenSQL connection created successfully.

Feb 15, 2006 10:32:05... Info: <!LOGHEADER[START]/>

Feb 15, 2006 10:32:05... Info: <!HELP[Manual modification of the header may cause parsing problem!]/>

Feb 15, 2006 10:32:05... Info: <!LOGGINGVERSION[1.5.3.7186 - 630]/>

Feb 15, 2006 10:32:05... Info: <!NAME[C:\usr\sap\J2E\JC00\SDM\program\log\jddilog20060215103203.log]/>

Feb 15, 2006 10:32:05... Info: <!PATTERN[jddilog20060215103203.log]/>

Feb 15, 2006 10:32:05... Info: <!FORMATTER[com.sap.dictionary.database.dbs.DbTraceFormatter(%s %m %-30l %24d)]/>

Feb 15, 2006 10:32:05... Info: <!ENCODING[Cp1252]/>

Feb 15, 2006 10:32:05... Info: <!LOGHEADER[END]/>

Feb 15, 2006 10:32:05... Info:

Feb 15, 2006 10:32:05... Info: E R R O R ******* (DbObjectSqlStatements)

Feb 15, 2006 10:32:05... Info: 10:32:04 2006-02-15 dbs-Error: Exception caught during SQL execution [-6000] (at 15): Duplicate table name:BC_CMSRTS CREATE TABLE "BC_CMSRTS"("VENDOR" VARCHAR(256) UNICODE DEFAULT ' ' , "NAME" VARCHAR(256) UNICODE DEFAULT ' ' , "PROVIDER" VARCHAR(40) UNICODE DEFAULT ' ' , "CMSNAME" VARCHAR(10) UNICODE DEFAULT ' ' , "CMSURL" VARCHAR(256) UNICODE DEFAULT ' ' , "TRACKNAME" VARCHAR(8) UNICODE DEFAULT ' ' , "SYSTYPE" VARCHAR(10) UNICODE DEFAULT ' ' , "LOCATION" VARCHAR(40) UNICODE DEFAULT ' ' , "CONFIGTYPE" VARCHAR(5) UNICODE DEFAULT ' ' , "RELEASE" VARCHAR(10) UNICODE DEFAULT ' ' , "SERVICELEVEL" VARCHAR(10) UNICODE DEFAULT ' ' , "PATCHLEVEL" VARCHAR(10) UNICODE DEFAULT ' ' , "APPLYTIME" VARCHAR(20) UNICODE DEFAULT ' ' )

Feb 15, 2006 10:32:05... Info:

Feb 15, 2006 10:32:05... Info: E R R O R ******* (DbModificationManager)

Feb 15, 2006 10:32:05... Info: 10:32:04 2006-02-15 dbs-Error: Statements could not be executed successfully

Feb 15, 2006 10:32:05... Error: Aborted: development component 'tc/SL/UTIL_JDD'/'sap.com'/'SAP AG'/'6.4015.00.0000.20051027101403.0000':

No further description found.

Feb 15, 2006 10:32:05... Info: -

---

Deployment was successful -

---

Feb 15, 2006 10:32:05... Info: Summarizing the deployment results:

Feb 15, 2006 10:32:05... Error: Admitted: C:\Documents and Settings\DKEISERlocal\My Documents\Portal\installs\WAS15\J2EE-RUNT-CD\J2EE-ENG\OFFLINE\SAPJEECOR15_0.SCA

Feb 15, 2006 10:32:05... Error: Admitted: C:\Documents and Settings\DKEISERlocal\My Documents\Portal\installs\WAS15\J2EE-RUNT-CD\J2EE-ENG\OFFLINE\JRFC.SDA

Feb 15, 2006 10:32:06... Error: Processing error. Return code: 4

Have tried everything I know of (restarting, etc.). Also tried to drop the duplicate table and it won't let me. Anyone have any ideas??

Thanks in advance...

[Former Member]

Refer these notes: 756084, 905856 which has solutions for some SDM issues.

If they did not work, I suspect that some of the SP15 files (C:\Documents and Settings\DKEISERlocal\My Documents\Portal\installs\WAS15\J2EE-RUNT-CD\J2EE-ENG\OFFLINE\SAPJEECOR15_0.SCA) are not found or are corrupted. Unarchive again and it should work.

HTH

--

Venkat