dispatcher dies with message dialog queue standstill

[Former Member]

Hi All,

SAP WAS 6.20 is installed in win2000 server with oracle 9i as the database.

When trying to start the server with SAP managment console

messeger and dispatcher comes up fine. But within some seconds dispatcher stops.

When trying to restart again messeger starts but dispatcher turns yellow with a message "dialog queue standstill" and stops.

Please see the developer trace below.Need your help to bring the server up.

Thanks and regards,

Niranjan

-

---

trc file: "dev_w11", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Wed Oct 27 22:37:44 2004

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\KNW\SYS\exe\run\dboraslib.dll' ...

B Library 'D:\usr\sap\KNW\SYS\exe\run\dboraslib.dll' loaded

B Version of 'D:\usr\sap\KNW\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.1504)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 1509

M intno 20020600

M make: multithreaded, ASCII

M pid 1916

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc11 1916) [dpxxdisp.c 1088]

I MtxInit: -2 0 0

M DpShMCreate: sizeof(wp_adm) 12920 (760)

M DpShMCreate: sizeof(tm_adm) 1692424 (8420)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 05CC0040, size: 1979784)

M DpShMCreate: allocated sys_adm at 05CC0040

M DpShMCreate: allocated wp_adm at 05CC0638

M DpShMCreate: allocated tm_adm_list at 05CC38B0

M DpShMCreate: allocated tm_adm at 05CC38D8

M DpShMCreate: allocated wp_ca_adm at 05E60BE0

M DpShMCreate: allocated appc_ca_adm at 05E65230

M DpShMCreate: allocated comm_adm_list at 05E669A0

M DpShMCreate: allocated comm_adm at 05E669B8

M DpShMCreate: allocated ca_info at 05E957B8

M DpShMCreate: allocated wall_adm at 05E957C0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 11 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Wed Oct 27 22:37:45 2004

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora92 from environment

C

C Wed Oct 27 22:37:46 2004

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPKNW's password

C Connecting as /@KNW on connection 0 ...

C Attaching to DB Server KNW (con_hdl=0,svchp=081810CC,svrhp=08183334)

C Starting user session (con_hdl=0,svchp=081810CC,srvhp=08183334,usrhp=0818BB1C)

C

C Wed Oct 27 22:37:47 2004

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c 3795]

C Detaching from DB Server (con_hdl=0,svchp=081810CC,srvhp=08183334)

C *** ERROR => CONNECT failed with sql error '1033'

[dboci.c 9702]

C Try to connect with default password

C Connecting as SAPKNW/<pwd>@KNW on connection 0 ...

C Attaching to DB Server KNW (con_hdl=0,svchp=081810CC,svrhp=08183334)

C Starting user session (con_hdl=0,svchp=081810CC,srvhp=08183334,usrhp=0818BB1C)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c 3795]

C Detaching from DB Server (con_hdl=0,svchp=081810CC,srvhp=08183334)

C *** ERROR => CONNECT failed with sql error '1033'

[dboci.c 9702]

B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 957] [dbsh 0957 ]

B ***LOG BY2=> sql error 1033 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 11

M

M stat = 4

M reqtype = 3

M rq_info = 0

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

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 WHPWKNOW_KNW_00 on host WHPWKNOW (wp 11)

M * ERROR tskh_init: db_connect

M *

M * TIME Wed Oct 27 22:37:47 2004

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8932

M * COUNTER 1

M *

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

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc11 1916) [dpnttool.c 356]

[Former Member]

hi Niranjan,

I too got stuck with the same problem.Please let me know how to resolve the issue.

C *** ERROR=>OCI-call 'OCISessionBegin' failed: rc =1033

(dboci.c 3733)

Thanks and Regards

Prasad

[Former Member]

Hi,

check please your konfiguration files (tnsnames.ora, listener.ora, sqlnet.ora). Entries like service or global names should be the same in tnsnames.ora and listener.ora files.

In sqlnet.ora you should have the entry<i> SQLNET.AUTHENTICATION_SERVICE = (TNS).</i> You need it for your sap users (<SID>adm and SAPSERVICE<SID>).

Read please the note: 480266.

Your environment variables should be set correct. Read please the note 556232 for it (WINDOWS)

Read also please the notes 35278, 445038 and 400241.

Best regards

K.Baran

Message was edited by: Kutbettin Baran

Message was edited by: Kutbettin Baran

Message was edited by: Kutbettin Baran

[Former Member]

Hi,

I am facing the same problem of dispatcher running but dialogue queue got standstill. If you got the solution please pass onto me, so that i can up my system asap.

Regards,

Pankaj

[Former Member]

Search the OSS for

"CONNECT failed with sql error '1033'"

I think you'll be surprised at the results.

[Former Member]

Check out OSS note 655240. This one should provide you both some guidance, Tiest