JR64319: SLOW SAVE DUE TO MANY LSW_PARAMETER_MAPPING QUERIES IN THE WEB IBM PROCESS DESIGNER

APAR status

• Closed as program error.

Error description

• When you try to save in Process designer, you might experience a
  slow save leading to a warning message, such as the "Saving
  Editors".
  
  If you turn on
  'WLE.wle_webpd.scheduler.sql=all:WLE.wle_bpmrest.sql=all'
  traces, you might see duplicates SQL calls with the same
  parameters during one save against the lsw_parameter_mapping
  table, such as in this example:
  
  [10/25/21 13:49:51:992 UTC] 000000d9 sql           1   spent:
  1138 --- select
  PARAMETER_MAPPING_ID,VERSION_ID,PARENT_TYPE,GUID,NAME,DESCRIPTIO
  N,LAST_MODIFIED,PROCESS_PARAMETER_ID,PARENT_ID,LAST_MODIFIED_BY_
  USER_ID,CLASS_REF,VALUE,USE_DEFAULT,IS_LIST,IS_INPUT from
  LSW_PARAMETER_MAPPING where PARENT_ID in (?) and PARENT_TYPE=3
  and version_id in (select po_version_id from lsw_po_versions
  where po_type = ? and branch_id = ? and start_seq_num <= ? and
  end_seq_num > ?) args: 0ae98ba3-ecb0-40d7-acc7-052a92c47777,
  2054,  868cd62a-9464-436e-9f52-c8d18fc81e08,  452608,  452608
  [10/25/21 13:49:53:417 UTC] 000000d9 sql           1   spent:
  1019 --- select
  PARAMETER_MAPPING_ID,VERSION_ID,PARENT_TYPE,GUID,NAME,DESCRIPTIO
  N,LAST_MODIFIED,PROCESS_PARAMETER_ID,PARENT_ID,LAST_MODIFIED_BY_
  USER_ID,CLASS_REF,VALUE,USE_DEFAULT,IS_LIST,IS_INPUT from
  LSW_PARAMETER_MAPPING where PARENT_ID in (?) and PARENT_TYPE=3
  and version_id in (select po_version_id from lsw_po_versions
  where po_type = ? and branch_id = ? and start_seq_num <= ? and
  end_seq_num > ?) args: 0ae98ba3-ecb0-40d7-acc7-052a92c47777,
  2054,  868cd62a-9464-436e-9f52-c8d18fc81e08,  452608,  452608
  [10/25/21 13:49:54:734 UTC] 000000d9 sql           1   spent:
  1065 --- select
  PARAMETER_MAPPING_ID,VERSION_ID,PARENT_TYPE,GUID,NAME,DESCRIPTIO
  N,LAST_MODIFIED,PROCESS_PARAMETER_ID,PARENT_ID,LAST_MODIFIED_BY_
  USER_ID,CLASS_REF,VALUE,USE_DEFAULT,IS_LIST,IS_INPUT from
  LSW_PARAMETER_MAPPING where PARENT_ID in (?) and PARENT_TYPE=3
  and version_id in (select po_version_id from lsw_po_versions
  where po_type = ? and branch_id = ? and start_seq_num <= ? and
  end_seq_num > ?) args: 0ae98ba3-ecb0-40d7-acc7-052a92c47777,
  2054,  868cd62a-9464-436e-9f52-c8d18fc81e08,  452608,  452608
  

Local fix

• -Remove as much data as possible from the database by running
  the BPMSnapshotCleanup command
  (https://www.ibm.com/docs/en/baw/20.x?topic=scripting-bpmsnapsho
  tcleanup) or unnamed snapshot cleanup service (Link:
  https://www.ibm.com/docs/en/baw/20.x?topic=snapshots-deleting-un
  named-automated-method).
  

Problem summary

• No additional information is available.
  
  PRODUCT AFFECTED:
  IBM Business Automation Workflow
  IBM Cloud Pak for Business Automation
  

Problem conclusion

• A fix is available or will be available that improves save
  operation by cache many queries related to
  Lsw_parameter_mapping.
  

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