cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ERP ECC 6 Upgrade, Phase: MAIN_TRANSEXEC/DDIC_TRANS

Former Member
0 Kudos

Dear all,

I have a problem during upgrading to ECC6, it is more than 2 days that it is in the MAIN_TRANSEXEC/DDIC_TRANS phase. There is no error but also no progress.

OS: Win2008 server, DB: Oracle 11g

I did not stop the SAP service but it is stopped.

The SAPupconsole. Log

2013/08/01 12:10:21  START OF PHASE MAIN_TRANSEXEC/DDIC_TRANS

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DEFAULT.TPP checkimpdp BQ1

0:00: Importing for group 1/64 size 368.99 MB: Setting stop mark before 'SAPK-604DRINSAPHR'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=1 -Dparallel=3

5:32: Importing for group 2/64 size 85.59 MB: Setting stop mark before 'SAPKGEI05A'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=2 -Dparallel=2

11:34: Importing for group 3/64 size 467.85 MB: Setting stop mark before 'SAPK-603DRINFICA'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=1 -Dparallel=3

27:03: Importing for group 4/64 size 273.53 MB: Setting stop mark before 'SAPK-603DRINISOIL'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=2 -Dparallel=2

37:45: Importing for group 5/64 size 17.01 MB: Setting stop mark before 'SAPK-604DZINISPRA'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=1 -Dparallel=3

38:46: Importing for group 6/64 size 1.95 MB: Setting stop mark before 'SAPK-603DRINISPSCA'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=2 -Dparallel=2

39:26: Importing for group 7/64 size 31.85 MB: Setting stop mark before 'SAPK-603DRINISUT'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=1 -Dparallel=3

40:47: Importing for group 8/64 size 84.54 MB: Setting stop mark before 'SAPK-605IRINSEMBW'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=2 -Dparallel=2

43:28: Importing for group 9/64 size 544.12 MB: Setting stop mark before 'SAPKB73102'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=1 -Dparallel=3

58:20: Importing for group 10/64 size 563.35 MB: Setting stop mark before 'SAPK-405AGINEAIPPE'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=2 -Dparallel=2

1:04:22: Importing for group 11/64 size 35.63 MB: Setting stop mark before 'SAPK-604DRINEAFINSRV'.

Running D:\usr\sap\BQ1\DVEBMGS00\exe\tp pf=G:\SUM\abap\var\DDICUPG.TPP put BQ1 -Dmainimp_proc=1 -Dparallel=3

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

  1. SAPup.log

CURRENTPHASE MAIN_TRANSEXEC/DDIC_TRANS

...started at 20130801121021

...begin processing at 20130801121025

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

  1. Sysstatus.log

SAPup> Starting subprocess in phase 'CHECKSYSSTATUS_POST' at 20130729112217

ENV: JAVA_HOME=C:\j2sdk1.4.2_17-x64

ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV: ORACLE_HOME=D:\oracle\BQ1\11203

ENV: ORACLE_SID=BQ1

ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

ENV: SAPDATA_HOME=F:\oracle\BQ1

ENV: SAPSYSTEMNAME=BQ1

ENV: dbs_ora_schema=SAPSR3

ENV: dbs_ora_tnsname=BQ1

EXECUTING D:\usr\sap\BQ1\DVEBMGS00\exe\sapcontrol.exe -format script -prot PIPE -host SrvSapERPQA6 -nr 00 -function GetProcessList

  1. 29.07.2013 11:22:17

GetProcessList

OK

0 name: msg_server.EXE

0 description: MessageServer

0 dispstatus: GREEN

0 textstatus: Running

0 starttime: 2013 07 29 10:11:11

0 elapsedtime: 1:11:06

0 pid: 3624

1 name: disp+work.EXE

1 description: Dispatcher

1 dispstatus: GREEN

1 textstatus: Running, Message Server connection ok, Dialog Queue time: 0.00 sec

1 starttime: 2013 07 29 10:11:11

1 elapsedtime: 1:11:06

1 pid: 3680

2 name: igswd.EXE

2 description: IGS Watchdog

2 dispstatus: GREEN

2 textstatus: Running

2 starttime: 2013 07 29 10:11:11

2 elapsedtime: 1:11:06

2 pid: 3052

SAPup> Process with PID 27972 terminated with status 3 at 20130729112217!

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

Would you please help?

BR,

Salameh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear IIke

How can i set the Oracle initialization parameter? would you please tell me step by step.

BR,

Salameh

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello

Why don't you just raise an OSS message ?

What is the status of the upgrade in the SUM tool ?

What happens when you repeat the phase in the SUM tool.

In order to help you, you need to help us with the correct information with the logs and screen shots.

Regards

RB

tsenol
Active Participant
0 Kudos

Hi Salameh,

I'm writing the steps. If you can't set the parameter please ask to a DBA.

Cancel the SAP upgrade

in CMD screen

     sqlplus "/ as sysdba"

     alter system set "_use_zero_copy_io" = false scope = spfile;

     shutdown immediate;

     startup;

     show paremeter _use_zero_copy_io;

After starting the Oracle, in same screen you must see the parameter value as FALSE.

Start the Upgrade again.

Regards

Tutku

former_member185239
Active Contributor
0 Kudos

Hi Tutku,

What i know about the parameter is that , you should not change this parameter until and unless SAP suggest you to do so.

With Regards

Ashutosh Chaturvedi

tsenol
Active Participant
0 Kudos

Hi Ashutosh,

this suggestion from SAP is written in this 2 SAP notes as a workaround. When I faced with this situation first time, OSS sent me this notes.

•1738989  - Upgrade/Support Package import hang due to INACTIVE wait event "SQL*Net break/reset client" in Oracle

•1635605 - CLIENT HANGS ON INSERT INTO TABLE WITH SECUREFILE LOB

Answers (10)

Answers (10)

Former Member
0 Kudos

Dear IIke

I restart the upgrading and it again hang at the same phase and this time I did as you told me and it worked and is now going on. I really appreciate your help. Thank you so much for sharing with me your valuable experience.

WR,

Salameh

Dear All Experts,

Thank you all for helping me, I learned a lot from you all.

Here in SCN I do not feel alone.

WR,

Salameh

Former Member
0 Kudos

Hi Tutku,

I am upgrading my test system from ECC 6 to EHP7, I was facing same error. After changing the parameter suggested by you. The upgrade is generating logs in log directory, earlier it was not generating any log (being stop).

Thank you for sharing the solution, which relaxed me as things are moving properly.

Thank you once again Tutku.

Regards,

Yogesh

tsenol
Active Participant
0 Kudos

Hi all,

I faced with same error before.

Set the Oracle initialization parameter " _use_zero_copy_io=false" as a workaround and reboot the database instance. Sap Notes about this issue are below:

  • 1738989  - Upgrade/Support Package import hang due to INACTIVE wait event "SQL*Net break/reset client" in Oracle
  • 1635605 - CLIENT HANGS ON INSERT INTO TABLE WITH SECUREFILE LOB
former_member185239
Active Contributor
0 Kudos

Hi ,

Please do as follow,

1. stop the SAP

2. run sapcpe pf=<Give the instance profile  DVEBMGS00>

  Run sapcpe pf=<Give the Central service instant SCS01>>(if you have a dual stack or java)

Please let me know your kernel level as well.

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi,

I tried to reset the upgrading as follow but it is not possible

G:\SUM\abap\bin>sapup.exe reset prepare

Enter the path of your root directory [G:\SUM\abap]:

Root directory =

FATAL ERROR: System already in or after downtime, no reset possible

?!

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello

Before you reset can you check whether the SAP is started ?

Secondly provide the dev-w0 trace file to see why you are not able to login.

Regards

RB

former_member188883
Active Contributor
0 Kudos

Hi,

As per the logs

Library 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' loaded

B  *** ERROR => Version mismatch between kernel (721.02) and DBSL shared library (720.00)

[dbcon.c      5450]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 008192) [thxxhead.c   1497]

Could you update the kernel is not synchronized between DVEB*/exe and /sapmnt/SID/exe

Please synchronize the same and start the system manually.

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi RB,

The SAP service is start.

this is the dev_w0 log:

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        BQ1

M systemid   562 (PC with Windows NT)

M relno      7210

M patchlevel 0

M patchno    100

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    \\SrvSapERPQA6\sapmnt\BQ1\SYS\profile\BQ1_DVEBMGS00_SrvSapERPQA6

M pid        3816

M

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

M  length of sys_adm_ext is 588 bytes

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

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M  DpIPCInit2: read dp-profile-values from sys_adm_ext

M  DpShMCreate: sizeof(wp_adm)        36096    (2256)

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/1384064/1384080

M  DpShMCreate: sizeof(comm_adm)        1384080    (2744)

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

M  DpShMCreate: sizeof(slock_adm)        0    (296)

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

M  DpShMCreate: sizeof(file_adm)        0    (80)

M  DpShMCreate: sizeof(vmc_adm)        0    (2160)

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

M  DpShMCreate: sizeof(gw_adm)    48

M  DpShMCreate: sizeof(j2ee_adm)    3952

M  DpShMCreate: SHM_DP_ADM_KEY        (addr: 000000000FD90050, size: 7168064)

M  DpShMCreate: allocated sys_adm at 000000000FD90060

M  DpShMCreate: allocated wp_adm_list at 000000000FD930B0

M  DpShMCreate: allocated wp_adm at 000000000FD932A0

M  DpShMCreate: allocated tm_adm_list at 000000000FD9BFB0

M  DpShMCreate: allocated tm_adm at 000000000FD9C000

M  DpShMCreate: allocated wp_ca_adm at 00000000102DEF10

M  DpShMCreate: allocated appc_ca_adm at 00000000102EE920

M  DpShMCreate: allocated comm_adm at 00000000102FE330

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 00000000104501D0

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated gw_adm at 0000000010450280

M  DpShMCreate: allocated j2ee_adm at 00000000104502C0

M  DpShMCreate: allocated ca_info at 0000000010451240

M  DpShMCreate: allocated wall_adm at 00000000104512D0

M Tue Aug 13 09:58:27 2013

M  DpCommAttachTable: attached comm table (header=00000000102FE330/ft=00000000102FE340)

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  <ES> EsILock: use spinlock for locking

X  Using implementation view

X  <EsNT> Using memory model view.

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

X  mm.dump: set maximum dump mem to 96 MB

M  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

M Tue Aug 13 09:58:29 2013

M  ThInit: running on host SrvSapERPQA6

M Tue Aug 13 09:58:30 2013

M  calling db_connect ...

B  Loading DB library 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' ...

B  Library 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' loaded

B Tue Aug 13 09:58:31 2013

B  Version of 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' is "721.02", patchlevel (0.42)

C  Prepending D:\usr\sap\BQ1\DVEBMGS00\exe to Path.

C  Register application info.

C  Oracle client version: 11.2.0.3.0, (dbsl 721 240113, UNICODE[2])

C  Detailed Oracle client (patch) info not available.

C Tue Aug 13 09:58:32 2013

C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@BQ1 on connection 0 (nls 0) ... (dbsl 721 240113, UNICODE[2])

C  Attaching to database server BQ1 (con=0, svchp=078BFA00, srvhp=160EFBD0)

C Tue Aug 13 09:58:56 2013

C  Starting user session: OCISessionBegin(con=0, usr='/', svc=078BFA00, srv=160EFBD0, usr=160FEE60)

C  Now '/@BQ1' is connected: con=0, nls=0, session=241, time='2013-08-13 09:58:56'

C  Got SAPSR3's password from OPS$-user

C  Disconnecting from connection 0 ...

C  Closing user session (con=0, svc=078BFA00, usr=160FEE60)

C  Disconnected (con=0) from ORACLE.

C  Connecting as SAPSR3/<pwd>@BQ1 on connection 0 (nls 0) ... (dbsl 721 240113, UNICODE[2])

C  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=078BFA00, srv=160EFBD0, usr=160FEE60)

C  Now 'SAPSR3/<pwd>@BQ1' is connected: con=0, nls=0, session=241, time='2013-08-13 09:58:56'

C  DB instance BQ1 is running on SRVSAPERPQA6 with ORACLE version 11.2.0.3.0 since AUG 13, 2013, 09:57:53.

C  con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8

C  Nls CharacterSet                      NationalCharSet                   EnvHp            ErrHp            ErrBt          

C    0 UTF16                             AL16UTF16                         160E4AB0         078BCAA8         078BDB88       

B  Connection 0 opened (DBSL handle 0)

C     DbSlControl(DBSL_CMD_SAPRELEASE_SET,abap='731')

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

I  MtxInit: 0 0 0

M  SHM_PRES_BUF            (addr: 000000001B870050, size: 4400000)

M  SHM_ROLL_AREA        (addr: 000007FFD78D0050, size: 268435456)

M  SHM_PAGING_AREA        (addr: 000000001BCB0050, size: 134217728)

M  SHM_ROLL_ADM            (addr: 0000000023CC0050, size: 2767448)

M  SHM_PAGING_ADM        (addr: 00000000055D0050, size: 787488)

M  ThCreateNoBuffer        allocated 548152 bytes for 1000 entries at 00000000078C0050

M  ThCreateNoBuffer        index size: 3000 elems

M  ThCreateVBAdm        allocated 31056 bytes (50 server) at 00000000029F0050

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation view

X  ES initialized.

X  mm.dump: set maximum dump mem to 96 MB

B  db_con_shm_ini:  WP_ID = 0, WP_CNT = 16, CON_ID = -1

B  dbtbxbuf: Buffer TABL  (addr: 0000000029A60160, size: 30000000, end: 000000002B6FC4E0)

B  dbtbxbuf: Buffer TABLP (addr: 000000002B700160, size: 10240000, end: 000000002C0C4160)

B  dbsync[db_syinit]: successfully attached to shared memory, sync_adm_p = 0000000002A00050

B  dbsync[db_syinit]: Buffer synchronisation started with

B    sync_concept      = SEQ_NR

B    sendon            = 0

B    bufreftime        = 120

B    max_gap_wait_time = 60

B    ddlog_del_time    = 60

B    last_counter      = -2147464956

B    oldest_gap        = (2147483647,00000000000000)

B    time_of_last_sync = 20130813095843

B    MySysId           = 'SrvSapERPQA6        00'

B  dbexpbuf[EXP_SHB]: buffer EIBUF installed with

B    semkey             = 35

B    shmkey             = 54

B    wp_n               = 16

B    sclass             = 0

B    block_length       = 256

B    max_objects        = 2000

B    max_obj_size       = 859936

B    pref_obj_size      = 0

B    est_large_obj_size = 16384

B    free_vec_lg        = 65

B    hash_vec_size      = 4001

B    buffer_l           = 4194304

B    max_blocks         = 13439

B    free_blocks        = 13439

B    mutex_n            = 4001

B    max_mtx_wait_time  = 17000

B    recovery_delay     = 500000

B    tracing            = 0

B    force_checks       = 0

B    protect_shm        = 0

B  dbexpbuf[EXP_SHM]: buffer ESM   installed with

B    semkey             = 56

B    shmkey             = 65

B    wp_n               = 16

B    sclass             = 0

B    block_length       = 256

B    max_objects        = 2000

B    max_obj_size       = 859936

B    pref_obj_size      = 0

B    est_large_obj_size = 16384

B    free_vec_lg        = 65

B    hash_vec_size      = 4001

B    buffer_l           = 4194304

B    max_blocks         = 13439

B    free_blocks        = 13439

B    mutex_n            = 4001

B    max_mtx_wait_time  = 17000

B    recovery_delay     = 500000

B    tracing            = 0

B    force_checks       = 0

B    protect_shm        = 0

B  dbexpbuf[EXP_CUA]: buffer CUA   installed with

B    semkey             = 30

B    shmkey             = 47

B    wp_n               = 16

B    sclass             = 10

B    block_length       = 512

B    max_objects        = 1500

B    max_obj_size       = 626016

B    pref_obj_size      = 0

B    est_large_obj_size = 98304

B    free_vec_lg        = 193

B    hash_vec_size      = 3001

B    buffer_l           = 3072000

B    max_blocks         = 4892

B    free_blocks        = 4892

B    mutex_n            = 3001

B    max_mtx_wait_time  = 17000

B    recovery_delay     = 500000

B    tracing            = 0

B    force_checks       = 0

B    protect_shm        = 0

B  dbexpbuf[EXP_OTR]: buffer OTR   installed with

B    semkey             = 55

B    shmkey             = 64

B    wp_n               = 16

B    sclass             = 13

B    block_length       = 256

B    max_objects        = 2000

B    max_obj_size       = 859872

B    pref_obj_size      = 0

B    est_large_obj_size = 20480

B    free_vec_lg        = 81

B    hash_vec_size      = 4001

B    buffer_l           = 4194304

B    max_blocks         = 13438

B    free_blocks        = 13438

B    mutex_n            = 4001

B    max_mtx_wait_time  = 17000

B    recovery_delay     = 500000

B    tracing            = 0

B    force_checks       = 0

B    protect_shm        = 0

I  MPI: dynamic quotas disabled.

I  MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%

M  rdisp/thwpsf_critical_path : -1 -> 0

M  CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

M  CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

G Tue Aug 13 09:58:57 2013

G  RelWritePermissionForShm( pLocation = 120, pEnforce = 0 )

G  GetWritePermissionForShm( pLocation =  99, pEnforce = 1 )

G  RelWritePermissionForShm( pLocation = 100, pEnforce = 1 )

S  *** init spool environment

S  TSPEVJOB updates outside critical section: event_update_nocsec = 1

S  initialize debug system

T  Stack direction is downwards.

T  debug control: prepare exclude for printer trace

T  new memory block 0000000016276BA0

S  spool kernel/ddic check: Ok

S  using table TSP02FX for frontend printing

S  0 spool work process(es) found

S  frontend print via spool service enabled

S  printer list size is 150

S  printer type list size is 50

S  queue size (profile)   = 300

S  hostspool list size = 3000

S  option list size is 30

S      found processing queue enabled

S  found spool memory service RSPO-RCLOCKS at 00000000164C00D0

S  doing lock recovery

S  setting server cache root

S  found spool memory service RSPO-SERVERCACHE at 00000000164C05C0

S    using messages for server info

S  size of spec char cache entry: 297032 bytes (timeout 100 sec)

S  size of open spool request entry: 2512 bytes

S  immediate print option for implicitely closed spool requests is disabled

C                 -> 'OCI_11201_SHARE, 11.2.0.3.0'

A  ***GENER* Trace switched on ***

A  ---PXA-------------------------------------------

A  PXA INITIALIZATION

A  PXA: Locked PXA-Semaphore.

A  System page size: 4kb, total admin_size: 29896kb, dir_size: 29124kb.

A  Attached to PXA (address 000007FFE7900050, size 400000K, 1 fragments of 370104K )

A  PXA allocated (address 000007FFE7900050, size 400000K)

A  abap/pxa = shared protect gen_remote

A  PXA: checking structure sizes: 752|272|16

A  PXA INITIALIZATION FINISHED

A  ---PXA-------------------------------------------

A  ATRA: pfclock execution time = 2

A  abap/force_local_update_task=0

A  ABAP ShmAdm attached (addr=000007DFDF15B000 leng=20955136 end=000007DFE0557000)

A  >> Shm MMADM area (addr=000007DFDF652B20 leng=242240 end=000007DFDF68DD60)

A  >> Shm MMDAT area (addr=000007DFDF68E000 leng=15503360 end=000007DFE0557000)

A  RFC Destination> destination SrvSapERPQA6_BQ1_00 host SrvSapERPQA6 system BQ1 systnr 0 (SrvSapERPQA6_BQ1_00)

A  RFC Options> H=SrvSapERPQA6,S=00,d=2,

A  RFC FRFC> fallback activ but this is not a central instance.

A   

A  RFC rfc/signon_error_log = -1

A  RFC rfc/dump_connection_info = 0

A  RFC rfc/dump_client_info = 0

A  RFC rfc/cp_convert/ignore_error = 1

A  RFC rfc/cp_convert/conversion_char = 23

A  RFC rfc/wan_compress/threshold = 251

A  RFC rfc/recorder_pcs not set, use defaule value: 2

A  RFC rfc/delta_trc_level not set, use default value: 0

A  RFC rfc/no_uuid_check not set, use default value: 0

H  HTTP> Parameter icf/ssocookie_mandatory set to 0

B  dbtran INFO (init_connection '<DEFAULT>' [ORACLE:721.02]):

B   max_blocking_factor       =   5,  min_blocking_factor         =   5,

B   max_in_blocking_factor    =   5,  min_in_blocking_factor      =   5,

B   max_union_blocking_factor =   5,  min_union_blocking_factor   =   5,

B   prefer_union_all          =   0,  prefer_join                 =   0,

B   prefer_fix_blocking       =   0,  prefer_in_itab_opt          =   1,

B   convert AVG               =   0,  alias table FUPD            =   0,

B   escape_as_literal         =   1,                                  

B   select *                  =0x0f,  character encoding          = STD / <none>:-,

B   use_hints                 = abap->1, dbif->0x1, upto->4294967295

M  ThrCreateShObjects        allocated 33280 bytes at 0000000002A10050

Y  dyWpInit

Y    ztta/dynpro_ara 800000

Y    ztta/cua_ara    500000

Y    ztta/diag_ara   250000

N  SsfSapSecin: getenv(SECUDIR)=="D:\usr\sap\BQ1\DVEBMGS00/sec"

N  =================================================

N  === SSF INITIALIZATION:

N  ===...SSF Security Toolkit name SAPSECULIB .

N  ===...SSF library is D:\usr\sap\BQ1\DVEBMGS00\exe\sapcrypto.dll .

N  ===...SSF default hash algorithm is SHA1 .

N  ===...SSF default symmetric encryption algorithm is DES-CBC .

N  ===...SECUDIR="D:\usr\sap\BQ1\DVEBMGS00/sec"

N  ===...loading of Security Toolkit successfully completed.

N  ===   SAPCRYPTOLIB  5.5.5C pl34  (Mar  1 2012) MT,[aesni],NB

N  =================================================

N Tue Aug 13 09:58:59 2013

N  MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N  MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M  JrfcVmcRegisterNativesDriver o.k.

W  =================================================

W  === ipl_Init() called

W    ITSP ICMAN is not active: Disable Kernel Web GUI functionality

W  === ipl_Init() returns 2, ITSPE_DISABLED: Service is disabled (sapparam)

W  =================================================

N  SignInit: successfully obtained handle for Security Context cache

N  SignInit: Not attempted to load Kerberos Library (ABAP parts missing, note TODO)

N  VSI: WP init in ABAP VM completed with rc=0

E  Enqueue Info: enque/use_pfclock2 = FALSE

E  Enqueue Info: row condense enabled

E  EnqId_Initialize: local EnqId initialization o.k.

M  rdisp/thsend_order : -1 -> 0

M  ThISend: set thsend_order to 0

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello

I don't see any error in the log file. Are you able to login to SAP ?

If not what is the error you get ?

Also I see that the kernel release is 721

Version of 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' is "721.02", patchlevel (0.42)

Regards

RB

Former Member
0 Kudos

Dear All experts,

Thank you so much for your kind attentions.

I did as you said, i copied the 721 DBSL files in both folders. fortunately my SAP Service became started. i reset the upgrading from the beginning of the phase MAIN_TRANSEXEC/DDIC_TRANS but still the same problem it shows running but no progress the service is start but when i want to logon to SAP after entering the user and PW it cannot logon with no error.

Maybe i reset the upgrading from the beginning.

i cannot find any thing in SAPUP and SAPUPCONSOLE log files.

WR,

Salameh

Former Member
0 Kudos

Dear RB,

I did as your recommendation but still the same problem.

still i have mismatch version in sap_dew0

WR,

Salameh

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello

Connect to the server as bq1adm and open a command prompt.

Execute this command and provide the output

sapcontrol -nr 00 -function GetVersionInfo

Regards

RB

Former Member
0 Kudos

Hi,

From the logs it looks like that some of the old kernel files are picked...

Please check when to replace the kernel from 720 to 721 some file are still not replaced.

it shows that old file is still present some where in home of sidadm or in /usr/sap/sid/DV*/exe or some where.

Please try to run the find command with the file dboraslib.dll in the root directory and see where all you can find it.

You should not find old version as the old version is causing issues.

Thanks

Rishi Abrol

Former Member
0 Kudos

Hi Salameh,

The issue will be resolved if you download the 721 DBSL files and extract and copy them in

D:\usr\sap\BQ1\DVEBMGS00\exe  as well as \sapmnt\BQ1\SYS\exe locations.

Do stop your SAP and DB prior to that.

I had faced the same issue once.

Best Regards,

Anita

former_member185239
Active Contributor
0 Kudos

Hi Sohi,

Download the 721 DBSL Patches and follow the process as suggested by RB.

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Dear SS,

i have Oracle Client 11.2.0.3, does it need upgrading?

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

Dev_w0 log:

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        BQ1

M systemid   562 (PC with Windows NT)

M relno      7210

M patchlevel 0

M patchno    100

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    \\SrvSapERPQA6\sapmnt\BQ1\SYS\profile\BQ1_DVEBMGS00_SrvSapERPQA6

M pid        1884

M

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

M  length of sys_adm_ext is 588 bytes

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

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M Sun Aug 04 12:41:12 2013

M  DpIPCInit2: read dp-profile-values from sys_adm_ext

M  DpShMCreate: sizeof(wp_adm)        36096    (2256)

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/1384064/1384080

M  DpShMCreate: sizeof(comm_adm)        1384080    (2744)

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

M  DpShMCreate: sizeof(slock_adm)        0    (296)

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

M  DpShMCreate: sizeof(file_adm)        0    (80)

M  DpShMCreate: sizeof(vmc_adm)        0    (2160)

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

M  DpShMCreate: sizeof(gw_adm)    48

M  DpShMCreate: sizeof(j2ee_adm)    3952

M  DpShMCreate: SHM_DP_ADM_KEY        (addr: 000000000FE80050, size: 7168064)

M  DpShMCreate: allocated sys_adm at 000000000FE80060

M  DpShMCreate: allocated wp_adm_list at 000000000FE830B0

M  DpShMCreate: allocated wp_adm at 000000000FE832A0

M  DpShMCreate: allocated tm_adm_list at 000000000FE8BFB0

M  DpShMCreate: allocated tm_adm at 000000000FE8C000

M  DpShMCreate: allocated wp_ca_adm at 00000000103CEF10

M  DpShMCreate: allocated appc_ca_adm at 00000000103DE920

M  DpShMCreate: allocated comm_adm at 00000000103EE330

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 00000000105401D0

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated gw_adm at 0000000010540280

M  DpShMCreate: allocated j2ee_adm at 00000000105402C0

M  DpShMCreate: allocated ca_info at 0000000010541240

M  DpShMCreate: allocated wall_adm at 00000000105412D0

M  DpCommAttachTable: attached comm table (header=00000000103EE330/ft=00000000103EE340)

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  <ES> EsILock: use spinlock for locking

X  Using implementation view

X  <EsNT> Using memory model view.

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

X  mm.dump: set maximum dump mem to 96 MB

M  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M Sun Aug 04 12:41:13 2013

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

M Sun Aug 04 12:41:14 2013

M  ThInit: running on host SrvSapERPQA6

M Sun Aug 04 12:41:15 2013

M  calling db_connect ...

B  Loading DB library 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' ...

B Sun Aug 04 12:41:16 2013

B  Library 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' loaded

B  *** ERROR => Version mismatch between kernel (721.02) and DBSL shared library (720.00)

[dbcon.c      5450]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 008192) [thxxhead.c   1497]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11348]

M  Info for wp 0

M    pid = 1884

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 0

M    act_cs_count = 0

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 0

M    control_flag = 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    attachedVm = no VM

M  ThIErrHandle: current request:

M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1

M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -   

M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1

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

M  *

M  *  LOCATION    SAP-Server SrvSapERPQA6_BQ1_00 on host SrvSapERPQA6 (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Sun Aug 04 12:41:16 2013

M  *  RELEASE     721

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        11629

M  *  COUNTER     1

M  *

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

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M  ThIErrHandle: entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 1884) [dpnttool.c   339]

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

dev_disp

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

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

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

sysno      00

sid        BQ1

systemid   562 (PC with Windows NT)

relno      7210

patchlevel 0

patchno    100

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

profile    \\SrvSapERPQA6\sapmnt\BQ1\SYS\profile\BQ1_DVEBMGS00_SrvSapERPQA6

pid        2784

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

length of sys_adm_ext is 588 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 2784) [dpxxdisp.c   1314]

    shared lib "dw_xml.dll" version 100 successfully loaded

    shared lib "dw_xtc.dll" version 100 successfully loaded

    shared lib "dw_stl.dll" version 100 successfully loaded

    shared lib "dw_gui.dll" version 100 successfully loaded

    shared lib "dw_mdm.dll" version 100 successfully loaded

    shared lib "dw_rndrt.dll" version 100 successfully loaded

    shared lib "dw_abp.dll" version 100 successfully loaded

    shared lib "dw_sym.dll" version 100 successfully loaded

    shared lib "dw_aci.dll" version 100 successfully loaded

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

use internal message server connection to port 3900

rdisp/dynamic_wp_check : 1

rdisp/calculateLoadAverage : 1

Sun Aug 04 12:41:07 2013

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

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

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: write dp-profile-values into sys_adm_ext

DpIPCInit2: start server >SrvSapERPQA6_BQ1_00                     <

DpShMCreate: sizeof(wp_adm)        36096    (2256)

DpShMCreate: sizeof(tm_adm)        5517056    (27448)

DpShMCreate: sizeof(wp_ca_adm)        64000    (64)

DpShMCreate: sizeof(appc_ca_adm)    64000    (64)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1384064/1384080

DpShMCreate: sizeof(comm_adm)        1384080    (2744)

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

DpShMCreate: sizeof(slock_adm)        0    (296)

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

DpShMCreate: sizeof(file_adm)        0    (80)

DpShMCreate: sizeof(vmc_adm)        0    (2160)

DpShMCreate: sizeof(wall_adm)        (41664/42896/64/192)

DpShMCreate: sizeof(gw_adm)    48

DpShMCreate: sizeof(j2ee_adm)    3952

DpShMCreate: SHM_DP_ADM_KEY        (addr: 00000000079A0050, size: 7168064)

DpShMCreate: allocated sys_adm at 00000000079A0060

DpShMCreate: allocated wp_adm_list at 00000000079A30B0

DpShMCreate: allocated wp_adm at 00000000079A32A0

DpShMCreate: allocated tm_adm_list at 00000000079ABFB0

DpShMCreate: allocated tm_adm at 00000000079AC000

DpShMCreate: allocated wp_ca_adm at 0000000007EEEF10

DpShMCreate: allocated appc_ca_adm at 0000000007EFE920

DpShMCreate: allocated comm_adm at 0000000007F0E330

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 00000000080601D0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated gw_adm at 0000000008060280

DpShMCreate: allocated j2ee_adm at 00000000080602C0

DpShMCreate: allocated ca_info at 0000000008061240

DpShMCreate: allocated wall_adm at 00000000080612D0

Sun Aug 04 12:41:08 2013

DpCommAttachTable: attached comm table (header=0000000007F0E330/ft=0000000007F0E340)

DpSysAdmIntInit: initialize sys_adm

rdisp/test_roll : roll strategy is DP_NORMAL_ROLL

dia token check not active (7 token)

MBUF state OFF

DpCommInitTable: init table for 500 entries

Sun Aug 04 12:41:10 2013

DpRqQInit: keep protect_queue / slots_per_queue 0 / 2001 in sys_adm

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

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> EsILock: use spinlock for locking

<ES> InitFreeList

<ES> block size is 4096 kByte.

<ES> Info: em/initial_size_MB( 16383MB) not multiple of em/blocksize_KB( 4096KB)

<ES> Info: em/initial_size_MB rounded up to 16384MB

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 4095 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

MPI: dynamic quotas disabled.

MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%

Sun Aug 04 12:41:11 2013

*** WARNING => System running without ICM - check rdisp/start_icman [dpxxdisp.c   13431]

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 4.0.1 4.0.1 5.1) [dpxxdisp.c   1700]

***LOG Q0K=> DpMsAttach, mscon ( SrvSapERPQA6) [dpxxdisp.c   12667]

MBUF state LOADING

DpStartStopMsg: send start message (myname is >SrvSapERPQA6_BQ1_00                     <)

DpStartStopMsg: start msg sent to message server o.k.

Sun Aug 04 12:41:12 2013

CCMS: Initialized monitoring segment of size 60000000.

CCMS: Initialized CCMS Headers in the shared monitoring segment.

Sun Aug 04 12:41:13 2013

CCMS: Checking Downtime Configuration of Monitoring Segment.

Sun Aug 04 12:41:15 2013

CCMS: AlMsUpload called by wp 1024.

Sun Aug 04 12:41:16 2013

CCMS: AlMsUpload successful for D:\usr\sap\BQ1\DVEBMGS00\log\ALMTTREE.DAT (725 MTEs).

Sun Aug 04 12:41:17 2013

CCMS: start to initalize 3.X shared alert area (first segment).

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1296]

MBUF state ACTIVE

DpWpBlksLow: max wp blocks in queue is 800 (80 %)

MBUF component UP

DpMsgProcess: 1 server in MBUF

DpAppcBlksLow: max appc blocks in queue is 500 (50 %)

Sun Aug 04 12:41:52 2013

*** ERROR => DpHdlDeadWp: W0 (pid 1884) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W1 (pid 3240) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W2 (pid 3284) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W3 (pid 3304) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W4 (pid 2244) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W5 (pid 2024) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W6 (pid 3272) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W7 (pid 348) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W8 (pid 704) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W9 (pid 2604) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W10 (pid 1312) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W11 (pid 3980) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W12 (pid 168) died (severity=0, status=0) [dpxxwp.c     1729]

*** ERROR => DpHdlDeadWp: W13 (pid 3520) died (severity=0, status=0) [dpxxwp.c     1729]

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1033

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Aug 04 12:42:02 2013

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long)            Sun Aug 04 08:12:02 2013

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

No Type  Pid    Status  Cause Start Rstr  Err Sem Time Program          Cl  User         Action                    Table

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

0 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

1 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

2 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

3 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

4 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

5 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

6 DIA       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

7 UPD       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

8 UPD       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

9 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

10 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

11 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

12 BTC       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

13 UP2       -1 Ended         no    no     1   0    0                                    NO_ACTION                          

Dispatcher Queue Statistics            Sun Aug 04 08:12:02 2013

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

+------+--------+--------+--------+------------+------------+

|  Typ |    now |   high |    max | writes     |  reads     |

+------+--------+--------+--------+------------+------------+

| NOWP |      0 |      1 |   2000 |          1 |          1 |

+------+--------+--------+--------+------------+------------+

|  DIA |      2 |      2 |   2000 |          2 |          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        4

wake_evt_udp_now    0

wake events          total     2,  udp     1 ( 50%),  shm     1 ( 50%)

since last update    total     2,  udp     1 ( 50%),  shm     1 ( 50%)

DpGetLoadAverage: la1[1] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[1] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[1] = 0.022222 / -1.000000 %

Dispatcher Load Statistics

+------+---------+---------+---------+

|  Typ |     LA1 |     LA5 |    LA15 |

+------+---------+---------+---------+

|  DIA |   0.000 |   0.000 |   0.022 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[2] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[2] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[2] = 0.000000 / -1.000000 %

|  UPD |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[3] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[3] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[3] = 0.000000 / -1.000000 %

|  ENQ |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[4] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[4] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[4] = 0.000000 / -1.000000 %

|  BTC |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[5] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[5] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[5] = 0.000000 / -1.000000 %

|  SPO |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

DpGetLoadAverage: la1[6] = 0.000000 / -1.000000 %

DpGetLoadAverage: la5[6] = 0.000000 / -1.000000 %

DpGetLoadAverage: la15[6] = 0.000000 / -1.000000 %

|  UP2 |   0.000 |   0.000 |   0.000 |

+------+---------+---------+---------+

Dump of tm_adm structure:            Sun Aug 04 08:12:02 2013

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

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

RM-T16, U17,                 , , 12:41:21, M0, W-1,     , 1/0

Workprocess Comm. Area Blocks            Sun Aug 04 08:12:02 2013

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

Slots: 1000, Used: 1, Max: 1

+------+--------------+----------+-------------+

|   id | owner        |   pid    | eyecatcher  |

+------+--------------+----------+-------------+

|    0 | DISPATCHER   |       -1 | 0xdeadbeef |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1033

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Aug 04 12:42:07 2013

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >SrvSapERPQA6_BQ1_00                     < (normal)

DpJ2eeDisableRestart

DpMBufRead: read server list from MBUF (1 entries)

DpMBufMod: name [SrvSapERPQA6_BQ1_00                     ], types 43 state 3 (0x0 0x0 0x0 0x0)

DpMBufMod: call hooks for event MBUF_DPEVT_DSTATE (5->3)

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 000000013F5AB6E0

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

DpWpBlksLow: wp_blks_in_queue/limit/max = 1/800/1000

DpLockWpBlkEx: lock wp ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqIPutIntoQ: put elem in queue DIA, elems=3

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 5)

MBUF server state SHUTDOWN

DpModState: change state STARTING -> SHUTDOWN

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

DpHalt: 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

DpHalt: stop work processes

DpHalt: stop gateway

killing process (3092) (SOFT_KILL)

DpHalt: terminate gui connections

send SHUTDOWN to REM TM 16

DpWpBlksLow: wp_blks_in_queue/limit/max = 2/800/1000

DpLockWpBlkEx: lock wp ca_blk 2

return errno (-17) to T16

DpTmSend: errormsg without overhead: use mode 0

NiBufIAlloc: malloc NiBufadm, to 0 bytes

DpTmSend: try to send 14 bytes to T16/M0

NiBufSend starting

NiIWrite: hdl 33 sent data (wrt=14,pac=1,MESG_IO)

REL WP ca_blk 2

set status of T16 to TM_DISCONNECTED

NiBufISelUpdate: new MODE -- (r-) for hdl 33 in set0

SiSelNSet: set events of sock 1032 to: ---

NiBufISelRemove: remove hdl 33 from set0

SiSelNRemove: removed sock 1032

NiSelIRemove: removed hdl 33

DpDelSocketInfo: del info for nihdl 33 (pos/type=4/3)

NiICloseHandle: shutdown and close hdl 33/sock 1032

NiBufIClose: clear extension for hdl 33

dp_tm_adm[16].stat = DP_SLOT_FREE

DpGetSchedule: next schedule 1375603931/913000

DpGetSchedule: no schedule found

DpITmSlotRelease: release slot 16

DpListRemove: remove elem 16 from tmadm_inuse_list

DpListRemove: 16 elems in tmadm_inuse_list

DpListInsert: insert elem 16 into tmadm_free_list (at begin)

DpListInsert: 185 elems in tmadm_free_list

DpHalt: wait for end of work processes

DpHalt: wait for end of gateway

[DpProcDied] Process lives  (PID:3092  HANDLE:900)

DpHalt: waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1033

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sun Aug 04 12:42:08 2013

NiISelect: TIMEOUT occured (1000ms)

*** ERROR => [DpProcDied] Process died  (PID:3092  HANDLE:900  rc:0x0) [dpnttool2.c  147]

DpStartStopMsg: send stop message (myname is >SrvSapERPQA6_BQ1_00                     <)

DpStartStopMsg: Write AD_STARTSTOP message with type=  0, name=SrvSapERPQA6_BQ1_00 , sapsysnr= 0, hostname=SrvSapERPQA6                                                   

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 000000013F5AB6E0

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 4

AdCallRegisteredCvtToExt: opcode 4 call 000000013F5D1470

AdCallRegisteredCvtToExt: opcode 4 exit rc=SAP_O_K

DpConvertRequest: net size = 189 bytes

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

MsISndTypeOnce: send msg (ms hdr/msg 110/452 bytes) to MSG_SERVER, type 1

DpStartStopMsg: stop msg sent to message server o.k.

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes

NiIRead: hdl 17 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 17

NiBufReceive starting

MsINiRead: received 274 bytes

MsIReceive: received msg (ms hdr/msg 110/164 bytes), flag 1, from MSG_SERVER          , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 17 recv would block (errno=EAGAIN)

NiIRead: read for hdl 17 timed out (0ms)

DpHalt: more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

MsISnd2: send msg (ms hdr/msg 110/4 bytes) to name           MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiBufIAlloc: malloc MSLIB-BUF, to 32110 bytes

NiBufIAlloc: malloc NIBUF-IN, to 32110 bytes

NiIRead: hdl 17 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 17

NiBufReceive starting

MsINiRead: received 114 bytes

MsIReceive: received msg (ms hdr/msg 110/4 bytes), flag 3, from MSG_SERVER          , typ 0, key -

Received 4 bytes from MSG_SERVER                             

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsISendKeepalive : keepalive sent to message server

NiIRead: hdl 17 recv would block (errno=EAGAIN)

Sun Aug 04 12:42:09 2013

NiIPeek: peek for hdl 17 timed out (r; 1000ms)

NiIRead: read for hdl 17 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

DpHalt: detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c   13064]

NiBufSend starting

NiIWrite: hdl 17 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server (SrvSapERPQA6 / 3900)

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 17 in set0

SiSelNSet: set events of sock 896 to: ---

NiBufISelRemove: remove hdl 17 from set0

SiSelNRemove: removed sock 896 (pos=2)

SiSelNRemove: removed sock 896

NiSelIRemove: removed hdl 17

DpDelSocketInfo: del info for nihdl 17 (pos/type=2/4)

MBUF state OFF

AdGetSelfIdentRecord: >                                                                           <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 60

AdCallRegisteredCvtToExt: opcode 60 call 000000013F5AB6E0

AdCallRegisteredCvtToExt: opcode 60 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCallRegisteredCvtToExt: opcode 40

AdCallRegisteredCvtToExt: opcode 40 call 000000013FCB7650

AdCallRegisteredCvtToExt: opcode 40 exit rc=SAP_O_K

DpWpBlksLow: wp_blks_in_queue/limit/max = 2/800/1000

DpLockWpBlkEx: lock wp ca_blk 2

make DISP owner of wp_ca_blk 2

DpRqIPutIntoQ: put elem in queue DIA, elems=4

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 7)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 17/sock 896

NiBufIClose: clear extension for hdl 17

MsIDetach: detach MS-system (SrvSapERPQA6 / 3900)

DpHalt: cleanup EM

EsCleanup( )

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 2784) [dpxxdisp.c   11574]

DpHalt: Good Bye .....

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

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello

B  Loading DB library 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' ...

B

B Sun Aug 04 12:41:16 2013

B  Library 'D:\usr\sap\BQ1\DVEBMGS00\exe\dboraslib.dll' loaded

B  *** ERROR => Version mismatch between kernel (721.02) and DBSL shared library (720.00)

[dbcon.c      5450]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 008192) [thxxhead.c   1497]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11348]

The problem you have is due to two different kernel release files present in the D:\usr\sap\BQ1\DVEBMGS00\exe location.

Stop the SAP system.

Stop all the services

Delete all the files form D:\usr\sap\BQ1\DVEBMGS00\exe

Copy all the fles from \\SrvSapERPQA6\sapmnt\BQ1\SYS\exe location to D:\usr\sap\BQ1\DVEBMGS00\exe

Stat all the services

Start SAP

Regards

RB

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello

Can you check whether the logs in the G:\SUM\abap\tmp are getting updated ?

Connect to the SAP system with the DDIC user and check whether there are any dumps in the system.

Also check the active jobs in the system from Tx SM37.

Regards

RB

Former Member
0 Kudos

Hi Salameh,

Check oracle DB parameter "sessions" and "processes" are good enough in your system- SAP Note 1431798.

Regards, KK

Former Member
0 Kudos

Dear KK & RB,

Thanks for your replies.

I did not change any oracle parameter and everything is as default.

there is no change in tmp

as i told before my sap service is stop. i tried to start it but the dispatcher is stopped and in sys log the error is " DB-Connect Failed, Return Code  008192"

I think if I can start the service it will go on.

would you please help?

WR,

Salameh

sujit_sharma
Active Participant
0 Kudos

Hello Salameh,

" DB-Connect Failed, Return Code  008192"

Please share the logs of dev_w0 and  dev_disp.

Did you upgrade your Oracle Client ? If not then you can try that.

Regards-SS