Reset Upgrade of BI on MAIN_SHDRUN/ACT_UPG

Hi Expert,

I have upgrade the BI Production server via SUM tool, I need to reset the hole upgrade on Preprocessing phase " MAIN_SHDRUN/ACT_UPG" so please provide the procedure to reset the hole upgrade on wiondows at this point ( Shadow system is running now).

Regards

Ashwani

SAP Managed Tags:
NW AS Java Administrator (NWA)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

You can't simply click on a reset button now, too many changes has been done.

Any particular reason for the reset?...

You'll need to do a DB restore and a full cleanup of the shadow instance services.

Regards, Juan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Juan,

I need the procedure only via SUM tool, we cann not restore the DB, How to reset also shadow instance

Regards

Ashwani

As far as I know you can't once an upgrade starts is meant to be finished... thats why im asking if you have any particular reason to "reset" the upgrade.

Regards, Juan

Hello Ashwani,

Juan is rite, you can's reset upgrade during MAIN phase. The only way is to restore the database backup and restart the upgrade or if you have backup of database & SUM folder during middle of the phase you can try that too. However, What error you are facing to reset the upgrade ?

Thanks,
Arjun

Hi Juan,

System is stuck on this phase and we need to up system immedeatly, so we have change the plan for next month of starting the upgradation. so i request to you i need the reset the holl upgrade and system need to up on previus stage.

Regards

Ashwani

Hi Ashwani,

Please find the SAP Note Note 417670 for Resetting the upgrade.

Request you to please go through the SAP Note and follow all the steps which is useful as per your release.

Regards,

Anil Shenoy

Well, ACT_UPG is on the preprocessing phase so in theory your system should be still available as you have not reached the downtime/execution phase.

My best piece of advice in the case you have to "reset" the upgrade and you want a clean start is to restore the DB and cleanup the previous attempt (if possible)

Regards, Juan

Hi Juan,

Thanks for the reply and support!

I have DB backup of before start the upgradation, but My one process chain extract the Data fromECC to BI, So taht i have no chance to restore the DB for Upgrade shadow cleanup.

If i reset the upgrade at this point as per you shadow system not clean, i need to restore the DB for shadow cleanup!

Any other option to reset the hole upgrade automatically.

Regards

Ashwani

I have DB backup of before start the upgradation, but My one process chain extract the Data fromECC to  BI, So taht i have no chance to restore the DB for Upgrade shadow cleanup.

Sorry I didn't understand that, can you rephrase it

Hi Juan ,

I have the similiar issue . My NW7.4 upgrade is in ACT_UPG phase and it is hang from last one day, there are no log updates . Initially there was memory issue , there was not enough free memory in the system due to which it was in hnag state but now i have 6 GB free Ram in the system. Still the upgrade is in same state no log updates , so how should i go further. Can you quickly advice me the thing need to be done to proceed upgrade.

Find the SAPup.ECO Log below :

=================================================================

EXECUTING /oracle/SBD/SUM/SUM/abap/exe/tp pf=/oracle/SBD/SUM/SUM/abap/var/ACTUPG.TPP put SBD
This is tp version 380.18.82 (release 741, unicode enabled)
Looking for effective putsteps ... ... ready (looking for putsteps)
tp[S](LinStackBacktrace+0x8c)[0x433e13]
tp[S](LinStack+0x35)[0x43772e]
tp[S](CTrcStack2+0x48)[0x43838e]
tp[S](tp_trc_print_stack+0x20)[0x5f7660]
tp[S](tp_exit_on_signals+0x64)[0x5ffb94]
libclntsh.so.11.1[N](sslssAsynchHdlr+0x1b2)[0x7fead4ec9586]
libclntsh.so.11.1[N](sslsshandler+0x91)[0x7fead4ec8db5]
libc.so.6[T][0x3e32832920]
libc.so.6[T](nanosleep+0x10)[0x3e328acb70]
libc.so.6[T](sleep+0xe0)[0x3e328aca00]
tp[S](tp_getprots+0xe98)[0x556508]
tp[S](tp_batch+0x91a)[0x55dcfa]
tp[S](tp_exec+0xe075)[0x54f615]
tp[S](nlsui_main+0xdf)[0x551bff]
libc.so.6[T](__libc_start_main+0xfd)[0x3e3281ecdd]

### Phase MAIN_SHDRUN/ACT_UPG:
SAPup> Starting subprocess with PID 15203 in phase 'ACT_UPG' at 20140821212648
    ENV: DIR_LIBRARY=/oracle/SBD/SUM/SUM/abap/exe
    ENV: LD_LIBRARY_PATH=/oracle/SBD/SUM/SUM/abap/exe:/oracle/SBD/SUM/SUM/jvm/jre/lib/amd64/server:/oracle/SBD/SUM/SUM/jvm/jre/lib/amd64:/oracle/SBD/SUM/SUM/jvm/jre/../lib/amd64:/oracle/SBD/SUM/SUM/abap/exe/:/usr/sap/SBD/SYS/exe/uc/linuxx86_64:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/SBD/112_64
    ENV: ORACLE_SID=SBD
    ENV: PATH=/oracle/SBD/SUM/SUM/abap/exe:/oracle/SBD/112_64/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/SBD/SYS/exe/uc/linuxx86_64:/usr/sap/SBD/SYS/exe/run:/home/sbdadm:.
    ENV: SAPDATA_HOME=/oracle/SBD
    ENV: SAPSYSTEMNAME=SBD
    ENV: auth_shadow_upgrade=1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPBIW
    ENV: dbs_ora_tnsname=SBD

EXECUTING /oracle/SBD/SUM/SUM/abap/exe/tp pf=/oracle/SBD/SUM/SUM/abap/var/ACTUPG.TPP put SBD
This is tp version 380.18.82 (release 741, unicode enabled)
Looking for effective putsteps ... ... ready (looking for putsteps)
tp[S](LinStackBacktrace+0x8c)[0x433e13]
tp[S](LinStack+0x35)[0x43772e]
tp[S](CTrcStack2+0x48)[0x43838e]
tp[S](tp_trc_print_stack+0x20)[0x5f7660]
tp[S](tp_exit_on_signals+0x64)[0x5ffb94]
libclntsh.so.11.1[N](sslssAsynchHdlr+0x1b2)[0x7f3f3dab4586]
libclntsh.so.11.1[N](sslsshandler+0x91)[0x7f3f3dab3db5]
libc.so.6[T][0x3e32832920]
libc.so.6[T](nanosleep+0x10)[0x3e328acb70]
libc.so.6[T](sleep+0xe0)[0x3e328aca00]
tp[S](tp_getprots+0xe98)[0x556508]
tp[S](tp_batch+0x215)[0x55d5f5]
tp[S](tp_exec+0xe075)[0x54f615]
tp[S](nlsui_main+0xdf)[0x551bff]
libc.so.6[T](__libc_start_main+0xfd)[0x3e3281ecdd]

### Phase MAIN_SHDRUN/ACT_UPG:
SAPup> Starting subprocess with PID 29221 in phase 'ACT_UPG' at 20140821230514
    ENV: DIR_LIBRARY=/oracle/SBD/SUM/SUM/abap/exe
    ENV: LD_LIBRARY_PATH=/oracle/SBD/SUM/SUM/abap/exe:/oracle/SBD/SUM/SUM/jvm/jre/lib/amd64/server:/oracle/SBD/SUM/SUM/jvm/jre/lib/amd64:/oracle/SBD/SUM/SUM/jvm/jre/../lib/amd64:/usr/sap/SBD/SYS/exe/run:/usr/sap/SBD/SYS/exe/uc/linuxx86_64:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/SBD/112_64
    ENV: ORACLE_SID=SBD
    ENV: PATH=/oracle/SBD/SUM/SUM/abap/exe:/oracle/SBD/112_64/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/SBD/SYS/exe/uc/linuxx86_64:/usr/sap/SBD/SYS/exe/run:/home/sbdadm:.
    ENV: SAPDATA_HOME=/oracle/SBD
    ENV: SAPSYSTEMNAME=SBD
    ENV: auth_shadow_upgrade=1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPBIW
    ENV: dbs_ora_tnsname=SBD

================================================================

SAPup.Log :

================================================================

CURRENTPHASE MAIN_SHDRUN/ACT_UPG
...started at 20140821145521
#
# ************************* SAPup started in UPGRADE mode *************************
# This is SAPup release lmt_006 version 55.000 compile time 23:38:33 Jul 5 2014.
# Command line: '/oracle/SBD/SUM/SUM/abap/bin/SAPup stdout=/oracle/SBD/SUM/SUM/abap/log/SAPup.out rootdir=/oracle/SBD/SUM/SUM/abap uaport=4240 restart=3'
# Running in graphics mode batch.
# DB-functions initialized for 'ORACLE'.
# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'handleerror' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.
# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.
# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.
# GUI reports feature 'unitstatus' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'actions' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'mid' as 'enabled' level 4, user said 'unknown'.
# GUI reports feature 'exit' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'evaluation' as 'enabled' level 1, user said 'unknown'.
# GUI reports feature 'newhttpsrv' as 'unknown' level 0, user said 'unknown'.
STARTUP 20140821212629
Current unit is 'PRE-EXECUTE', next unit is 'PRE-EXECUTE'.
-> decided to continue with unit PRE-EXECUTE.
...begin dialog at 20140821212630
...end dialog at 20140821212640
..answered at 20140821212640.
-> decided to try again with "init".
# Executing module 'MAIN_SHDRUN'.

Execution of MAIN module "Shadow System Operations: SPDD and Activation" begins at 20140821212640

# Starting phase execution with maxpar = 3, scheduled: 9x'-' 3x'+' '|' 104x'-'

CURRENTPHASE MAIN_SHDRUN/ACT_UPG
...started at 20140821212640
# SPDD is not necessary in this system for phase ACT_UPG
...begin processing at 20140821212644
#
# ************************* SAPup started in UPGRADE mode *************************
# This is SAPup release lmt_006 version 55.000 compile time 23:38:33 Jul 5 2014.
# Command line: '/oracle/SBD/SUM/SUM/abap/bin/SAPup stdout=/oracle/SBD/SUM/SUM/abap/log/SAPup.out rootdir=/oracle/SBD/SUM/SUM/abap uaport=4240 restart=3'
# Running in graphics mode batch.
# DB-functions initialized for 'ORACLE'.
# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'handleerror' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.
# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.
# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.
# GUI reports feature 'unitstatus' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'actions' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.
# GUI reports feature 'mid' as 'enabled' level 4, user said 'unknown'.
# GUI reports feature 'exit' as 'unknown' level 0, user said 'unknown'.
# GUI reports feature 'evaluation' as 'enabled' level 1, user said 'unknown'.
# GUI reports feature 'newhttpsrv' as 'unknown' level 0, user said 'unknown'.
STARTUP 20140821230446
Current unit is 'PRE-EXECUTE', next unit is 'PRE-EXECUTE'.
-> decided to continue with unit PRE-EXECUTE.
...begin dialog at 20140821230450
...end dialog at 20140821230503
..answered at 20140821230503.
-> decided to try again with "init".
# Executing module 'MAIN_SHDRUN'.

Execution of MAIN module "Shadow System Operations: SPDD and Activation" begins at 20140821230504

# Starting phase execution with maxpar = 3, scheduled: 9x'-' 3x'+' '|' 104x'-'

CURRENTPHASE MAIN_SHDRUN/ACT_UPG
...started at 20140821230504
# SPDD is not necessary in this system for phase ACT_UPG
...begin processing at 20140821230507
dqss4003:sbdadm 128>

================================================================

TP.ECO Log

SAPup> Starting subprocess with PID 29217 in phase 'ACT_UPG' at 20140821230513
    ENV: DIR_LIBRARY=/oracle/SBD/SUM/SUM/abap/exe
    ENV: LD_LIBRARY_PATH=/oracle/SBD/SUM/SUM/abap/exe:/oracle/SBD/SUM/SUM/jvm/jre/lib/amd64/server:/oracle/SBD/SUM/SUM/jvm/jre/lib/amd64:/oracle/SBD/SUM/SUM/jvm/jre/../lib/amd64:/usr/sap/SBD/SYS/exe/run:/usr/sap/SBD/SYS/exe/uc/linuxx86_64:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/SBD/112_64
    ENV: ORACLE_SID=SBD
    ENV: PATH=/oracle/SBD/SUM/SUM/abap/exe:/oracle/SBD/112_64/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/SBD/SYS/exe/uc/linuxx86_64:/usr/sap/SBD/SYS/exe/run:/home/sbdadm:.
    ENV: SAPDATA_HOME=/oracle/SBD
    ENV: SAPSYSTEMNAME=SBD
    ENV: auth_shadow_upgrade=1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPBIW
    ENV: dbs_ora_tnsname=SBD

EXECUTING /oracle/SBD/SUM/SUM/abap/exe/tp pf=/oracle/SBD/SUM/SUM/abap/var/SHADOW.TPP delstopmark buffer=SBD
This is tp version 380.18.82 (release 741, unicode enabled)
tp finished with return code: 0
meaning:
Everything OK

================================================================

Ask a Question

Top Q&A Solution Author

User

Count