Home » 2011 » March » 29

Daily Archives: March 29, 2011

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


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.