work processes in run state, unable to log on to server

[Former Member]

Hi All,

Component: ERP 6.0 EHP1 SR1

DB: MaxDB

Operating System: RHEL 5 SR3

Server Architecture: IBM X3650 M2(7947)

Followed Reference: Master Guide For EHP1 SR1

We have installed a new SAP ABAP system where in the SAP installation was

successful. After the fresh installation we have upgraded the Kernel to

the latest one which was downloaded from the SAP Market place. After the Kernel upgrade we ran SGEN then to go further with the post installation activities.

Unfortunately nothing seems to work at the moment. When SGEN was getting performed we have noticed that nothing was happening on the screen,

everything was stand still.

We did even try to log on to the server using SAP Gui but it displays SAP

GUI for windows and that's it, nothing happens either.

Since the Installation we have bee following SAP Master Guide for ERP 6.0

EHP1 SR1. All the parameters have been keyed in according to the notes

provided.

Notes followed since Installation

883072 Globalization Information On SAP ERP

916649 LINUX REDHAT EL5/X86_64 64BIT -Maxdb

1165067 Release info SAP EHP4 for ERP 6.0

1165437 Required support packages

1165438 Required Software Components

1143022 Installation of SAP EHP4

1142632 Enhancements for EHP installer:MaxDB

1048303 Red Hat Installation and upgrade on SAP

171356 Sap software on Linux

941735 Linux kernel parameters

146289 Parameter Recommendations for 64 bit

816097 Availability of SAP on Linux for X86_64 platform

1021236 Using sap kernel 7.01 and higher on RHEL

171380 Linux: Released IBM hardware

1300536 Installation net 7.0 ehp1 sr1

1437105 o/s limits for sap instances

823941 sap start service

1414994 sapinit permissions

215877 IBM serve raid adapter

1148232 stopdb doesn't shutdown the database under unix

500235 Network Diagnosis using NIPING

674630 SAP GUI gets disconnected

The Whole time taken for the SAP installation is about 23 hours. Then

upgraded the kernel to the latest ones available in the market.

The original installed kernel patch level was:32

The latest installed kernel patch level is: 93

Files downloaded from SAP Market place in order to perform kernel upgrade

are: SAPEXE_69-10005984.SAR, SAPEXEDB_69-10005988.SAR, dw_93-10005984.sar.

After the successful upgrade process we then ran SGEN transaction,

everything seems to be alright for a while and then found that nothing is

happening on the screen. We did even try loggin on to the SAP server

using SAP GUI but wasn't able to log on to it either.

Checked the DB state using command: dbmcli -U c db_state and the output

was: ok, state, online

Then tried R3trans -x: the return code was(0000). Also tried checking

R3trans -d, the output is: checking ADA db Database and that's it,

nothing happens here. Just the cursor at the command line blinks for ever.

Tried dpmon to check the Work Processes status.

Typed dpmon

Output: the dispatcher queue statistics are displayed

-->q quit

-->m menu

select m

and selected option l to take a look at the work processes. We noticed

that all the work processes seem to be in the run state.

-

---

dev_w0 log says this ...

trc file: "dev_w0", trc level: 1, release: "701"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 00

M sid SPP

M systemid 390 (AMD/Intel x86_64 with Linux)

M relno 7010

M patchlevel 0

M patchno 32

M intno 20020600

M make: single threaded, Unicode, 64 bit, optimized

M pid 8915

M

M

M Thu Jun 3 21:52:36 2010

M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q01=> ThInit, WPStart (Workproc 0 1 8915) [thxxhead.c 1290]

M ThInit: running on host sapserver1

M

M Thu Jun 3 21:52:37 2010

M calling db_connect ...

C

C DBSDBSLIB : version 700.08, patch 0.024 (Make PL 0.32)

C MAXDB shared library (dbsdbslib) patchlevels (last 10)

C (0.024) Default value for max. input variables is 2000 (note 655018)

C (0.024) Profile parameter to define max. input variables (note 655018)

C (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841)

C (0.024) Input parameters for SQL statements increased (note 655018)

C (0.018) Create index serial for MaxDB 7.6 (note 1267841)

C (0.018) More trace in case of packed to string conversion error (note 1262799)

C (0.016) R3trans export aborts with signal 6 (note 1262245)

C (0.007) Support DB-Type 'SAP DB' by UPDSTAT (note 1225668)

C

C

C Loading SQLDBC client runtime ...

C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 002-121-083-965

C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 015-123-202-938

C SQLDBC client runtime is MaxDB 7.6.5.015 CL 202938

C SQLDBC supports new DECIMAL interface : 0

C SQLDBC supports VARIABLE INPUT data : 1

C SQLDBC supports keepAlive indicator : 0

C INFO : SQLOPT= -I 0 -t 0 -S SAPR3

C Try to connect (DEFAULT) on connection 0 ...

C Attach to SAP DB : Kernel 7.7.06 Build 010-123-204-327

C Database release is SAP DB 7.7.06.010

C INFO : Database 'SPP' instance is running on 'sapserver1'

C DB max. input host variables : 2000

C INFO : SAP DB Packet_Size = 131072

C INFO : SAP DB Min_Reply_Size = 4096

C INFO : SAP DB Comm_Size = 126976

C INFO : DBSL buffer size = 126976

C INFO : SAP DB MaxLocks = 300000

C INFO : Connect to DB as 'SAPSPP'

C Command info enabled

C Now I'm connected to SAP DB

C 00: sapserver1-SPP, since=20100603215237, ABAP= <unknown> (0)

B Connection 0 opened (DBSL handle 0)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20100603 215237 sapserver1

C INFO : SAP RELEASE (DB) = 701

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif,.swc,.swf

-

---

please help me with this ... the system is supposed to be up by now.... hope u all understand the criticality ...

[Former Member]

Hi ,

Can you please check the logging of the Max DB has not filled up.

Thanks

Rishi Abrol

[Former Member]

Hi Rishi,

Thanks for the reply. I am pretty new to MaxDB, could you tell me how to check it or the command related to it.

I have checked it there is an issue with the shared memory but it looks fine.

the command used to check the file size is: df -l

even checked /dev/shm which is 8192

[Former Member]

Hi ,

Please install the MaxDb gui to make the administration for the Maxdb database.

In that you can easily find out that the log is fill or not.

Thanks

Rishi Abrol.

[JPReyes]

If the logs of MaxDB get full your system will be frozen...

You can install DB Manager in your PC to check the log utilization. Basically if the logs are full the only way to reset it is to do a log backup.

You can also do this task using the dbmcli commands... if its the first time you backup your system then you'll need to define the backup media an do a full backup before the log backup.

All this info is on the guides.

Regards

Juan

[Former Member]

Hi All,

I have checked all the logs and also checked the usernames and the password in the xuser list. still unable to log on as the work processes are still in run state...

[Former Member]

Hi,

Kindly check the permissions of database files and /etc/hosts. Few days before I faced the same problem where all the dia are in run state and no one was able to login.

Thanks

Shaz

[Former Member]

Hi,

I have checked all the permissions and also changed the passwords but the problem still persists.

[Former Member]

Hi guys,

Thanks a lot for all ur sweet replies.. Finally my work processes started working.. I have recently installed DB studio and god know how i got connected to the database using the studio. Then log file came in to my notice, it was damn full. I have added nother logfile and restart the database using DB studio and thts it.. I see my work processes in the wait state and i does allow my login now...

The thing is, i see my data file size as 91% full, log file size as 80% full and same with the sessions.. I need some serious help help. Would some tell me wats goin on here and assist me with some precious inputs. I have already added couple data files and log files but i still see no big change..

This system has no data as of now, i have recently installed SAP on to it..

Thanks in advance.

Thanks and regards

Pradeep Aleti

9989689602