disp+work goes yellow with message: running but dialog queue standstill

[Former Member]

I just installed CRM 7.0 on Windows with MaxDB 7.7.04 build 28. After the installation I was able to logon and begin applying support packs. In the middle of doing this, the system hung and I noticed the disp+work went yellow with the message "Running but dialog queue standstill". I shut down the system, rebooted the machine and started up again. The same error is occuring. Here are some log files:

adatmp:

Error! Connection failed to node sitaserv23 for database CRE:

-24700,ERR_DBMSRV_NOSTART: Could not start DBM server.

-24832,ERR_SHMNOTAVAILABLE: Shared memory not available

-24827,ERR_SHMALLOCFAILED: ID C:\sapdb\data\wrk\CRE.dbm.shi, requested size 2600

stderr1:

C:\usr\sap\CRE\DVEBMGS02\work>set DBNAME=CRE

C:\usr\sap\CRE\DVEBMGS02\work>set DBNAME=CRE

C:\usr\sap\CRE\DVEBMGS02\work>if "" == "" (set DB_USERKEY="c" ) else (set DB_USERKEY="c_J2EE" )

C:\usr\sap\CRE\DVEBMGS02\work>dbmcli -U "c" db_state 1>adatmp

C:\usr\sap\CRE\DVEBMGS02\work>findstr "ONLINE" adatmp

C:\usr\sap\CRE\DVEBMGS02\work>dbmcli -U "c" dbm_version VERSION 1>adatmp

C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.2" adatmp

C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.3" adatmp

C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.4" adatmp

C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.5" adatmp

C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.6" adatmp

C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.7" adatmp

Error: Database CRE NOT started !

I tried applying note 1041650 but this seems to be for UNIX. I don't know how to clear memory in Windows 2003 server.

I updated the kernel to 117 with disp+work at 130. Still the same.

Please help.

Thanks,

Peggy

[Former Member · Accepted solution]

Here is the result

db_state

OK

ONLINE

x_cons <SID> sh ac

SERVERDB: CRE

ID UKT Win TASK APPL Current Timeout Region Wait

tid type pid state priority cnt try item

T113 8 0x8F0 User 956 LOG FULL (246) ! 0 0 11514(s)

So I can see that it is full. What can I do to increase the size and/or turn off logging?

Thanks!

[markus_doehr2 · Accepted solution]

> So I can see that it is full. What can I do to increase the size and/or turn off logging?

Check the HowTo:

http://wiki.sdn.sap.com/wiki/display/MaxDB/LogAreaFull

Markus

[Former Member]

Can you advise me how to do that? I'm new to MaxDB (Oracle is what I normally use).

There is a log file under: C:\sapdb\CRE\saplog called DISKL001 that I see with a size of 2,048,000 but I don't know how to check if it's full or how to create a new one.

Please advise.

Thanks,

Peggy

[markus_doehr2]

Please execute the following commands as user <sid>adm:

dbmcli -U c db_state

x_cons <SID> sh ac

Markus

[markus_doehr2]

> I just installed CRM 7.0 on Windows with MaxDB 7.7.04 build 28. After the installation I was able to logon and begin applying support packs. In the middle of doing this, the system hung and I noticed the disp+work went yellow with the message "Running but dialog queue standstill". I shut down the system, rebooted the machine and started up again. The same error is occuring. Here are some log files:

Please check if the log area of the database is full.

Markus