Dispatcher running but Dialog queue standstill

[former_member184158]

I have this problem , any solution please

Dispatcher running but Dialog queue standstill

Green --> yellow

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        NSP

M systemid   562 (PC with Windows NT)

M relno      7200

M patchlevel 0

M patchno    214

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    \\Ibo-PC\sapmnt\NSP\SYS\profile\NSP_DVEBMGS00_Ibo-PC

M pid        2620

M

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

M  length of sys_adm_ext is 588 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 2620) [dpxxdisp.c   1377]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M  DpIPCInit2: read dp-profile-values from sys_adm_ext

M  DpShMCreate: sizeof(wp_adm) 31696 (2264)

M  DpShMCreate: sizeof(tm_adm) 5517056 (27448)

M  DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

M  DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1384064/1384080

M  DpShMCreate: sizeof(comm_adm) 1384080 (2744)

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

M  DpShMCreate: sizeof(slock_adm) 0 (296)

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

M  DpShMCreate: sizeof(file_adm) 0 (80)

M  DpShMCreate: sizeof(vmc_adm) 0 (2152)

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

M  DpShMCreate: sizeof(gw_adm) 48

M  DpShMCreate: sizeof(j2ee_adm) 3952

M  DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000FB30050, size: 7163600)

M  DpShMCreate: allocated sys_adm at 000000000FB30060

M  DpShMCreate: allocated wp_adm_list at 000000000FB33070

M  DpShMCreate: allocated wp_adm at 000000000FB33260

M  DpShMCreate: allocated tm_adm_list at 000000000FB3AE40

M  DpShMCreate: allocated tm_adm at 000000000FB3AE90

M  DpShMCreate: allocated wp_ca_adm at 000000001007DDA0

M  DpShMCreate: allocated appc_ca_adm at 000000001008D7B0

M  DpShMCreate: allocated comm_adm at 000000001009D1C0

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 00000000101EF060

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated gw_adm at 00000000101EF110

M  DpShMCreate: allocated j2ee_adm at 00000000101EF150

M  DpShMCreate: allocated ca_info at 00000000101F00D0

M  DpShMCreate: allocated wall_adm at 00000000101F0160

M  DpCommAttachTable: attached comm table (header=000000001009D1C0/ft=000000001009D1D0)

M  DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

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

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  <ES> EsILock: use spinlock for locking

X 

X Thu May 29 09:06:57 2014

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  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M  ThStart: taskhandler started

M  rdisp/thsend_mode : -1 -> 0

M  ThInit: initializing DIA work process W0

M 

M Thu May 29 09:07:07 2014

M  ThInit: running on host Ibo-PC

M 

M Thu May 29 09:07:08 2014

M  calling db_connect ...

B  Loading DB library 'C:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' ...

B 

B Thu May 29 09:07:09 2014

B  Library 'C:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' loaded

B  Version of 'C:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' is "720.00", patchlevel (0.212)

C 

C  DBSDBSLIB : version 720.00, patch 0.212 (Make PL 0.214)

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

C    (0.212) Call TH callback after cancel (note 1692560)

C    (0.210) Init length of tablename for describe (note 1678130)

C    (0.200) Take care of warnings during database connect (note 1600066)

C    (0.117) Define a primary key on the temp tables for R3szchk (note 1606260)

C    (0.114) Support of MaxDB 7.8 and 7.9 (note 1653058)

C    (0.103) Close all lob locators at end of the transaction (note 1626591)

C    (0.101) Fix for unknown table __TABLE_SIZES_ (R3szchk) (note 1619504)

C    (0.098) Use filesystem counter for R3szchk (note 1606260)

C    (0.092) Secondary connection to HANA (note 1481256)

C    (0.089) UPDSTAT with SAPSYSTEMNAME longer as 3 characters (note 1584921)

C 

C 

C  Loading SQLDBC client runtime ...

C 

C Thu May 29 09:07:10 2014

C  SQLDBC Module  : C:\sapdb\clients\NSP\pgm\libSQLDBC77.dll

C  SQLDBC SDK     : SQLDBC.H  7.8.2    BUILD 028-121-245-008

C  SQLDBC Runtime : libSQLDBC 7.8.2    BUILD 028-121-245-008

C  SQLDBC client runtime is MaxDB 7.8.2.028 CL 245008

C  SQLDBC supports new DECIMAL interface : 1

C  SQLDBC supports VARIABLE INPUT data   : 1

C  SQLDBC supports VARIABLE OUTPUT data  : 1

C  SQLDBC supports Multiple Streams      : 1

C  SQLDBC supports LOB LOCATOR KEEPALIVE : 1

C  SQLDBC supports LOB LOCATOR COPY      : 1

C  SQLDBC supports BULK SELECT with LOBS : 1

C  SQLDBC supports BATCH STREAM          : 1

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

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

C  Attach to SAP DB : SlowKnl   7.8.02   Build 028-121-245-008

C  Database release is SAP DB 7.8.02.028

C  INFO : Database 'NSP' instance is running on 'ibo-pc'

C  DB supports UPSERT SQL syntax : 1

C  DB supports new EXPAND syntax : 1

C  DB supports LOB locators      : 1

C  DB uses MVCC support          : 0

C  DB max. input host variables  : 2000

C  DB max. statement length      : 65535

C  UPSERT is disabled for : WBCROSSGT

C 

C Thu May 29 09:07:11 2014

C  INFO : SAP DB Packet_Size = 131072

C  INFO : SAP DB Min_Reply_Size = 4096

C  INFO : SAP DB Comm_Size = 126976

C  INFO : DBSL buffer size = 126976

C  INFO : SAP DB MaxLocks = 300000

C 

C Thu May 29 09:07:12 2014

C  INFO : Connect to DB as 'SAPNSP'

C  Command info enabled

C  Now I'm connected to MaxDB

C  00: ibo-pc-NSP, since=20140529090710, ABAP= <unknown> (0)

B  Connection 0 opened (DBSL handle 0)

C  INFO : SAP RELEASE (DB) = 702

M  ThInit: db_connect o.k.

M  ICT: exclude compression: *.zip,*.rar,*.arj,*.z,*.gz,*.tar,*.lzh,*.cab,*.hqx,*.ace,*.jar,*.ear,*.war,*.css,*.pdf,*.gzip,*.uue,*.bz2,*.iso,*.sda,*.sar,*.gif,*.png,*.swc,*.swf

I  MtxInit: 0 0 0

M  SHM_PRES_BUF (addr: 0000000016110050, size: 4400000)

M  SHM_ROLL_AREA (addr: 000007FFDDA80050, size: 268435456)

M  SHM_PAGING_AREA (addr: 0000000016550050, size: 134217728)

M  SHM_ROLL_ADM (addr: 000000001E560050, size: 2767448)

M  SHM_PAGING_ADM (addr: 0000000002F20050, size: 787488)

M  ThCreateNoBuffer allocated 548152 bytes for 1000 entries at 0000000015F70050

M  ThCreateNoBuffer index size: 3000 elems

M  ThCreateVBAdm allocated 30976 bytes (50 server) at 00000000029E0050

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation view

X  ES initialized.

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

B 

B Thu May 29 09:08:15 2014

B  db_con_shm_ini:  WP_ID = 0, WP_CNT = 14, CON_ID = -1

B  dbtbxbuf: Buffer TABL  (addr: 0000000026270160, size: 30000000, end: 0000000027F0C4E0)

B  dbtbxbuf: Profile: max_objects = 5000, displace = 1, reorg = 1

B  dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5, parallel_penalty = 0

B  dbtbxbuf: protect_shm = 0, force_checks = 0

B  dbtbxbuf: tsize_retry = 14446080

B  dbtbxbuf: obj_entry_size = 208, nt_genkey_entry_size = 28

B  ***LOG BB0=> buffer TABL       started with length 30000000   bytes [dbtbxbuf     16909]

B  dbtbxbuf: Buffer TABLP (addr: 0000000027F10160, size: 10240000, end: 00000000288D4160)

B  dbtbxbuf: Profile: max_objects = 500, displace = 1, reorg = 1

B  dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5, parallel_penalty = 50

B  dbtbxbuf: protect_shm = 0, force_checks = 0

B  dbtbxbuf: tsize_retry = 5056000

B  dbtbxbuf: obj_entry_size = 208, nt_genkey_entry_size = 28

B  ***LOG BB0=> buffer TABLP      started with length 10240000   bytes [dbtbxbuf     16909]

B  dbtbxbuf: Reading TBX statistics:

B 

B Thu May 29 09:08:16 2014

B  dbtbxbuf: 0 object entries precreated

B  dbsync[db_syinit]: shared memory successfully created and initialised, sync_adm_p = 00000000029F0050

B  dbsync[db_syinit]: Buffer synchronisation started with

B    sync_concept      = SEQ_NR

B    sendon            = 1

B    bufreftime        = 120

B    max_gap_wait_time = 60

B    ddlog_del_time    = 60

B    last_counter      = -2147478159

B    oldest_gap        = (2147483647,00000000000000)

B    time_of_last_sync = 20140529090816

B    MySysId           = 'Ibo-PC              00'

B  dbexpbuf[EXP_SHB]: Aquired semaphore 35 in db_exp_init(EXP_INIT)

B  Layout of EIBUF buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 424 = 424

B  2: 14 * 40 = 560

B  3: 4001 * 52 = 208052

B  4: 2000 * 256 = 512000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 65 * 8 = 520

B  8: 13439 * 256 = 3440384

B  Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B  dbexpbuf: Buffer EIBUF (addr: 00000000288E0170, size: 4194304, end: 0000000028CE0170)

B  ***LOG BB0=> buffer EIBUF      started with length 4096k      bytes [dbexpbuf     2312]

B  dbexpbuf[EXP_SHB]: semaphore 35 released in db_exp_init

B  dbexpbuf[EXP_SHM]: Aquired semaphore 56 in db_exp_init(EXP_INIT)

B  Layout of ESM   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 424 = 424

B  2: 14 * 40 = 560

B  3: 4001 * 52 = 208052

B  4: 2000 * 256 = 512000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 65 * 8 = 520

B  8: 13439 * 256 = 3440384

B  Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B  dbexpbuf: Buffer ESM   (addr: 0000000028CF0170, size: 4194304, end: 00000000290F0170)

B  ***LOG BB0=> buffer ESM        started with length 4096k      bytes [dbexpbuf     2312]

B  dbexpbuf[EXP_SHM]: semaphore 56 released in db_exp_init

B  dbexpbuf[EXP_CUA]: Aquired semaphore 30 in db_exp_init(EXP_INIT)

B  Layout of CUA   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 424 = 424

B  2: 14 * 40 = 560

B  3: 3001 * 52 = 156052

B  4: 1500 * 256 = 384000

B  5: 3001 * 8 = 24008

B  6: 1 * 200 = 200

B  7: 193 * 8 = 1544

B  8: 4892 * 512 = 2504704

B  Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B  dbexpbuf: Buffer CUA   (addr: 0000000029100170, size: 3072000, end: 00000000293EE170)

B  ***LOG BB0=> buffer CUA        started with length 3000k      bytes [dbexpbuf     2312]

B  dbexpbuf[EXP_CUA]: semaphore 30 released in db_exp_init

B  dbexpbuf[EXP_OTR]: Aquired semaphore 55 in db_exp_init(EXP_INIT)

B  Layout of OTR   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 424 = 424

B  2: 14 * 40 = 560

B  3: 4001 * 52 = 208052

B  4: 2000 * 256 = 512000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 81 * 8 = 648

B  8: 13439 * 256 = 3440384

B  Tracing = 0, Shm Protection = 0, Force checks = 0, Recovery delay = 500000

B  dbexpbuf: Buffer OTR   (addr: 00000000293F0170, size: 4194304, end: 00000000297F0170)

B  ***LOG BB0=> buffer OTR        started with length 4096k      bytes [dbexpbuf     2312]

B  dbexpbuf[EXP_OTR]: semaphore 55 released in db_exp_init

B  ***LOG BB0=> buffer CALE       started with length 500000     bytes [dbcalbuf     2211]

B  dbtran INFO (init_connection '<DEFAULT>' [ADABAS D:720.00]):

B   max_blocking_factor       =  10,  min_blocking_factor         =  10,

B   max_in_blocking_factor    = 127,  min_in_blocking_factor      = 127,

B   max_union_blocking_factor =  10,  min_union_blocking_factor   =  10,

B   prefer_union_all          =   1,  prefer_join                 =   0,

B   prefer_fix_blocking       =   0,  prefer_in_itab_opt          =   1,

B   convert AVG               =   0,  alias table FUPD            =   0,

B   escape_as_literal         =   0,                                  

B   select *                  =0x0f,  character encoding          = STD / <none>:-,

B   use_hints                 = abap->1, dbif->0x1, upto->4294967295

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

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

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

sysno      00

sid        NSP

systemid   562 (PC with Windows NT)

relno      7200

patchlevel 0

patchno    214

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

profile    \\Ibo-PC\sapmnt\NSP\SYS\profile\NSP_DVEBMGS00_Ibo-PC

pid        140

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

length of sys_adm_ext is 588 bytes

*** SWITCH TRC-HIDE on ***

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

  shared lib "dw_xml.dll" version 214 successfully loaded

  shared lib "dw_xtc.dll" version 214 successfully loaded

  shared lib "dw_stl.dll" version 214 successfully loaded

  shared lib "dw_gui.dll" version 214 successfully loaded

  shared lib "dw_mdm.dll" version 214 successfully loaded

  shared lib "dw_rndrt.dll" version 214 successfully loaded

  shared lib "dw_abp.dll" version 214 successfully loaded

  shared lib "dw_sym.dll" version 214 successfully loaded

  shared lib "dw_aci.dll" version 214 successfully loaded

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

use internal message server connection to port 3900

rdisp/dynamic_wp_check : 1

rdisp/calculateLoadAverage : 1

Thu May 29 09:06:53 2014

*** 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  6423]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: write dp-profile-values into sys_adm_ext

DpIPCInit2: start server >Ibo-PC_NSP_00                           <

DpShMCreate: sizeof(wp_adm) 31696 (2264)

DpShMCreate: sizeof(tm_adm) 5517056 (27448)

DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1384064/1384080

DpShMCreate: sizeof(comm_adm) 1384080 (2744)

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

DpShMCreate: sizeof(slock_adm) 0 (296)

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

DpShMCreate: sizeof(file_adm) 0 (80)

DpShMCreate: sizeof(vmc_adm) 0 (2152)

DpShMCreate: sizeof(wall_adm) (41664/42896/64/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: sizeof(j2ee_adm) 3952

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000DEC0050, size: 7163600)

DpShMCreate: allocated sys_adm at 000000000DEC0060

DpShMCreate: allocated wp_adm_list at 000000000DEC3070

DpShMCreate: allocated wp_adm at 000000000DEC3260

DpShMCreate: allocated tm_adm_list at 000000000DECAE40

DpShMCreate: allocated tm_adm at 000000000DECAE90

DpShMCreate: allocated wp_ca_adm at 000000000E40DDA0

DpShMCreate: allocated appc_ca_adm at 000000000E41D7B0

DpShMCreate: allocated comm_adm at 000000000E42D1C0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000E57F060

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated gw_adm at 000000000E57F110

DpShMCreate: allocated j2ee_adm at 000000000E57F150

DpShMCreate: allocated ca_info at 000000000E5800D0

DpShMCreate: allocated wall_adm at 000000000E580160

DpCommAttachTable: attached comm table (header=000000000E42D1C0/ft=000000000E42D1D0)

DpSysAdmIntInit: initialize sys_adm

rdisp/test_roll : roll strategy is DP_NORMAL_ROLL

dia token check not active (6 token)

MBUF state OFF

DpCommInitTable: init table for 500 entries

Thu May 29 09:06:54 2014

DpRqQInit: keep protect_queue / slots_per_queue 0 / 2001 in sys_adm

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

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> EsILock: use spinlock for locking

<ES> InitFreeList

<ES> block size is 4096 kByte.

<ES> Info: em/initial_size_MB( 4095MB) not multiple of em/blocksize_KB( 4096KB)

<ES> Info: em/initial_size_MB rounded up to 4096MB

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 1023 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

MPI: dynamic quotas disabled.

MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.4 3.4 4.1) [dpxxdisp.c   1701]

Thu May 29 09:06:55 2014

***LOG Q0K=> DpMsAttach, mscon ( Ibo-PC) [dpxxdisp.c   12514]

MBUF state LOADING

DpStartStopMsg: send start message (myname is >Ibo-PC_NSP_00                           <)

DpStartStopMsg: start msg sent

CCMS uses Shared Memory Key 73 for monitoring.

CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

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

DpMBufHwIdSet: set Hardware-ID

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

MBUF state ACTIVE

DpWpBlksLow: max wp blocks in queue is 800 (80 %)

MBUF component UP

DpMsgProcess: 1 server in MBUF

DpAppcBlksLow: max appc blocks in queue is 500 (50 %)

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

[Reagan]

Open MaxDB Studio Manager and check the Log Area and Data Area free space.

If there is a problem with the free space then fix that and restart SAP

Regards

RB

[former_member184158]

I have this one also,

[former_member184158]

[former_member184158]

I dont want to reinstall SAP , please HELP

[Reagan]

You need to add the database connection using the user CONTROL and then connect to the database.

You will then be able to check the log and data area.

Regards

RB

[former_member188883]

Hi Ibrahim,

Please refer steps to add database under the link

Managing the List of Database Instances (SAP Library - Tools)

You can use the link below to perform connection to DB instance

Connection to the DBM Server (SAP Library - Tools)

Backup configuration

Database Manager (DBMGUI): SAP DB - SAP High Availability (BC-CCM-HAV) - SAP Library

Hope this helps.

Regards,

Deepak Kori

[former_member184158]

thank you very much , I will do!

[former_member184158]

Thank you very much for your help.