Shadow Instance Not Starting NW04s SR2

[Former Member]

I'm on my 3rd of trying to get the shadow instance up, and I have no where else but this forum.

This is the error that I get when the shadow instance is trying to start (by the way, the central instance starts okay...no problems):

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Sat Feb 03 10:24:18 2007

B create_con (con_name=R/3)

B Loading DB library 'd:\usr\sap\put\exe\dbmssslib.dll' ...

B Library 'd:\usr\sap\put\exe\dbmssslib.dll' loaded

B Version of 'd:\usr\sap\put\exe\dbmssslib.dll' is "700.08", patchlevel (0.87)

B New connection 0 created

M sysno 08

M sid NIS

M systemid 561 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 95

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 6148

M

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

M length of sys_adm_ext is 572 bytes

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

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) 23552 (1472)

M DpShMCreate: sizeof(tm_adm) 5584592 (27784)

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 (1848)

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

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000D0E0050, size: 6278912)

M DpShMCreate: allocated sys_adm at 000000000D0E0050

M DpShMCreate: allocated wp_adm at 000000000D0E1F40

M DpShMCreate: allocated tm_adm_list at 000000000D0E7B40

M DpShMCreate: allocated tm_adm at 000000000D0E7BA0

M DpShMCreate: allocated wp_ca_adm at 000000000D63B270

M DpShMCreate: allocated appc_ca_adm at 000000000D641030

M DpShMCreate: allocated comm_adm at 000000000D642F70

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000D6C9C00

M DpShMCreate: allocated gw_adm at 000000000D6C9C80

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000D6C9CB0

M DpShMCreate: allocated wall_adm at 000000000D6C9CC0

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 ThInit: running on host fmsap653

M calling db_connect ...

C Thread ID:4476

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'd:\usr\sap\put\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 87

C patchcomment MSSQL: UTAB/ATAB/Dynp-access via clientside cursor (1002914)

C np:(local) connection used on FMSAP653

C CopyLocalParameters: dbuser is 'nis_shd'

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: MARS property was not set.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'nis_shd' setuser 'nis_shd']

C sloledb.cpp [ExecuteAndFlush,line 6430]: Error/Message: (err 4604, sev 0), There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'nis_shd' failed -- connect terminated

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'nis_shd' setuser 'nis_shd']

C sloledb.cpp [ExecuteAndFlush,line 6430]: Error/Message: (err 4604, sev 0), There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'nis_shd' failed -- connect terminated

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'nis_shd' setuser 'nis_shd']

C sloledb.cpp [ExecuteAndFlush,line 6430]: Error/Message: (err 4604, sev 0), There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'nis_shd' failed -- connect terminated

C failed to establish conn to np:(local).

C Retrying without protocol specifier: (local)

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'nis_shd' setuser 'nis_shd']

C sloledb.cpp [ExecuteAndFlush,line 6430]: Error/Message: (err 4604, sev 0), There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'nis_shd' failed -- connect terminated

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'nis_shd' setuser 'nis_shd']

C sloledb.cpp [ExecuteAndFlush,line 6430]: Error/Message: (err 4604, sev 0), There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'nis_shd' failed -- connect terminated

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'nis_shd' setuser 'nis_shd']

C sloledb.cpp [ExecuteAndFlush,line 6430]: Error/Message: (err 4604, sev 0), There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'nis_shd' failed -- connect terminated

C failed to establish conn. 0

B ***LOG BY2=> sql error 0 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> <message text not available> [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 0 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> <message text not available> [dblink#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

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 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 vm = no VM

M

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

M *

M * LOCATION SAP-Server fmsap653_NIS_08 on host fmsap653 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Sat Feb 03 10:24:18 2007

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10439

M * COUNTER 1

M *

M Sat Feb 03 10:24:19 2007

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 720]

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

M Entering ThSetStatError

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

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

[Former Member]

Hi guys,

I had the same problem.

SAP Notes 551915 and 849142 should solve the problem.

Regards,

Prasad

[Former Member]

My setup is on a Windows/SQL2000. I'm upgrading from Nw04 to NW04s SR2. I've update sapup.exe and the java and abap upgrade fix also.

What's weird is that the shadow instance was working up to this point. There were no changes to any memory settings, and it's on 64-bit with 18GB of RAM and unicode.

[former_member185954]

Hi,

Have you paid attention to the SAP Note which the logs are referring to ?

Note 734034 - Native OLEDB provider SQLNCLI

Also it might help checking these notes:

Note 799058 - Setting Up Microsoft SQL Server 2005

Note 639702 - JDBC driver for MS SQL Server

Regards,

Siddhesh

[Former Member]

Hi Vu,

This might me a user/groups related error as the log shows:

ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'nis_shd' setuser 'nis_shd']

C sloledb.cpp [ExecuteAndFlush,line 6430]: Error/Message: (err 4604, sev 0),

There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

sql error 0 performing CON

nis_shd is being used to connect to the DB and its not available. Could you check

if this user is existing and has proper access to the DB.

Regards

Srikishan

[Former Member]

Hi

as per the error msg

"Error/Message: (err 4604, sev 0), There is no such user or group 'nis_shd'.

C Procname: [ExecuteAndFlush - no proc]

C setuser<b> 'nis_shd'</b> failed -- connect terminated

C failed to establish conn. 0

B ***LOG BY2=> sql error 0 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> <message text not available> [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 0 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> <message text not available> [dblink#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

have you done this..

• You have to login as root and enter: <b>the shadow dispatcher instance</b> sapdp<shadow instance number> in /etc/services with number 3212

• Please create the user for the shadow instance by executing

SQL script <b>crshdusr.sql</b>. [which is available in “/DEPOT” directory].

To run the script logon as ora<sid> user and copy the script

“crshdusr.sql” from “/DEPOT” to $ORACLE_HOME/dbs:

cd $ORACLE_HOME/dbs;

cp /DEPOT/crshdusr.sql .

Execute the script by calling ??

and check wthr you are able to connect to Shadow instance using RFC connection (by logging into central instance, using 000/"ddic" & "SAP_UPGRADE_SHADOW_SYSTEM" .

hope this info help you!

with regards,

raj.

<i>pls, award points</i>

[Former Member]

Thanks for this tip. My system is not on Oracle but I'll try to find the script to create this user in MSSQL2000.

[Former Member]

By the way, I've checked the "services" file, and it seems to be okay.

sapmsSHDNIS 3608/tcp #Upgrade shadow instance

sapdp08 3208/tcp #Upgrade shadow instance

sapgw08 3308/tcp #Upgrade shadow instance

> Hi

> as per the error msg

> "Error/Message: (err 4604, sev 0), There is no such

> user or group 'nis_shd'.

> C Procname: [ExecuteAndFlush - no proc]

> C setuser<b> 'nis_shd'</b> failed -- connect

> terminated

> C failed to establish conn. 0

> B ***LOG BY2=> sql error 0 performing CON [dbsh#2 @

> 1204] [dbsh 1204 ]

> B ***LOG BY0=> <message text not available> [dbsh#2 @

> 1204] [dbsh 1204 ]

> B ***LOG BY2=> sql error 0 performing CON [dblink#3 @

> 431] [dblink 0431 ]

> B ***LOG BY0=> <message text not available> [dblink#3

> @ 431] [dblink 0431 ]

> M ***LOG R19=> ThInit, db_connect ( DB-Connect

> 000256) [thxxhead.c 1426]

> M in_ThErrHandle: 1

> M *** ERROR => ThInit: db_connect (step 1, th_errno

> 13, action 3, level 1) [thxxhead.c 10240]"

>

> have you done this..

> • You have to login as root and enter: <b>the shadow

> dispatcher instance</b> sapdp<shadow instance number>

> in /etc/services with number 3212

>

> • Please create the user for the shadow instance by

> executing

> SQL script <b>crshdusr.sql</b>. [which is available

> in “/DEPOT” directory].

> To run the script logon as ora<sid> user and copy the

> script

> “crshdusr.sql” from “/DEPOT” to $ORACLE_HOME/dbs:

> cd $ORACLE_HOME/dbs;

> cp /DEPOT/crshdusr.sql .

> Execute the script by calling ??

>

> and check wthr you are able to connect to Shadow

> instance using RFC connection (by logging into

> central instance, using 000/"ddic" &

> "SAP_UPGRADE_SHADOW_SYSTEM" .

>

>

> hope this info help you!

> with regards,

> raj.

>

>

> <i>pls, award points</i>

[Former Member]

Hi

have you checked this..

For SQL 2000 users:

The new provider can be used as a client for SQL 2000 systems as long as the SQLNCLI version is SQL2005 SP1 or later. Do not use the RTM version because some errors were discovered which are fixed in SP1.

more on this. .please go thru this note <a href="https://websmp206.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=734034">Note 734034 - Native OLEDB provider SQLNCLI</a>

hope this will help you!

Good Luck!!

raj.

<i>pls, award points</i>

[Former Member]

I downloaded this but it still didn't work.

The only other thing I can try is run the create shadow user script. I can't do that because only the dba is allowed to do that at my company.

[Former Member]

It seems that the issue that I have encountered is a known problem if you are upgrading a system that has been "refreshed" in the past.

This is the solution:

Symptoms: CONFIGURE_IIOP_SERVICE phase with erro saying “Could not find configuration for instance with id"

1) Start configtool

2) Change the global dispatcher and server configuration of the iiop service so that its startup mode is set to always

3) Add to the JVM parameters of the server the following parameter:

-Dorg.omg.PortableInterceptor.ORBInitializerClass.com.sap.engine.services.ts.jts.ots.PortableInterceptor.JTSInitializer

4) Apply the changes and restart engine

5) Resume the upgrade

6) Repeat the phase, when the phase fails select Ignore error and go to next phase.

When you are prompted for the password needed to skip this phase, enter: 14620348

7) Continue the upgrade

[Former Member]

Thanks, everyone.

I've completed the upgrade today. Yeah!

Keep in mind the following for your next upgrade:

- Update to the latest kernel (very important)

- Update to the latest sapup.exe or r3up.exe

[vincentlim826]

Hi,

the error below seems to be memory issue.

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

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed

Did you implement ZAMM (SAP Note 88416) (I believe you're in Windows environment) ? or have you modify any memory parameters ? i.e

rdisp/ROLL_MAXFS

rdisp/ROLL_SHM..

rdisp/PG_MAXFS..

rdisp/PG_SHM....

What is the output of "R3trans -dx " ?

Please check the environment variables set for user <sid>adm and ora<sid>.

Could it be wrong db schema ?

Regards,

Vincent

[Former Member]

Also, I'm at the Java upgrade phase of CONFIGURE_IIOP_SERVICE, and the ABAP upgrade is waiting for the JAVA Upgrade phase to complete.