cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work not staring after restore MaxDB

Former Member
0 Kudos

Hi all,

I got OS some level problem after fresh installation of Ehp4, so I re-installed OS & ecc6 ehp4 ready & restored the ehp4 backup.

OS is windows 2003 x64, DB is MaxDb 7.8.

After restore I am getting error to start sap instance.

dev_disp:

      • DP_FATAL_ERROR => DpWPCheck: no more work processes

      • DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=321

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Aug 23 01:43:30 2011

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Mon Aug 22 20:13:30 2011

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

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

-


0 DIA 4028 Ended no 1 0 0

1 DIA 4020 Ended no 1 0 0

2 DIA 540 Ended no 1 0 0

3 DIA 3616 Ended no 1 0 0

4 DIA 3648 Ended no 1 0 0

#############################################################################################

dev_w0:

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 10

M sid EIP

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 137

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 4028

M

M

M Tue Aug 23 01:42:39 2011

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

M length of sys_adm_ext is 576 bytes

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

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) 29792 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

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

M DpShMCreate: sizeof(slock_adm) 0 (104)

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

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000B2E0050, size: 6614192)

M DpShMCreate: allocated sys_adm at 000000000B2E0050

M DpShMCreate: allocated wp_adm at 000000000B2E22A0

M DpShMCreate: allocated tm_adm_list at 000000000B2E9700

M DpShMCreate: allocated tm_adm at 000000000B2E9760

M DpShMCreate: allocated wp_ca_adm at 000000000B88CFE0

M DpShMCreate: allocated appc_ca_adm at 000000000B892DE0

M DpShMCreate: allocated comm_adm at 000000000B894D20

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000B91B9B0

M DpShMCreate: allocated gw_adm at 000000000B91BA30

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000B91BA60

M DpShMCreate: allocated wall_adm at 000000000B91BA70

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M

M Tue Aug 23 01:42:40 2011

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M ThInit: rdisp/cleanup_after_crash = 1

M

M Tue Aug 23 01:42:41 2011

M ThInit: running on host emugeprod

M

M Tue Aug 23 01:42:42 2011

M calling db_connect ...

B Loading DB library 'D:\usr\sap\EIP\DVEBMGS10\exe\dbsdbslib.dll' ...

B Library 'D:\usr\sap\EIP\DVEBMGS10\exe\dbsdbslib.dll' loaded

B Version of 'D:\usr\sap\EIP\DVEBMGS10\exe\dbsdbslib.dll' is "700.08", patchlevel (0.111)

C

C DBSDBSLIB : version 700.08, patch 0.111 (Make PL 0.137)

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

C (0.111) Empty string handling for NUMC, DATE and TIME (note 1509705)

C (0.101) MSSQL: database fingerprint (note 1405158)

C (0.099) ABAP: Return technical database PPMS information (note 1419552)

C (0.093) Unknown primary key (note 1459400)

C (0.093) Connection table corrected (note 1466271)

C (0.092) Improved overflow error handling (note 1463647)

C (0.084) Use SCHEMANAME instead of OWNER for MaxDB 7.8 (note 1353266)

C (0.082) Support of MaxDB 7.8 (note 1353266)

C (0.047) MVCC support for MaxDB (note 1332203)

C (0.037) NUMC conversion corrected (note 1288313)

C

C

C Loading SQLDBC client runtime ...

C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 009-123-191-997

C SQLDBC client runtime is MaxDB 7.6.5.009 CL 191997

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

C Tue Aug 23 01:42:44 2011

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 @ 1208] [dbsh 1208 ]

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

B ***LOG BY2=> sql error -4008 performing CON [dblink#4 @ 433] [dblink 0433 ]

B ***LOG BY0=> POS(1) Unknown user name/password combination [dblink#4 @ 433] [dblink 0433 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M pid = 4028

M severity = 0

M status = 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

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

M *

M * LOCATION SAP-Server emugeprod_EIP_10 on host emugeprod (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue Aug 23 01:42:44 2011

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10917

M * COUNTER 1

M *

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

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

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

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 (Workproc 0 4028) [dpnttool.c 334]

############################################################################################

dev_ms:

-


trc file: "dev_ms", trc level: 1, release: "701"

-


[Thr 3940] Tue Aug 23 01:42:33 2011

[Thr 3940] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 562 (PC with Windows NT)

relno 7010

patchlevel 0

patchno 135

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 3932

[Thr 3940] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3932) [msxxserv.c 1853]

[Thr 3940] load acl file = D:\usr\sap\EIP\SYS\global\ms_acl_info.DAT

[Thr 3940] MsGetOwnIpAddr: my host addresses are :

[Thr 3940] 1 : [192.168.100.102] EMUGEPROD (HOSTNAME)

[Thr 3940] 2 : [127.0.0.1] emugeprod (LOCALHOST)

[Thr 3940] 3 : [169.254.95.120] emugeprod (NILIST)

[Thr 3940] MsHttpInit: full qualified hostname = emugeprod

[Thr 3940] HTTP logging is switch off

[Thr 3940] set HTTP state to LISTEN

[Thr 3940] ms/icf_info_server : deleted

[Thr 3940] *** I listen to port sapmsEIP (3610) ***

[Thr 3940] *** I listen to internal port 3910 (3910) ***

[Thr 3940] *** HTTP port 8110 state LISTEN ***

[Thr 3940] CUSTOMER KEY: >K1612826589<

[Thr 3940] build version=701.2009.12.02

[Thr 3940] Tue Aug 23 01:43:47 2011

[Thr 3940] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from emugeprod_EIP_10 [msxxserv.c 4731]

[Thr 3940] Tue Aug 23 01:54:08 2011

[Thr 3940] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.100.102) after 300 secs received [msxxserv.c 3217]

[Thr 3940] *** ERROR => MsSCheckConnections: disconnect now [192.168.100.102] [msxxserv.c 3221]

[Thr 3508] Tue Aug 23 02:20:58 2011

[Thr 3508] MsSExit: received SIGINT (2)

[Thr 3508] ***LOG Q02=> MsSHalt, MSStop (Msg Server 3932) [msxxserv.c 6041]

######################################################################################

I am using Maxdb Studio 7.8

How could I change the superdba password.

I found that after restore, I am not able to login to database in db studio with old password & able to log in by new password only.

Pls tell me the post restore steps.

Regardsm

DS

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member229109
Active Contributor
0 Kudos

Hello,

1. u201CI found that after restore, I am not able to login to database in db studio with old password & able to log in by new password only.

Pls tell me the post restore steps.u201D

If you are SAP customer => Please see the SAP note 129352.

Please check that you run the steps as of c) < !> in target database.

2. Also the XUSER entries of the <SID>adm user on the application server need to be checked/adjusted with the correct user/password information. See SAP note 39439.

Regards, Natalia Khlopina

vincentlim826
Employee
Employee
0 Kudos

Hi,

at least you know it is user/password problem at DB level from dispatcher points of view.

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

how about SAP notes:

1015489 Connection problems after system copy

616555 liveCache >= 7.4: Password chan...

25591 Changing the DBM, SYSDBA and DBA user passwords

Regards,

Vincent