Skip to Content
author's profile photo Former Member
Former Member

When the sap server restart, despatcher is not getting started showing the error

---------------------------------------------------

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

---------------------------------------------------

*

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, M

*

B

B Fri Sep 25 03:02:07 2015

B create_con (con_name=R/3)

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

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

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

B New connection 0 created

M sysno 00

M sid SPP

M systemid 562 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 347

M intno 20020600

M make: multithreaded, ASCII, 64 bit

M pid 4000

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 24400 (976)

M DpShMCreate: sizeof(tm_adm) 3267456 (16256)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 212000 (424)

M DpShMCreate: sizeof(vmc_adm) 0 (448)

M DpShMCreate: sizeof(wall_adm) (22440/36712/56/104)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000EA70050, size: 3593376)

M DpShMCreate: allocated sys_adm at 000000000EA70050

M DpShMCreate: allocated wp_adm at 000000000EA71880

M DpShMCreate: allocated tm_adm_list at 000000000EA777D0

M DpShMCreate: allocated tm_adm at 000000000EA777F8

M DpShMCreate: allocated wp_ca_adm at 000000000ED95378

M DpShMCreate: allocated appc_ca_adm at 000000000ED999C8

M DpShMCreate: allocated comm_adm_list at 000000000ED9B138

M DpShMCreate: allocated comm_adm at 000000000ED9B150

M DpShMCreate: allocated vmc_adm_list at 000000000EDCED70

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000EDCED98

M DpShMCreate: allocated wall_adm at 000000000EDCEDA8

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M ThTaskStatus: rdisp/reset_online_during_debug 0

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 tskh_init: rdisp/cleanup_after_crash = 1

M

M Fri Sep 25 03:02:08 2015

M calling db_connect ...

C Warning: Env(MSSQL_SERVER) [ECCPRD] <> Prof(dbs/mss/server) [eccprd]. Profile value will be used.

C Thread ID:3996

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 350

C patchcomment Tp import: error 13 on MAIN IMPORT (1515557)

C np:(local) connection used on ECCPRD

C CopyLocalParameters: dbuser is 'spp'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23604. hr: 0x8000ffff Login failed for user 'ECCPRD\SAPServiceSPP'.

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

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23604]: 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 23604. hr: 0x8000ffff Login failed for user 'ECCPRD\SAPServiceSPP'.

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

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23604]: 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 23604. hr: 0x8000ffff Login failed for user 'ECCPRD\SAPServiceSPP'.

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

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

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

C Retrying without protocol specifier: (local)

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C OpenOledbConnection: line 23604. hr: 0x8000ffff Login failed for user 'ECCPRD\SAPServiceSPP'.

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

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23604]: 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 23604. hr: 0x8000ffff Login failed for user 'ECCPRD\SAPServiceSPP'.

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

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23604]: 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 23604. hr: 0x8000ffff Login failed for user 'ECCPRD\SAPServiceSPP'.

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

C Procname: [OpenOledbConnection - no proc]

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

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23604]: 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 0 performing CON [dbsh#4 @ 1208] [dbsh 1208 ]

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

B ***LOG BY2=> sql error 0 performing CON [dblink#6 @ 430] [dblink 0430 ]

B ***LOG BY0=> <message text not available> [dblink#6 @ 430] [dblink 0430 ]

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

M in_ThErrHandle: 1

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

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 eccprd_SPP_00 on host eccprd (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Fri Sep 25 03:02:08 2015

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9993

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 25, 2015 at 04:37 PM

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

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

    B ***LOG BY2=> sql error 0 performing CON [dblink#6 @ 430] [dblink 0430 ]

    B ***LOG BY0=> <message text not available> [dblink#6 @ 430] [dblink 0430 ]

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

    M in_ThErrHandle: 1

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

    Is the database up and running?

    What is the return code of "R3trans -d"?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.