JR41577: CMVC 213576 - MOVE CHANGE LIST OUT OF TASK GROUP COMMIT.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• When a business user approves a task group in a workspace, the
  TaskGroupCommitCmd is executed and may run for a long time and
  appear hung when a large amount of data exists in the task
  group.   Customers may experience transaction timeouts or full
  database transaction logs that could result in exceptions such
  as the following in SystemOut.log:
  [21/12/11 10:02:48:117 EST] 00000014 ThreadMonitor W
  WSVR0605W: Thread "WorkManager.default : 0" (00000025) has been
  active for 1812625 milliseconds and may be hung.  There is/are 1
  thread(s) in total in the server that may be hung.
   at java.net.SocketInputStream.socketRead0(Native Method)
   at java.net.SocketInputStream.read(SocketInputStream.java:140)
   at com.ibm.db2.jcc.t4.z.b(z.java:199)
   at com.ibm.db2.jcc.t4.z.c(z.java:289)
   at com.ibm.db2.jcc.t4.z.c(z.java:402)
   at com.ibm.db2.jcc.t4.z.v(z.java:1170)
   at com.ibm.db2.jcc.t4.cb.a(cb.java:61)
   at com.ibm.db2.jcc.t4.q.a(q.java:50)
   at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
   at com.ibm.db2.jcc.am.go.oc(go.java)
   at com.ibm.db2.jcc.am.go.b(go.java:4379)
   at com.ibm.db2.jcc.am.go.gc(go.java:782)
   at com.ibm.db2.jcc.am.go.executeUpdate(go.java:761)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(
  WSJdbcPreparedStatement.java:810)
   at
  com.ibm.commerce.foundation.internal.server.services.changehisto
  ry.utility.ChangeHistoryUtility.executeParameterizedUpdate(Chang
  eHistoryUtility.java:948)
   at
  com.ibm.commerce.foundation.internal.server.services.changehisto
  ry.utility.ChangeHistoryUtility.commitTaskGroupChangeHistory(Cha
  ngeHistoryUtility.java:882)
   at
  com.ibm.commerce.foundation.internal.server.services.changehisto
  ry.utility.ChangeHistoryUtilityHelper.commitTaskGroupChangeHisto
  ry(ChangeHistoryUtilityHelper.java:451)
   at
  com.ibm.commerce.context.content.resources.ResourceContentEventL
  istener.processActivityEvent(ResourceContentEventListener.java:1
  04)
  

Local fix

• If this problem occurs, the customer can complete the approval
  by removing the records in the CMPRMYOBJ table corresponding to
  the task group and retry the approval.  For example: DELETE from
  CMPRMYOBJ where TASKGRP=?
  where the TASKGRP is the identifier of the task group being
  approved ( i.e. G_???? )
  

Problem summary

• USERS AFFECTED:
  All WebSphere Commerce users on V7 with feature pack 3 enabled
  and are using workspaces functionality.
  
  PROBLEM ABSTRACT:
  Updates to change history data cause performance decline when
  committing large size of data in Workspace.
  
  BUSINESS IMPACT:
  The approval of the task group may take a long time to complete
  or fail after timing out.
  
  RECOMMENDATION:
  

Problem conclusion

• The additional processing to remove the records from CMPRMYOBJ
  was moved from the TaskGroupCommitCmd and moved to the
  TaskGroupCleanupCmd which is run in a different scheduler job.
  The processing was also modified to remove the objects with a
  single SQL update instead of multiple SQL updates.
  
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP