RE: 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

      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

      User Rating: Be the first one !
      Ben Bolker Reviewer Asked on November 2, 2016 in 60 upgrade.
      Add Comment
      1 Answers

        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 Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.