JR63570: DELETING A TERMINATED PROCESS INSTANCE FROM PROCESS INSPECTOR THAT HAS DOCUMENTS ATTACHED WILL CAUSE HUNG THREADS

workflow.2102.delta.repository

APAR status

• Closed as program error.

Error description

• When you delete a process instance with documents (in external
  CPE) attached, instance deletion thread will hang due to
  deadlock, following sample stack trace will show in logs:
  ThreadMonitor W   WSVR0605W: Thread "WebContainer : 1"
  (00000131) has been active for 178,883 milliseconds and may be
  hung.  There is/are 2 thread(s) in total in the server that may
  be hung.
      at java.net.SocketInputStream.socketRead0(Native Method)
  ...
      at
  sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpU
  RLConnection.java:1510)
      at
  com.ibm.net.ssl.www2.protocol.https.b.getInputStream(b.java:60)
      at
  com.filenet.apiimpl.wsi.ServiceSessionNst.cGetAppropriateRespons
  eStream(ServiceSessionNst.java:760)
  ...
      at
  com.filenet.api.core.UpdatingBatch.updateBatch(UpdatingBatch.jav
  a:168)
  ...
      at
  com.ibm.bpm.embeddedecm.internal.EmbeddedECMInternalUtils.delete
  DocumentsForProcessInstance(EmbeddedECMInternalUtils.java:770)
      at
  com.ibm.bpm.embeddedecm.EmbeddedECMUtils.deleteDocumentsForProce
  ssInstance(EmbeddedECMUtils.java:74)
      at
  com.lombardisoftware.server.ejb.api.BPDInstanceDocumentAPICore.d
  eleteAllDocsWithProcessId(BPDInstanceDocumentAPICore.java:1162)
      at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.delete(BP
  DInstanceDAO.java:692)
  ...
      at
  com.lombardisoftware.bpd.runtime.engine.util.LockBPDInstanceComm
  and.execute(LockBPDInstanceCommand.java:90)
      at
  com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.delete
  Instance(BPDEngineServicesCore.java:1867)
      at
  com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.delete
  Instance(BPDEngineServicesCore.java:1843)
  ...
      at
  com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo
  rt.executeInNewTransaction(ProgrammaticTransactionSupport.java:5
  37)
  ...
      at
  com.lombardisoftware.client.delegate.BPDEngineServicesDelegateDe
  fault.deleteInstance(BPDEngineServicesDelegateDefault.java:782)
      at
  com.ibm.bpm.rest.impl.process.DeleteActionHandler.handleAction(D
  eleteActionHandler.java:100)
      at
  com.ibm.bpm.rest.impl.process.BusinessProcessDefinitionResource.
  processBPDAction(BusinessProcessDefinitionResource.java:679)
      at
  com.ibm.bpm.rest.impl.process.BusinessProcessDefinitionResource.
  processBulkBPDAction(BusinessProcessDefinitionResource.java:1313
  )
  
  [4/15/21 15:42:41:828 UTC] 00000087 ThreadMonitor W   WSVR0605W:
  Thread "WebContainer : 0" (00000130) has been active for 177,109
  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 com.ibm.db2.jcc.am.k5.executeUpdate(k5.java:801)
      at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpda
  te(WSJdbcPreparedStatement.java:1296)
  ...
      at
  com.lombardisoftware.server.ejb.persistence.dao.ECMObjectDAO.del
  eteBPMDocumentReferencesByVersionSeriesId(ECMObjectDAO.java:167)
      at
  com.ibm.bpm.integration.runtime.managedfolder.BPMDocumentsHelper
  .onBpmDocumentDeleted(BPMDocumentsHelper.java:173)
      at
  com.ibm.bpm.rest.impl.event.ECMEventResource.onVersionSeriesDele
  ted(ECMEventResource.java:157)
  
  PRODUCTS AFFECTED
  IBM Business Automation Workflow
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that prevents the
  deadlock issue when deleting a process instance with attached
  documents in external CPE.
  

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

  BUS AUTO WORKFL

• Fixed component ID

  5737H4100

Applicable component levels