Direct links to fixes
APAR status
Closed as program error.
Error description
If you encounter a problem while you are indexing tasks for a full text search, you might see many queries repeated in the database. For example, you might see SELECT t.task_id, t.user_id, t.group_id, t.subject, t.bpd_instance_id, t.status, t.snapshot_id, i.instance_name, i.cached_bpd_version_id FROM lsw_task t, lsw_bpd_instance i WHERE t.bpd_instance_id = i.bpd_instance_id AND t.task_id = ? WITH ur You also might not get as many results from task searches in IBM Process Portal as you expect. The cause of this issue is not obvious from the log files. PRODUCTS AFFECTED: IBM Business Process Manager (BPM) Advanced IBM BPM Standard IBM BPM Express
Local fix
Problem summary
When an error occurs while you are indexing the tasks for a full text search, the exception may not be caught, which causes the indexing process to continuously retry and many database queries to return.
Problem conclusion
A fix is available for IBM BPM V8.0.1.1, V8.0.1.2, and V8.5.0.1 that extends the error handling of the task search indexing process and enhances the trace capabilities. As a result, you receive better information that you can use for problem determination in the event of a failure. The errors are written to the system log files, and a maximum of three attempts occur. After the three attempts, you must correct the underlying error and restart the server before resuming the indexing process. On Fix Central (http://www.ibm.com/support/fixcentral), search for JR49509: 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 JR49509, 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
Not applicable
Comments
APAR Information
APAR number
JR49509
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-02-28
Closed date
2014-05-02
Last modified date
2014-12-20
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 October 2021