Products | Versions |
---|---|
TIBCO BusinessWorks Collaborator | - |
Not Applicable | - |
Description:
Symptoms
========
When TIBCO BWC 5.3 (IC 7.2) is used with Oracle 10.2.0.2 (with patch for bug 5116440), it MAY result in IcWorker hanging. When running a BWC application, one of the IcWorkers could hang (i.e. does not return from) the following statement: "delete from TASK_DEPENDENCIES where PARENT_ID in (select PARENT_ID from TASKS where JOB_ID=:b0)". Subsequently all other workers queue behind that IcWorker's unrelesed lock until the BWC server stalls completely.
Impact
======
TIBCO BWC server could stall completely in some cases.
Workaround
==========
This problem occurs ONLY if you have installed the Oracle patch for bug 5116440. If you have NOT installed the patch for bug 5116440 on Oracle 10.2.0.2 then you will NOT see this problem.
If you have installed the Oracle patch 5116440, please do the following -
Remove the patch for bug 5116440 and install the new merge bug fix Merge 5722731 on top of 10.2.0.2 for Bug 5667683 Bug 4722645 Bug 4712638
Cause
=====
Oracle Statistics job seems to have a strong involvement in this problem. When the job runs concurrently with the BWC application, you will be able to reproduce the problem, not in a deterministic way, but say in about 80% of all test runs (Oracle says that the job should usually run at times where there is no or little application activity, but there is no guarantee that it will finish within that window).
Resolution
==========
Same as mentioned in the Workaround section above.
Symptoms:
Cause: