Skip to Content
author's profile photo Former Member
Former Member

EU_SWITCH error in upgrade from ehp5 to ehp7

Hello,

Soon after entering the downtime (Execution) phase I recieved the errror -


Severe error(s) occured in phase MAIN_SWITCH/EU_SWITCH!
Last error code set: tp failed with return code 237, check /usr/sap/SBA/SUM/abap/log/TPSQLSTD.OUT

When I check the log I find :

EXECUTING /usr/sap/SBA/SUM/abap/exe/tp pf=/usr/sap/SBA/SUM/abap/var/DEFAULT.TPP execdbscript SBA -x ../var/EU_SWITC.XQL DBEXECNONT

This is tp version 380.07.32 (release 740)

INFO: XDNLevelTraceSetLocation: Trace set to: XDNTrace.038026.*

ERROR: Statement: RENAME "USMD0020?" TO "USMD0020"

ERROR: ERROR 1024: DB object does already exist

ERROR: SQL ERROR -601: USMD0020 in R3SBADATA type *FILE already exists. MSGID= Job=316145/SBAADM/QZSHSH

Log /usr/sap/sba/sum/abap/log/EU_SWITC.XUT contains the following message:

************Beginning of data**************

tp_exec_statement: RENAME "USMD0020?" TO "USMD0020"

TPERR- (row already exists)

tp_exec_dbscript: 0 statement(s) successfully processed.

1 statement(s) returned an error code.

************End of Data********************


When I check the database I find that the table USMD0020 does in fact exist. In this case, is the solution to simply rename the table to another name and proceed?

Our platform is IBM iSeries if that is important.

Thanks,

Craig

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 07, 2013 at 11:44 PM

    ERROR: Statement: RENAME "USMD0020?" TO "USMD0020"

    I would take an export of that table (backup) and then drop it.

    Repeat the phase.

    Have a look at this SAP note which is Oracle specific but the issue is almost similar.

    1844436 - ORA-00955: name is already used by an existing object

    Regards

    RB

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2013 at 11:45 PM

    Hi,

    Did you try to rerun this phase. I have see that most of the times the issue is not seen if you retry it.

    But an old note.

    500297 - Additional Information: Upgrade to SAP Web AS 6.20: iSeries

    Can you please also confirm that you are using the latest kernel in 740 release.

    Thanks

    Rishi Abrol

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 07:23 PM


    Hello - OSS responded to my inquiry with the suggestion that I rename the table and the upgrade was able to complete. A second test upgrade yielded the same problem and the same solution was used there.

    Thanks

    Craig

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.