A fix is available
APAR status
Closed as program error.
Error description
Databases with large number of persistant object versions (LSW_PO_VERSIONS table) increases the time to export an application. Large appications may take a very long time to export. The export will either fail or file for download is incomplete and truncated. You may see hung thread messages like [8/28/13 11:40:22:740 CDT] 0000001d ThreadMonitor W WSVR0605W: Thread "WebContainer : 6" (00000034) has been active for 681669 mill iseconds and may be hung. There is/are 1 thread(s) in total in the server that may be hung. at com.ibm.bpm.pal.capability.ServerImpl.getContainerCapability(Ser verImpl.java:201) at com.ibm.bpm.pal.action.BaseActionsImpl.getStateAndPossibleAction s(BaseActionsImpl.java:107) The call findByPrimaryKeys used in com.lombardisoftware.expimp.ExportImportManager.export(PackageDe scriptor,ExportImportPackageWriter,VersioningContext) was changed to use the method in the persistance layer.
Local fix
partial work arounds 1) adding additional indexes to LSW_PO_VERIONS table CREATE INDEX IDXA_PO_VERSIONS ON lsw_po_versions (PO_TYPE,BRANCH_ID,START_SEQ_NUM,END_SEQ_NUM,PO_VERSION_ID) COMPUTE STATISTICS; CREATE INDEX IDXB_PO_VERSIONS ON lsw_po_versions (BRANCH_ID,END_SEQ_NUM)COMPUTE STATISTICS; CREATE INDEX IDXC_PO_VERSIONS ON lsw_po_versions (BRANCH_ID,START_SEQ_NUM,END_SEQ_NUM) COMPUTE STATISTICS; CREATE INDEX IDXD_PO_VERSIONS ON lsw_po_versions (BRANCH_ID,END_SEQ_NUM,PO_TYPE,PO_ID) COMPUTE STATISTICS; CREATE INDEX IDXE_PO_VERSIONS ON lsw_po_versions (PO_VERSION_ID,PO_TYPE,BRANCH_ID,START_SEQ_NUM,END_SEQ_NUM) COMPUTE STATISTICS; 2) tune database to work with larger data sets. Increase the default buffers for the database memory.
Problem summary
**************************************************************** * USERS AFFECTED: Users with large process applicatons. * **************************************************************** * PROBLEM DESCRIPTION: Databases with large number of * * persistant object versions increases * * the time to export an application. * * Large appications may take a very * * long time to ‚  export. The export will * either fail or file for download is * * incomplete and truncated. ‚   **************************************************************** * RECOMMENDATION: * **************************************************************** Exporting large applications takes a long time and may not complete.
Problem conclusion
The algorithm has been optimized to reduce the number of queries to database. The ifix is available on BPM v7.5.1.1. The ifix file can be downloaded from Fix Central along with the ifix installation instruction.
Temporary fix
Comments
APAR Information
APAR number
JR47667
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-09-02
Closed date
2013-09-25
Last modified date
2015-03-02
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
R750 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
11 October 2021