cancel
Showing results for 
Search instead for 
Did you mean: 

Disp+Work was stopped immediately after startsap

Former Member
0 Kudos

Hi,

     I have a problem about start sap. I have doing system copy by Backup/Restore on different SID and used old schema ID now in step import and startsap then disp+work was stopped automatically after start sap.

     My environment:

     Solaris 10

     SAP netweaver 6.40 ECC 5.0

     Oracle 9

Please you help me to solve this problem.

logs dev_disp

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

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

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

Tue Sep 30 13:51:16 2014

kernel runs with dp version 128(ext=102) (@(#) DPLIB-INT-VERSION-128)

length of sys_adm_ext is 312 bytes

systemid   370 (SUN on SPARC CPU with Solaris 2.2)

relno      6400

patchlevel 0

patchno    43

intno      20020600

make:      single threaded, ASCII, 64 bit

pid        27744

***LOG Q00=> DpSapEnvInit, DPStart (10 27744) [dpxxdisp.c   1100]

        shared lib "dw_xml.so" version 43 successfully loaded

        shared lib "dw_xtc.so" version 43 successfully loaded

        shared lib "dw_stl.so" version 43 successfully loaded

        shared lib "dw_gui.so" version 43 successfully loaded

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: JAVA is not active

DpShMCreate: sizeof(wp_adm)             6848    (856)

DpShMCreate: sizeof(tm_adm)             2852592 (14192)

DpShMCreate: sizeof(wp_ca_adm)          26400   (88)

DpShMCreate: sizeof(appc_ca_adm)        8800    (88)

DpShMCreate: sizeof(comm_adm)           216000  (432)

DpShMCreate: sizeof(vmc_adm)            0       (432)

DpShMCreate: sizeof(wall_adm)           (22440/36712/80/104)

DpShMCreate: SHM_DP_ADM_KEY             (addr: ffffffff73800000, size: 3176280)

DpShMCreate: allocated sys_adm at ffffffff73800000

DpShMCreate: allocated wp_adm at ffffffff73801898

DpShMCreate: allocated tm_adm_list at ffffffff73803358

DpShMCreate: allocated tm_adm at ffffffff73803380

DpShMCreate: allocated wp_ca_adm at ffffffff73abba70

DpShMCreate: allocated appc_ca_adm at ffffffff73ac2190

DpShMCreate: allocated comm_adm_list at ffffffff73ac43f0

DpShMCreate: allocated comm_adm at ffffffff73ac4408

DpShMCreate: allocated vmc_adm_list at ffffffff73af8fc8

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at ffffffff73af8ff0

DpShMCreate: allocated wall_adm at ffffffff73af8ff8

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation std

EsIUnamFileMapInit: ES base = 0xfffffffe70000000

EsStdInit: Extended Memory 4092 MB allocated

<ES> 1022 blocks reserved for free list.

ES initialized.

Tue Sep 30 13:51:55 2014

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( hristmp) [dpxxdisp.c   9736]

Tue Sep 30 13:51:56 2014

*** ERROR => W0 (pid 27749) died [dpxxdisp.c   12187]

DpMsgAdmin: Set release to 6400, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 43

Release check o.K.

*** ERROR => W0 (pid 27749) died [dpxxdisp.c   12187]

*** ERROR => W2 (pid 27751) died [dpxxdisp.c   12187]

my types changed after wp death/restart 0xbf --> 0xbd

*** ERROR => W3 (pid 27752) died [dpxxdisp.c   12187]

my types changed after wp death/restart 0xbd --> 0xb9

*** ERROR => W4 (pid 27753) died [dpxxdisp.c   12187]

Tue Sep 30 13:52:15 2014

*** ERROR => W1 (pid 27750) died [dpxxdisp.c   12187]

my types changed after wp death/restart 0xb9 --> 0xb8

*** ERROR => W5 (pid 27756) died [dpxxdisp.c   12187]

my types changed after wp death/restart 0xb8 --> 0xb0

*** ERROR => W6 (pid 27757) died [dpxxdisp.c   12187]

my types changed after wp death/restart 0xb0 --> 0xa0

*** ERROR => W7 (pid 27808) died [dpxxdisp.c   12187]

my types changed after wp death/restart 0xa0 --> 0x80

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

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-27749 (SIGUSR2)

*** ERROR => DpWpKill(27749, SIGUSR2) failed [dpxxtool.c   2468]

killing W1-27750 (SIGUSR2)

*** ERROR => DpWpKill(27750, SIGUSR2) failed [dpxxtool.c   2468]

killing W2-27751 (SIGUSR2)

*** ERROR => DpWpKill(27751, SIGUSR2) failed [dpxxtool.c   2468]

killing W3-27752 (SIGUSR2)

*** ERROR => DpWpKill(27752, SIGUSR2) failed [dpxxtool.c   2468]

killing W4-27753 (SIGUSR2)

*** ERROR => DpWpKill(27753, SIGUSR2) failed [dpxxtool.c   2468]

killing W5-27756 (SIGUSR2)

*** ERROR => DpWpKill(27756, SIGUSR2) failed [dpxxtool.c   2468]

killing W6-27757 (SIGUSR2)

*** ERROR => DpWpKill(27757, SIGUSR2) failed [dpxxtool.c   2468]

killing W7-27808 (SIGUSR2)

*** ERROR => DpWpKill(27808, SIGUSR2) failed [dpxxtool.c   2468]

NiWait: sleep (10000 msecs) ...

NiISelect: timeout 10000 ms

NiISelect: maximum fd=14

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Regards,

P.Pholvises

Accepted Solutions (1)

Accepted Solutions (1)

former_member185239
Active Contributor
0 Kudos

Hi Peeravat,

Is the source system kernel and the target system kernel are same?

if not , then try to replace the target system kernel with the source system kernel.

As the patch level of your kernel is only 43 for 640 which is lower itself.

Also do paste the trans.log after running R3trans -d

With Regards

Ashutosh Chaturvedi

former_member185239
Active Contributor
0 Kudos

Hi Peeravat,

Upgrade your kernel with the latest patch of kernel release 640. This might resolve your issue.

With Regards

Ashutosh Chaturvedi

Answers (4)

Answers (4)

Reagan
Advisor
Advisor
0 Kudos

If possible attach the complete dev_w0 trace file.

Run sappfpar against the instant profile and check for errors and if there are correct them and restart the SAP system.

Also provide the SAP kernel version and patch level.

Former Member
0 Kudos

Hi

Source system:

kernel release            640
patch number              175

Target system:

kernel release            640
patch number              43

sappfpar no error occured

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, M

*

M systemid   370 (SUN on SPARC CPU with Solaris 2.2)

M relno      6400

M patchlevel 0

M patchno    43

M intno      20020600

M make:      single threaded, ASCII, 64 bit

M pid        27749

M

M Tue Sep 30 13:51:16 2014

M  ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 27749) [thxxhead.c   1131]

M  calling db_connect ...

C  Got ORACLE_HOME=/oracle/HRQ/920_64 from environment

C  Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C  Connecting as /@HRQ on connection 0 ...

C  Attaching to DB Server HRQ (con_hdl=0,svchp=103fe82a8,svrhp=103fea698)

C  Starting user session (con_hdl=0,svchp=103fe82a8,srvhp=103fea698,usrhp=103ff40b8)

C  Now I'm connected to ORACLE

C  Got SAPHRP's password from OPS$-user

C  Disconnecting from connection 0 ...

C  Closing user session (con_hdl=0,svchp=103fe82a8,usrhp=103ff40b8)

C  Now I'm disconnected from ORACLE

C  Connecting as SAPHRP/<pwd>@HRQ on connection 0 ...

C  Starting user session (con_hdl=0,svchp=103fe82a8,srvhp=103fea698,usrhp=103ff40b8)

C  Now I'm connected to ORACLE

C  Database NLS settings: AMERICAN_AMERICA.WE8DEC

C  Database instance HRQ is running on hristmp with ORACLE version 9.2.0.7.0 since 20140930

B  Connection 0 opened

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 20140930 135116 hristmp        

M  db_connect o.k.

I  MtxInit: 0 0 0

M  SHM_PRES_BUF                 (addr: ffffffff76656000, size: 4400000)

M  SHM_ROLL_AREA                (addr: fffffffe60000000, size: 134217728)

M  SHM_PAGING_AREA              (addr: fffffffe5a000000, size: 67108864)

M  SHM_ROLL_ADM                 (addr: ffffffff76a8c000, size: 2672386)

M  SHM_PAGING_ADM               (addr: ffffffff73700000, size: 656416)

M  ThCreateNoBuffer             allocated 352144 bytes for 1000 entries at fffffffe52004000

M  ThCreateNoBuffer             index size: 3000 elems

M  ThCreateVBAdm                allocated 7440 bytes (50 server) at ffffffff7bd00000

X  EmInit: MmSetImplementation( 2 ).

X  <ES> client 0 initializing ....

X  Using implementation std

X  ES initialized.

B Tue Sep 30 13:51:18 2014

B  db_con_shm_ini:  WP_ID = 0, WP_CNT = 8

B  dbtbxbuf: Buffer TABL  (addr: fffffffe50000100, size: 30000000, end: fffffffe51c9c480)

B  dbtbxbuf: Profile: max_objects = 5000, displace = 1, reorg = 1

B  dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B  dbtbxbuf: protect_shm = 0, force_checks = 0

B  dbtbxbuf: tsize_retry = 14451456

B  ***LOG BB0=> buffer TABL       started with length 30000000   bytes [dbtbxbuf#7 @ 15714] [dbtbxbuf1571 4]

B  dbtbxbuf: Buffer TABLP (addr: fffffffe6f400100, size: 10240000, end: fffffffe6fdc4100)

B  dbtbxbuf: Profile: max_objects = 500, displace = 1, reorg = 1

B  dbtbxbuf: request_unit = 2000, sync_reload = 5, inval_reload = 5

B  dbtbxbuf: protect_shm = 0, force_checks = 0

B  dbtbxbuf: tsize_retry = 5059776

B  ***LOG BB0=> buffer TABLP      started with length 10240000   bytes [dbtbxbuf#7 @ 15714] [dbtbxbuf1571 4]

B  dbtbxbuf: Reading TBX statistics:

B  dbtbxbuf: 0 object entries precreated

B  Layout of EIBUF buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 416 = 416

B  2: 8 * 40 = 320

B  3: 4001 * 64 = 256064

B  4: 2000 * 160 = 320000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 65 * 8 = 520

B  8: 28006 * 128 = 3584768

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B  dbexpbuf: Buffer EIBUF (addr: fffffffe69800108, size: 4194304, end: fffffffe69c00108)

B  ***LOG BB0=> buffer EIBUF      started with length 4096k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  Layout of ESM   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 416 = 416

B  2: 8 * 40 = 320

B  3: 4001 * 64 = 256064

B  4: 2000 * 160 = 320000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 65 * 8 = 520

B  8: 28006 * 128 = 3584768

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B  dbexpbuf: Buffer ESM   (addr: fffffffe69000108, size: 4194304, end: fffffffe69400108)

B  ***LOG BB0=> buffer ESM        started with length 4096k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  Layout of CUA   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 416 = 416

B  2: 8 * 40 = 320

B  3: 3001 * 64 = 192064

B  4: 1500 * 160 = 240000

B  5: 3001 * 8 = 24008

B  6: 1 * 200 = 200

B  7: 193 * 8 = 1544

B  8: 10208 * 256 = 2613248

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B Tue Sep 30 13:51:19 2014

B  dbexpbuf: Buffer CUA   (addr: fffffffe54dec108, size: 3072000, end: fffffffe550da108)

B  ***LOG BB0=> buffer CUA        started with length 3000k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  Layout of OTR   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 416 = 416

B  2: 8 * 40 = 320

B  3: 4001 * 64 = 256064

B  4: 2000 * 160 = 320000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 81 * 8 = 648

B  8: 28005 * 128 = 3584640

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B  dbexpbuf: Buffer OTR   (addr: fffffffe68800108, size: 4194304, end: fffffffe68c00108)

B  ***LOG BB0=> buffer OTR        started with length 4096k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  ***LOG BB0=> buffer CALE       started with length 500000     bytes [dbcalbuf#1 @ 2206] [dbcalbuf2206 ]

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

B   max_blocking_factor =  15,  max_in_blocking_factor      =   5,

B   min_blocking_factor =  10,  min_in_blocking_factor      =   5,

B   prefer_union_all    =   0,  prefer_union_for_select_all =   0,

B   prefer_fix_blocking =   0,  prefer_in_itab_opt          =   1,

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

B   escape_as_literal   =   1,  opt GE LE to BETWEEN        =   0,

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

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

B                         rule_fae->0, concat_fae->0, concat_fae_or->0

B  *** ERROR => missing return code handler    

caller does not handle code 32 from dbntab#7[3098]    

==> calling sap_dext to abort transaction

[dbeh.c       93]

M  ------------------ C-STACK ----------------------

[0] DoStack2 ( 0x103808080, 0x0, 0x2662800, 0x100000000, 0x1, 0x0 ), at 0x1004637a0

[1] CTrcStack2 ( 0x102bbc6a8, 0x0, 0x100000000, 0x2662000, 0x2, 0x1026623b4 ), at 0x100463350

[2] ThControl ( 0xffffffff7fffece0, 0xa, 0x102662000, 0x2662000, 0x100000000, 0x1 ), at 0x1004334f8

[3] dextIntern ( 0x0, 0x1, 0x103bc4ba0, 0xffffffff7fffece0, 0x20, 0x22e8 ), at 0x10051c660

[4] sap_dext ( 0xa, 0x1029c0c20, 0x384, 0xffffffff7fffed38, 0x0, 0x20 ), at 0x10051ba6c

[5] dbeh_exit ( 0x2810c00, 0x1029c0c00, 0x29c0c00, 0x100000000, 0x1, 0x0 ), at 0x10126a3b4

[6] db_ntab ( 0x0, 0x2808000, 0x0, 0x100000000, 0x2808000, 0x102808000 ), at 0x10128f0f8

[7] read_ntab ( 0x10280aff0, 0x5, 0x0, 0x0, 0x84, 0x0 ), at 0x1013a6000

[8] db_cbufload ( 0x10280aee0, 0x0, 0x102810c00, 0x1, 0x10280b014, 0x0 ), at 0x1013ab8f0

[9] reset_handling ( 0x1029c6ce0, 0x2f7b000, 0x0, 0xffffffff7ffff290, 0x1, 0x0 ), at 0x1013a51f4

[10] init_shm_and_load_cals ( 0x0, 0x29c6c00, 0x0, 0xffffffff76d1c05c, 0x10280ac00, 0x1 ), at 0x1013a4dfc

[11] db_cbufinst ( 0xffffffff7ffff508, 0x102662000, 0x10280b160, 0x100000000, 0x10280b000, 0x280b000 ), at 0x1013a2cf4

[12] db_calinit ( 0x1029c6608, 0x1029c6400, 0x29c6400, 0x100000000, 0x1, 0x0 ), at 0x1013996b0

[13] db_init ( 0x0, 0x10144c000, 0x144c000, 0x100000000, 0x0, 0x0 ), at 0x10144c060

[14] ThCallHooks ( 0x100000000, 0x0, 0xffffffffffffffff, 0x103f8d040, 0x0, 0x10291f8f0 ), at 0x100304b08

[15] ThIPCInit ( 0x10144b688, 0x102ba9bbc, 0x102919210, 0x0, 0x1, 0x4 ), at 0x1002305c8

[16] tskh_init ( 0x0, 0x1, 0x1cb6c00, 0x1cc0800, 0x1, 0x101cc0800 ), at 0x10022c5d8

[17] tskhstart ( 0x1, 0x10039cc00, 0x0, 0x1, 0x102662000, 0x2662000 ), at 0x10022aba0

[18] DpMain ( 0x2b11800, 0x2659000, 0x100000000, 0x1, 0x0, 0x0 ), at 0x1001570f8

M  -------------------------------------------------

M  ***LOG R1B=> ThControl, sap_dext-call (00 ) [thxxdynp.c   355]

M  in_ThErrHandle: 1

M  *** ERROR => ThControl: illegal sap_dext call !!! (step 1, th_errno 5, action 1, level 1) [thxxhead.c   9413]

M  Info for wp 0

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  Entering ThSetStatError

M  Entering ThReadDetachMode

M  ThISend: still inside critical section semaphore ?

M  ------------------ C-STACK ----------------------

[0] _longjmp ( 0x100000000, 0xffffffffffffffff, 0x0, 0x1, 0x1, 0x265a000 ), at 0xffffffff7cc3afdc

[1] ThIErrHandle ( 0x100000000, 0x2662000, 0x0, 0x1029351e8, 0x0, 0xffffffffffffffff ), at 0x1002608b0

[2] ThControl ( 0xffffffff7fffece0, 0x2662000, 0x22a0400, 0x102935000, 0x2935000, 0x100000000 ), at 0x100433730

[3] dextIntern ( 0x0, 0x1, 0x103bc4ba0, 0xffffffff7fffece0, 0x20, 0x22e8 ), at 0x10051c660

[4] sap_dext ( 0xa, 0x1029c0c20, 0x384, 0xffffffff7fffed38, 0x0, 0x20 ), at 0x10051ba6c

[5] dbeh_exit ( 0x2810c00, 0x1029c0c00, 0x29c0c00, 0x100000000, 0x1, 0x0 ), at 0x10126a3b4

[6] db_ntab ( 0x0, 0x2808000, 0x0, 0x100000000, 0x2808000, 0x102808000 ), at 0x10128f0f8

[7] read_ntab ( 0x10280aff0, 0x5, 0x0, 0x0, 0x84, 0x0 ), at 0x1013a6000

[8] db_cbufload ( 0x10280aee0, 0x0, 0x102810c00, 0x1, 0x10280b014, 0x0 ), at 0x1013ab8f0

[9] reset_handling ( 0x1029c6ce0, 0x2f7b000, 0x0, 0xffffffff7ffff290, 0x1, 0x0 ), at 0x1013a51f4

[10] init_shm_and_load_cals ( 0x0, 0x29c6c00, 0x0, 0xffffffff76d1c05c, 0x10280ac00, 0x1 ), at 0x1013a4dfc

[11] db_cbufinst ( 0xffffffff7ffff508, 0x102662000, 0x10280b160, 0x100000000, 0x10280b000, 0x280b000 ), at 0x1013a2cf4

[12] db_calinit ( 0x1029c6608, 0x1029c6400, 0x29c6400, 0x100000000, 0x1, 0x0 ), at 0x1013996b0

[13] db_init ( 0x0, 0x10144c000, 0x144c000, 0x100000000, 0x0, 0x0 ), at 0x10144c060

[14] ThCallHooks ( 0x100000000, 0x0, 0xffffffffffffffff, 0x103f8d040, 0x0, 0x10291f8f0 ), at 0x100304b08

[15] ThIPCInit ( 0x10144b688, 0x102ba9bbc, 0x102919210, 0x0, 0x1, 0x4 ), at 0x1002305c8

[16] tskh_init ( 0x0, 0x1, 0x1cb6c00, 0x1cc0800, 0x1, 0x101cc0800 ), at 0x10022c5d8

[17] tskhstart ( 0x1, 0x10039cc00, 0x0, 0x1, 0x102662000, 0x2662000 ), at 0x10022aba0

[18] DpMain ( 0x2b11800, 0x2659000, 0x100000000, 0x1, 0x0, 0x0 ), at 0x1001570f8

M  -------------------------------------------------

M  ***LOG Q0E=> SigIGenAction, signal ( 10) [sigux.c      836]

M  in_ThErrHandle: 2

M  ***LOG R0H=> ThIErrHandle, Loop in ThErrHandle, restart wp () [thxxhead.c   9434]

M  ------------------ C-STACK ----------------------

[0] DoStack2 ( 0x103808080, 0x0, 0x2662800, 0x100000000, 0x1, 0x0 ), at 0x1004637a0

[1] CTrcStack2 ( 0x102bbc6a8, 0x0, 0x100000000, 0x2662000, 0x2, 0x1026623b4 ), at 0x100463350

[2] ThIErrHandle ( 0x0, 0x1, 0x3, 0x102927468, 0xb, 0x4 ), at 0x10025e7d4

[3] SigIGenAction ( 0x102a80400, 0x1026623d8, 0x3, 0xa, 0x0, 0x1026623ac ), at 0x101c87b78

[4] __sighndlr ( 0xa, 0xffffffff7fffe3f0, 0xffffffff7fffe110, 0x101c873c8, 0x0, 0x0 ), at 0xffffffff7ccd6fdc

[5] call_user_handler ( 0xffffffff7d900200, 0xffffffff7d900200, 0xffffffff7fffe110, 0x19, 0x0, 0x0 ), at 0xffffffff7cccab70

[6] sigacthandler ( 0x0, 0xffffffff7fffe3f0, 0xffffffff7fffe110, 0xffffffff7d900200, 0x0, 0xffffffff7ce3c000 ), at 0xffffffff7cccad7c

[7] ThISend ( 0x100000000, 0xffffffffffffffff, 0x0, 0x1, 0x1, 0x265a000 ), at 0x10025dd64

[8] ThIErrHandle ( 0x100000000, 0x2662000, 0x0, 0x1029351e8, 0x0, 0xffffffffffffffff ), at 0x1002608b0

[9] ThControl ( 0xffffffff7fffece0, 0x2662000, 0x22a0400, 0x102935000, 0x2935000, 0x100000000 ), at 0x100433730

[10] dextIntern ( 0x0, 0x1, 0x103bc4ba0, 0xffffffff7fffece0, 0x20, 0x22e8 ), at 0x10051c660

[11] sap_dext ( 0xa, 0x1029c0c20, 0x384, 0xffffffff7fffed38, 0x0, 0x20 ), at 0x10051ba6c

[12] dbeh_exit ( 0x2810c00, 0x1029c0c00, 0x29c0c00, 0x100000000, 0x1, 0x0 ), at 0x10126a3b4

[13] db_ntab ( 0x0, 0x2808000, 0x0, 0x100000000, 0x2808000, 0x102808000 ), at 0x10128f0f8

[14] read_ntab ( 0x10280aff0, 0x5, 0x0, 0x0, 0x84, 0x0 ), at 0x1013a6000

[15] db_cbufload ( 0x10280aee0, 0x0, 0x102810c00, 0x1, 0x10280b014, 0x0 ), at 0x1013ab8f0

[16] reset_handling ( 0x1029c6ce0, 0x2f7b000, 0x0, 0xffffffff7ffff290, 0x1, 0x0 ), at 0x1013a51f4

[17] init_shm_and_load_cals ( 0x0, 0x29c6c00, 0x0, 0xffffffff76d1c05c, 0x10280ac00, 0x1 ), at 0x1013a4dfc

[18] db_cbufinst ( 0xffffffff7ffff508, 0x102662000, 0x10280b160, 0x100000000, 0x10280b000, 0x280b000 ), at 0x1013a2cf4

[19] db_calinit ( 0x1029c6608, 0x1029c6400, 0x29c6400, 0x100000000, 0x1, 0x0 ), at 0x1013996b0

[20] db_init ( 0x0, 0x10144c000, 0x144c000, 0x100000000, 0x0, 0x0 ), at 0x10144c060

[21] ThCallHooks ( 0x100000000, 0x0, 0xffffffffffffffff, 0x103f8d040, 0x0, 0x10291f8f0 ), at 0x100304b08

[22] ThIPCInit ( 0x10144b688, 0x102ba9bbc, 0x102919210, 0x0, 0x1, 0x4 ), at 0x1002305c8

[23] tskh_init ( 0x0, 0x1, 0x1cb6c00, 0x1cc0800, 0x1, 0x101cc0800 ), at 0x10022c5d8

[24] tskhstart ( 0x1, 0x10039cc00, 0x0, 0x1, 0x102662000, 0x2662000 ), at 0x10022aba0

[25] DpMain ( 0x2b11800, 0x2659000, 0x100000000, 0x1, 0x0, 0x0 ), at 0x1001570f8

M  -------------------------------------------------

M  ThSigHandler: signal (step 5, th_errno 11, action 4)

M  Info for wp 0

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  PfStatDisconnect: disconnect statistics

M  Entering ThSetStatError

M  ThIErrHandle: don't try rollback again

B  Disconnecting from ALL connections:

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 20140930 135116 hristmp        

C  Disconnecting from connection 0 ...

C  Closing user session (con_hdl=0,svchp=103fe82a8,usrhp=103ff40b8)

C  Detaching from DB Server (con_hdl=0,svchp=103fe82a8,srvhp=103fea698)

C  Now I'm disconnected from ORACLE

B  Disconnected from connection 0

B  statistics db_con_commit (com_total=0, com_tx=0)

B  statistics db_con_rollback (roll_total=0, roll_tx=0)

M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 27749) [dpuxtool.c   322]

Sriram2009
Active Contributor
0 Kudos

Hi

I am already told you, in your source & target kernel level are different, you must upgrade the kernel level minimum to 175

BR

SS

Reagan
Advisor
Advisor
0 Kudos

Like Sriram said copy the source system kernel and use it on the target system.

Restart SAP and see if that helps.

Also run sappfpar against the instance profile and check for errors or paste the output here.

Any error in the message server log file - dev_ms ?

Former Member
0 Kudos

Hi,

         

Sorry for my confusion.

Now I already upgraded the kernel to same source system but it still occur same problem disp+work is stopped.

kernel release            640
patch number              175
Reagan
Advisor
Advisor
0 Kudos

What about these two :

Also run sappfpar against the instance profile and check for errors or paste the output here.

Any error in the message server log file - dev_ms ?

Former Member
0 Kudos

Hi Reagan

       sappfpar has no error occur.

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

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

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

[Thr 01] Tue Sep 30 19:53:13 2014

[Thr 01] MsSSetTrcLog: trc logging not active

[Thr 01] systemid   370 (Solaris on SPARCV9 CPU)

[Thr 01] relno      6400

[Thr 01] patchlevel 0

[Thr 01] patchno    171

[Thr 01] intno      20020600

[Thr 01] pid        3502

[Thr 01] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3502) [msxxserv_mt. 1680]

[Thr 01] SigISetDefaultAction : default handling for signal 18

[Thr 01] MsHttpInit: full qualified hostname = hristmp.baac.or.th

[Thr 01] HTTP logging is switch off

[Thr 01] set HTTP state to LISTEN

[Thr 01] MsHttpOwnDomain: own domain[1] = baac.or.th

[Thr 01] *** I listen to port sapmsHRQ (3610) ***

[Thr 01] *** HTTP port 8110 state LISTEN ***

[Thr 01] CUSTOMER KEY: >I0160700743<

            

[Thr 01] Tue Sep 30 19:54:27 2014

[Thr 01] *** ERROR => MsSClientHandle: no server provides service ENQ  (4), requested from hristmp_HRQ_10 [msxxserv_mt. 4290]

Sriram2009
Active Contributor
0 Kudos

Hi

Could update the latest log. After upgraded the kernel have restart the system ?

BR

SS

Sriram2009
Active Contributor
0 Kudos

Hi

I thing your kernel & DBSL patch level are low you can upgrade the kernel and then check the same.

(Your source & target kernel not same)

BR

SS

Former Member
0 Kudos

Hi

You mean kernel is OS kernel or SAP kernel ?

Sorry for my confusion because I just was recently as a Basis.

Sriram2009
Active Contributor
0 Kudos

You have to upgrade the SAP kernel for your OS & DB

BR

SS

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi,

Please upload dev_w0 logs and share r3trans -d trans.log.

Regards,

Former Member
0 Kudos

Hi Divyanshu

Here is R3trans.log

4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 30.09.2014 - 17:40:05

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [dev trc     ,00000]  Tue Sep 30 17:40:05 2014                              76  0.000076

4 ETW000  [dev trc     ,00000]  db_con_init called                                    12  0.000088

4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                             34  0.000122

4 ETW000  [dev trc     ,00000]  Loading DB library '/usr/sap/HRQ/SYS/exe/run/dboraslib.so' ...

4 ETW000                                                                              25  0.000147

4 ETW000  [dev trc     ,00000]  load shared library (/usr/sap/HRQ/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000                                                                           18342  0.018489

4 ETW000  [dev trc     ,00000]  Library '/usr/sap/HRQ/SYS/exe/run/dboraslib.so' loaded     

4 ETW000                                                                              73  0.018562

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library /usr/sap/HRQ/SYS/exe/run/dboraslib.so

4 ETW000                                                                              27  0.018589

4 ETW000  [dev trc     ,00000]  Version of '/usr/sap/HRQ/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.32)

4 ETW000                                                                             117  0.018706

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library /usr/sap/HRQ/SYS/exe/run/dboraslib.so

4 ETW000                                                                              15  0.018721

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library /usr/sap/HRQ/SYS/exe/run/dboraslib.so

4 ETW000                                                                              43  0.018764

4 ETW000  [dev trc     ,00000]  New connection 0 created                              13  0.018777

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              21  0.018798

4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                         27  0.018825

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

4 ETW000                                                                              15  0.018840

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                              14  0.018854

4 ETW000  [dev trc     ,00000]  Got ORACLE_HOME=/oracle/HRQ/920_64 from environment

4 ETW000                                                                             205  0.019059

4 ETW000  [dev trc     ,00000]  -->oci_initialize                                     25  0.019084

4 ETW000  [dev trc     ,00000]  Client NLS settings: AMERICAN_AMERICA.WE8DEC        2257  0.021341

4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPHRP's password           12  0.021353

4 ETW000  [dev trc     ,00000]  Connecting as /@HRQ on connection 0 ...               10  0.021363

4 ETW000  [dev trc     ,00000]  Allocating service context handle                     20  0.021383

4 ETW000  [dev trc     ,00000]  Allocating server context handle                      12  0.021395

4 ETW000  [dev trc     ,00000]  Attaching to DB Server HRQ (con_hdl=0,svchp=100f03df8,svrhp=100f061a8)

4 ETW000                                                                              39  0.021434

4 ETW000  [dev trc     ,00000]  Assigning server context 100f061a8 to service context 100f03df8

4 ETW000                                                                           22405  0.043839

4 ETW000  [dev trc     ,00000]  Allocating user session handle                        38  0.043877

4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=100f03df8,srvhp=100f061a8,usrhp=100f0fb78)

4 ETW000                                                                              19  0.043896

4 ETW000  [dev trc     ,00000]  Assigning user session 100f0fb78 to service context 100f03df8

4 ETW000                                                                            5388  0.049284

4 ETW000  [dev trc     ,00000]  Now I'm connected to ORACLE                          581  0.049865

4 ETW000  [dev trc     ,00000]  Got SAPHRP's password from OPS$-user                 747  0.050612

4 ETW000  [dev trc     ,00000]  Disconnecting from connection 0 ...                   14  0.050626

4 ETW000  [dev trc     ,00000]  Rolling back transaction ...                          18  0.050644

4 ETW000  [dev trc     ,00000]  Closing user session (con_hdl=0,svchp=100f03df8,usrhp=100f0fb78)

4 ETW000                                                                             109  0.050753

4 ETW000  [dev trc     ,00000]  Now I'm disconnected from ORACLE                     216  0.050969

4 ETW000  [dev trc     ,00000]  Connecting as SAPHRP/<pwd>@HRQ on connection 0 ...

4 ETW000                                                                              17  0.050986

4 ETW000  [dev trc     ,00000]  Assigning username to user session 100f0fb78           8  0.050994

4 ETW000  [dev trc     ,00000]  Assigning password to user session 100f0fb78          11  0.051005

4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=100f03df8,srvhp=100f061a8,usrhp=100f0fb78)

4 ETW000                                                                              15  0.051020

4 ETW000  [dev trc     ,00000]  Assigning user session 100f0fb78 to service context 100f03df8

4 ETW000                                                                            1538  0.052558

4 ETW000  [dev trc     ,00000]  Now I'm connected to ORACLE                          206  0.052764

4 ETW000  [dev trc     ,00000]  Database NLS settings: AMERICAN_AMERICA.WE8DEC       369  0.053133

4 ETW000  [dev trc     ,00000]  Database instance HRQ is running on hristmp with ORACLE version 9.2.0.7.0 since 20140930

4 ETW000                                                                             208  0.053341

4 ETW000  [dev trc     ,00000]  Connection 0 opened                                  872  0.054213

4 ETW000  [dev trc     ,00000]  NTAB: Structure of NTAB on DB is VERS_B             3154  0.057367

4 ETW000  [dev trc     ,00000]  NTAB: standalone processing                           40  0.057407

4 ETW000  [dev trc     ,00000]  NTAB: read profile                                    10  0.057417

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/entrycount 1000.                       9  0.057426

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/ftabsize 500.                          8  0.057434

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/irbdsize 100.                          8  0.057442

4 ETW000  [dev trc     ,00000]  NTAB: rsdb/ntab/sntabsize 100.                        15  0.057457

4 ETW000  [dev trc     ,00000]  NTAB: compute_hash_card: 2003.                       481  0.057938

4 ETW000  [dev trc     ,00000]  NTAB: maxcnt 1000.                                    13  0.057951

4 ETW000  [dev trc     ,00000]  NTAB: hfactor 2003.                                    8  0.057959

4 ETW000  [dev trc     ,00000]  NTAB: mem_protocol_size 104                            8  0.057967

4 ETW000  [dev trc     ,00000]  NTAB: hdr_backpack_offset 0                            8  0.057975

4 ETW000  [dev trc     ,00000]  NTAB: hdr_backpack_size 0                              8  0.057983

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: header_size 80.                            8  0.057991

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: item_size 64.                              8  0.057999

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: item_cnt 1000.                             8  0.058007

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: unit_size 4                               36  0.058043

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: unit_cnt 128000.                           9  0.058052

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: data_size 512000.                          9  0.058061

4 ETW000  [dev trc     ,00000]  NTAB: IREC: header_size 80.                            8  0.058069

4 ETW000  [dev trc     ,00000]  NTAB: IREC: item_size 64.                              9  0.058078

4 ETW000  [dev trc     ,00000]  NTAB: IREC: item_cnt 250.                              8  0.058086

4 ETW000  [dev trc     ,00000]  NTAB: IREC: unit_size 8                                9  0.058095

4 ETW000  [dev trc     ,00000]  NTAB: IREC: unit_cnt 12800.                            8  0.058103

4 ETW000  [dev trc     ,00000]  NTAB: IREC: data_size 102400.                          8  0.058111

4 ETW000  [dev trc     ,00000]  NTAB: STAB: header_size 80.                            9  0.058120

4 ETW000  [dev trc     ,00000]  NTAB: STAB: item_size 64.                              8  0.058128

4 ETW000  [dev trc     ,00000]  NTAB: STAB: item_cnt 250.                             32  0.058160

4 ETW000  [dev trc     ,00000]  NTAB: STAB: unit_size 4                                9  0.058169

4 ETW000  [dev trc     ,00000]  NTAB: STAB: unit_cnt 25600.                            8  0.058177

4 ETW000  [dev trc     ,00000]  NTAB: STAB: data_size 102400.                          8  0.058185

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: header_size 184.                           8  0.058193

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: item_size 40.                              8  0.058201

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: item_cnt 1000.                             8  0.058209

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: unit_size 152                              8  0.058217

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: unit_cnt 1000.                             8  0.058225

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: data_size 152000.                          9  0.058234

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: hh_p 100f32d40, hh_len 80               4753  0.062987

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: aa_p 100fbfcf0, aa_len 16024              11  0.062998

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: ia_p 100fc3ba0, ia_len 64000               9  0.063007

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: dat_p 100fd35b0, dat_len 512000            9  0.063016

4 ETW000  [dev trc     ,00000]  NTAB: IREC: hh_p 1010505c0, hh_len 80                  8  0.063024

4 ETW000  [dev trc     ,00000]  NTAB: IREC: aa_p 101050620, aa_len 16024               9  0.063033

4 ETW000  [dev trc     ,00000]  NTAB: IREC: ia_p 1010544d0, ia_len 16000               8  0.063041

4 ETW000  [dev trc     ,00000]  NTAB: IREC: dat_p 101058360, dat_len 102400            9  0.063050

4 ETW000  [dev trc     ,00000]  NTAB: STAB: hh_p 101071370, hh_len 80                  8  0.063058

4 ETW000  [dev trc     ,00000]  NTAB: STAB: aa_p 1010713d0, aa_len 16024               8  0.063066

4 ETW000  [dev trc     ,00000]  NTAB: STAB: ia_p 101075280, ia_len 16000              13  0.063079

4 ETW000  [dev trc     ,00000]  NTAB: STAB: dat_p 101079110, dat_len 102400            9  0.063088

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: hh_p 101092120, hh_len 184                 9  0.063097

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: aa_p 1010921f0, aa_len 16024               8  0.063105

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: ia_p 1010960a0, ia_len 40000               9  0.063114

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: dat_p 10109fcf0, dat_len 152000            8  0.063122

4 ETW000  [dev trc     ,00000]  NTAB: ntab_mem_protocol 101092120, ntab_mp_p 101092120, ntab_proc_id 0

4 ETW000                                                                              15  0.063137

4 ETW000  [dev trc     ,00000]  NTAB: FTAB: hh_p 100f32d40, ha_list 100fbfcf0, hi_list 100fc3ba0, buffer 100fd35b0

4 ETW000                                                                              69  0.063206

4 ETW000  [dev trc     ,00000]  NTAB: IREC: hh_p 1010505c0, ha_list 101050620, hi_list 1010544d0, buffer 101058360

4 ETW000                                                                              16  0.063222

4 ETW000  [dev trc     ,00000]  NTAB: STAB: hh_p 101071370, ha_list 1010713d0, hi_list 101075280, buffer 101079110

4 ETW000                                                                              13  0.063235

4 ETW000  [dev trc     ,00000]  NTAB: TTAB: hh_p 101092188, ha_list 1010921f0, hi_list 1010960a0, buffer 10109fcf0

4 ETW000                                                                              13  0.063248

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000                                                                              17  0.063265

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 1       

4 ETW000                                                                              21  0.063286

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000                                                                              24  0.063310

4 ETW000  [dev trc     ,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000                                                                              19  0.063329

4 ETW000  [dev trc     ,00000]  { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:736}

4 ETW000                                                                             806  0.064135

4 ETW000  [dev trc     ,00000]  } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )4 ETW000                                                                             344  0.064479

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'HRQ' --- SYSTEM = 'HRP'.

4 ETW000  [dev trc     ,00000]  { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1128}

4 ETW000                                                                             162  0.064641

4 ETW000  [dev trc     ,00000]  } db_rtab( fcode = 'RT_INSERT', retcode = 0 )        544  0.065185

4 ETW000  [dev trc     ,00000]  dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000                                                                              39  0.065224

4 ETW000  [dev trc     ,00000]  dsql_fetch (con_da=(0,R/3),cu_id=0,#output=8)         39  0.065263

4 ETW000  [dev trc     ,00000]  dsql_close (con_da=(0,R/3),cu_id=0)                  267  0.065530

4 ETW000  [dev trc     ,00000]  { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1236}

4 ETW000                                                                              19  0.065549

4 ETW000  [dev trc     ,00000]  } db_rtab( fcode = 'RT_DELETE', retcode = 0 )        242  0.065791

4 ETW690 "0" "0"

4 ETW000  [dev trc     ,00000]  db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)

4 ETW000                                                                              26  0.065817

4 ETW000 COMMIT (0).

4 ETW000  trace to file pointer closed

4 ETW000  trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time   : 30.09.2014 - 17:40:05

4 ETW000 function    : CONNECT

4 ETW000 buffersync  : YES

4 ETW000 clients     : default

4 ETW000 l.s.m.      : VECTOR

4 ETW000 commit      : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000  [dev trc     ,00000]  Disconnecting from ALL connections:                 4066  0.004066

4 ETW000  [dev trc     ,00000]  Disconnecting from connection 0 ...                   19  0.004085

4 ETW000  [dev trc     ,00000]  Closing user session (con_hdl=0,svchp=100f03df8,usrhp=100f0fb78)

4 ETW000                                                                             169  0.004254

4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=100f03df8,srvhp=100f061a8)

4 ETW000                                                                             161  0.004415

4 ETW000  [dev trc     ,00000]  Now I'm disconnected from ORACLE                     365  0.004780

4 ETW000  [dev trc     ,00000]  Disconnected from connection 0                        13  0.004793

4 ETW000  [dev trc     ,00000]  statistics db_con_commit (com_total=1, com_tx=1)4 ETW000                                                                              13  0.004806

4 ETW000  [dev trc     ,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000                                                                              13  0.004819

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 30.09.2014 - 17:40:05

Former Member
0 Kudos

Hi Peeravat,

As per your log " R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42)"

It seems R3trans has very old version.Can you cross check R3trans and all executables in exe directory?

Thanks,

Prakash

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi,

The issue is not with the kernel.

The problem is with shared memory or some parameter.

Can you check the system profiles and stop sap and db, issue cleanipc and if required use ipcrm.

Once this is done, start db and sap and continue.

Regards

Former Member
0 Kudos

Hi,

I tried to cleanup share-memory already but it's not help disp+work still automatically down.

Former Member
0 Kudos

Hello,

typical reason of immediate death of work processes could be full file system or not enough memory. Have a look on this thread please: http://scn.sap.com/thread/1369854

Maybe can you add here the content (last 100-200 rows should be enough) of dev_w0 file?

Kind regards

Former Member
0 Kudos

Last 200 rows of dev_w0 log

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

B  4: 2000 * 160 = 320000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 65 * 8 = 520

B  8: 28006 * 128 = 3584768

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B  dbexpbuf: Buffer EIBUF (addr: fffffffe69800108, size: 4194304, end: fffffffe69c00108)

B  ***LOG BB0=> buffer EIBUF      started with length 4096k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  Layout of ESM   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 416 = 416

B  2: 8 * 40 = 320

B  3: 4001 * 64 = 256064

B  4: 2000 * 160 = 320000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 65 * 8 = 520

B  8: 28006 * 128 = 3584768

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B  dbexpbuf: Buffer ESM   (addr: fffffffe69000108, size: 4194304, end: fffffffe69400108)

B  ***LOG BB0=> buffer ESM        started with length 4096k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  Layout of CUA   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 416 = 416

B  2: 8 * 40 = 320

B  3: 3001 * 64 = 192064

B  4: 1500 * 160 = 240000

B  5: 3001 * 8 = 24008

B  6: 1 * 200 = 200

B  7: 193 * 8 = 1544

B  8: 10208 * 256 = 2613248

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B Tue Sep 30 13:51:19 2014

B  dbexpbuf: Buffer CUA   (addr: fffffffe54dec108, size: 3072000, end: fffffffe550da108)

B  ***LOG BB0=> buffer CUA        started with length 3000k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  Layout of OTR   buffer shared memory:

B  0: 1 * 4 = 4

B  1: 1 * 416 = 416

B  2: 8 * 40 = 320

B  3: 4001 * 64 = 256064

B  4: 2000 * 160 = 320000

B  5: 4001 * 8 = 32008

B  6: 1 * 200 = 200

B  7: 81 * 8 = 648

B  8: 28005 * 128 = 3584640

B  Tracing = 0, Shm Protection = 0, Force checks = 0

B  dbexpbuf: Buffer OTR   (addr: fffffffe68800108, size: 4194304, end: fffffffe68c00108)

B  ***LOG BB0=> buffer OTR        started with length 4096k      bytes [dbexpbuf#5 @ 2322] [dbexpbuf2322 ]

B  ***LOG BB0=> buffer CALE       started with length 500000     bytes [dbcalbuf#1 @ 2206] [dbcalbuf2206 ]

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

B   max_blocking_factor =  15,  max_in_blocking_factor      =   5,

B   min_blocking_factor =  10,  min_in_blocking_factor      =   5,

B   prefer_union_all    =   0,  prefer_union_for_select_all =   0,

B   prefer_fix_blocking =   0,  prefer_in_itab_opt          =   1,

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

B   escape_as_literal   =   1,  opt GE LE to BETWEEN        =   0,

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

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

B                         rule_fae->0, concat_fae->0, concat_fae_or->0

B  *** ERROR => missing return code handler    

caller does not handle code 32 from dbntab#7[3098]    

==> calling sap_dext to abort transaction

[dbeh.c       93]

M  ------------------ C-STACK ----------------------

[0] DoStack2 ( 0x103808080, 0x0, 0x2662800, 0x100000000, 0x1, 0x0 ), at 0x1004637a0

[1] CTrcStack2 ( 0x102bbc6a8, 0x0, 0x100000000, 0x2662000, 0x2, 0x1026623b4 ), at 0x100463350

[2] ThControl ( 0xffffffff7fffece0, 0xa, 0x102662000, 0x2662000, 0x100000000, 0x1 ), at 0x1004334f8

[3] dextIntern ( 0x0, 0x1, 0x103bc4ba0, 0xffffffff7fffece0, 0x20, 0x22e8 ), at 0x10051c660

[4] sap_dext ( 0xa, 0x1029c0c20, 0x384, 0xffffffff7fffed38, 0x0, 0x20 ), at 0x10051ba6c

[5] dbeh_exit ( 0x2810c00, 0x1029c0c00, 0x29c0c00, 0x100000000, 0x1, 0x0 ), at 0x10126a3b4

[6] db_ntab ( 0x0, 0x2808000, 0x0, 0x100000000, 0x2808000, 0x102808000 ), at 0x10128f0f8

[7] read_ntab ( 0x10280aff0, 0x5, 0x0, 0x0, 0x84, 0x0 ), at 0x1013a6000

[8] db_cbufload ( 0x10280aee0, 0x0, 0x102810c00, 0x1, 0x10280b014, 0x0 ), at 0x1013ab8f0

[9] reset_handling ( 0x1029c6ce0, 0x2f7b000, 0x0, 0xffffffff7ffff290, 0x1, 0x0 ), at 0x1013a51f4

[10] init_shm_and_load_cals ( 0x0, 0x29c6c00, 0x0, 0xffffffff76d1c05c, 0x10280ac00, 0x1 ), at 0x1013a4dfc

[11] db_cbufinst ( 0xffffffff7ffff508, 0x102662000, 0x10280b160, 0x100000000, 0x10280b000, 0x280b000 ), at 0x1013a2cf4

[12] db_calinit ( 0x1029c6608, 0x1029c6400, 0x29c6400, 0x100000000, 0x1, 0x0 ), at 0x1013996b0

[13] db_init ( 0x0, 0x10144c000, 0x144c000, 0x100000000, 0x0, 0x0 ), at 0x10144c060

[14] ThCallHooks ( 0x100000000, 0x0, 0xffffffffffffffff, 0x103f8d040, 0x0, 0x10291f8f0 ), at 0x100304b08

[15] ThIPCInit ( 0x10144b688, 0x102ba9bbc, 0x102919210, 0x0, 0x1, 0x4 ), at 0x1002305c8

[16] tskh_init ( 0x0, 0x1, 0x1cb6c00, 0x1cc0800, 0x1, 0x101cc0800 ), at 0x10022c5d8

[17] tskhstart ( 0x1, 0x10039cc00, 0x0, 0x1, 0x102662000, 0x2662000 ), at 0x10022aba0

[18] DpMain ( 0x2b11800, 0x2659000, 0x100000000, 0x1, 0x0, 0x0 ), at 0x1001570f8

M  -------------------------------------------------

M  ***LOG R1B=> ThControl, sap_dext-call (00 ) [thxxdynp.c   355]

M  in_ThErrHandle: 1

M  *** ERROR => ThControl: illegal sap_dext call !!! (step 1, th_errno 5, action 1, level 1) [thxxhead.c   9413]

M  Info for wp 0

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  Entering ThSetStatError

M  Entering ThReadDetachMode

M  ThISend: still inside critical section semaphore ?

M  ------------------ C-STACK ----------------------

[0] _longjmp ( 0x100000000, 0xffffffffffffffff, 0x0, 0x1, 0x1, 0x265a000 ), at 0xffffffff7cc3afdc

[1] ThIErrHandle ( 0x100000000, 0x2662000, 0x0, 0x1029351e8, 0x0, 0xffffffffffffffff ), at 0x1002608b0

[2] ThControl ( 0xffffffff7fffece0, 0x2662000, 0x22a0400, 0x102935000, 0x2935000, 0x100000000 ), at 0x100433730

[3] dextIntern ( 0x0, 0x1, 0x103bc4ba0, 0xffffffff7fffece0, 0x20, 0x22e8 ), at 0x10051c660

[4] sap_dext ( 0xa, 0x1029c0c20, 0x384, 0xffffffff7fffed38, 0x0, 0x20 ), at 0x10051ba6c

[5] dbeh_exit ( 0x2810c00, 0x1029c0c00, 0x29c0c00, 0x100000000, 0x1, 0x0 ), at 0x10126a3b4

[6] db_ntab ( 0x0, 0x2808000, 0x0, 0x100000000, 0x2808000, 0x102808000 ), at 0x10128f0f8

[7] read_ntab ( 0x10280aff0, 0x5, 0x0, 0x0, 0x84, 0x0 ), at 0x1013a6000

[8] db_cbufload ( 0x10280aee0, 0x0, 0x102810c00, 0x1, 0x10280b014, 0x0 ), at 0x1013ab8f0

[9] reset_handling ( 0x1029c6ce0, 0x2f7b000, 0x0, 0xffffffff7ffff290, 0x1, 0x0 ), at 0x1013a51f4

[10] init_shm_and_load_cals ( 0x0, 0x29c6c00, 0x0, 0xffffffff76d1c05c, 0x10280ac00, 0x1 ), at 0x1013a4dfc

[11] db_cbufinst ( 0xffffffff7ffff508, 0x102662000, 0x10280b160, 0x100000000, 0x10280b000, 0x280b000 ), at 0x1013a2cf4

[12] db_calinit ( 0x1029c6608, 0x1029c6400, 0x29c6400, 0x100000000, 0x1, 0x0 ), at 0x1013996b0

[13] db_init ( 0x0, 0x10144c000, 0x144c000, 0x100000000, 0x0, 0x0 ), at 0x10144c060

[14] ThCallHooks ( 0x100000000, 0x0, 0xffffffffffffffff, 0x103f8d040, 0x0, 0x10291f8f0 ), at 0x100304b08

[15] ThIPCInit ( 0x10144b688, 0x102ba9bbc, 0x102919210, 0x0, 0x1, 0x4 ), at 0x1002305c8

[16] tskh_init ( 0x0, 0x1, 0x1cb6c00, 0x1cc0800, 0x1, 0x101cc0800 ), at 0x10022c5d8

[17] tskhstart ( 0x1, 0x10039cc00, 0x0, 0x1, 0x102662000, 0x2662000 ), at 0x10022aba0

[18] DpMain ( 0x2b11800, 0x2659000, 0x100000000, 0x1, 0x0, 0x0 ), at 0x1001570f8

M  -------------------------------------------------

M  ***LOG Q0E=> SigIGenAction, signal ( 10) [sigux.c      836]

M  in_ThErrHandle: 2

M  ***LOG R0H=> ThIErrHandle, Loop in ThErrHandle, restart wp () [thxxhead.c   9434]

M  ------------------ C-STACK ----------------------

[0] DoStack2 ( 0x103808080, 0x0, 0x2662800, 0x100000000, 0x1, 0x0 ), at 0x1004637a0

[1] CTrcStack2 ( 0x102bbc6a8, 0x0, 0x100000000, 0x2662000, 0x2, 0x1026623b4 ), at 0x100463350

[2] ThIErrHandle ( 0x0, 0x1, 0x3, 0x102927468, 0xb, 0x4 ), at 0x10025e7d4

[3] SigIGenAction ( 0x102a80400, 0x1026623d8, 0x3, 0xa, 0x0, 0x1026623ac ), at 0x101c87b78

[4] __sighndlr ( 0xa, 0xffffffff7fffe3f0, 0xffffffff7fffe110, 0x101c873c8, 0x0, 0x0 ), at 0xffffffff7ccd6fdc

[5] call_user_handler ( 0xffffffff7d900200, 0xffffffff7d900200, 0xffffffff7fffe110, 0x19, 0x0, 0x0 ), at 0xffffffff7cccab70

[6] sigacthandler ( 0x0, 0xffffffff7fffe3f0, 0xffffffff7fffe110, 0xffffffff7d900200, 0x0, 0xffffffff7ce3c000 ), at 0xffffffff7cccad7c

[7] ThISend ( 0x100000000, 0xffffffffffffffff, 0x0, 0x1, 0x1, 0x265a000 ), at 0x10025dd64

[8] ThIErrHandle ( 0x100000000, 0x2662000, 0x0, 0x1029351e8, 0x0, 0xffffffffffffffff ), at 0x1002608b0

[9] ThControl ( 0xffffffff7fffece0, 0x2662000, 0x22a0400, 0x102935000, 0x2935000, 0x100000000 ), at 0x100433730

[10] dextIntern ( 0x0, 0x1, 0x103bc4ba0, 0xffffffff7fffece0, 0x20, 0x22e8 ), at 0x10051c660

[11] sap_dext ( 0xa, 0x1029c0c20, 0x384, 0xffffffff7fffed38, 0x0, 0x20 ), at 0x10051ba6c

[12] dbeh_exit ( 0x2810c00, 0x1029c0c00, 0x29c0c00, 0x100000000, 0x1, 0x0 ), at 0x10126a3b4

[13] db_ntab ( 0x0, 0x2808000, 0x0, 0x100000000, 0x2808000, 0x102808000 ), at 0x10128f0f8

[14] read_ntab ( 0x10280aff0, 0x5, 0x0, 0x0, 0x84, 0x0 ), at 0x1013a6000

[15] db_cbufload ( 0x10280aee0, 0x0, 0x102810c00, 0x1, 0x10280b014, 0x0 ), at 0x1013ab8f0

[16] reset_handling ( 0x1029c6ce0, 0x2f7b000, 0x0, 0xffffffff7ffff290, 0x1, 0x0 ), at 0x1013a51f4

[17] init_shm_and_load_cals ( 0x0, 0x29c6c00, 0x0, 0xffffffff76d1c05c, 0x10280ac00, 0x1 ), at 0x1013a4dfc

[18] db_cbufinst ( 0xffffffff7ffff508, 0x102662000, 0x10280b160, 0x100000000, 0x10280b000, 0x280b000 ), at 0x1013a2cf4

[19] db_calinit ( 0x1029c6608, 0x1029c6400, 0x29c6400, 0x100000000, 0x1, 0x0 ), at 0x1013996b0

[20] db_init ( 0x0, 0x10144c000, 0x144c000, 0x100000000, 0x0, 0x0 ), at 0x10144c060

[21] ThCallHooks ( 0x100000000, 0x0, 0xffffffffffffffff, 0x103f8d040, 0x0, 0x10291f8f0 ), at 0x100304b08

[22] ThIPCInit ( 0x10144b688, 0x102ba9bbc, 0x102919210, 0x0, 0x1, 0x4 ), at 0x1002305c8

[23] tskh_init ( 0x0, 0x1, 0x1cb6c00, 0x1cc0800, 0x1, 0x101cc0800 ), at 0x10022c5d8

[24] tskhstart ( 0x1, 0x10039cc00, 0x0, 0x1, 0x102662000, 0x2662000 ), at 0x10022aba0

[25] DpMain ( 0x2b11800, 0x2659000, 0x100000000, 0x1, 0x0, 0x0 ), at 0x1001570f8

M  -------------------------------------------------

M  ThSigHandler: signal (step 5, th_errno 11, action 4)

M  Info for wp 0

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  PfStatDisconnect: disconnect statistics

M  Entering ThSetStatError

M  ThIErrHandle: don't try rollback again

B  Disconnecting from ALL connections:

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 20140930 135116 hristmp        

C  Disconnecting from connection 0 ...

C  Closing user session (con_hdl=0,svchp=103fe82a8,usrhp=103ff40b8)

C  Detaching from DB Server (con_hdl=0,svchp=103fe82a8,srvhp=103fea698)

C  Now I'm disconnected from ORACLE

B  Disconnected from connection 0

B  statistics db_con_commit (com_total=0, com_tx=0)

B  statistics db_con_rollback (roll_total=0, roll_tx=0)

M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 27749) [dpuxtool.c   322]

Former Member
0 Kudos

Dear

This could be related to shared memory problems.

clear all sahred memory

kill all active processes  some time something locked in shared memory

then you tried rebooting the server?

Problem May be with your Database ....just give First run this as sidadm in command prompt and let us know

R3trans -d SID it houls be 0000

Regards

Former Member
0 Kudos

Hi Rajendra

     Now I can't reboot the server but I have a schedule plan for restart in the nearly future. Therefore when I already restarted I will tell the result.