Disp+work in Yellow flag (Win 2003; MaxDB; NW2004s, BI-ABAP+Java)

[Former Member]

Hi Gurus,

We have Win 2003, MaxDB in NW2004s with BI-ABAP+Java.

When we tried to start SAP via MMC, disp+work in Yellow flag . Can anyone tell how to move forward.

Please find error below:

-

---

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

-

---

sysno 01

sid BI1

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 52

intno 20050900

make: multithreaded, Unicode, optimized

pid 3684

Tue Dec 12 13:51:40 2006

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

length of sys_adm_ext is 572 bytes

• SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (01 3684) [dpxxdisp.c 1231]

shared lib "dw_xml.dll" version 52 successfully loaded

shared lib "dw_xtc.dll" version 52 successfully loaded

shared lib "dw_stl.dll" version 52 successfully loaded

shared lib "dw_gui.dll" version 52 successfully loaded

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

use internal message server connection to port 3901

Tue Dec 12 13:51:45 2006

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds

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

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: start server >ootspdbs01_BI1_01 <

DpShMCreate: sizeof(wp_adm) 12672 (1408)

DpShMCreate: sizeof(tm_adm) 3954072 (19672)

DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

DpShMCreate: sizeof(comm_adm) 528064 (1048)

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

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1452)

DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 060B0040, size: 4607512)

DpShMCreate: allocated sys_adm at 060B0040

DpShMCreate: allocated wp_adm at 060B1E28

DpShMCreate: allocated tm_adm_list at 060B4FA8

DpShMCreate: allocated tm_adm at 060B4FD8

DpShMCreate: allocated wp_ca_adm at 0647A570

DpShMCreate: allocated appc_ca_adm at 06480330

DpShMCreate: allocated comm_adm at 06482270

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 06503130

DpShMCreate: allocated gw_adm at 06503170

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 065031A0

DpShMCreate: allocated wall_adm at 065031A8

Tue Dec 12 13:51:46 2006

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

MM diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 511 blocks reserved for free list.

ES initialized.

J2EE server info

start = TRUE

state = STARTED

pid = 900

argv[0] = E:\usr\sap\BI1\DVEBMGS01\exe\jcontrol.EXE

argv[1] = E:\usr\sap\BI1\DVEBMGS01\exe\jcontrol.EXE

argv[2] = pf=E:\usr\sap\BI1\SYS\profile\BI1_DVEBMGS01_ootspdbs01

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=1042

argv[5] = -DSAPSYSTEM=01

argv[6] = -DSAPSYSTEMNAME=BI1

argv[7] = -DSAPMYNAME=ootspdbs01_BI1_01

argv[8] = -DSAPPROFILE=E:\usr\sap\BI1\SYS\profile\BI1_DVEBMGS01_ootspdbs01

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

rdisp/http_min_wait_dia_wp : 1 -> 1

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

***LOG Q0K=> DpMsAttach, mscon ( ootspdbs01) [dpxxdisp.c 11414]

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

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

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

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

DpJ2eeLogin: j2ee state = CONNECTED

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 52

Release check o.K.

[Former Member]

Hi Natayanan,

Can you paste here the out of dev_server0 file.

Also dev_server.out file.

Regards,

Tushar Chavan

[Former Member]

Hi Narayanan,

Did you ever find an answer to this? I am having the exact same problem.

Thanks!

Heather

[former_member229109]

Hello Narayanan,

1. You posted the question at MaxDB/liveCache forum, but

from the given information, it's not clear, if you have

any errors/problem in your database.

Lets go & check first, if you have any errors in the database

logs and the database is running, check if there are NO LOG_FULL

or DB_FULL issues.

-> Please update with output of the following commands, run on the

database server:

sdbregview -l

dbmcli -s inst_enum

dbmcli -s db_enum

dbmcli -d <DB-name> -u <dbm-user>,<pwd> db_state

dbmcli -d <DB-name> -u <dbm-user>,<pwd> show active

-> Please check errors in the current knldiag, knldiag.err & dbm.prt

files located in the Rundirectory on the database server.

2. You wrote, that 'disp+work in Yellow flag'.

Did you check the WP dev log on the application server?

Please review the logs stderr, sapstart.log, dev_ms, dev_w ...

and check the error messages.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia,

Kindly let me know any command to find out DB name & Dbm user as we are not sure about it..

thanks.

[former_member229109]

Hello Narayanan,

-> As I wrote, please update with output of the following commands, run on the

database server:

sdbregview -l

< to list the database software packages installed on the server>

dbmcli -s inst_enum

< To display a list of all registered versions of the database

software. >

dbmcli -s db_enum

< to display a list of all registered database instances on the server. >

=> For example on my PC ( <DB-name> = J2E 😞

dbmcli db_enum

OK

J2E C:\SAPDB\J2E\DB 7.5.0.7 slow offline

J2E C:\SAPDB\J2E\DB 7.5.0.7 quick offline

J2E C:\SAPDB\J2E\DB 7.5.0.7 fast offline

<DB-name><dependent_path><database_version><kernel_version><operational_state>

******

Please see the documents/information at http://dev.mysql.com/doc/maxdb

If you are SAP customer, please review the FAQ notes listed at

/thread/81856 [original link is broken]

Regards, Natalia khlopina

[Former Member]

- > sdbregview -l

<<< OUTPUT >>>

Server Utilities c:/program files/sdb/programs 7.6.00.18 32 bit valid

DB Analyzer c:/program files/sdb/programs 7.6.00.18 32 bit valid

PCR 7300 c:/program files/sdb/programs 7.3.00.54 valid

Base c:/program files/sdb/programs 7.6.00.18 32 bit valid

Redist Python c:/program files/sdb/programs 7.6.00.18 32 bit valid

PCR 7301 c:/program files/sdb/programs 7.3.01.19 valid

JDBC c:/program files/sdb/programs 7.6.00.16 valid

Messages c:/program files/sdb/programs MSG 0.3017 valid

ODBC c:/program files/sdb/programs 7.6.00.18 32 bit valid

Database Kernel c:/program files/sdb/7600 7.6.00.18 32 bit valid

Database Kernel e:/sapdb/bi1/db 7.6.00.18 32 bit valid

Loader c:/program files/sdb/programs 7.6.00.18 32 bit valid

PCR 7104 c:/program files/sdb/programs 7.1.04.45 valid

SQLDBC c:/program files/sdb/programs 7.6.00.18 32 bit valid

Webtools c:/program files/sdb/programs/web 7.6.00.18 32 bit valid

SQLDBC 7600 c:/program files/sdb/programs 7.6.00.18 32 bit valid

PCR 7403 c:/program files/sdb/programs 7.4.03.40 32 bit valid

-> dbmcli -s inst_enum

<<< OUTPUT >>>

OK

7.6.00.18 e:\sapdb\bi1\db

7.6.00.18 c:\program files\sdb\7600

-> dbmcli -s db_enum

<<< OUTPUT >>>

OK

BI1 e:\sapdb\bi1\db 7.6.00.18 slow offline

BI1 e:\sapdb\bi1\db 7.6.00.18 fast running

Also, let me know how to find out user ID & Password of DBM.

[former_member229109]

-> By default the dbm-user/pwd are control/control.

For example, I didn't change the password of the dbm-user &

run the standard J2EE installation on my PC & DB-name = J2E:

dbmcli -d J2E -u control,control db_state

OK

State

OFFLINE

-> Please see more information about database users at:

null

[Former Member]

We named our DB as BI1 but user name "Control" not working. Is there any way to list down all user in DB ?

[former_member229109]

A)

Database System Administrator User -

SUPERDBA ( default password - admin)

Please run:

dbmcli -d BI1 -u superdba,admin db_state

B)

If you will have the success to run the A) command =>

dbmcli -d BI1 -u superdba,admin

<enter>

dbmcli on BI1>user_getall

dbmcli on BI1>sql_connect superdba,admin

dbmcli on BI1>sql_execute select * from users

< update with output >

dbmcli on BI1>sql_release

dbmcli on BI1>exit

C) logon as bi1adm & run:

xuser list

< update with output >

[Former Member]

Hi Natalia,

Able to trace Superdba (and our password is different and able to trace it).

Able to run Step A & B. We found "control" user but we dont know the password. Any ways to change control password ?

Not able to find out bi1adm. Can u give us step by step for Step C.

thank u.

[Former Member]

Hi,

Able to run on "control" user. Find the details below for the following:

-> Please update with output of the following commands, run on the

database server:

sdbregview -l (already given)

dbmcli -s inst_enum (already given)

dbmcli -s db_enum(already given)

~~ dbmcli -d <DB-name> -u <dbm-user>,<pwd> db_state

<<<Output>>>

OK

State

ONLINE

~~dbmcli -d <DB-name> -u <dbm-user>,<pwd> show active

<<<Output>>>

OK

SERVERDB: BI1

ID UKT Win TASK APPL Current Timeout Region Wait

tid type pid state priority cnt try item

For Step 2, We shall review it and come back to soon. Meanwhile, kindly let us know if you have any work around.

thank you.

[Former Member]

Any update ?

[former_member229109]

Hello Narayanan,

1. Concerning the xuser tool please review the SAP note 39439.

-> Did you check the errors in the knldiag.err & knldiag files?

2. You wrote: "For Step 2, We shall review it and come back to soon."

Did you check the application logs & did you see any errors?

3. So far I didn't see any errors in the posted "dev_disp" & another

information from the database provided by you => What kind of the

workaround you asked for? To give you the workaround I need to know,

what errors/problems did you get.

Please check the system, logs & update with additional information.

Do you have the problems with the database or the communication to

the database?

4. You wrote "When we tried to start SAP via MMC, disp+work in Yellow flag".

When you will start the system in SAPMMC , then refresh the status of the

processes & review the results => disp+work process status could be, for

example:

green - running ... OK

yellow - Running but dialog Queue stand still

red - Could not be started ...

-> What is in your case? Was you able to logon to your system?

Thank you & best regards, Natalia Khlopina

[Former Member]

Hi Techie Gurus,

We're still facing the problem, to be precise:

1) In MMC Console, We are trying to start the SAP System and it started but few.

2) In Process List of SAP MMC & SID:

- Msg_server.exe(Green) with status as "running"

- disp+work.exe(Yellow) with status as "running, Message Server connection ok, Dialog Queue time 0.00 sec, J2EE: Some process running

- igswd.exe(Green) with status as "Running".

3) J2EE Process Table:

- SDM(Green); pid(3904) with Status as "RUnning" & Debug as "Switched off"

- dispatcher(Green); pid(3092) with status as "Running" & Debug as "Disabled"

- server0(Grey); pid(0) with status as "stopped" & debug as "Disabled"; Exitcode (-11113)

Background:

We have created J2EE_Guest in SAP back end which is working find. Visual Administrator is not working and suddently port got changed to some 8000. Also tried to check telnet for 3900 which also held by another port( we think). Hope this background info helps.

Appreciate help from tech gurus asap.

thank you in advance.