"stopsap all" command stuck with message "Checking ADA Database"

[Former Member]

Hi,

After installing NW 7.31 ABAP, we upgraded the Basis component to SPS 03 (SAPKB73103) using SPAM, which is causing the following issues -

1. Cannot stop SAP app server and database ("stopsap all" command gets stuck with message "Checking ADA Database".

2. Cannot login via SAP GUI - Hangs with the message "Connecting - please wait".

We have already tried to reboot the server at OS level. We are able to start the app server and database with the command "startsap all" when the OS comes back up, but the above two issues still persist - cannot login to SAP GUI and cannot stop app server and database.

We are using MaxDB version 7.8

Any input / help would be much appreciated.

Thanks,

Birla.

[Former Member · Accepted solution]

Check the DB with Database Studio, or dbmcli without starting SAP.
It sounds like the log area, or database files are full. (if it is MaxDB)

Also check filesystems.

regards

Chris

[hannes_kuehnemund · Accepted solution]

The dbmcli command should be executed as sidadm.

> dbmcli db_state

To check what the DB is doing at all (more info than the state), just execute

> x_cons <SID> sh act 1

and you see what the MaxDB UserKernelTasks are doing.

Regards,

  Hannes

[Former Member · Accepted solution]

Thank you all for the reply! I executed the following command as user SDB and it appears that Database LOG is full. How do I rectify this situation?

Command: /sapdb/GDD/db/pgm/cons GDD sh act 1

T153   8   6325 User	12732 LOG FULL (246)	0	3744(s)
T169   8   6325 User	9586 LOG FULL (246)	0	3744(s)

Thanks,

Birla.

[former_member188883 · Accepted solution]

Hi Birla,

Refer link on solutions to Log area being full

http://wiki.sdn.sap.com/wiki/display/MaxDB/Log+Area+Full

Hope this helps.

Regards,

Deepak Kori

[csaba_goetz]

Hello Birla,

1. Cannot stop SAP app server and database ("stopsap all" command gets stuck with message "Checking ADA Database".

Check stopdb.log, stopsap.log and startsap.trc in $HOME folder of sidadm (usually: /home/sidadm).

Those may contain more information about the root cause.

2. Cannot login via SAP GUI - Hangs with the message "Connecting - please wait". 

Chech with dpmon, sapcontrol or SAP MC (SAPMMC) the ABAP workprocess list, i.e. the status of workprocesses. Probably they are busy.

Some help reg. the commands:

    dpmon pf=/sapmnt/SID/profile/<instance_profile> l   (there is a lowercase "l" letter at the end of command, this will show the long work process list)

    sapcontrol -nr <instance nr> -host <hostname> -function ABAPGetWPList

Best regards,

Adam