My Oracle Support Banner

Robustness Problems With CC&B (Doc ID 1386535.1)

Last updated on DECEMBER 05, 2018

Applies to:

Oracle Utilities Framework - Version 2.2.0 and later
Information in this document applies to any platform.

Goal

Sometimes a JVM of the coherence cluster is frozen whilst all of its applicative threads can be ok (as we can see in the table CI_BATCH_THD & CI_BATCH_RUN).
Several submitters are then on hold waiting for this threadpoolworker to update the status of their threads.

So when the threadpoolworker freeze the DB is not updated with the COHERENCE_CACHE.

We need to get a manner to keep in sync the database information (on BATCH_THD & CI_BATCH_RUN tables) with the data in the COHERENCE CACHE in the TPW.

There should be a way to have a recovery script/process that :
checks the status of the applicative threads in the database (CI_BATCH_RUN & _THD) and
updates the status of the threads in the coherence cluster accordingly so
the submitters can be released correctly.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.