Solved: dispatcher is not starting after restore in maxdb

Hi,

I successfully restored the database with different sid. .

After that i will able to connect with database and db running online.

But dispatcher is not running .

Here is the out put of command :

dpmon nr=73

dpmon=>sapparam(1c): No Profile used.

dpmon=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

DpMonInit failed - possibly no dispatcher running

DpMon: External/Internal dplib version: 109/232

Please help

SAP Managed Tags:
NW AS Java Administrator (NWA)

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 (1)

can you post the errors in dev_disp?

Regards, Juan

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

Comment

Here i am attaching dev_disp file..

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

trc file: "dev_disp.new", trc level: 1, release: "700"

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

sysno 73

sid DE1

systemid 390 (AMD/Intel x86_64 with Linux)

relno 7000

patchlevel 0

patchno 144

intno 20050900

make: single threaded, Unicode, 64 bit, optimized

pid 3611

Wed Jul 11 03:29:57 2012

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

length of sys_adm_ext is 576 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (73 3611) [dpxxdisp.c 1243]

shared lib "dw_xml.so" version 144 successfully loaded

shared lib "dw_xtc.so" version 144 successfully loaded

shared lib "dw_stl.so" version 144 successfully loaded

shared lib "dw_gui.so" version 144 successfully loaded

shared lib "dw_mdm.so" version 144 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3973

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >sgtr-s-devde1_DE1_73 <

DpShMCreate: sizeof(wp_adm) 25160 (1480)

DpShMCreate: sizeof(tm_adm) 5748600 (28600)

DpShMCreate: sizeof(wp_ca_adm) 28800 (96)

DpShMCreate: sizeof(appc_ca_adm) 9600 (96)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/548056/548064

DpShMCreate: sizeof(comm_adm) 548064 (1088)

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

DpShMCreate: sizeof(slock_adm) 0 (104)

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

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (2008)

DpShMCreate: sizeof(wall_adm) (40056/36728/80/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 0x7f8f1fb01000, size: 6446000)

DpShMCreate: allocated sys_adm at 0x7f8f1fb01000

DpShMCreate: allocated wp_adm at 0x7f8f1fb031b8

DpShMCreate: allocated tm_adm_list at 0x7f8f1fb09400

DpShMCreate: allocated tm_adm at 0x7f8f1fb09460

DpShMCreate: allocated wp_ca_adm at 0x7f8f20084bd8

DpShMCreate: allocated appc_ca_adm at 0x7f8f2008bc58

DpShMCreate: allocated comm_adm at 0x7f8f2008e1d8

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0x7f8f20113eb8

DpShMCreate: allocated gw_adm at 0x7f8f20113f38

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 0x7f8f20113f68

DpShMCreate: allocated wall_adm at 0x7f8f20113f70

MBUF state OFF

DpCommInitTable: init table for 500 entries

ThTaskStatus: rdisp/reset_online_during_debug 0

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation map

<EsMap> EsMapUnamFileMapInit: Initialize the memory 2552 MB

Linux: Kernel supports shared memory disclaiming

Linux: using madvise(<pointer>, <size>, 9).

Linux: disclaiming for shared memory enabled

<ES> 636 blocks reserved for free list.

ES initialized.

Wed Jul 11 03:29:58 2012

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1633]

***LOG Q0K=> DpMsAttach, mscon ( sgtr-s-devde1) [dpxxdisp.c 11822]

DpStartStopMsg: send start message (myname is >sgtr-s-devde1_DE1_73 <)

DpStartStopMsg: start msg sent

Warning: Swap space is configured quite small with 20473 MB.

It should be configured with at least 20 GB on 64 bit systems.

See note 153641 for more information.

Warning: tmpfs at /dev/shm is configured quite small with 2564 MB!

Minimum value is 8192 MB.

Recommended size is 75 % of RAM + swap.

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

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

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 144

Release check o.K.

Wed Jul 11 03:30:18 2012

*** ERROR => DpHdlDeadWp: W0 (pid 3635) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W1 (pid 3636) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W2 (pid 3637) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W3 (pid 3638) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W4 (pid 3639) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W5 (pid 3640) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W6 (pid 3641) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W7 (pid 3642) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W8 (pid 3643) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W9 (pid 3644) died [dpxxdisp.c 14532]

my types changed after wp death/restart 0xbf --> 0xbe

*** ERROR => DpHdlDeadWp: W10 (pid 3645) died [dpxxdisp.c 14532]

my types changed after wp death/restart 0xbe --> 0xbc

*** ERROR => DpHdlDeadWp: W11 (pid 3646) died [dpxxdisp.c 14532]

my types changed after wp death/restart 0xbc --> 0xb8

*** ERROR => DpHdlDeadWp: W12 (pid 3647) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W13 (pid 3648) died [dpxxdisp.c 14532]

*** ERROR => DpHdlDeadWp: W14 (pid 3649) died [dpxxdisp.c 14532]

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

*** ERROR => DpHdlDeadWp: W15 (pid 3650) died [dpxxdisp.c 14532]

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

*** ERROR => DpHdlDeadWp: W16 (pid 3651) died [dpxxdisp.c 14532]

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

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

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:28 2012

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Wed Jul 11 08:30:28 2012

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

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

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

0 DIA 3635 Ended no 1 0 0

1 DIA 3636 Ended no 1 0 0

2 DIA 3637 Ended no 1 0 0

3 DIA 3638 Ended no 1 0 0

4 DIA 3639 Ended no 1 0 0

5 DIA 3640 Ended no 1 0 0

6 DIA 3641 Ended no 1 0 0

7 DIA 3642 Ended no 1 0 0

8 DIA 3643 Ended no 1 0 0

9 DIA 3644 Ended no 1 0 0

10 UPD 3645 Ended no 1 0 0

11 ENQ 3646 Ended no 1 0 0

12 BTC 3647 Ended no 1 0 0

13 BTC 3648 Ended no 1 0 0

14 BTC 3649 Ended no 1 0 0

15 SPO 3650 Ended no 1 0 0

16 UP2 3651 Ended no 1 0 0

Dispatcher Queue Statistics Wed Jul 11 08:30:28 2012

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

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

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

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

| NOWP | 0 | 2 | 2000 | 6 | 6 |

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

| DIA | 3 | 3 | 2000 | 3 | 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 10

wake_evt_udp_now 0

wake events total 6, udp 6 (100%), shm 0 ( 0%)

since last update total 6, udp 6 (100%), shm 0 ( 0%)

Dump of tm_adm structure: Wed Jul 11 08:30:28 2012

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

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

Workprocess Comm. Area Blocks Wed Jul 11 08:30:28 2012

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

Slots: 300, Used: 1, Max: 0

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

| id | owner | pid | eyecatcher |

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

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

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:33 2012

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >sgtr-s-devde1_DE1_73 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

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( key 57 valid )

ShmProtect( slot Index 56 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 57 prot 3/0 done

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect( key 57 valid )

ShmProtect( slot Index 56 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 57 prot 1/4096 done

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes

Stop gateway

killing proc (3633) (SOFT_KILL)

Stop icman

killing proc (3634) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

kill(3633,0) successful -> process alive

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:34 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3633,0) -> ESRCH: process died

wait for end of icman

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:35 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:36 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:37 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:38 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:39 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:40 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:41 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:42 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:43 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:44 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) successful -> process alive

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=15

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Jul 11 03:30:45 2012

NiISelect: TIMEOUT occured (1000ms)

kill(3634,0) -> ESRCH: process died

DpStartStopMsg: send stop message (myname is >sgtr-s-devde1_DE1_73 <)

NiIMyHostName: hostname = 'sgtr-s-devde1'

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 = 189 bytes

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

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

DpStartStopMsg: stop msg sent

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

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

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

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

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

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

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

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

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

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

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

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

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

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

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIRead: read for hdl 2 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)

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: hdl 2 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

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

NiIRead: hdl 2 recv would block (errno=EAGAIN)

Wed Jul 11 03:30:46 2012

NiIPeek: peek for hdl 2 timed out (r; 1000ms)

NiIRead: read for hdl 2 timed out (1000ms)

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

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0

SiSelPSet: set events of sock 12 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelPRemove: removed sock 12 (pos=3)

NiSelIRemove: removed hdl 2

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

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/17

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

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

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 12

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EsCleanup destroy slot 0

<EsMap: unlink /SAP_ES_73_000

EsCleanup destroy slot 1

<EsMap: unlink /SAP_ES_73_001

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

ShmCreate( 76, 0, 2, 0x0x5425b70 )

ShmKeyPermission( 76 ) = 0740 (octal)

ShmDelete( 13 )

cleanup event management

cleanup shared memory/semaphores

ShmCleanup SHM_SYS_ADM_KEY

ShmCleanup( 1 )

ShmCreate( 1, 0, 2, 0x0x7fffd5746c30 )

ShmProtect( 1, 3 )

ShmProtect( key 1 valid )

ShmProtect( slot Index 0 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 1 prot 3/0 done

ShmCreate( 1, 0, 2, -> 0x0x7f8f2cb06000 )

ShmCleanup SHM_DP_ADM_KEY

ShmCleanup( 2 )

ShmCreate( 2, 0, 2, 0x0x7fffd5746c30 )

ShmProtect( 2, 3 )

ShmProtect( key 2 valid )

ShmProtect( slot Index 1 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 2 prot 3/0 done

ShmCreate( 2, 0, 2, -> 0x0x7f8f1fb01000 )

ShmCleanup SHM_DP_CA_KEY

ShmCleanup( 3 )

ShmCreate( 3, 0, 2, 0x0x7fffd5746c30 )

ShmProtect( 3, 3 )

ShmProtect( key 3 valid )

ShmProtect( slot Index 2 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 3 prot 3/0 done

ShmCreate( 3, 0, 2, -> 0x0x7f8f1ee8c000 )

ShmCleanup SHM_PF_KEY

ShmCleanup( 4 )

ShmCreate( 4, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 4 ) = 0740 (octal)

ShmCleanup SHM_PRES_BUF

ShmCleanup( 14 )

ShmCreate( 14, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 10, 14, 0, 2, 0x0x7fffd5746b48 )

ShmCleanup SHM_CALI_BUFFER

ShmCleanup( 11 )

ShmCreate( 11, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 10, 11, 0, 2, 0x0x7fffd5746b48 )

ShmCleanup SHM_DB_TBUFF

ShmCleanup( 19 )

ShmCreate( 19, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 19 ) = 0740 (octal)

ShmCleanup SHM_DB_TBUFF_P

ShmCleanup( 33 )

ShmCreate( 33, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 33 ) = 0740 (octal)

ShmCleanup SHM_DB_STBUFF

ShmCleanup( 41 )

ShmCreate( 41, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 41 ) = 0740 (octal)

ShmCleanup SHM_DB_TTBUFF

ShmCleanup( 42 )

ShmCreate( 42, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 40, 42, 0, 2, 0x0x7fffd5746b48 )

ShmCreate( 40, 0, 2, 0x0x7fffd5746668 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_FTBUFF

ShmCleanup( 43 )

ShmCreate( 43, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 40, 43, 0, 2, 0x0x7fffd5746b48 )

ShmCreate( 40, 0, 2, 0x0x7fffd5746668 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_SNTBUFF

ShmCleanup( 45 )

ShmCreate( 45, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 40, 45, 0, 2, 0x0x7fffd5746b48 )

ShmCreate( 40, 0, 2, 0x0x7fffd5746668 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_IRBUFF

ShmCleanup( 44 )

ShmCreate( 44, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 40, 44, 0, 2, 0x0x7fffd5746b48 )

ShmCreate( 40, 0, 2, 0x0x7fffd5746668 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_OBJ_BUFFER

ShmCleanup( 54 )

ShmCreate( 54, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 54 ) = 0740 (octal)

ShmCleanup SHM_DB_SYNC

ShmCleanup( 46 )

ShmCreate( 46, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 40, 46, 0, 2, 0x0x7fffd5746b48 )

ShmCreate( 40, 0, 2, 0x0x7fffd5746668 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_CUA_BUFFER

ShmCleanup( 47 )

ShmCreate( 47, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 40, 47, 0, 2, 0x0x7fffd5746b48 )

ShmCreate( 40, 0, 2, 0x0x7fffd5746668 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_OTR_BUFFER

ShmCleanup( 64 )

ShmCreate( 64, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 64 ) = 0740 (octal)

ShmCleanup SHM_DB_ESM_BUFFER

ShmCleanup( 65 )

ShmCreate( 65, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 65 ) = 0740 (octal)

ShmCleanup SHM_ROLL_AREA_KEY

ShmCleanup( 9 )

ShmCreate( 9, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 9 ) = 0740 (octal)

ShmCleanup SHM_PAGING_AREA_KEY

ShmCleanup( 8 )

ShmCreate( 8, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 8 ) = 0740 (octal)

ShmCleanup SHM_ROLL_ADM_KEY

ShmCleanup( 17 )

ShmCreate( 17, 0, 2, 0x0x7fffd5746c30 )

ShmGet( 10, 17, 0, 2, 0x0x7fffd5746b48 )

ShmCleanup SHM_PAGING_ADM_KEY

ShmCleanup( 18 )

ShmCreate( 18, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 18 ) = 0740 (octal)

ShmCleanup SHM_PXA_KEY

ShmCleanup( 6 )

ShmCreate( 6, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 6 ) = 0740 (octal)

ShmCleanup SHM_ENQ_TABLE_KEY

ShmCleanup( 34 )

ShmCreate( 34, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 34 ) = 0740 (octal)

ShmCleanup SHM_ENQID_KEY

ShmCleanup( 58 )

ShmCreate( 58, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 58 ) = 0740 (octal)

ShmCleanup SHM_VB_ADM_KEY

ShmCleanup( 7 )

ShmCreate( 7, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 7 ) = 0740 (octal)

ShmCleanup SHM_ES2_ADM

ShmCleanup( 76 )

ShmCreate( 76, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 76 ) = 0740 (octal)

ShmCleanup SHM_EM_ADM

ShmCleanup( 51 )

ShmCreate( 51, 0, 2, 0x0x7fffd5746c30 )

ShmProtect( 51, 3 )

ShmProtect( key 51 valid )

ShmProtect( slot Index 50 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 51 prot 3/0 done

ShmCreate( 51, 0, 2, -> 0x0x7f8f1cd63000 )

ShmCleanup SHM_EM2_ADM

ShmCleanup( 77 )

ShmCreate( 77, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 77 ) = 0740 (octal)

ShmCleanup SHM_EG2_ADM

ShmCleanup( 78 )

ShmCreate( 78, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 78 ) = 0740 (octal)

ShmCleanup SHM_MSBUF

ShmCleanup( 52 )

ShmCreate( 52, 0, 2, 0x0x7fffd5746c30 )

ShmProtect( 52, 3 )

ShmProtect( key 52 valid )

ShmProtect( slot Index 51 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 52 prot 3/0 done

ShmCreate( 52, 0, 2, -> 0x0x7f8f2c966000 )

ShmCleanup SHM_THRUN_ADM_KEY(th run adm)

ShmCleanup( 30 )

ShmCreate( 30, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 30 ) = 0740 (octal)

ShmCleanup SHM_JAVA

ShmCleanup( 70 )

ShmCreate( 70, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 70 ) = 0740 (octal)

ShmCleanup SHM_PF_AS_KEY(Appl.Statistics)

ShmCleanup( 56 )

ShmCreate( 56, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 56 ) = 0740 (octal)

ShmCleanup SHM_PROFILE

ShmCleanup( 57 )

ShmCreate( 57, 0, 2, 0x0x7fffd5746c30 )

ShmProtect( 57, 3 )

ShmProtect( key 57 valid )

ShmProtect( slot Index 56 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 57 prot 3/0 done

ShmCreate( 57, 0, 2, -> 0x0x7f8f29577000 )

removing request queue

ShmCleanup( 31 )

ShmCreate( 31, 0, 2, 0x0x7fffd5746c20 )

ShmProtect( 31, 3 )

ShmProtect( key 31 valid )

ShmProtect( slot Index 30 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 31 prot 3/0 done

ShmCreate( 31, 0, 2, -> 0x0x7f8f1e90a000 )

ShmCleanup SHM_POOL_0

ShmCleanup( 10 )

ShmCreate( 10, 0, 2, 0x0x7fffd5746c30 )

ShmProtect( 10, 3 )

ShmProtect( key 10 valid )

ShmProtect( slot Index 9 )

ShmProtect( Mode: 136000000 )

ShmCreate( 10, 0, 2, -> 0x0x7f8f213c3000 )

ShmCleanup SHM_DB_POOL

ShmCleanup( 40 )

ShmCreate( 40, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_POOL_50

ShmCleanup( 50 )

ShmCreate( 50, 0, 2, 0x0x7fffd5746c30 )

ShmKeyPermission( 50 ) = 0740 (octal)

MiCleanup:

ShmCleanup( 62 )

ShmCreate( 62, 0, 2, 0x0x7fffd5746c10 )

ShmProtect( 62, 3 )

ShmProtect( key 62 valid )

ShmProtect( slot Index 61 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 62 prot 3/0 done

ShmCreate( 62, 0, 2, -> 0x0x7f8e1493e000 )

MpiCleanup() -> 0

removing Semaphore-Management

closing connect handles (dgm + tcp)

DpDelSocketInfo: del info for socket 0 (type=2)

NiICloseHandle: shutdown and close hdl 0 / sock 9

DpDelSocketInfo: del info for socket 1 (type=1)

NiICloseHandle: shutdown and close hdl 1 / sock 10 - sock 11

***LOG Q05=> DpHalt, DPStop ( 3611) [dpxxdisp.c 10700]

*** shutdown completed - server stopped ***

Good Bye .....

Ok, now can you post dev_w0 please

Regards, Juan

Hi Reyes,

Please find the dev_w0 log...

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

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

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

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, MJ

M sysno 73

M sid DE1

M systemid 390 (AMD/Intel x86_64 with Linux)

M relno 7000

M patchlevel 0

M patchno 144

M intno 20050900

M make: single threaded, Unicode, 64 bit, optimized

M pid 3635

M Wed Jul 11 03:29:57 2012

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

M length of sys_adm_ext is 576 bytes

M ***LOG Q01=> ThInit, WPStart (Workproc 0 1 3635) [thxxhead.c 1281]

M ThInit: running on host sgtr-s-devde1

M calling db_connect ...

C DBSDBSLIB : version 700.08, patch 0.144 (Make PL 0.144)

C MAXDB shared library (dbsdbslib) patchlevels (last 10)

C (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)

C (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)

C (0.139) Return DS_SQLERR instead of DS_CONNECTERR (note 1121076)

C (0.131) Do not trace password of SQLOPT into dev trace (note 1097930)

C (0.130) Performance optimization for UPDSTAT PREPARE (note 1096387)

C (0.125) Update statistic prepare on row level (note 1086430)

C (0.104) Update statistic with empty schemas (note 1041547)

C (0.095) MaxDB DBSL patch collection 1 2007 (note 1014270)

C (0.082) MaxDB DBSL patch collection 3 2006 (note 991258)

C (0.079) MaxDB DBSL patch collection 2 2006 (note 984406)

C Loading SQLDBC client runtime ...

C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 002-121-083-965

C SQLDBC Library Version : libSQLDBC 7.6.3 BUILD 009-123-163-622

C SQLDBC client runtime is MaxDB 7.6.3.009 CL 163622

C SQLDBC supports new DECIMAL interface : 0

C SQLDBC supports VARIABLE INPUT data : 1

C SQLDBC supports keepAlive indicator : 0

C INFO : SQLOPT= -I 0 -t 0 -S SAPR3

C Try to connect (DEFAULT) on connection 0 ...

C Wed Jul 11 03:29:58 2012

C *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

[dbsdbsql.cpp 137]

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

B ***LOG BY0=> POS(1) Unknown user name/password combination [dbsh#2 @ 1204] [dbsh 1204 ]

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

B ***LOG BY0=> POS(1) Unknown user name/password combination [dblink#5 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M Info for wp 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

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 mode_cleaned_counter = 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 attachedVm = no VM

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

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

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 Wed Jul 11 03:29:59 2012

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3635) [dpuxtool.c 260]

Errors :

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

B ***LOG BY0=> POS(1) Unknown user name/password combination [dbsh#2 @ 1204] [dbsh 1204 ]

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

B ***LOG BY0=> POS(1) Unknown user name/password combination [dblink#5 @ 431] [dblink 0431 ]

please check SAP Note 955670

Note 955670 - DB multiconnect with MaxDB as secondary database

Regards

Ashish

Unknown user name/password combination

You have problems with your DB user password

Read,

Note 653887 - Password of the DBM user in Unicode database

Regards, Juan

Yes, my password is changed it.

How to change the password in XUSER?

Its on the note i gave you

dbmcli on <database_name>>user_put <DBM_user> PASSWORD=<password>

Regards, Juan

Hi Juan,

Actually what happend is that , I restored the ST1 database with TT1.

Earlier i am able to connect with the the TT1 database with superdba, XXXXXXXX.

Then i loaded the system tables with command

load_systab -u superdba,admin -ud domain which is executed successfully.

Now i am able to connect with the TT1 with the following password : superdba,XXXXXXXX.

When i start the sap its not connecting through GUI.

where is dev_w0 log it says username/password unknown.

So since it seems sap is not connected with database due to change in password.

So i need to keep older password or need to change any Xuser entries password ?

Hope You clearly understand my situation ...

Please advice .....

Read,

SAP Note 39439 - XUSER entries for SAP DB and MaxDB

Regards, Juan

Hi Juan,

What should be the exact username password should i connect with sourcedb or

targetdb user ?

Hi Juan,

Issue is solved by changing the Xuser entries of DEFAULT and SUPERDBA.

Thanks a lot for your support.........

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

dispatcher is not starting after restore in maxdb

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

DR Documentation

SFTP receiver - error Cannot store file cause: jav...

Re: SAP RAP Refresh issue when update from grand c...

Re: SAP RAP Refresh issue when update from grand c...

Re: Sap Analytics Cloud - Input a Date Parameter i...