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

[Former Member]

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

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]

[isaias_freitas]

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"?