LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings

[former_member274034]

Hello Experts,

After the last Windows 7 patch install I have a problem with my NW ABAP Trial 70206 64Bit Version.

When I start the server through MMC it becomes yellow after that green and yellow again.

Please help,

I attached dev_disp, dev_icm, dev_ms, dev_w0

dev_disp.zip

dev_ms.zip

dev_icm.zip

[former_member274034 · Accepted solution]

---------------------------------------------------

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

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        NSP

M systemid   562 (PC with Windows NT)

M relno      7200

M patchlevel 0

M patchno    46

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    \\HOME1\sapmnt\NSP\SYS\profile\NSP_DVEBMGS00_HOME1

M pid        6668

M

M 

M Mon Apr 14 16:30:49 2014

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

M  length of sys_adm_ext is 588 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 6668) [dpxxdisp.c   1314]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is active

M  DpIPCInit2: read dp-profile-values from sys_adm_ext

M  DpShMCreate: sizeof(wp_adm) 31696 (2264)

M  DpShMCreate: sizeof(tm_adm) 5517056 (27448)

M  DpShMCreate: sizeof(wp_ca_adm) 64000 (64)

M  DpShMCreate: sizeof(appc_ca_adm) 64000 (64)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/584064/584080

M  DpShMCreate: sizeof(comm_adm) 584080 (1144)

M  DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=512/48/65600/90416/156064

M  DpShMCreate: sizeof(slock_adm) 156064 (104)

M  DpFileTableSize: max/headSize/ftSize/tableSize=2800/16/268864/268880

M  DpShMCreate: sizeof(file_adm) 268880 (80)

M  DpShMCreate: sizeof(vmc_adm) 30128 (2152)

M  DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M  DpShMCreate: sizeof(gw_adm) 48

M  DpShMCreate: sizeof(j2ee_adm) 3936

M  DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000DCB0050, size: 6812336)

M  DpShMCreate: allocated sys_adm at 000000000DCB0060

M  DpShMCreate: allocated wp_adm_list at 000000000DCB3030

M  DpShMCreate: allocated wp_adm at 000000000DCB3220

M  DpShMCreate: allocated tm_adm_list at 000000000DCBAE00

M  DpShMCreate: allocated tm_adm at 000000000DCBAE50

M  DpShMCreate: allocated wp_ca_adm at 000000000E1FDD60

M  DpShMCreate: allocated appc_ca_adm at 000000000E20D770

M  DpShMCreate: allocated comm_adm at 000000000E21D180

M  DpShMCreate: allocated slock_adm at 000000000E2ABB20

M  DpShMCreate: allocated file_adm at 000000000E2D1CD0

M  DpShMCreate: allocated vmc_adm_list at 000000000E313730

M  DpShMCreate: allocated vmc_adm at 000000000E3137E0

M  DpShMCreate: allocated gw_adm at 000000000E31ADA0

M  DpShMCreate: allocated j2ee_adm at 000000000E31ADE0

M  DpShMCreate: allocated ca_info at 000000000E31BD50

M  DpShMCreate: allocated wall_adm at 000000000E31BD70

M  DpCommAttachTable: attached comm table (header=000000000E21D180/ft=000000000E21D190)

M  DpSesCreateTable: attached session table at 0000000002BD0050 (len=161328)

M  DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

M  rdisp/queue_size_check_value :  -> on,50,30,40,500,50,500,80

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation view

X  <EsNT> Using memory model view.

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

M 

M Mon Apr 14 16:30:50 2014

M  DpVmcSetActive: set vmc state DP_VMC_ENABLED

M  DpVmcSetActive: set vmc state DP_VMC_ACTIVE

M  DpVmcInit2: o.k.

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

M 

M Mon Apr 14 16:30:52 2014

M  ThInit: running on host HOME1

M 

M Mon Apr 14 16:30:53 2014

M  calling db_connect ...

B  create_con (con_name=R/3)

B  Loading DB library 'C:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' ...

B 

B Mon Apr 14 16:30:54 2014

B  Library 'C:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' loaded

B  Version of 'C:\usr\sap\NSP\DVEBMGS00\exe\dbsdbslib.dll' is "720.00", patchlevel (0.45)

B  New connection 0 created

C 

C  DBSDBSLIB : version 720.00, patch 0.045 (Make PL 0.46)

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

C    (0.045) Unknown primary key (note 1459400)

C    (0.039) Define your own command buffersize (note 1340617)

C    (0.031) Dbm commands support added (note 1420733)

C    (0.027) Count of records for bulk insert optimized (note 1340617)

C    (0.021) Connect with special xuser key (note 1390464)

C    (0.018) Error handling for external update statistics changed (note 1340617)

C    (0.018) Dbsl procedure to update datasource information (note 1340617)

C    (0.015) Special describe handling on MaxDB systemtables (note 1382175)

C    (0.013) Possibility to disable UPSERT statements (note 1340617)

C    (0.013) Check for external update statistics changed (note 1340617)

C 

C 

C  Loading SQLDBC client runtime ...

C 

C Mon Apr 14 16:30:56 2014

C  SQLDBC Module  : C:\sapdb\clients\NSP\pgm\libSQLDBC77.dll

C  SQLDBC SDK     : SQLDBC.H  7.7.4    BUILD 009-123-173-450

C  SQLDBC Runtime : libSQLDBC 7.8.1    BUILD 014-121-233-288

C  SQLDBC client runtime is MaxDB 7.8.1.014 CL 233288

C  SQLDBC supports new DECIMAL interface : 1

C  SQLDBC supports VARIABLE INPUT data   : 1

C  SQLDBC supports VARIABLE OUTPUT data  : 1

C  SQLDBC supports Multiple Streams      : 1

C  SQLDBC supports LOB LOCATOR KEEPALIVE : 1

C  SQLDBC supports LOB LOCATOR COPY      : 1

C  SQLDBC supports BULK SELECT with LOBS : 1

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

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

C  Attach to SAP DB : Kernel    7.8.01   Build 014-121-233-288

C  Database release is SAP DB 7.8.01.014

C  INFO : Database 'NSP' instance is running on 'HOME1'

C 

C Mon Apr 14 16:30:57 2014

C  DB supports UPSERT SQL syntax : 1

C  DB supports new EXPAND syntax : 1

C  DB supports LOB locators      : 1

C  DB uses MVCC support          : 0

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 'SAPNSP'

C  Command info enabled

C  Now I'm connected to MaxDB

C  00: HOME1-NSP, since=20140414163056, ABAP= <unknown> (0)

B  Connection 0 opened (DBSL handle 0)

B  Wp  Hdl ConName          ConId     ConState     TX  BC  HC  PRM RCT FRC TIM MAX OPT Date     Time   DBHost           Program                                

B  000 000 R/3              000000000 ACTIVE       NO  NO  NO  YES NO  NO  000 255 255 20140414 163054 HOME1                                                   

C  INFO : SAP RELEASE (DB) = 702

M  ThInit: db_connect o.k.

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

M 

M Mon Apr 14 16:30:58 2014

M  vmcj/sgc_options: switch on template cleanup before cloning

M  vmcj/sgc_options: switch off delayed session cleanup during shared gc

M  ThVmcInitWaitForVm: th_maxWaitForVmTime=30

M  ThVmcInitMaxErrCount: th_max_error_count=5

[Reagan · Accepted solution]

Hello

Connect to the MaxDB database using MaxDB Database Manager and check whether there is a space issue in the log area and/or data area.

Regards

RB

[former_member274034 · Accepted solution]

Thanks for you reply

Do you know what is the User Name & Password for the trial version NSP Database name ?

Regards,

Oren

[Reagan · Accepted solution]

I believe it should be the one you used when you installed it.

Try the username control with the password control.

If that doesn't work then check this SAP note

396492 - Changing the DBM user (CONTROL)

Regards

RB

[former_member274034 · Accepted solution]

Dear RB,

Indeed the Log Area Full.

I will try to empty it and see if this will work

Thank you very much !

Regards,

Oren

[Reagan · Accepted solution]

Take a log area backup using the MaxDB Database Manager.

Follow this wiki

Log Area Full - MaxDB - SCN Wiki

Regards

RB

[former_member274034 · Accepted solution]

Dear Reagan Benjamin,

Thank you very much for your help it was very quick and helpful !

Best Regards,

Oren