JR50863: RUNNING A MIGRATED PROCESS INSTANCE CAUSES A CWLLG0181E TO BE LOGGED WITH A TeamWorksRuntimeException

Version 8.5 Refresh Pack 6 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• When you migrate from IBM Business Process Manager V8.5.0.0, and
  a process applica-tion contains instances, an exception such as
   the following can occur when the instances are run after the
  migration:
  
  CWLLG0181E: The following error occurred in the 1,476 task:
  Runtime error in script ("Process: 'Update All SLA Statuses'
  ProcessItem: 'Update Statuses' Type: 'ITEM'" 1:0).Internal
  Script error:
  com.lombardisoftware.core.TeamWorksRuntimeException:
  com.lombardisoftware.client.delegate.BusinessDelegateException:
  PreparedStatement-Callback; uncategorized SQLException for SQL
  [select reference_id, dep_path_id, tar-get_type, target_id,
  target_summary_data from lsw_po_reference where branch_id = ?
  and start_seq_num <= ? and end_seq_num > ?]; SQL state [null];
  error code [-4470]; [jcc][t4][10120][10898][4.11.69] Invalid
  operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null;
  nested exception is com.ibm.db2.jcc.am.SqlException:
  [jcc][t4][10120][10898][4.11.69] Invalid operation: result set
  is closed. ERRORCODE=-4470, SQLSTATE=null
  Script (line 1):
  <B>   1 :
  Packages.com.lombardisoftware.core.sla.SLATracking.updateAllSLAs
  ();</B>
  
  t<B>   1 :
  Packages.com.lombardisoftware.core.sla.SLAT6updateAllSLAs();</B>
  
  
  at
  com.lombardisoftware.client.delegate.BusinessDelegateException.a
  sBusinessDelegateException(BusinessDelegateException.java:46)
  at
  com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
  per.doAsCurrentSubjectContextSensitive(WebsphereDelegateHelper.j
  ava:199)
  at
  com.lombardisoftware.client.delegate.EventMgrDelegateDefault.exe
  cuteUCA(EventMgrDelegateDefault.java:153)
  at
  com.lombardisoftware.server.scheduler.tasks.UcaExecutorTask.exec
  ute(UcaExecutorTask.java:39)
  at
  com.lombardisoftware.server.scheduler.Engine.execute(Engine.java
  :918)
  at
  com.lombardisoftware.server.scheduler.Engine.executeThreadTasks(
  Engine.java:643)
  at
  com.lombardisoftware.server.scheduler.Engine$1.run(Engine.java:5
  90)
  at
  com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
  per$3$1.run(WebsphereDelegateHelper.java:100)
  at
  java.security.AccessController.doPrivileged(AccessController.jav
  a:362)
  at javax.security.auth.Subject.doAs(Subject.java:573)
  at
  com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:19
  5)
  at
  com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:15
  2)
  at
  com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
  per.doAs(WebsphereDelegateHelper.java:172)
  at
  com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
  per$3.run(WebsphereDelegateHelper.java:96)
  at
  com.lombardisoftware.server.scheduler.ThreadPool$MyWork.run(Thre
  adPool.java:296)
  at
  com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java
  :269)
  at
  java.security.AccessController.doPrivileged(AccessController.jav
  a:298)
  at javax.security.auth.Subject.doAs(Subject.java:495)
  at
  com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:13
  2)
  at
  com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:90
  )
  at
  com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.jav
  a:336)
  at
  java.security.AccessController.doPrivileged(AccessController.jav
  a:327)
  at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:804)
  at
  com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithE
  xecutionContextImpl.java:222)
  at
  com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:20
  6)
  at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864)
  Caused by: com.lombardisoftware.core.TeamWorksException: Runtime
  error in script ("Process: 'Update All SLA Statuses'
  ProcessItem: 'Update Statuses' Type: 'ITEM'" 1:0).Internal
  Script error:
  com.lombardisoftware.core.TeamWorksRuntimeException:
  com.lombardisoftware.client.delegate.BusinessDelegateException:
  PreparedStatement-Callback; uncategorized SQLException for SQL
  [select reference_id, dep_path_id, tar-get_type, target_id,
  target_summary_data from lsw_po_reference where branch_id = ?
  and start_seq_num <= ? and end_seq_num > ?]; SQL state [null];
  error code [-4470]; [jcc][t4][10120][10898][4.11.69] Invalid
  operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null;
  nested exception is com.ibm.db2.jcc.am.SqlException:
  [jcc][t4][10120][10898][4.11.69] Invalid operation: result set
  is closed. ERRORCODE=-4470, SQLSTATE=null
  Script (line 1):
  <B>   1 :
  Packages.com.lombardisoftware.core.sla.SLATracking.updateAllSLAs
  ();</B>
  
  
  PRODUCTS AFFECTED:
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  

Local fix

Problem summary

• First time running upon server startup caused transaction to
  close before data is completely read from database.
  

Problem conclusion

• A fix is available for IBM BPM V8.5.5.0 that ensures an explicit
   transaction would be used.  Transaction would only be closed
  after data is completely read from database.
  
  
  On Fix Central (http://www.ibm.com/support/fixcentral), and
  search for JR50863:
  
  1. Select IBM Business Process Manager with your edition from
  the product selec-tor, the installed version to the fix pack
  level, and your platform, and then click Continue.
  2. Select APAR or SPR, enter JR50863, and click Continue.
  
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

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

• R855 PSY

     UP