Internel TSKH error, session Terminated

[Former Member]

Hi Gurus,

I have upgraded the sap kernel from 46D to 640. My oracle version is 9.2.0.7 and OS is SUN SPARC 10.

Sap is up but when i start the SAP GUI . Iam getting below error

Internel TSKH error, session Terminated.

Below is the dev_disp log....

• VERSION 1

M * RC 5

M * MODULE thxxhead.c

M * LINE 9555

M * COUNTER 7

M *

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

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M TrThHookFunc: called for WP dump

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M ThrSaveSPAFields: save spa fields

M Entering ThSetStatError

M ThIErrHandle: incomplete previous roll out, do a full roll out

M ThRollOut: roll out T22/U23/M0 (level=7, short_roll_out=0)

M ThRollOut: call rrol_out (1)

M ThRollOut: act roll state = DP_ROLLED_OUT

M ThRollOut: roll level <> 0, don't call ab_rollout

M ThRollOut: full roll out of U23 M0 I0 (Level 7) ok

M ThIErrHandle: don't try rollback again

M ThIErrHandle: Entering ThReplyToMsg

M ThIErrHandle: Entering ThErrHdlUser

M ThErrHdlUser: set th_errno (5)

M ThErrHdlUser: save context

M ThEmContextDetach2: detach T22/M0 from em memory (em_hdl=1, force=0)

M ThEmContextDetach2: reset local em info

M call ThrShutDown ...

B Disconnecting from ALL connections:

B Wp Hdl ConName ConId ConState TX PRM RCT MAX OPT Date Time DBHost

B 022 000 R/3 000000000 INACTIVE NO YES NO 255 255 20081021 092653 geecc

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=103f5b938,usrhp=103f67758)

C Detaching from DB Server (con_hdl=0,svchp=103f5b938,srvhp=103f5dd28)

C Now I'm disconnected from ORACLE

B Disconnected from connection 0

B statistics db_con_commit (com_total=6, com_tx=1)

B statistics db_con_rollback (roll_total=2, roll_tx=1)

M ***LOG Q02=> wp_halt, WPStop (Workproc22 20144) [dpuxtool.c 322]

-

---

trc file: "dev_w22", 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 21

M intno 20020600

M make: single threaded, ASCII, 64 bit

M pid 20149

M

M

M Tue Oct 21 09:27:54 2008

M ***LOG Q01=> tskh_init, WPStart (Workproc2215 20149) [thxxhead.c 1133]

M calling db_connect ...

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

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server PRD (con_hdl=0,svchp=103f5b938,svrhp=103f5dd28)

C Starting user session (con_hdl=0,svchp=103f5b938,srvhp=103f5dd28,usrhp=103f67758)

C Now I'm connected to ORACLE

C Got SAPR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=103f5b938,usrhp=103f67758)

C Now I'm disconnected from ORACLE

C Connecting as SAPR3/<pwd>@PRD on connection 0 ...

C Starting user session (con_hdl=0,svchp=103f5b938,srvhp=103f5dd28,usrhp=103f67758)

C Now I'm connected to ORACLE

C Database NLS settings: AMERICAN_AMERICA.WE8DEC

C Database instance PRD is running on geecc with ORACLE version 9.2.0.7.0 since 20081021

B Connection 0 opened

B Wp Hdl ConName ConId ConState TX PRM RCT MAX OPT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 255 255 20081021 092754 geecc

M db_connect o.k.

I MtxInit: 22 0 0

M SHM_PRES_BUF (addr: ffffffff76256000, size: 20000000)

M SHM_ROLL_AREA (addr: fffffffe62800000, size: 134217728)

M SHM_PAGING_AREA (addr: fffffffe5e400000, size: 67108864)

M SHM_ROLL_ADM (addr: ffffffff7756c000, size: 2672386)

M SHM_PAGING_ADM (addr: ffffffff70700000, size: 656416)

I Profile configuration error detected, use temporary corrected setup

I Shared Pool 40: ipc/shm_psize_40 = 70000000 (too small)

I Shared Pool 40: (smaller than min requirement 110824088)

I Shared Pool 40: (estimated size assumed 114000000)

M ThCreateNoBuffer allocated 352144 bytes for 1000 entries at fffffffe57404000

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 7440 bytes (50 server) at ffffffff71900000

X EmInit: MmSetImplementation( 2 ).

X <ES> client 22 initializing ....

X Using implementation std

X ES initialized.

B db_con_shm_ini: WP_ID = 22, WP_CNT = 25

B dbtbxbuf: Buffer TABL (addr: fffffffe53800100, size: 50000000, end: fffffffe567af180)

B dbtbxbuf: Buffer TABLP (addr: fffffffe52400100, size: 20480000, end: fffffffe53788100)

B dbexpbuf: Buffer EIBUF (addr: fffffffe51c00108, size: 4194304, end: fffffffe52000108)

B dbexpbuf: Buffer ESM (addr: fffffffe51400108, size: 4194304, end: fffffffe51800108)

B dbexpbuf: Buffer CUA (addr: fffffffe5a1ee108, size: 5120000, end: fffffffe5a6d0108)

B dbexpbuf: Buffer OTR (addr: fffffffe50c00108, size: 4194304, end: fffffffe51000108)

M rdisp/reinitialize_code_page -> 0

M icm/accept_remote_trace_level -> 0

M PfReadDBVersion: use compatibility mode for stat-files

C *** ERROR => ORA-904 occured when executing SQL statement (parse error offset = 7)

[dbsloci.c 11247]

C sc_p=103f03fe8,no=1,idc_p=0,con=0,act=1,slen=27,smax=256,#vars=0,stmt=10424a690,table=DDNTT

C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=0,ocistmth_p=103f64458

C IN : cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=0,vmax=0,bound=0,iobuf_p=0,vda_p=0

C lobs=0,lmax=0,lpcnt=0,larr=0,lcurr_p=0,rret=0

C OUT: cols=1,rmax=10833,xcnt=1,rpc=0,rowi=0,rtot=0,upto=1,rsize=4,vmax=32,bound=1,iobuf_p=103f88000,vda_p=10424a800

C lobs=0,lmax=0,lpcnt=0,larr=0,lcurr_p=0,rret=0

C SELECT COMPCNT FROM "DDNTT";

S *** init spool environment

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 1042a31c0

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 1 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S found spool memory service RSPO-RCLOCKS at fffffffe5a6d4060

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at fffffffe5a6d4940

S using messages for server info

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

S size of open spool request entry: 1184 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A -PXA--

---

A PXA INITIALIZATION

A PXA: Fragment Size too small: 97 MB, reducing # of fragments

A System page size: 8kb, admin_size: 15424kb.

A Attached to PXA (address fffffffe38400000, size 400000K)

A abap/pxa = shared protect gen_remote

A PXA INITIALIZATION FINISHED

A -PXA--

---

A

A ***Error in abrtm.c: DB-Error 32 opening table SRTM_ACT.

A ABAP ShmAdm attached (addr=fffffffe70526000 leng=20938752 end=fffffffe7191e000)

A >> Shm MMADM area (addr=fffffffe70746aa0 leng=144960 end=fffffffe7076a0e0)

A >> Shm MMDAT area (addr=fffffffe7076c000 leng=18554880 end=fffffffe7191e000)

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

M slave hook = T-1/U-1/M255

geecc:prdadm 14% more dev_disp

-

---

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

-

---

Tue Oct 21 09:16:27 2008

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 21

intno 20020600

make: single threaded, ASCII, 64 bit

pid 19994

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

shared lib "dw_xml.so" version 21 successfully loaded

shared lib "dw_xtc.so" version 21 successfully loaded

shared lib "dw_stl.so" version 21 successfully loaded

shared lib "dw_gui.so" version 21 successfully loaded

MtxInit: -2 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: JAVA is not active

DpShMCreate: sizeof(wp_adm) 21400 (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: ffffffff71b00000, size: 3190832)

DpShMCreate: allocated sys_adm at ffffffff71b00000

DpShMCreate: allocated wp_adm at ffffffff71b01898

DpShMCreate: allocated tm_adm_list at ffffffff71b06c30

DpShMCreate: allocated tm_adm at ffffffff71b06c58

DpShMCreate: allocated wp_ca_adm at ffffffff71dbf348

DpShMCreate: allocated appc_ca_adm at ffffffff71dc5a68

DpShMCreate: allocated comm_adm_list at ffffffff71dc7cc8

DpShMCreate: allocated comm_adm at ffffffff71dc7ce0

DpShMCreate: allocated vmc_adm_list at ffffffff71dfc8a0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at ffffffff71dfc8c8

DpShMCreate: allocated wall_adm at ffffffff71dfc8d0

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 Oct 21 09:16:32 2008

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( geecc) [dpxxdisp.c 9719]

• ERROR => W0 (pid 19999) died [dpxxdisp.c 12170]

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 21

Release check o.K.

MBUF state ACTIVE

DpModState: change server state from STARTING to ACTIVE

Tue Oct 21 09:16:54 2008

• ERROR => W22 (pid 20051) died [dpxxdisp.c 12170]

• ERROR => DpRqCheck: mode 0 in status CANCEL [dpxxdisp.c 5726]

Tue Oct 21 09:17:13 2008

• ERROR => W22 (pid 20074) died [dpxxdisp.c 12170]

Tue Oct 21 09:17:33 2008

• ERROR => W22 (pid 20080) died [dpxxdisp.c 12170]

Tue Oct 21 09:17:53 2008

• ERROR => W22 (pid 20087) died [dpxxdisp.c 12170]

Tue Oct 21 09:18:54 2008

• ERROR => W22 (pid 20095) died [dpxxdisp.c 12170]

Tue Oct 21 09:19:54 2008

• ERROR => W22 (pid 20105) died [dpxxdisp.c 12170]

Tue Oct 21 09:20:54 2008

• ERROR => W22 (pid 20111) died [dpxxdisp.c 12170]

Tue Oct 21 09:21:54 2008

• ERROR => W22 (pid 20114) died [dpxxdisp.c 12170]

Tue Oct 21 09:22:52 2008

• ERROR => W22 (pid 20119) died [dpxxdisp.c 12170]

Tue Oct 21 09:23:54 2008

• ERROR => W22 (pid 20124) died [dpxxdisp.c 12170]

Tue Oct 21 09:24:54 2008

• ERROR => W22 (pid 20127) died [dpxxdisp.c 12170]

Tue Oct 21 09:25:54 2008

• ERROR => W22 (pid 20130) died [dpxxdisp.c 12170]

Tue Oct 21 09:26:53 2008

• ERROR => W22 (pid 20136) died [dpxxdisp.c 12170]

Tue Oct 21 09:27:54 2008

• ERROR => W22 (pid 20144) died [dpxxdisp.c 12170]

Tue Oct 21 09:28:53 2008

• ERROR => W22 (pid 20149) died [dpxxdisp.c 12170]

Tue Oct 21 09:29:54 2008

• ERROR => W22 (pid 20154) died [dpxxdisp.c 12170]

Tue Oct 21 09:30:54 2008

• ERROR => W22 (pid 20166) died [dpxxdisp.c 12170]

Tue Oct 21 09:31:54 2008

• ERROR => W22 (pid 20175) died [dpxxdisp.c 12170]

Tue Oct 21 11:10:05 2008

• ERROR => W22 (pid 20610) died [dpxxdisp.c 12170]

Tue Oct 21 11:11:12 2008

• ERROR => W22 (pid 20613) died [dpxxdisp.c 12170]

Tue Oct 21 11:12:03 2008

• ERROR => W22 (pid 20616) died [dpxxdisp.c 12170]

Tue Oct 21 11:13:12 2008

• ERROR => W22 (pid 20619) died [dpxxdisp.c 12170]

Tue Oct 21 11:14:09 2008

• ERROR => W22 (pid 20624) died [dpxxdisp.c 12170]

Tue Oct 21 11:15:12 2008

• ERROR => W22 (pid 20627) died [dpxxdisp.c 12170

Please can any one help on this...

Thanks,

Balu..

[Former Member · Accepted solution]

Hi Balu,

I think you have problem with the new kernel.You can not upgrade your kernel from 46D to 640.

Regards

Ashok

[Former Member]

Hi,

This issue has been resolved by upgarding the kernel to 46D_EXT.

Thanks

[Former Member]

>I have upgraded the sap kernel from 46D to 640. My oracle version is 9.2.0.7 and OS is SUN SPARC 10.

which note number you are following to perform the kernel upgrade? which R/3 version you have?

cheers,

-Sunil

[Former Member]

Please attach work process trace(dev_w0 or dev_w1....)

Raj

Edited by: Raj on Oct 22, 2008 11:46 AM

[Former Member]

Hi Balu,

dev_disp file is not sufficient to figure out the problem. Please attach dev_w0 or w1 trace files.

However if you see the attached log it shows two errors:

ERROR => ORA-904 occured when executing SQL statement (parse error offset = 7)

***Error in abrtm.c: DB-Error 32 opening table SRTM_ACT

ORA-904 occurs when requested column doesnt exist. but we cannot conclude anything at this stage unless we analysed wp trace files.

Thanks,

Kiran.