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 number
JR64319
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
K00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-11-01
Closed date
2022-04-01
Last modified date
2022-04-01
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
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0.0.1"}]
Document Information
Modified date:
02 April 2022