SAP not getting started after Kernel Upgrade 640_REL (139) -> 640_REL (247)

[Former Member]

Hi,

Recently we have done Kernel Upgrade to our Quality Server and the System information is as follows:

OS : Windows 2000 Advanced Srvr 5.0.2195 SP4 Build 2195

DB : Microsoft SQL Server 2000 8.00.2039

Memory : 6GB

SAP Kernel : 640_REL (139) --> 640_REL (247)

SAP BASIS 640 (14)

Problem :

-

---

We have upgraded the Kernel from 640_REL (139) --> 640_REL (247). After the Kernl Upgrade the SAP system is not getting started. I had attached the DEV_W0 file for your reference. Please let me know if you know solution for the error.

Also Please let me know if you need any more logs.

Would appreciate if you could kindly help me solving this issue.

Info: the /PAE setting has already be done in boot.ini file.

Regards,

L Raghunahth

[Former Member · Accepted solution]

Hi,

I am attaching the DEV_W0 file for your reference.

Best Regards

L Raghunahth

(I had to truncate the log file because to match with 15000 characters rule by SDN.. verytough)

DEV_W0 File

-

---

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Mar 14 10:13:43 2009

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\Q01\sys\exe\run\dbmssslib.dll' ...

B Library 'E:\usr\sap\Q01\sys\exe\run\dbmssslib.dll' loaded

B Version of 'E:\usr\sap\Q01\sys\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.241)

B New connection 0 created

M sysno 00

M sid Q01

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 247

M intno 20020600

M make: multithreaded, ASCII

M pid 4208

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 4208) [dpxxdisp.c 1170]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: allocated wall_adm at 00392908

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Sat Mar 14 10:13:44 2009

M calling db_connect ...

C Thread ID:4204

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'E:\usr\sap\Q01\sys\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 241

C patchcomment MSSQL: memory leak in DSQL access to (x)strings (2) (1225411)

C np:(local) connection used on QDRRRV09

C CopyLocalParameters: dbuser is 'dbo'

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: MARS property was not set.

C

C Sat Mar 14 10:13:45 2009

C Provider Release:08.00.1117

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C Cache sizes: header 52 bytes, 20000 names (26880000 bytes), 1000 dynamic statements (5456000 bytes), total 32336052 bytes

C Initializing shared procedure name cache QDRRRV09_Q01_Q01_MEM.

C procedure cache created/attached

C

C Sat Mar 14 10:13:48 2009

C Connected to db server : [QDRRRV09] server_used : [np:(local)], dbname: Q01, dbuser: dbo

C pn_id:QDRRRV09_Q01_Q01

C Not using MARS (on sql 8.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 20090314 101344 QDRRRV09

C The IRow interface is supported by this OLEDB provider

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

M

M Sat Mar 14 10:13:53 2009

M CrtChkOsSem: create check mutex and RC=[already exists] (Key:4/Name:SAP_SYSTEM_MUTEX_0_4/Hdl:76)

I

I Sat Mar 14 10:13:58 2009

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0BD30040, size: 4400000)

M SHM_ROLL_AREA (addr: 1FB70040, size: 268435456)

M SHM_PAGING_AREA (addr: 10440040, size: 134217728)

M SHM_ROLL_ADM (addr: 0C170040, size: 2678942)

M SHM_PAGING_ADM (addr: 05450040, size: 525344)

M ThCreateNoBuffer allocated 324144 bytes for 1000 entries at 054E0040

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 7424 bytes (50 server) at 003C0040

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

X ES initialized.

I Sat Mar 14 10:15:09 2009

I *** ERROR => [MapOsShm] Can't find free space for Shared Memory (Size=83582 KB)

[shmnt.c 2130]

I *** ERROR => [AttachOsShm] MapViewOfFile(Key=62,Handle=0x0000041C) failed with Err=0

[shmnt.c 2130]

I *** ERROR => ShmCreate: Attach (62,85588608,2) failed [shmnt.c 385]

*****************************************************

• Memory diagnostic *

*****************************************************

Systeminformation

-

---

Processor-Typ : Intel unknown

Processor-Count : 4

Operating System : NT 5.0, Build 2195

Service Pack : Service Pack 4

-

---

NT Pagefile Informations

-

---

Config. minimum size : 16774144 K

Config. maximum size : 16774144 K

Avail. maximum size : 16774144 K

Num	Pagefile	Min.Size	Max.Size	Avail.Max	Curr.Size
1	C:\pagefile.sys	4193280 K	4193280 K	4193280 K	4193280 K
2	E:\pagefile.sys	4193280 K	4193280 K	4193280 K	4193280 K
3	F:\pagefile.sys	4193280 K	4193280 K	4193280 K	4193280 K
4	G:\pagefile.sys	2097152 K	2097152 K	2097152 K	2097152 K
5	H:\pagefile.sys	2097152 K	2097152 K	2097152 K	2097152 K

-

---

NT Task Manager Informations

-

---

Total Handles : 17766

Total Threads : 986

Total Processes : 105

Commit Charge Total : 4438268 K

Commit Charge Limit : 22875336 K

Commit Charge Peak : 5699400 K

Phys.Memory Total : 6290732 K

Phys.Memory Available : 5109460 K

File Cache : 98440 K

Kernel Memory Total : 85160 K

Kernel Memory Paged : 66852 K

Kernel Memory Nonpaged : 18308 K

-

---

Memory usage of current process

-

---

Total virt.address space : 2097024 K

Avail.virt.address space : 308804 K

Private Pages : 53544 K

Total heap size : 14999 K

Virtual memory regions : 0 K

Uncommitted heap memory : 9208 K

Allocated heap memory : 5541 K

Moveable heap memory : 0 K

DDE shared heap memory : 0 K

-

---

Memory usage of all processes

-

---

PID	Image	Instance	Work.Set	WS Peak	Priv.Pages	PP Peak	Pg Fault
8			256 K	1420 K	28 K	1192 K	344
	Sum		1096724 K		1196052 K

I

I Sat Mar 14 10:15:11 2009

I *** ERROR => ShmCreate( ATTACH 62, 85588600) failed 1 [mpixx.c 843]

M *** ERROR => DpInitMpi: MpiInit failed (1) [dpxxtool2.c 3557]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: DpInitMpi (step 1, th_errno 17, action 3, level 1) [thxxhead.c 9708]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server QDRRRV09_Q01_00 on host QDRRRV09 (wp 0)

M * ERROR tskh_init: DpInitMpi

M *

M * TIME Sat Mar 14 10:15:11 2009

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 17

M * MODULE thxxhead.c

M * LINE 9893

M * COUNTER 1

M *

M *****************************************************************************

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M TrThHookFunc: called for WP dump

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 255]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 4208) [dpnttool.c 357]

[Former Member · Accepted solution]

Hi,

If this is the Central DB Instance then value of PHYS_MEMSIZE parameter should be 30% of RAM. Also check your page file size and make it atleast 3 to 4 times of RAM.

check out SAP note on Zero administration memory management on windows.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=88416]

Hope this helps.

Manoj

[Former Member · Accepted solution]

hi,

Have you gone thru the note and the memory leak problem, the section in the attached W0 log.

From the log:

M Sat Mar 14 10:13:44 2009

M calling db_connect ...

C Thread ID:4204

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'E:\usr\sap\Q01\sys\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 241

C patchcomment MSSQL: memory leak in DSQL access to (x)strings (2) (1225411)

C np:(local) connection used on QDRRRV09

C CopyLocalParameters: dbuser is 'dbo'

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: MARS property was not set.

END

Observd there is memory leak happening from log.

Also make R3TRANS and see if SAP able to connect to DB wht was the return code for tht, should be 0000 any thing other than tht, no connection between SAP and DB.

ALso From LOG

NT Pagefile Informations

Config. minimum size : 16774144 K

Config. maximum size : 16774144 K

Avail. maximum size : 16774144 K

Num Pagefile Min.Size Max.Size Avail.Max Curr.Size

-

---

-

---

-

---

-

---

-

---

-

---

1 C:\pagefile.sys 4193280 K 4193280 K 4193280 K 4193280 K

2 E:\pagefile.sys 4193280 K 4193280 K 4193280 K 4193280 K

3 F:\pagefile.sys 4193280 K 4193280 K 4193280 K 4193280 K

4 G:\pagefile.sys 2097152 K 2097152 K 2097152 K 2097152 K

5 H:\pagefile.sys 2097152 K 2097152 K 2097152 K 2097152 K

END

wht is CURR mean, is tht size currently occupied, in tht case there is no further space available in ssytem for paging, even this could lead to system down. CHK for memory leakage from the vendor...

Regards....

Edited by: Sita Rr Uppalapati on Mar 22, 2009 12:45 PM

[Former Member]

please paste the contents of dev_w0 log here,i couldnt find any attachments

Rohit