disp+work.exe is stopped???

hello friends,

in our ecc6.0 system dip+work.exe stoped. previously i have applying patches in spam. while applying patches system has restarted unfortunately. then only this problem has came.

what shuld i have to do....

Farkath

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)

Hello Farkath,

Please check latest dev_w* and dev_disp trace files under work directory for possible reasons of this issue.

Thanks,

Siva Kumar

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

Comment

hello siva,

this details only be in the dev_w12, hav u got any idea about this issue.

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

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ

B Fri Jan 27 17:43:38 2012

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\SAI\DVEBMGS00\exe\dbmssslib.dll' ...

B Library 'D:\usr\sap\SAI\DVEBMGS00\exe\dbmssslib.dll' loaded

B Version of 'D:\usr\sap\SAI\DVEBMGS00\exe\dbmssslib.dll' is "700.08", patchlevel (0.109)

B New connection 0 created

M sysno 00

M sid SAI

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 111

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 2632

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

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc12 2632) [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) 18672 (1436)

M DpShMCreate: sizeof(tm_adm) 4232256 (21056)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

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

M DpShMCreate: sizeof(slock_adm) 0 (96)

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

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1536)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 089E0040, size: 4892312)

M DpShMCreate: allocated sys_adm at 089E0040

M DpShMCreate: allocated wp_adm at 089E2090

M DpShMCreate: allocated tm_adm_list at 089E6980

M DpShMCreate: allocated tm_adm at 089E69B0

M DpShMCreate: allocated wp_ca_adm at 08DEFDF0

M DpShMCreate: allocated appc_ca_adm at 08DF5BB0

M DpShMCreate: allocated comm_adm at 08DF7AF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 08E789B0

M DpShMCreate: allocated gw_adm at 08E789F0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 08E78A20

M DpShMCreate: allocated wall_adm at 08E78A28

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 12 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M Fri Jan 27 17:43:39 2012

M ThInit: running on host VIJAI

M Fri Jan 27 17:43:40 2012

M calling db_connect ...

C Thread ID:2808

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'D:\usr\sap\SAI\DVEBMGS00\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 110

C patchcomment MSSQL: Connect error handling (1053754)

C Local connection used on VIJAI to named instance: np:VIJAI\SAI

C CopyLocalParameters: dbuser is 'sai'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Fri Jan 27 17:43:55 2012

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err -1, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Fri Jan 27 17:44:11 2012

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Fri Jan 27 17:44:26 2012

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login timeout expired

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Login timeout expired

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err -1, sev 0), SQL Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to np:VIJAI\SAI.

C Retrying without protocol specifier: VIJAI\SAI

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Fri Jan 27 17:44:27 2012

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'VIJAI\SAPServiceSAI'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'VIJAI\SAPServiceSAI'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 4060, sev 0), Cannot open database "SAI" requested by the login. The login failed.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'VIJAI\SAPServiceSAI'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'VIJAI\SAPServiceSAI'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 4060, sev 0), Cannot open database "SAI" requested by the login. The login failed.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23577. hr: 0x8000ffff Login failed for user 'VIJAI\SAPServiceSAI'.

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 18456, sev 0), Login failed for user 'VIJAI\SAPServiceSAI'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 4060, sev 0), Cannot open database "SAI" requested by the login. The login failed.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23577]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn. 0

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

B ***LOG BY0=> Login failed for user 'VIJAI\SAPServiceSAI'. [dbsh#2 @ 1204] [dbsh 1204 ]

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

B ***LOG BY0=> Login failed for user 'VIJAI\SAPServiceSAI'. [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 10283]

M Info for wp 12

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_VB2WP

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

M attachedVm = no VM

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

M *

M * LOCATION SAP-Server VIJAI_SAI_00 on host VIJAI (wp 12)

M * ERROR ThInit: db_connect

M *

M * TIME Fri Jan 27 17:44:27 2012

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

M * COUNTER 1

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 (Workproc12 2632) [dpnttool.c 327]

thans in advance

Farkath

Hello,

Please check the properties of user SAPServiceSAI (like account status, password etc).

LOG BY0=> Login failed for user 'VIJAI\SAPServiceSAI'

Error/Message: (err 4060, sev 0), Cannot open database "SAI" requested by the login. The login failed.

Thanks,

Siva Kumar

Edited by: Siva Kumar Arivinti on Jan 27, 2012 8:15 PM

hello siva.

*******************************************************************************************************************************************************

Info for WP 12

stat = WP_RUN

waiting_for = NO_WAITING

reqtype = DP_RQ_VB2WP

act_reqtype = NO_REQTYPE

rq_info = 0

tid = -1

mode = 255

len = -1

rq_id = 65535

rq_source =

last_tid = 0

last_mode = 0

semaphore = 0

act_cs_count = 0

csTrack = 0

csTrackRwExcl = 0

csTrackRwShrd = 0

control_flag = 0

int_checked_resource(RFC) = 0

ext_checked_resource(RFC) = 0

int_checked_resource(HTTP) = 0

ext_checked_resource(HTTP) = 0

report = > <

action = 0

tab_name = > <

req.vm = no VM

attachedVm = no VM

*****************************************************************************

LOCATION SAP-Server VIJAI_SAI_00 on host VIJAI (wp 12)

ERROR ThInit: db_connect

TIME Fri Jan 27 17:44:27 2012

RELEASE 700

COMPONENT Taskhandler

VERSION 1

RC 13

MODULE thxxhead.c

LINE 10486

COUNTER 1

*****************************************************************************

PfStatDisconnect: disconnect statistics

Entering TH_CALLHOOKS

ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

Entering ThSetStatError

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

Entering ThReadDetachMode

call ThrShutDown (1)...

***LOG Q02=> wp_halt, WPStop (Workproc12 2632) [dpnttool.c 327]

Hello Farkath,

The root cause of this problem is the user SAPServiceSAI. As suggested in my previous comment, please make sure it's not locked out and password is correct.

Thanks,

Siva Kumar

Hello Farkath,

with this issue ....could you please check the following things:

1.SPAM upgrade requires certail "KERNEL PATCH" level.

2.After upgrading spam the filesystem under /USR/SAP/<SID>/EXE/RUN has the proper authorizations or not.

Most of teh time it gets changed from '777' to something else (lets say 447)........

Hope this will be help ful.

Ask a Question

Top Q&A Solution Author

User

Count