Skip to Content
0
Former Member
Feb 16, 2009 at 10:19 AM

DB connect problem,Disp+Work.exe dies and the work processes die on startup

185 Views

Dear Experts,

I am getting the error on SAP startup,Disp+Work.exe dies and the work processes die on startup.

I found below error in my DEV_W0 trace as below

*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() != 'pec' setuser 'pec']*

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

*C Procname: [ExecuteAndFlush - no proc]*

But i could see the user 'pec' is availble in my database users list with db_owner , public permissions also been assigned to it.

However When trying to delete a user on SQL server 2000, we recieve the message "You cannot drop the selected login ID because that login ID owns objects in one or more databases.".

Please refer the below work process trace and please suggest the possible solution..

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Feb 14 15:10:21 2009

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\PEC\SYS\exe\run\dbmssslib.dll' ...

B Library 'E:\usr\sap\PEC\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'E:\usr\sap\PEC\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.195)

B New connection 0 created

M sysno 00

M sid PEC

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 196

M intno 20020600

M make: multithreaded, Unicode

M pid 3844

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 21120 (1320)

M DpShMCreate: sizeof(tm_adm) 29558776 (14772)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpShMCreate: sizeof(comm_adm) 1160000 (580)

M DpShMCreate: sizeof(vmc_adm) 0 (424)

M DpShMCreate: sizeof(wall_adm) (384056/329560/64/184)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 07800040, size: 31492672)

M DpShMCreate: allocated sys_adm at 07800040

M DpShMCreate: allocated wp_adm at 07801B88

M DpShMCreate: allocated tm_adm_list at 07806E08

M DpShMCreate: allocated tm_adm at 07806E30

M DpShMCreate: allocated wp_ca_adm at 09437628

M DpShMCreate: allocated appc_ca_adm at 0943D3E8

M DpShMCreate: allocated comm_adm_list at 0943F328

M DpShMCreate: allocated comm_adm at 0943F340

M DpShMCreate: allocated vmc_adm_list at 0955A680

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0955A6A8

M DpShMCreate: allocated wall_adm at 0955A6B0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Sat Feb 14 15:10:22 2009

M calling db_connect ...

C Thread ID:3868

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'E:\usr\sap\PEC\SYS\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 195

C patchcomment DBCON: database names must not start with digits (1078650)

C np:(local) connection used on CAMBSVR15

C CopyLocalParameters: dbuser is 'pec'

C

C Sat Feb 14 15:10:23 2009

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

C Sat Feb 14 15:10:26 2009

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

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'pec' 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() != 'pec' setuser 'pec']

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'pec' 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() != 'pec' setuser 'pec']

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'pec' 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() != 'pec' setuser 'pec']

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'pec' 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() != 'pec' setuser 'pec']

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'pec' 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() != 'pec' setuser 'pec']

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'pec' failed -- connect terminated

C failed to establish conn. 0

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

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

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

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

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 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

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

M *

M * LOCATION SAP-Server cambsvr15_PEC_00 on host cambsvr15 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat Feb 14 15:10:26 2009

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9806

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

I would greatly appriciate your quick response, Since it is a production issue.

Many Thanks,

Vinod