IBM Support

JR47667: EXPORTING LARGE APPLICATIONS TAKES A LONG TIME AND MAY NOT COMPLETE IF THERE ARE MANY ROWS IN LSW_PO_VERSIONS TABLE

Subscribe

You can track all active APARs for this component.

 

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