IBM Support

JR50261: PROCESS INSPECTOR FAILS WITH LARGE NUMBER OF INSTANCES.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Process Inspector fails with large number of instances.
    .
    Process inspector results in a 500 error when concatenation
    optimization property is enabled and there are many running
    instances. Tne query fails with SQLCODE=-129 (too many table
    name in query) CWTBG0019E: Unexpected exception during execution
    .
    [6/6/14 13:40:50:866 EDT] 00000137 wle E CWLLG2229E: An
    exception occurred in an EJB call. Error:
    PreparedStatementCallback;
    SQL [SELECT *
    FROM (
    SELECT actualSearch.*, ROW_NUMBER() OVER ( order by
    instanceModifyDate
    desc, taskPriorityRanking, instanceId, taskDueDate, taskId ) AS
    search_result_row_idx
    FROM (
    select *
     from (select i.instance_name as instanceName,
    t.bpd_instance_id as
    instanceId, bpd.name as bpdName, i.due_date as instanceDueDate,
    i.create_datetime as instanceCreateDate,
    i.last_modified_datetime as
    instanceModifyDate, istatus.name as instanceStatus,
    iprj.short_name as
    instanceProcessApp, tuser.user_name as assignedToUser,
    trole.group_name
    as assignedToRole, tstatus.name as taskStatus, t.subject as
    taskSubject, t.activity_name as taskActivityName, t.due_date as
    taskDueDate, tpriority.name as taskPriority, t.rcvd_datetime as
    taskReceivedDate, t.close_datetime as taskClosedDate,
    t.sent_datetime
    as taskSentTime, t.read_datetime as taskReadTime,
    treceivedUser.user_name as taskReceivedFrom,
    tclosedUser.user_name as
    taskClosedBy, t.task_id as taskId, t.attached_form_ref as
    taskAttachedInfoPathFormRef, t.attached_ext_activity_ref as
    taskAttachedExtActivityRef, cbb.bpd_id as taskCreatedByBpdId,
    t.created_by_bpd_flow_object_id as taskCreatedByBpdFlowObjectId,
    tpriority.ranking as taskPriorityRanking
     from lsw_task t
    left join lsw_bpd_instance i on t.bpd_instance_id =
    i.bpd_instance_id
    left join lsw_task_status_codes tstatus on t.status =
    tstatus.status_value
    ...
    ) unionedSearch
    ) actualSearch
    ) searchWithRowIdx
    WHERE search_result_row_idx <= ?
     order by instanceModifyDate desc, taskPriorityRanking,
    instanceId,
    taskDueDate, taskId
      with UR ]; DB2 SQL Error: SQLCODE=-129, SQLSTATE=54004,
    SQLERRMC=null, DRIVER=4.11.69; nested exception is
    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-129,
    SQLSTATE=54004, SQLERRMC=null, DRIVER=4.11.69
     at
    com.lombardisoftware.client.delegate.BusinessDelegateException.a
    sBusines
    sDelegateException(BusinessDelegateException.java:46)
     at
    com.lombardisoftware.client.delegate.ProcessSearchAPIDelegateDef
    ault.exe
    cuteQuery(ProcessSearchAPIDelegateDefault.java:188)
     at
    com.lombardisoftware.server.ejb.psapi.SearchAPIFacadeCore.execut
    eSearchU
    nfiltered(SearchAPIFacadeCore.java:266)
    

Local fix

Problem summary

  • ABSTRACT ? PROCESS INSPECTOR FAILS WITH LARGE NUMBER OF
    INSTANCES.
    ERROR DESCRIPTION -
    When you query for process instances by using Process Inspector
    in the Process Admin Console, you might see the following error
    in the browser if a large number of process instances are
    returned:
    
    ?CWTBG0019E: Unexpected exception during execution.
    The error occurs  when the concatenation
    optimization property (<use-concatenation-optimization>) is
    enabled and there are many running instances. The query fails
    with SQLCODE=-129 (too many table
    name in query).
    
    
    
    
    
    
    
    PRODUCTS AFFECTED
    IBM Business Process Manager (BPM) Advanced
    IBM BPM Standard
    IBM BPM Express
    
    LOCAL FIX - N/A
    
    
    PROBLEM SUMMARY
    No additional information is available.
    

Problem conclusion

  • PROBLEM CONCLUSION ?
    A fix is available for IBM BPM v8.0.1.2 to prevent the database
    error from occurring by reducing the number of table joins in
    the SQL query.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR50261:
    1.Select IBM Business Process Manager with your edition from the
    product selector, the installed version to the fix pack level,
    and your platform, and then click Continue.
    2.Select APAR or SPR, enter JR50261, and click Continue.
    When you download fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR50261

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-15

  • Closed date

    2014-07-21

  • Last modified date

    2014-11-05

  • 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 ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
05 November 2014