disp+work.EXE running but Dialog Queue standstill

[Former Member]

Hi,

The dispatcher of my ERP system has the status 'running but Dialog Queue standstill'  and all ABAP work processes are not running. Without having any work processes running, I am not even able to use SAP GUI to connect to the system.

Host and system details:

• I have installed an ERP system and Solution Manager on the same Windows box
• The host is Amazon EC2 instance running Windows 2008R2 SP1 Server 64 bit (total memory 15 GB and Processing Power 8 ECUs) .
• The ERP system is ERP 6.0 Support Release 3, MaxDB 7.8, Central System.
• The Solution Manager 7.1 Support Release 1, MaxDB 7.8, Central System.

Both systems -- ERP and Solution Manager -- were running at the same time. I have no idea why the ERP system is broken but the Solution Manager is still running.

Has anyone faced the highlighted problem 'Windows time jumped approx -2 seconds. ' as seen below. The following log is from dev_disp:

Tue May 07 00:40:12 2013

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 %)

Tue May 07 01:25:14 2013

*** ERROR => 07.05.2013 01:25:14.319 PID=5652, TID=6640    SapTimer error. Time may be incorrect on your system. Windows time jumped approx -2 seconds. Slept 1000 millisec, Qpc elapsed: +989 millisec, WindowsUtc elapsed -1618 millisec.  SapTime-WindowsUtcTime=+2560 millisec. QpcTime-WindowsUtcTime=-1663 millisec (*). [dpxxdisp.c   21114]

Tue May 07 01:55:15 2013

*** ERROR => 07.05.2013 01:55:15.095 PID=5652, TID=6640    SapTimer error. Time may be incorrect on your system. Windows time jumped approx -2 seconds. Slept 1000 millisec, Qpc elapsed: +999 millisec, WindowsUtc elapsed -1175 millisec.  SapTime-WindowsUtcTime=+1155 millisec. QpcTime-WindowsUtcTime=-1612 millisec (*). [dpxxdisp.c   21114]

Tue May 07 02:37:23 2013

DpSigInt: caught signal 2

DpHalt: shutdown server >WEDOIT-HOST_ER1_02                      < (normal)

DpModState: change server state from STARTING to SHUTDOWN

DpHalt: stop work processes

Tue May 07 02:38:24 2013

DpHalt: stop gateway

DpHalt: stop icman

DpHalt: terminate gui connections

DpHalt: wait for end of work processes

DpHalt: waiting for termination of work processes ...

Tue May 07 02:38:25 2013

DpHalt: waiting for termination of work processes ...

Tue May 07 02:38:26 2013

DpHalt: waiting for termination of work processes ...

Tue May 07 02:38:27 2013

DpHalt: waiting for termination of work processes ...

Tue May 07 02:38:28 2013

DpHalt: waiting for termination of work processes ...

Tue May 07 02:38:29 2013

DpHalt: waiting for termination of work processes ...

...........

Tue May 07 02:39:22 2013

DpHalt: waiting for termination of work processes ...

Tue May 07 02:39:23 2013

*** ERROR => DpHalt: W8 (pid 6280) still alive ... [dpxxdisp.c   11145]

DpHalt: waiting for termination of work processes ...

Tue May 07 02:39:24 2013

DpHalt: wait for end of gateway

*** ERROR => [DpProcDied] Process died  (PID:6816  HANDLE:924  rc:0x0) [dpnttool2.c  147]

DpHalt: wait for end of icman

*** ERROR => [DpProcDied] Process died  (PID:6820  HANDLE:936  rc:0x0) [dpnttool2.c  147]

DpStartStopMsg: send stop message (myname is >WEDOIT-HOST_ER1_02                      <)

DpStartStopMsg: stop msg sent

Tue May 07 02:39:25 2013

DpHalt: sync with message server o.k.

DpHalt: detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c   12911]

MBUF state OFF

MBUF component DOWN

DpHalt: cleanup EM

***LOG Q05=> DpHalt, DPStop ( 5652) [dpxxdisp.c   11427]

Many thanks for your help.

Regards,

Andreas

[Former Member]

I assume that my problem is caused by a strange behavior of the database connection.  For some admin user, the database connection seems to work, but for other admin users the connections is failing.

I have installed an ERP system, Solution Manager and  SAP MaxDB on the same host (using as a demo system). SAP MaxDB version 7.8.02.26, the ERP and Solution Manager have their own DB.

Installation Properties for the database DB2 which is used by the ERP system:

OK

VERSION    = 7.8.02.26

INSTROOT   = C:\sapdb\DB2\db

SYSTEM     = NO

ISOLATED   = YES

XServerState = Running

SSLPortNoOrService = 7205

NIPortNoOrService = 7204

PortNoOrService = 7203

XserverAutostart = yes

DataPath   = C:\sapdb\DB2\data

Name = DB2

Installation Properties for the database DB1 which is used by the Solution Manager system:

OK

VERSION    = 7.8.02.26

INSTROOT   = C:\sapdb\DB1\db

SYSTEM     = NO

ISOLATED   = YES

XServerState = Running

SSLPortNoOrService = 7202

NIPortNoOrService = 7201

PortNoOrService = 7200

XserverAutostart = yes

DataPath   = C:\sapdb\DB1\data

Name = DB1

Testing database connection with Solution Manager admin sm1adm user:

C:\usr\sap\SM1\SYS\profile>r3trans -d

This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).

unicode enabled version

sizeof(Selection_t) = 272

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

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

r3trans finished (0000).

C:\usr\sap\ER1\SYS\profile>r3trans -d

This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).

unicode enabled version

sizeof(Selection_t) = 272

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

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

r3trans finished (0000).

--> the database connection with the solution manager admin works fine.

Testing database connection with ERP admin user er1adm user:

C:\usr\sap\SM1\SYS\profile>r3trans -d

This is r3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

unicode enabled version

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

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

C:\usr\sap\ER1\SYS\profile>r3trans -d

This is r3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

unicode enabled version

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

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

--> both tests do not complete returning a validation code

Testing database connection with Windows admin user:

C:\usr\sap\SM1\SYS\profile>r3trans -d

This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).

unicode enabled version

sizeof(Selection_t) = 272

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

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

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

r3trans finished (0012).

C:\usr\sap\ER1\SYS\profile>r3trans -d

This is r3trans version 6.24 (release 720 - 19.03.13 - 20:13:03 ).

unicode enabled version

sizeof(Selection_t) = 272

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

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

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

r3trans finished (0012).

--> return code indicates kernel issue

What is causing the different behavior?  Why is the database connection depending on the user?

[AtulKumarJain]

Hi ,

Please check the below url

http://scn.sap.com/message/506791

http://scn.sap.com/thread/1611444

R3trans -d should be excuted with <sid>adm user and pleasse check the trans.log after excuteing R3trans -d

Best Regards,

Atul

[Former Member]

Try updating the database password file

In DB2 the  database password file is dscsb6up

[Former Member]

Hi Atul,

I have executed r3trans -d with different users as you can see above.

Then I used the er1adm user which is the local ERP admin.  Even so the test did not completed with any return code such as r3trans finished (0012), the trans log file did not contain any error.

The trans log file looks ok.

4 ETW000  [	dev trc,00000]   <- getNewConnection(con_hdl=0)	87  0.156398
4 ETW000  [	dev trc,00000]   -> checkEnvironment(con_hdl=0)	33  0.156431
4 ETW000  [	dev trc,00000]   -> connect()	32  0.156463
4 ETW000  [	dev trc,00000]  INFO : SQLOPT= -I 0 -t 0 -S SAPR3	56  0.156519
4 ETW000  [	dev trc,00000]  Try to connect (DEFAULT) on connection 0 ...	74  0.156593
4 ETW000  [	dev trc,00000]   -> check_db_params(con_hdl=0)	9734  0.166327
4 ETW000  [	dev trc,00000]  Attach to SAP DB : Kernel	7.8.02   Build 026-121-243-456	711  0.167038
4 ETW000  [	dev trc,00000]  Database release is SAP DB 7.8.02.026	31  0.167069
4 ETW000  [	dev trc,00000]  INFO : Database 'DB2' instance is running on 'WEDOIT-HOST'	243  0.167312
4 ETW000  [	dev trc,00000]  DB supports UPSERT SQL syntax : 1	5340  0.172652
4 ETW000  [	dev trc,00000]  DB supports new EXPAND syntax : 1	27  0.172679
4 ETW000  [	dev trc,00000]  DB supports LOB locators	: 1	19  0.172698
4 ETW000  [	dev trc,00000]  DB uses MVCC support	: 0	18  0.172716
4 ETW000  [	dev trc,00000]  DB max. input host variables  : 2000	18  0.172734
4 ETW000  [	dev trc,00000]  DB max. statement length	: 65535	19  0.172753
4 ETW000  [	dev trc,00000]  UPSERT is disabled for : WBCROSSGT	22  0.172775
4 ETW000  [	dev trc,00000]  INFO : SAP DB Packet_Size = 131072	2421  0.175196
4 ETW000  [	dev trc,00000]  INFO : SAP DB Min_Reply_Size = 4096	1754  0.176950
4 ETW000  [	dev trc,00000]  INFO : SAP DB Comm_Size = 126976	29  0.176979
4 ETW000  [	dev trc,00000]  INFO : DBSL buffer size = 126976	27  0.177006
4 ETW000  [	dev trc,00000]  INFO : SAP DB MaxLocks = 300000	561  0.177567
4 ETW000  [	dev trc,00000]  INFO : Connect to DB as 'SAPER1'	229  0.177796
4 ETW000  [	dev trc,00000]  Command info enabled	298  0.178094
4 ETW000  [	dev trc,00000]  Now I'm connected to MaxDB	24  0.178118
4 ETW000  [	dev trc,00000]  00: WEDOIT-HOST-DB2, since=20130508230757, ABAP= <unknown> (0)	42  0.178160
4 ETW000  [	dev trc,00000]  } DbSlSdbConnect(rc=0)	19  0.178179
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=30,arg_p=0000000000000000)	22  0.178201
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=15)	17  0.178218
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=21,arg_p=000000000202FB10)	20  0.178238
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	18  0.178256
4 ETW000  [	dev trc,00000]  Connection 0 opened (DBSL handle 0)	19  0.178275
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=7,arg_p=000000000202FB50)	27  0.178302
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	18  0.178320
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=63,arg_p=000000000202F950)	33  0.178353
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	18  0.178371
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=21,arg_p=000000000202F9A0)	26  0.178397
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	17  0.178414
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=11,arg_p=000000000202FAC0)	21  0.178435
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	17  0.178452
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=22,arg_p=000000000202FA30)	21  0.178473
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	17  0.178490
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=13,arg_p=000000000202F900)	20  0.178510
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	18  0.178528
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=24,arg_p=000000000202F8B0)	20  0.178548
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=0)	17  0.178565
4 ETW000  [	dev trc,00000]  { DbSlSdbControl(con_hdl=0,command=51,arg_p=000000000202F8A0)	21  0.178586
4 ETW000  [	dev trc,00000]  } DbSlSdbControl(rc=15)	17  0.178603
4 ETW000  [	dev trc,00000]  { DbSlSdbPrepare(con_hdl=0,ss_p=000000000202FB80,op=3,da_p=000000000202FC00)
4 ETW000	36  0.178639
4 ETW000  [	dev trc,00000]   -> build_stmt(stmt_p=000000000202FB60,da_p=000000000202FC00,for_explain=0,lock=0,op=3)
4 ETW000	99  0.178738
4 ETW000  [	dev trc,00000]	SELECT INTO is possible with 1 parameters	25  0.178763

Many thanks for your help.

Andreas

[Reagan]

Hello

Can you come back the dev_w0 and the trans.log trace files ?

Attach them to the message instead of pasting part of them.

The trans.log file is not complete.

Cheers

RB

[Reagan]

Hello

I see SapTimer errors and the only SAP Note that speak about it is this

Note 1466511 - Missing Statistic Data in ST03

Please check it.

Cheers

RB

[karthikeyan_natarajan4]

Hi Andreas,

since your solman is running, only erp is down - please check the log area of erp instance.

Use DBMGUI and select the instance and check the log area, if its full, you have to backup the log area in order to reuse the existing log volume.

As Juan requested, please paste dev_w0 logs too

regards

karthik

[AtulKumarJain]

Hi Andreas,

Please find the solution in below thread

http://scn.sap.com/thread/3269025

BR

Atul

[JPReyes]

Can you post errors on dev_w0?

Regards, Juan