Direct links to fixes
Version 8.5 Refresh Pack 5 for the IBM Business Process Manager products
Download Version 8.0.1 Fix Pack 3 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products
Closed as program error.
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)
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 ? A fix is available for IBM BPM v220.127.116.11 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.
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels
05 November 2014