on 09-30-2014 11:05 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M 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
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M 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]
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]
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please upload dev_w0 logs and share r3trans -d trans.log.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M 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
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M 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]
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
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.