cancel
Showing results for 
Search instead for 
Did you mean: 

Dispatcher doesnt start

Former Member
0 Kudos

Hi guys,

After a system copy when I try to start sap dispatcher start and stop because connot connect do message server:

R3trans -d:

C:\Users\qaladm>R3trans -d

This is R3trans version 6.13 (release 640 - 25.04.12 - 10:00:00 ).

2EETW169 no connect possible: "DBMS = MSSQL                            ---  SERV

ER = 'oersapdev1' DBNAME = 'QAL'"

R3trans finished (0012).

________________________________________________________

Dev_w0

B Thu Aug 30 10:09:44 2012

B  create_con (con_name=R/3)

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

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

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

B  New connection 0 created

M sysno      00

M sid        QAL

M systemid   562 (PC with Windows NT)

M relno      6400

M patchlevel 0

M patchno    404

M intno      20020600

M make:      multithreaded, ASCII, 64 bit

M pid        1432

M

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

I  MtxInit: -2 0 0

M  DpSysAdmExtCreate: ABAP is active

M  DpShMCreate: sizeof(wp_adm)        19520    (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: 000000000DC10050, size: 3588576)

M  DpShMCreate: allocated sys_adm at 000000000DC10050

M  DpShMCreate: allocated wp_adm at 000000000DC11880

M  DpShMCreate: allocated tm_adm_list at 000000000DC164C0

M  DpShMCreate: allocated tm_adm at 000000000DC164E8

M  DpShMCreate: allocated wp_ca_adm at 000000000DF34068

M  DpShMCreate: allocated appc_ca_adm at 000000000DF386B8

M  DpShMCreate: allocated comm_adm_list at 000000000DF39E28

M  DpShMCreate: allocated comm_adm at 000000000DF39E40

M  DpShMCreate: allocated vmc_adm_list at 000000000DF6DA60

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 000000000DF6DA88

M  DpShMCreate: allocated wall_adm at 000000000DF6DAE8

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: initializing DIA work process W0

M  tskh_init: rdisp/cleanup_after_crash = 1

M  calling db_connect ...

C  Thread ID:4984

C  Thank You for using the SLOLEDB-interface

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

C  dbmssslib.dll patch info

C    patchlevel   0

C    patchno      371

C    patchcomment Safety check for command buffer allocation (1569421)

C  np:(local) connection used on OERSAPDEV1

C  CopyLocalParameters: dbuser is 'qal'

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

C  Using provider SQLOLEDB instead.

C  OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

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

C  Using provider SQLOLEDB instead.

C  OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

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

C  Using provider SQLOLEDB instead.

C  OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

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  OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

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

C  Using provider SQLOLEDB instead.

C  OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

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

C  Using provider SQLOLEDB instead.

C  OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

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

M  in_ThErrHandle: 1

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

M  Info for wp 0

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  *  LOCATION    SAP-Server oersapdev1_QAL_00 on host oersapdev1 (wp 0)

M  *  ERROR       tskh_init: db_connect

M  *

M  *  TIME        Thu Aug 30 10:09:44 2012

M  *  RELEASE     640

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        9997

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

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

M  Entering ThSetStatError

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

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

_________________________________

DEV_DISP

Thu Aug 30 10:09:37 2012

kernel runs with dp version 141(ext=102) (@(#) DPLIB-INT-VERSION-141)

length of sys_adm_ext is 312 bytes

sysno      00

sid        QAL

systemid   562 (PC with Windows NT)

relno      6400

patchlevel 0

patchno    404

intno      20020600

make:      multithreaded, ASCII, 64 bit

pid        1592

***LOG Q00=> DpSapEnvInit, DPStart (00 1592) [dpxxdisp.c   1167]

    shared lib "dw_xml.dll" version 404 successfully loaded

    shared lib "dw_xtc.dll" version 404 successfully loaded

    shared lib "dw_stl.dll" version 404 successfully loaded

    shared lib "dw_gui.dll" version 404 successfully loaded

    shared lib "dw_mdm.dll" version 404 successfully loaded

Thu Aug 30 10:09:42 2012

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  3883]

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpIPCInit2: start server >oersapdev1_QAL_00                       <

DpShMCreate: sizeof(wp_adm)        19520    (976)

DpShMCreate: sizeof(tm_adm)        3267456    (16256)

DpShMCreate: sizeof(wp_ca_adm)        18000    (60)

DpShMCreate: sizeof(appc_ca_adm)    6000    (60)

DpShMCreate: sizeof(comm_adm)        212000    (424)

DpShMCreate: sizeof(vmc_adm)        0    (448)

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

DpShMCreate: SHM_DP_ADM_KEY        (addr: 000000000BE70050, size: 3588576)

DpShMCreate: allocated sys_adm at 000000000BE70050

DpShMCreate: allocated wp_adm at 000000000BE71880

DpShMCreate: allocated tm_adm_list at 000000000BE764C0

DpShMCreate: allocated tm_adm at 000000000BE764E8

DpShMCreate: allocated wp_ca_adm at 000000000C194068

DpShMCreate: allocated appc_ca_adm at 000000000C1986B8

DpShMCreate: allocated comm_adm_list at 000000000C199E28

DpShMCreate: allocated comm_adm at 000000000C199E40

DpShMCreate: allocated vmc_adm_list at 000000000C1CDA60

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000C1CDA88

DpShMCreate: allocated wall_adm at 000000000C1CDAE8

MBUF state OFF

DpRqQInit: Parameter rdisp/queue_lock_level = 2

ThTaskStatus: rdisp/reset_online_during_debug 0

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 1556 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( oersapdev1) [dpxxdisp.c   10676]

DpStartStopMsg: send start message (myname is >oersapdev1_QAL_00                       <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 40000000 for monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6400, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1025]

DpMsgAdmin: Set patchno for this platform to 404

Release check o.K.

Thu Aug 30 10:10:22 2012

*** ERROR => W0 (pid 1432) died [dpxxdisp.c   13308]

*** ERROR => W1 (pid 4100) died [dpxxdisp.c   13308]

*** ERROR => W2 (pid 4980) died [dpxxdisp.c   13308]

*** ERROR => W3 (pid 4972) died [dpxxdisp.c   13308]

*** ERROR => W4 (pid 5048) died [dpxxdisp.c   13308]

*** ERROR => W5 (pid 3572) died [dpxxdisp.c   13308]

*** ERROR => W6 (pid 4700) died [dpxxdisp.c   13308]

*** ERROR => W7 (pid 3060) died [dpxxdisp.c   13308]

*** ERROR => W8 (pid 1252) died [dpxxdisp.c   13308]

*** ERROR => W9 (pid 3320) died [dpxxdisp.c   13308]

*** ERROR => W10 (pid 4692) died [dpxxdisp.c   13308]

*** ERROR => W11 (pid 1596) died [dpxxdisp.c   13308]

*** ERROR => W12 (pid 3864) died [dpxxdisp.c   13308]

*** ERROR => W13 (pid 4672) died [dpxxdisp.c   13308]

*** ERROR => W14 (pid 4340) died [dpxxdisp.c   13308]

*** ERROR => W15 (pid 4228) died [dpxxdisp.c   13308]

my types changed after wp death/restart 0xb7 --> 0xb6

*** ERROR => W16 (pid 3392) died [dpxxdisp.c   13308]

my types changed after wp death/restart 0xb6 --> 0xb4

*** ERROR => W17 (pid 2428) died [dpxxdisp.c   13308]

my types changed after wp death/restart 0xb4 --> 0xb0

*** ERROR => W18 (pid 3696) died [dpxxdisp.c   13308]

my types changed after wp death/restart 0xb0 --> 0xa0

*** ERROR => W19 (pid 4244) died [dpxxdisp.c   13308]

my types changed after wp death/restart 0xa0 --> 0x80

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-1432 (SIGUSR2)

*** ERROR => DpWpKill(1432, SIGUSR2) failed [dpxxtool.c   2526]

killing W1-4100 (SIGUSR2)

*** ERROR => DpWpKill(4100, SIGUSR2) failed [dpxxtool.c   2526]

killing W2-4980 (SIGUSR2)

*** ERROR => DpWpKill(4980, SIGUSR2) failed [dpxxtool.c   2526]

killing W3-4972 (SIGUSR2)

*** ERROR => DpWpKill(4972, SIGUSR2) failed [dpxxtool.c   2526]

killing W4-5048 (SIGUSR2)

*** ERROR => DpWpKill(5048, SIGUSR2) failed [dpxxtool.c   2526]

killing W5-3572 (SIGUSR2)

*** ERROR => DpWpKill(3572, SIGUSR2) failed [dpxxtool.c   2526]

killing W6-4700 (SIGUSR2)

*** ERROR => DpWpKill(4700, SIGUSR2) failed [dpxxtool.c   2526]

killing W7-3060 (SIGUSR2)

*** ERROR => DpWpKill(3060, SIGUSR2) failed [dpxxtool.c   2526]

killing W8-1252 (SIGUSR2)

*** ERROR => DpWpKill(1252, SIGUSR2) failed [dpxxtool.c   2526]

killing W9-3320 (SIGUSR2)

*** ERROR => DpWpKill(3320, SIGUSR2) failed [dpxxtool.c   2526]

killing W10-4692 (SIGUSR2)

*** ERROR => DpWpKill(4692, SIGUSR2) failed [dpxxtool.c   2526]

killing W11-1596 (SIGUSR2)

*** ERROR => DpWpKill(1596, SIGUSR2) failed [dpxxtool.c   2526]

killing W12-3864 (SIGUSR2)

*** ERROR => DpWpKill(3864, SIGUSR2) failed [dpxxtool.c   2526]

killing W13-4672 (SIGUSR2)

*** ERROR => DpWpKill(4672, SIGUSR2) failed [dpxxtool.c   2526]

killing W14-4340 (SIGUSR2)

*** ERROR => DpWpKill(4340, SIGUSR2) failed [dpxxtool.c   2526]

killing W15-4228 (SIGUSR2)

*** ERROR => DpWpKill(4228, SIGUSR2) failed [dpxxtool.c   2526]

killing W16-3392 (SIGUSR2)

*** ERROR => DpWpKill(3392, SIGUSR2) failed [dpxxtool.c   2526]

killing W17-2428 (SIGUSR2)

*** ERROR => DpWpKill(2428, SIGUSR2) failed [dpxxtool.c   2526]

killing W18-3696 (SIGUSR2)

*** ERROR => DpWpKill(3696, SIGUSR2) failed [dpxxtool.c   2526]

killing W19-4244 (SIGUSR2)

*** ERROR => DpWpKill(4244, SIGUSR2) failed [dpxxtool.c   2526]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:32 2012

NiISelect: TIMEOUT occured (10000 ms)

dump system status

Workprocess Table (long)            Thu Aug 30 09:10:32 2012

========================

No Ty. Pid      Status  Cause Start Err Sem CPU    Time  Program  Cl  User         Action                    Table

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

0 DIA     1432 Ended         no      1   0             0                                                             

1 DIA     4100 Ended         no      1   0             0                                                             

2 DIA     4980 Ended         no      1   0             0                                                             

3 DIA     4972 Ended         no      1   0             0                                                             

4 DIA     5048 Ended         no      1   0             0                                                             

5 DIA     3572 Ended         no      1   0             0                                                             

6 DIA     4700 Ended         no      1   0             0                                                             

7 DIA     3060 Ended         no      1   0             0                                                             

8 DIA     1252 Ended         no      1   0             0                                                             

9 DIA     3320 Ended         no      1   0             0                                                             

10 DIA     4692 Ended         no      1   0             0                                                             

11 DIA     1596 Ended         no      1   0             0                                                             

12 DIA     3864 Ended         no      1   0             0                                                             

13 DIA     4672 Ended         no      1   0             0                                                             

14 DIA     4340 Ended         no      1   0             0                                                             

15 DIA     4228 Ended         no      1   0             0                                                             

16 UPD     3392 Ended         no      1   0             0                                                             

17 ENQ     2428 Ended         no      1   0             0                                                             

18 SPO     3696 Ended         no      1   0             0                                                             

19 UP2     4244 Ended         no      1   0             0                                                             

Dispatcher Queue Statistics            Thu Aug 30 09:10:32 2012

===========================

+------+--------+--------+--------+--------+--------+

|  Typ |    now |   high |    max | writes |  reads |

+------+--------+--------+--------+--------+--------+

| NOWP |      0 |      3 |   2000 |     10 |     10 |

+------+--------+--------+--------+--------+--------+

|  DIA |      5 |      5 |   2000 |      5 |      0 |

+------+--------+--------+--------+--------+--------+

|  UPD |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  ENQ |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  BTC |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  SPO |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

|  UP2 |      0 |      0 |   2000 |      0 |      0 |

+------+--------+--------+--------+--------+--------+

max_rq_id        13

wake_evt_udp_now    0

wake events          total     9,  udp     8 ( 88%),  shm     1 ( 11%)

since last update    total     9,  udp     8 ( 88%),  shm     1 ( 11%)

Dump of tm_adm structure:            Thu Aug 30 09:10:32 2012

=========================

Term    uid  man user    term   lastop  mod wp  ta   a/i (modes)

Workprocess Comm. Area Blocks            Thu Aug 30 09:10:32 2012

=============================

Slots: 300, Used: 1, Max: 1

+------+--------------+----------+-------------+

|   id | owner        |   pid    | eyecatcher  |

+------+--------------+----------+-------------+

|    0 | DISPATCHER   |       -1 | *WPCAAD000* |

NiWait: sleep (5000 msecs) ...

NiISelect: timeout 5000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:37 2012

NiISelect: TIMEOUT occured (5000 ms)

DpHalt: shutdown server >oersapdev1_QAL_00                       < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes...

Stop gateway

killing process (968) (SOFT_KILL)

Stop icman

killing process (4804) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives  (PID:968  HANDLE:1112)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:38 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died  (PID:968  HANDLE:1112)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:39 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:40 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:41 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:42 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:43 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:44 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:45 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:46 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:47 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process lives  (PID:4804  HANDLE:1120)

waiting for termination of icman

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1245

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Thu Aug 30 10:10:48 2012

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died  (PID:4804  HANDLE:1120)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

DpStartStopMsg: send stop message (myname is >oersapdev1_QAL_00                       <)

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 163 bytes

NiBufSend starting

NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name          -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiIRead: read 229, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=229

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 229 bytes

MSG received, len 110+119, flag 1, from MSG_SERVER, typ 0, key -

DpHalt: received 119 bytes from message server

NiPRead: WSAEWOULDBLOCK 1.time 4

NiIPeek: peek for hdl 3 / socket 1108 timed out (r; 0)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: write 114, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: read 114, 1 packs, MESG_IO, hdl 3, data complete

NiBufIn: NIBUF len=114

NiBufIn: Packet complete for hdl 3

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER, typ 0, key -

Received 4 bytes from MSG_SERVER                             

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiPRead: WSAEWOULDBLOCK 1.time 4

Thu Aug 30 10:10:49 2012

NiIPeek: peek for hdl 3 / socket 1108 timed out (r; 1000)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c   10966]

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiSelClear: removed hdl 3 from selectset

MBUF state OFF

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/20

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 19)

MBUF component DOWN

NiBufClose: clear extensions for hdl 3

NiBufSetStat: bufstat of hdl 3 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 3 / socket 1108

MsIDetach: detach MS-system

EsCleanup ....

***LOG Q05=> DpHalt, DPStop ( 1592) [dpxxdisp.c   9268]

Good Bye .....

______________________

Could you help me please? I cant find the error.

Thanks!

Best regards!

Accepted Solutions (1)

Accepted Solutions (1)

JPReyes
Active Contributor
0 Kudos

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

C  Using provider SQLOLEDB instead.

C  OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

Seems pretty evident that you need to check SAP Note 734034 - Native OLEDB provider SQLNCLI

Regards, Juan

Former Member
0 Kudos

Hi Juan,

Thanks for your help.

I've that note before and I have 2008 Native client installed with the same version of sql and the env is not set.

Thanks again!

Best regards,

MM

JPReyes
Active Contributor
0 Kudos

Check that both <sid>adm and SAPService<SID> has local Admin rights...

Regards, Juan

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Guys,

I've Installed SQL server 2005 client and dispatcher starts. Everything is ok now,

Thanks for your help!

Best regards

MM

Former Member
0 Kudos

Hi,

You need to perform op$ Mechanism before starting up the database as below.

if you use Tablespace PSAPDATUSR and not PSAPUSER1D you have to change that in the oradbusr.sql

          vi oradbusr.sql

          :%s/psapuser1d/psapdatusr/g

sqlplus "/ as sysdba"

drop table ops$<SRC>adm.sapuser;

drop user ops$<SRC>adm cascade;

drop user ops$ora<SRC> cascade;

alter database rename global_name to <SID>;

alter user system identified by <password>

alter user sys identified by <password>

exit

sqlplus /nolog @oradbusr.sql $dbs_ora_schema UNIX <SID> x

sqlplus "/ as sysdba"

grant dba to ops$<sid>adm;

After performing the above steps start SAP.

Regards,

Sandeep Singh

Former Member
0 Kudos

Hi Sandeep,

I think Marco is using SQL 2008, so this is not going to be relevant.

Marco,

Logon to SQL with <sid>adm and SAPService<SID> and ensure you can browse your 'QAL' database. Also, connect with the dbuser 'qal' as this looks to be the user you have set.

Do you have another schema name?

Regards,

Nick Palmer

Former Member
0 Kudos

Hi,

Do you have you database on a separate server?

R3Trans return code says SAP is unable to connect to Database.

Please check if your database is running fine.

Also, the trace has network timeout messages,this could be a network issue  if the database is running fine please try rebooting the server and then try starting SAP.

Please check if the SAP note below helps you:

Note 551915 - R/3 won't start after database restore or database copy

Regards,

Pradeep


Former Member
0 Kudos

Make sure the kernel level are same on both Source System and Target System. And if source is Non-unicode then Target should be same.

Thanks,

Asad