work process dies during an Upgrade in Shadow Instance

[Former Member]

Hi all,

Systemconfiguration: Windows 2003 Server SP2 - Oracle 10.2.0.2

during the Upgrade PHASE SET "SETSYNC_EULCK_START_D1 after STARTSAP_IMP nothing more happends on the system. No errors in den SAPup.log etc.

The reason:

I can`t start the shadow Instance. During the start process in mmc the dispatcher + work process died...

Has anyone an Idea....there are som

Here is the dev_w0 logfile:

It might be great if anyone can help me!!!

The errors in a row:

1 - C SQL error 942: 'ORA-00942: table or view does not exist'

B ***LOG BZA=> table SVERS does not exist on database [dblink#5 @ 1299] [dblink 1299 ]

2 -

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 11535]

C OCI-call failed with -1=OCI_ERROR

C SQL error 942: 'ORA-00942: table or view does not exist'

3 -

B ***LOG BZA=> table SVERS does not exist on database [dblink#5 @ 1299] [dblink 1299 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1440]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10504

-

---

trc file: "dev_w0", trc level: 1, release: "700"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Sat Jun 07 12:29:47 2008

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\put\exe\dboraslib.dll' ...

B Library 'E:\usr\sap\put\exe\dboraslib.dll' loaded

B Version of 'E:\usr\sap\put\exe\dboraslib.dll' is "700.08", patchlevel (0.152)

B New connection 0 created

M sysno 50

M sid CDP

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 155

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 3656

M

M kernel runs with dp version 235000(ext=110000) (@(#) DPLIB-INT-VERSION-235000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3656) [dpxxdisp.c 1312]

I

I Sat Jun 07 12:29:49 2008

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 12928 (1616)

M DpShMCreate: sizeof(tm_adm) 5652128 (28120)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000010A80050, size: 6336352)

M DpShMCreate: allocated sys_adm at 0000000010A80050

M DpShMCreate: allocated wp_adm at 0000000010A82150

M DpShMCreate: allocated tm_adm_list at 0000000010A853D0

M DpShMCreate: allocated tm_adm at 0000000010A85430

M DpShMCreate: allocated wp_ca_adm at 0000000010FE92D0

M DpShMCreate: allocated appc_ca_adm at 0000000010FEF090

M DpShMCreate: allocated comm_adm at 0000000010FF0FD0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 0000000011077C60

M DpShMCreate: allocated gw_adm at 0000000011077CE0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0000000011077D10

M DpShMCreate: allocated wall_adm at 0000000011077D20

M rdisp/queue_size_check_value : -> off

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Sat Jun 07 12:29:50 2008

M ThInit: running on host drfeelgood

M

M Sat Jun 07 12:29:51 2008

M calling db_connect ...

C CLIENT_ORACLE_HOME is not set as environment variable or

C DIR_CLIENT_ORAHOME is not set as profile parameter.

C assuming using instant client with unspecified location.

C

C Sat Jun 07 12:29:53 2008

C Oracle Client Version: '10.2.0.1.0'

C

C Sat Jun 07 12:29:55 2008

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3SHD's password

C Connecting as /@CDP on connection 0 (nls_hdl 0) ... (dbsl 700 130308)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 00000000138A2020 000000000A91EC10 00000000138C59C8

C Attaching to DB Server CDP (con_hdl=0,svchp=00000000138C5888,srvhp=00000000138C7CB8)

C

C Sat Jun 07 12:30:20 2008

C Starting user session (con_hdl=0,svchp=00000000138C5888,srvhp=00000000138C7CB8,usrhp=000000000A91F428)

C

C Sat Jun 07 12:30:26 2008

C Now '/@CDP' is connected: con_hdl=0, nls_hdl=0, session_id=55.

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 11535]

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=00000000138C5888,usrhp=000000000A91F428)

C Now I'm disconnected from ORACLE

C Try to connect with default password

C Connecting as SAPSR3SHD/<pwd>@CDP on connection 0 (nls_hdl 0) ... (dbsl 700 130308)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 00000000138A2020 000000000A91EC10 00000000138C59C8

C Starting user session (con_hdl=0,svchp=00000000138C5888,srvhp=00000000138C7CB8,usrhp=000000000A91F428)

C

C Sat Jun 07 12:30:27 2008

C Now 'SAPSR3SHD/<pwd>@CDP' is connected: con_hdl=0, nls_hdl=0, session_id=52.

C Database NLS settings: AMERICAN_AMERICA.UTF8

C DB instance CDP is running on DRFEELGOOD with ORACLE version 10.2.0.2.0 since JUN 07, 2008, 00:35:17

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20080607 122951 DRFEELGOOD

C build_stmt: reallocating stmt buffer: 256 -> 2000 characters

C

C Sat Jun 07 12:30:30 2008

C OCI-call failed with -1=OCI_ERROR

C SQL error 942: 'ORA-00942: table or view does not exist'

B ***LOG BZA=> table SVERS does not exist on database [dblink#5 @ 1299] [dblink 1299 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1440]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10504]

M

M Info for wp 0

M

M pid = 3656

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server drfeelgood_CDP_50 on host drfeelgood (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Sat Jun 07 12:30:30 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10724

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 724]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M

M Sat Jun 07 12:30:31 2008

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3656) [dpnttool.c 333]

[markus_doehr2]

C Sat Jun 07 12:29:53 2008

C Oracle Client Version: '10.2.0.1.0'

First: you are using an unsupported Oracle instantclient version - install 10.2.0.2.

To you actual problem: It seems that the shadow instance hasn´t been created correctly - I suggest you open an OSS call so people can investigate on the system.

Markus

[Former Member]

Hi Markus,

thks for your advise. I already updated the Oracle Client to version 10.2.0.2.

The upgrade from CRM 5.0 to CRM 6.0 - 2007 is still running, but theres nothing happens in PHASE SETSYNC_EULCK_D1. This Phase comes after the EU_Imports 1-7.

In the log directory there ist also nothing the indicates about errors.

Here is the last SAPUp.log entries

1. ************************* SAPup started in UPGRADE mode *************************

2. This is SAPup version 7.00/2 patch level 24.103.

3. This is UNICODE SAPup!

4. Reading Parameter File "E:\usr\sap\put\bin\DBSYNC.PAR" at 20080607162600

5. Condition level 1, total => TRUE '#if ( "ORA" == "ORA" )' => TRUE

6. Reading Parameter File "E:\usr\sap\put\bin\R3CURENV.LST" at 20080607162600

...begin dialogue at 20080607162603

...end dialogue at 20080607162607

...STARTED at 20080607162607.

1. Reading Parameter File "E:\usr\sap\put\bin\TRATTR.LST" at 20080607162607

2. Reading Parameter File "E:\usr\sap\put\bin\TRGROUP.LST" at 20080607162607

3. Reading Parameter File "E:\usr\sap\put\bin\R3CURENV.LST" at 20080607162607

4. Reading Parameter File "E:\usr\sap\put\bin\DBSWTC.PAR" at 20080607162607

5. Condition level 1, total => FALSE '#if "ORACLE" == "SAPDB"' => FALSE

6. Condition level 1, total => FALSE '#elseif "ORACLE" == "DB2-z/OS"' => FALSE

7. Condition level 1, total => FALSE '#elseif "ORACLE" == "DB2/400"' => FALSE

8. Condition level 1, total => FALSE '#elseif "ORACLE" == "DB6"' => FALSE

9. Condition level 1, total => FALSE '#elseif "ORACLE" == "INFORMIX"' => FALSE

10. Condition level 1, total => FALSE '#elseif "ORACLE" == "MSSQL"' => FALSE

11. Condition level 1, total => TRUE '#elseif "ORACLE" == "ORACLE"' => TRUE

12. Condition level 1, total => FALSE '#if "Windows NT X86_64" ~= "Linux"' => FALSE

13. Condition level 1, total => FALSE '#elseif "Windows NT X86_64" ~= "Windows NT INTEL"' => FALSE

14. Condition level 1, total => FALSE '#elseif "Windows NT X86_64" ~= "Windows NT IA64"' => FALSE

15. Condition level 1, total => TRUE '#elseif "Windows NT X86_64" ~= "Windows NT X86_64"' => TRUE

...begin dialogue at 20080607162610

...end dialogue at 20080607162615

...begin dialogue at 20080607162615

...end dialogue at 20080607162637

UPGRADEPHASE SETSYNC_EULCK_START_D1

...started at 20080607162637

1. Setting syncpoint EU_LOCKED=STARTED in E:\usr\sap\put\mig\SYNC.DAT

At the usr sap put tmp directory, that shows the current activitiy of the upgrade, there also nothing happens.

if i have to start the shadow instance in the mmc manually at this time of the upgrade phase....at this time it doesnt work, but i dont find anything in the upgrade documentation.

Cheers Mario

[markus_doehr2]

Is this a combined ABAP + Java instance?

And: I HIGHLY suggest using the very latest version of SAPup and fixpack, we had several errors where the development needed to fix things manually.

One error is not yet in the actual fixpack.

Markus

[Former Member]

Hi Markus,

yes is a double stack ABAP & JAVA System.

How can i check the sapup version and what did you recommend ?

The shadowinstance is not possible to start at this time. I test it with the command line command: sapup startshd .....its not possible before phase START_SHDI_FIRST

[markus_doehr2]

The reason, why the upgrade is not progressing, is the fact, that the Java upgrade must run in parallel. The system waits for the Java instance to reach a certain point of the upgrade also.

So you have to start SAPJup also, do prepare, bind support packages etc. - just as you were doing an ABAP upgrade.

Markus

[Former Member]

Yes i know. I start the jave upgrade parallel. the Java upgrade Manager is in the PHASE GETSYNC_PREUPTIME_FINSISHED...

But it doesn`t run.....i repeat and initialize the last ABAP phase twice but nothing in the status.

Do you mean it is helpful to repeat the java phase ? When i start the startgui.bat in the usr-sap-jupgrade-exe directory in show the last phase, i can`t see a possobility to repeat the phase.

[markus_doehr2]

I see...

hmm.. it´s very difficult to "debug" this problem remotely. I suggest you open an OSS call and let the support people have a look on the system.

Markus

[Former Member]

At this time of the Upgrade, the Shadow instance couldn`t run. It was that Problem ->