Skip to Content
0
Former Member
May 08, 2010 at 08:35 AM

Sql Server Network Error !!

82 Views

HI

we hav 2 sys landscape ,dev and qal on one server and prd on one server dev and qal are not getting up simultaneously . when I start dev the qal is getting down and if start qal dev is getting down. but if I start dev alone its getting up and same with qal.

disp trace file

-


trc file: "dev_disp", trc level: 1, release: "700"

-


sysno 01

sid GEQ

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 164

intno 20050900

make: multithreaded, Unicode, optimized

pid 5608

Sun May 02 19:48:08 2010

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

length of sys_adm_ext is 576 bytes

  • SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (01 5608) [dpxxdisp.c 1257]

shared lib "dw_xml.dll" version 164 successfully loaded

shared lib "dw_xtc.dll" version 164 successfully loaded

shared lib "dw_stl.dll" version 164 successfully loaded

shared lib "dw_gui.dll" version 164 successfully loaded

shared lib "dw_mdm.dll" version 164 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3901

Sun May 02 19:48:12 2010

  • WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5418]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >saperpged_GEQ_01 <

DpShMCreate: sizeof(wp_adm) 28968 (1704)

DpShMCreate: sizeof(tm_adm) 4415616 (21968)

DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

DpShMCreate: sizeof(comm_adm) 528064 (1048)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (96)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1544)

DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 06830040, size: 5086040)

DpShMCreate: allocated sys_adm at 06830040

DpShMCreate: allocated wp_adm at 06832098

DpShMCreate: allocated tm_adm_list at 068391C0

DpShMCreate: allocated tm_adm at 068391F0

DpShMCreate: allocated wp_ca_adm at 06C6F270

DpShMCreate: allocated appc_ca_adm at 06C75070

DpShMCreate: allocated comm_adm at 06C76FB0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 06CF7E70

DpShMCreate: allocated gw_adm at 06CF7EB0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 06CF7EE0

DpShMCreate: allocated wall_adm at 06CF7EE8

MBUF state OFF

DpCommInitTable: init table for 500 entries

rdisp/queue_size_check_value : -> off

ThTaskStatus: rdisp/reset_online_during_debug 0

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

Sun May 02 19:48:13 2010

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 3324 blocks reserved for free list.

ES initialized.

  • ERROR => [CreateOsShm] CreateFileMapping(62,83926 KB) failed with Err=1455

ERROR_COMMITMENT_LIMIT: The paging file is too small for this operation to complete. [shmnt.c 2174]

  • ERROR => ShmCreate: Create (62,85940720,1) failed [shmnt.c 506]

http://support.microsoft.com/kb/155012 (Check this website)

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

  • Memory diagnostic *

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

Systeminformation

-


Processor-Typ : Intel Pentium Pro

Processor-Count : 4

Operating System : NT 5.2, Build 3790

Service Pack : Service Pack 2

-


NT Pagefile Informations

-


Config. minimum size : 12476416 K

Config. maximum size : 12476416 K

Avail. maximum size : 12476416 K

Num

Pagefile

Min.Size

Max.Size

Avail.Max

Curr.Size







1

c:\pagefile.sys

4190208 K

4190208 K

4190208 K

4190208 K

2

l:\pagefile.sys

4096000 K

4096000 K

4096000 K

4096000 K

3

z:\pagefile.sys

4190208 K

4190208 K

4190208 K

4190208 K

-


NT Task Manager Informations

-


Total Handles : 0

Total Threads : 0

Total Processes : 0

Commit Charge Total : 11569000 K

Commit Charge Limit : 11632572 K

Commit Charge Peak : 11569000 K

Phys.Memory Total : 54 K

Phys.Memory Available : 93191052 K

File Cache : 17424022 K

Kernel Memory Total : 2084222616 K

Kernel Memory Paged : 0 K

Kernel Memory Nonpaged : 93191080 K

-


Memory usage of current process

-


Total virt.address space : 2097024 K

Avail.virt.address space : 806584 K

Private Pages : 0 K

Total heap size : 12184 K

Virtual memory regions : 0 K

Uncommitted heap memory : 6764 K

Allocated heap memory : 5306 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









1848

sapstartsrv.exe

15944 K

15952 K

18744 K

18748 K

4

1708

msg_server.EXE

[MS] GEQ_01

8244 K

8244 K

10516 K

10516 K

2

5608

disp+work.EXE

24812 K

24940 K

67980 K

68112 K

6

384

igswd.EXE

[**] GEQ_01

2820 K

3064 K

1524 K

1804 K

0

4396

igsmux.exe

11916 K

11916 K

13040 K

13040 K

2

6016

igspw.exe

2560 K

2560 K

2424 K

2424 K

0

4900

igspw.exe

2560 K

2560 K

2424 K

2424 K

0









Sum

68856 K

116652 K

  • ERROR => ShmCreate(62, 85940712) failed 1 [mpixx.c 867]

  • ERROR => DpInitMpi: MpiInit failed (1) [dpxxtool2.c 5064]

  • DP_FATAL_ERROR => DpSapEnvInit: DpInitMpi failed

  • DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun May 02 19:48:23 2010

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Sun May 02 15:48:23 2010

========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

-


0 DIA -1 Run no 0 0 0

1 DIA -1 Run no 0 0 0

2 DIA -1 Run no 0 0 0

3 DIA -1 Run no 0 0 0

4 DIA -1 Run no 0 0 0

5 DIA -1 Run no 0 0 0

6 DIA -1 Run no 0 0 0

7 DIA -1 Run no 0 0 0

8 DIA -1 Run no 0 0 0

9 DIA -1 Run no 0 0 0

10 UPD -1 Run no 0 0 0

11 ENQ -1 Run no 0 0 0

12 BTC -1 Run no 0 0 0

13 BTC -1 Run no 0 0 0

14 BTC -1 Run no 0 0 0

15 SPO -1 Run no 0 0 0

16 UP2 -1 Run no 0 0 0

Dispatcher Queue Statistics Sun May 02 15:48:23 2010

===========================

--------


+
+

+

+
--


+

Typ

now

high

max

writes

reads

--------


+
+

+

+
--


+

NOWP

0

0

2000

0

0

--------


+
+

+

+
--


+

DIA

0

0

2000

0

0

--------


+
+

+

+
--


+

UPD

0

0

2000

0

0

--------


+
+

+

+
--


+

ENQ

0

0

2000

0

0

--------


+
+

+

+
--


+

BTC

0

0

2000

0

0

--------


+
+

+

+
--


+

SPO

0

0

2000

0

0

--------


+
+

+

+
--


+

UP2

0

0

2000

0

0

--------


+
+

+

+
--


+

max_rq_id 0

wake_evt_udp_now 0

wake events total 0, udp 0 ( 0%), shm 0 ( 0%)

since last update total 0, udp 0 ( 0%), shm 0 ( 0%)

Dump of tm_adm structure: Sun May 02 15:48:23 2010

=========================

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Sun May 02 15:48:23 2010

=============================

Slots: 300, Used: 0, Max: 0

--------


+
+
--


+

id

owner

pid

eyecatcher

--------


+
+
--


+

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun May 02 19:48:28 2010

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >saperpged_GEQ_01 < (normal)

DpJ2eeDisableRestart

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

[DpWpDied] W0 handle not set (PID:-1)

[DpWpDied] W1 handle not set (PID:-1)

[DpWpDied] W2 handle not set (PID:-1)

[DpWpDied] W3 handle not set (PID:-1)

[DpWpDied] W4 handle not set (PID:-1)

[DpWpDied] W5 handle not set (PID:-1)

[DpWpDied] W6 handle not set (PID:-1)

[DpWpDied] W7 handle not set (PID:-1)

[DpWpDied] W8 handle not set (PID:-1)

[DpWpDied] W9 handle not set (PID:-1)

[DpWpDied] W10 handle not set (PID:-1)

[DpWpDied] W11 handle not set (PID:-1)

[DpWpDied] W12 handle not set (PID:-1)

[DpWpDied] W13 handle not set (PID:-1)

[DpWpDied] W14 handle not set (PID:-1)

[DpWpDied] W15 handle not set (PID:-1)

[DpWpDied] W16 handle not set (PID:-1)

Stop work processes

Terminate gui connections

wait for end of work processes

not attached to the message server

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 5608) [dpxxdisp.c 10705]

Good Bye .....