Home » Article » SAP Kernel 6.40_EX2 on Oracle 11g problem solved !!

SAP Kernel 6.40_EX2 on Oracle 11g problem solved !!

Pages

March 2011
M T W T F S S
« Feb   Apr »
 123456
78910111213
14151617181920
21222324252627
28293031  

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Twitter Updates

Blog Stats

  • 346,176 hits

Archives

Pengunjung


Akhirnya ketemu juga solusinya…

Problemnya muncul saat ane upgrade ke Oracle 11g (dari Oracle 10g). Sebenarnya masalah sudah muncul sejak upgrade dari Oracle 9i. Work process (disp+work) sering tiba-tiba mati sendiri. Padahal saat itu udah pake SAP Kernel 6.40_EX2 (the latest one). Versi dw (disp+work) untuk work process nya adalah keluaran tanggal 5 maret 2011.

Disini terlihat log dev_w0 :

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

M Sat Mar 26 00:36:16 2011
M  in_ThErrHandle: 1
M  ThIErrHandle: new stat of W0 is WP_SHUTDOWN
M  ThIErrHandle: I’m during shutdown
M  PfStatDisconnect: disconnect statistics
M  Entering ThSetStatError
B  db_sqlbreak() = 1
M  ThIErrHandle: don’t try rollback again
M  ThShutDownServer: shutdown server
M  ThExecShutDown: perform exclusive shutdown actions
M  ThCheckComOrRb (event=1, full_commit=1)
M  ThCallHooks: call hook >ASTAT-collect commit handling< for event BEFORE_COMMIT
M  ThCallHooks: call hook >rsts_before_commit< for event BEFORE_COMMIT
M  SosSearchAnchor: search anchor for 10
M  SosSearchAnchor: invalid tid/mode T-1/M255
M  ThCheckComOrRb (event=3, full_commit=1)
M  ThCallHooks: call hook >ThVBICmRbHook< for event AFTER_COMMIT
M  ThVBICmRbHook: called for commit
M  ThCallHooks: call hook >ThNoClearPrevErr< for event AFTER_COMMIT
M  ThNoClearPrevErr: clear prev no err
M  ThCallHooks: call hook >rsts_after_commit< for event AFTER_COMMIT
M  SosSearchAnchor: search anchor for 10
M  SosSearchAnchor: invalid tid/mode T-1/M255
M  ThCallHooks: call hook >dyKeyTableRest< for event AFTER_COMMIT
M  ThCallHooks: call hook >SpoolHandleHook< for event AFTER_COMMIT
M  SosSearchAnchor: search anchor for 2
M  SosSearchAnchor: invalid tid/mode T-1/M255
M  ThUsrDelEntry (*, *, emaprd2_WPR_10      ) o.k.
M  ThICommit3: full commit, set time, keep resources, redispatch
M  ThICommit3: commit and keep resources
M  ThCheckComOrRb (event=1, full_commit=0)
M  ThCallHooks: call hook >ASTAT-collect commit handling< for event BEFORE_COMMIT
M  ThCallHooks: call hook >rsts_before_commit< for event BEFORE_COMMIT
M  SosSearchAnchor: search anchor for 10
M  SosSearchAnchor: invalid tid/mode T-1/M255
M  ThCheckComOrRb (event=3, full_commit=0)
M  ThCallHooks: call hook >ThVBICmRbHook< for event AFTER_COMMIT
M  ThVBICmRbHook: called for commit
M  ThCallHooks: call hook >ThNoClearPrevErr< for event AFTER_COMMIT
M  ThNoClearPrevErr: clear prev no err
M  ThCallHooks: call hook >rsts_after_commit< for event AFTER_COMMIT
M  SosSearchAnchor: search anchor for 10
M  SosSearchAnchor: invalid tid/mode T-1/M255
M  ThCallHooks: call hook >dyKeyTableRest< for event AFTER_COMMIT
M  ThCallHooks: call hook >SpoolHandleHook< for event AFTER_COMMIT
M  SosSearchAnchor: search anchor for 2
M  SosSearchAnchor: invalid tid/mode T-1/M255
M  ThAlarm: set alarm to 600 sec
M  ThICommit3 o.k.
M  ThExecShutDown: ThUsrDelEntry o.k.
M  ThExecShutDown: called rsau_log_system_stop
M  PfStatIndInit: Initializing Index-Record
M  PfWriteIntoFile: copied shared buf (0 bytes) to local buf
M  PfTimeFactor: new value: 25200
M  Entering ThReadDetachMode
M  call ThrShutDown (1)…
B  Disconnecting from ALL connections:
B  Wp  Hdl ConName                        ConId     ConState     TX  HC  PRM RCT FRC TIM MAX OPT Date     Time   DBHost
B  000 000 R/3                            000000000 INACTIVE     NO  NO  YES NO  NO  000 255 255 20110326 002910 emaprd2
C  Disconnecting from connection 0 …
C  Close user session (con_hdl=0,svchp=113176338,usrhp=1131b6f80)
C  Detaching from DB Server (con_hdl=0,svchp=113176338,srvhp=1131773e0)
C  Now connection 0 is disconnected
B  Disconnected from connection 0
B  statistics db_con_commit (com_total=107, com_tx=58)
B  statistics db_con_rollback (roll_total=1, roll_tx=0)
M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 336276) [dpuxtool.c   318]

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

Ane udah sempet nanya ke forum sdn.sap.com dan ke temen konsultan SAP Basis. Blom ada jawaban. Trus kemaren pas liat ke SAP Service Marketplace (http://service.sap.com), ternyata keluar update-an untuk dw (disp+work) per tanggal 25 Maret 2011. Coba download dan update dw-nya. Lalu coba jalankan proses kompresi seperti biasa. Ambil yang tabel yang besar-besar.

Eh, ternyata so far lancar. Proses dw bisa berjalan dengan lancar.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: