Dev_disp in yellow state

Published by Tobias Hofmann on

3 min read

Installing a SAP NetWeaver ABAP system is easy, keeping it up and running demands a little bit more. Don’t expect a NetWeaver ABAP system to just work, be prepared to do some additional configuration.

Symptom

After starting the SAP NetWeaver ABAP instance, you are not able to connect to it. SAPGui tries to connect, but never finishes. This indicates that the message server accepts connections, but cannot process them. At the server, the startsap command executed successfully, it shows that ASCS and DI were started. But still, no connection is possible. What happened?

Analysis

Taking a look into the dev_disp log reveals that really a problem is going on.

Log file: dev_disp

It is always a good idea to check the connection to the database (here: MaxDB).

Command:
/usr/sap/GWD/DVEBMGS00/exe/R3load –testconnect

The program hangs and never terminates. Also, no trans.log file is created. This indicates a DB problem. Check if the DB is up and running.

  • DB GWD is up and running.

More information about DBMCLI

To get more information about MaxDB database, dbmcli offers the info command: dmbcli info

Command: dbmcli -d GWD -u control,<password> info LOG

Problem

The above command reveals what is causing the problem. The log area is full:

Used size is 100%. MaxDB cannot write anything anoymore to the log area. The solution is to archive the log area so MaxDB gains more space for the log area and is able to save new entires to it. Another command that can be used to find out if the log area is full is:

Command: dbmcli -d GWD -u control,<password> show active


Solution

The solution is to create a backup medium that MaxDB uses to archive its log area to.

Command: medium_put

Best approach is to ensure that a backup medium for DB and for log area are available for MaxDB to use.

Create backup mediums

  1. Log on to MaxDB with dbmcli.
  2. Command: dbmcli –d <DBSID> -u control,<password>

  3. Create medium for data backup

    Command: backup_template_create backup_data_1 to FILE /sap/sapdb/<DBSID>/backup/DAT0001 CONTENT DATA

  4. Create medium for log area backup
  5. Command:backup_template_create backup_log_1 to FILE /sap/sapdb/GWD/backup/LOG CONTENT LOG

  6. Start backup. For this, an open db connection must be established. If you are not already logged on to MaxDB via dbmcli, connect!
  7. Command: db_connect
  8. Backup of data

    Command: backup_start backup_data_1

  9. Backup log area

    Command: backup_start backup_log_1

    *You do the data backup first because this for the log area backup to be executed, a data backup must be run at least once before.

After these steps, a backup for the data content and for the log area was created.

To ensure that the log area is automatically backed up and is not reaching its limit again, activate auto backup.

To get a list of configured mediums available in MaxDB, issue the command medium_getall

Let the world know

Tobias Hofmann

Doing stuff with SAP since 1998. Open, web, UX, cloud. I am not a Basis guy, but very knowledgeable about Basis stuff, as it's the foundation of everything I do (DevOps). Performance is king, and unit tests is something I actually do. Developing HTML5 apps when HTML5 wasn't around. HCP/SCP user since 2012, NetWeaver since 2002, ABAP since 1998.

3 Comments

magnum3 · December 29, 2015 at 17:43

Bonjour,

thank you for these information.
I am using “mini SAP” (ABAP trial ; NSP) and the log file was full.

I used your solution and it was working fine for me..

I created a folder “backup” (C:sapdbNSPbackup). Here its situation : 4 files
– DATA0002 (size 23 816 832 ko)
– LOG0001 (size 682 880 ko)
– LOG0002 (size 682 880 ko)
– LOG0003 (size 682 512 ko)

But, as it is a trial system, used only by me for personal purpose (ABAP) on my personal computer, I am not interested to back up data (file of 23 go). The file DATA0002 is huge (23 go), is there a way to remove it so I can still access SAP netweaver NSP ?

Cordialement

    Tobias Hofmann · December 30, 2015 at 13:43

    Not 100% sure, but you should be able to delete the backup files. What you`ll need are the actual data files used by NW.

magnum3 · January 10, 2016 at 16:24

Thank you for your response. I will try to delete the back up file later.

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.