JR65020: AN OBJECTNOTFOUNDEXCEPTION IS ENCOUNTERED WHILE RUNNING THE BPMUPDATESYSTEMAPP COMMAND DURING UPGRADE

workflow.2202.delta.repository
8.6.30021030-WS-BPM-IFJR65020
workflow.21031.delta.repository

APAR status

• Closed as program error.

Error description

• BPMUpdateSystemApp command fails during an upgrade.
  
  You may see the following stack trace in the
  BPMUpdateSystemApp_<date_time>.log file.
  . . .
  Caused by:
  com.lombardisoftware.client.persistence.common.ObjectNotFoundExc
  eption: Snapshot.094d85e2-0a68-4b11-b4de-4306887b9dce
      at
  com.lombardisoftware.client.persistence.common.versioning.Versio
  ningContext$Snapshot.getBranchId(VersioningContext.java:321)
      at
  com.lombardisoftware.server.ejb.persistence.versioning.BranchMan
  ager.readAccess(BranchManager.java:269)
      at
  com.lombardisoftware.server.ejb.persistence.versioning.BranchMan
  ager.readAccess(BranchManager.java:195)
      at
  com.lombardisoftware.client.persistence.common.versioning.Refere
  nceHelper.getVersionSummary(ReferenceHelper.java:1014)
      at
  com.lombardisoftware.client.persistence.common.versioning.Refere
  nceHelper.access$200(ReferenceHelper.java:72)
      at
  com.lombardisoftware.client.persistence.common.versioning.Refere
  nceHelper$18.getSummary(ReferenceHelper.java:897)
      at
  com.lombardisoftware.client.persistence.common.versioning.Refere
  nceHelper$20.call(ReferenceHelper.java:971)
      at
  com.lombardisoftware.client.persistence.common.versioning.Refere
  nceHelper$20.call(ReferenceHelper.java:968)
      at
  com.lombardisoftware.client.persistence.common.versioning.Refere
  nceHelper.breadthFirstSearch(ReferenceHelper.java:1003)
      at
  com.lombardisoftware.client.persistence.common.versioning.Refere
  nceHelper.breadthFirstIdSearch(ReferenceHelper.java:894)
      at
  com.lombardisoftware.server.ejb.repositoryservices.SystemAppUpda
  teSupport.fixExistingBPDInstances(SystemAppUpdateSupport.java:44
  3)
      at
  com.lombardisoftware.server.ejb.repositoryservices.RepositorySer
  vicesCore.fixExistingBPDInstances(RepositoryServicesCore.java:18
  97)
      . . .
  
  PRODUCTS AFFECTED
  IBM Business Automation Workflow
  IBM Cloud Pak for Business Automation
  

Local fix

• 1. Rollback the upgrade.
  2. Delete any process instances named
  PerformanceMonitoringProcess
  3. Perform the upgrade again.
  
  More details for step 2.
  ================
  Execute the following steps to fix the orphaned instance, then
  run BPMProcessInstancesPurge command to remove the updated
  instance.
  
  Step 1: Find out the cached_bpd_version_id and snapshot_id
  select bpd.NAME, bpd.VERSION_ID as CACHED_BPD_VERSION_ID,
  snap.SNAPSHOT_ID
  from lsw_snapshot snap
  inner join lsw_po_versions ver ON (snap.BRANCH_ID =
  ver.BRANCH_ID AND ver.start_seq_num <= snap.seq_num AND
  ver.end_seq_num > snap.seq_num and ver.PO_TYPE=25)
  INNER JOIN lsw_bpd bpd on ver.PO_VERSION_ID = bpd.VERSION_ID
  where bpd.NAME = 'PerformanceMonitoringProcess' and
  snap.SNAPSHOT_ID='38765742-733e-4a31-8f0f-f6192543c50d';
  
  Step 2: Backup the cached_bpd_version_id and snapshot_id
  (replace the BPD_INSTANCE_ID with actual id)
  select *
  from lsw_bpd_instance ins
  where ins.BPD_INSTANCE_ID = '19199'
  
  Step 3: Update the to be removed instance (replace the
  BPD_INSTANCE_ID with actual id)
  update lsw_bpd_instance ins
  set ins.CACHED_BPD_VERSION_ID = '<CACHED_BPD_VERSION_ID from
  Step 1>', ins.SNAPSHOT_ID = '<SNAPSHOT_ID from Step 1>'
  where bpd_instance_id='19199'
  

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that supersedes
  JR64875,JR64874,JR64797 & updates the orphaned instance of
  Performance Dashboard process application to the latest
  snapshot.
  

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