JR47677: PERFORMANCE IMPROVEMENTS FOR TASK SEARCH

Version 7.5.1 Fix Pack 2 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• This APAR improves the execution performance of task searches in
  BPM.
  This affects Saved Searches, the task search in Process Portal
  and the default inbox.
  .
  [8/23/13 5:23:54:243 HKT] 00000003 ThreadMonitor W WSVR0605W:
  Thread
  "WebContainer : 38" (00014af0) has been active for 773533
  milliseconds
  and may be hung. There is/are 58 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 oracle.net.ns.Packet.receive(Packet.java:283)
  at oracle.net.ns.DataPacket.receive(DataPacket.java:103)
  at
  oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:2
  30)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
  at
  oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4
  CSocketInputStreamWrapper.java:119)
  at
  oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInp
  utStreamWrapper.java:79)
  at
  oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1
  122)
  at
  oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1
  099)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
  at
  oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  at
  oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.
  java:852)
  at
  oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleSt
  atement.java:1153)
  at
  oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
  atement.java:1275)
  at
  oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.
  java:1477)
  .--------------------------------------------------
  .
  slow query:
  
  select i.bpd_instance_id as instanceId, i.instance_name as
  instanceName,
   bpd.name as bpdName, istatus.name as instanceStatus,
         t.subject as taskSubject, tpriority.name as
  taskPriority, t.due_d
         t.attached_ext_activity_ref as
  taskAttachedExtActivityRef, t.task
         tpriority.ranking as taskPriorityRanking
  from lsw_task t inner join
         lsw_bpd_instance i on t.bpd_instance_id =
  i.bpd_instance_id
         left join lsw_task_status_codes tstatus on t.status =
  tstatus.sta
         left join lsw_bpd_status_codes istatus on
  i.execution_status = is
         left join lsw_priority tpriority on t.priority_id =
  tpriority.pri
         left join lsw_bpd bpd on i.cached_bpd_version_id =
  bpd.version_id
         left join lsw_usr_xref tuser on t.user_id =
  tuser.user_id
         inner join lsw_bpd_instance_vars_pivot vp on
  vp.bpd_instance_id=i
  where ( UPPER(tstatus.name) = UPPER('Closed')
          AND ( t.user_id = 8111 OR t.task_id in
          ( select t.task_id
           from lsw_task t
               inner join lsw_usr_grp_mem_xref m on t.group_id =
  m.group_i
           where m.user_id = 8111
               and t.user_id = -1 )
               OR t.task_id in ( select t.task_id
                                 from lsw_task t
                                 inner join
  lsw_grp_grp_mem_exploded_xref
                                 inner join lsw_usr_grp_mem_xref
  m on m.gr
                                 where m.user_id = 8111 and
  t.user_id = -1
         ) order by taskDueDate, taskPriorityRanking, instanceId,
  taskId
  

Local fix

Problem summary

• Performance improvements for Task Search
  
  
  This affects Saved Searches, the task search in Process Portal
  and the default
  inbox.
  

Problem conclusion

• This interim fix improves the execution performance of task
  searches in BPM.
  
  FIX AVAILABILITY:
  iFix for 7.5.1.0 is available on Fix Central, search for APAR
  JR47677 at http://www.ibm.com/support/fixcentral/
  iFix for 7.5.1.1 is available on Fix Central, search for APAR
  JR47677 at http://www.ibm.com/support/fixcentral/
  iFix for 8.0.0.0 is available on Fix Central, search for APAR
  JR47677 at http://www.ibm.com/support/fixcentral/
  Fix is also targetted for inclusion in next fixpack for BPM
  V7.5.1
  
  When obtaining any of the above fixes, be sure to download the
  accompanying readme, for itself, and any prerequisite fixes, and
  review them thorougly.
  

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

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R751 PSY

     UP

• R800 PSY

     UP