SAPgui: Waiting for response

[Former Member]

Hi all,

after the failed attempt to make a client copy I have some problems:

Stopping the system with stopsap or stopping the database (MaxDB) not possible, because "there are still active users on database system"

--> so I must stop the database with dbmcli

--> after each new sapstart I have the same problem

Also login is not possible:

While trying to connect to the system SAPgui gives

"Waiting for Response" but nothing works.

Problem with the database?

--> entry in dev-disp: swap space to small, tmpfs at /dev/shm to small

Connection problem?

--> entry in dev_ms:

"MsSCheckConnections: no response from Client C0 (<hostname>_<sid>00)"

--> entry in CPITRCxxxxx:

"GwIConnect to <hostname> / 3300 failed..."

"CPIC (TCP/IP) on local host

Partner 192.168.0.200 not reached

What can I do?

Thank you in advance

Wilhelm

[hannes_kuehnemund · Accepted solution]

Hi Wilhelm,

maybe the DB went full during copy?

Check:

dbmcli -U c -d <SID> -USQL c sql_execute 'select logsize - (usedlog) from serverdbstatistics'
dbmcli -U c -d <SID> -USQL c sql_execute 'select serverdbsize - (usedblocks) from serverdbstatistics'

if result is near to zero, either log or DB are full.

Thanks,

Hannes

[Former Member · Accepted solution]

HI Hannes,

thank you for response. Results:

1. command 'select logsize from serverdbstatistics' brings 255736

2. command 'select serverdbsize from serverdbstatistics' brings 12672000

So I think, that's not the problem

Wilhelm

[hannes_kuehnemund · Accepted solution]

HI Hannes,

thank you for response. Results:

1. command 'select logsize from serverdbstatistics' brings 255736
2. command 'select serverdbsize from serverdbstatistics' brings 12672000

So I think, that's not the problem

Wilhelm

Did you executed the commands I posted correctly? I looks like you executed:

dbmcli -U c -d <SID> -USQL c sql_execute 'select logsize from serverdbstatistics'

instead of the correct one:

dbmcli -U c -d <SID> -USQL c sql_execute 'select logsize - (usedlog) from serverdbstatistics'

we of course need to compute the number of free pages by substracting the number of used ones from the configured ones...

Thanks,

Hannes

[Former Member · Accepted solution]

Hi Hannes,

you are right, the correct command

"dbmcli -U c -d <SID> -USQL c sql_execute 'select logsize - (usedlog) from serverdbstatistics'"

brings 0!

That's the same result as I got by

Command "dbmcli -U c show TASKS" brings as T123: APPL Pid 5576 Current state "LOG FULL"

(see below)

Thank you

(I'm learning!)

[markus_doehr2 · Accepted solution]

yeah - your log is full (as described in the other thread)

Markus

[Former Member · Accepted solution]

Hi Markus,

now I have installed the MaxDB Database Studio 7.7, new Tool like MaxDB Database Manager with dbmcli-Features

(Sapnote 1097311 - MaxDB Database Studio Installation)

After backup of the database and the log area the DB is accessible again.

Thank you again for the tip

Wilhelm

[Former Member · Accepted solution]

Hi ,

I am encounter the same issue. i checked my log size, it shows the logsize and usedlog are equall . This gives that my logsize is full. I am getting wait for response and dbconnected with the active users.

So can you tell me how to clear the logs and what are the steps to be followed. Is this needed any backup. Its new installed system . How to do the maxdb backup . We dont have maxdbgui.

[hannes_kuehnemund · Accepted solution]

Dear usersrikanth,

I've seen that you already asked this question is the correct forum, the MaxDB one. Please note, that cross posts are not common practice in the SDN. Therefore I'm going to lock this thread.

Hannes

[markus_doehr2]

Stopping the system with stopsap or stopping the database (MaxDB) not possible, because "there are still active users on database system"

--> so I must stop the database with dbmcli

--> after each new sapstart I have the same problem

This is known and solved by applying the scripts of note 1148232 - stopdb does not shut down database under Unix

Also login is not possible:

While trying to connect to the system SAPgui gives

"Waiting for Response" but nothing works.

Well - this is also a "known" issue. The system just needs some time to startup. The problem here is the table TBTCO (and related ones). On system start a full table scan is made to check the status of the jobs in the system. Depending on the number of jobs that are still there and the speed of the underlying I/O system this startup can take quite some time.

After having restarted our BI system (on MaxDB) it takes 20 - 25 minutes for the system to get up completely until we´re able to login.

I hope that the new prefetching, which will be soon available, will help here making those table scans faster.

Markus

[Former Member]

Hi Markus,

"After having restarted our BI system (on MaxDB) it takes 20 - 25 minutes for the system to get up completely until we´re able to login."

Now I'm waiting for several hours without being able to login.

Can I clear this table TBTCO without logged in?

Perhaps this is a track?

Command "dbmcli -U c show TASKS" brings as T123: APPL Pid 5576 Current state "LOG FULL"

T124 - T159: "Comand wait"

37 Tasks are in State "Connect wait"

Is this helpful for diagnosis?

Wilhelm

[markus_doehr2]

> Now I'm waiting for several hours without being able to login.

> Can I clear this table TBTCO without logged in?

No.

> Perhaps this is a track?

> Command "dbmcli -U c show TASKS" brings as T123: APPL Pid 5576 Current state "LOG FULL"

> T124 - T159: "Comand wait"

> 37 Tasks are in State "Connect wait"

>

> Is this helpful for diagnosis?

Oh YES! and that is your problem.

Your log area is full and the database won't accept any more inserts/deletes/updates. This is a very common "problem".

You need to

- take a full backup of the database

- take a backup of the log area

After that your system should get online again

Markus

[Former Member]

Hi Markus,

see a smile in my face!

"- take a full backup of the database

- take a backup of the log area ."

-> for the first time: how do I do that?

[markus_doehr2]

> see a smile in my face!

>

> "- take a full backup of the database

> - take a backup of the log area ."

>

> -> for the first time: how do I do that?

The easiest way is to install DBMGUI or Database Studio (see here: https://www.sdn.sap.com/irj/sdn/maxdb-downloads) - you can choose

Check the guide

https://www.sdn.sap.com/irj/sdn/maxdb

--> Backup and Restore

and

http://maxdb.sap.com/doc/7_6/f8/5a27401544ed01e10000000a155106/frameset.htm

Basically you will need to

- connect DBMGUI or Database Studio to your database (using the dbm/control user)

- create a medium where to backup (disk, tape)

- run the database backup

- create a second medium for the logfiles

- backup the log

Get back if you have a problem

Markus

[nelis]

Hi,

Have you checked database space and the database logs ? What version Linux/SAP are you using ?

Please check note 171356 "SAP Software on Linux: Essential Information" for any specific changes that need to be made for your distribution.

Regards,

Nelis