Possible Product Issue In Realtime With ActiveMQ (Doc ID 2139335.1)

Last updated on MAY 20, 2016

Applies to:

Oracle Watchlist Screening - Version 11.1.1.7.3 and later
Information in this document applies to any platform.
EDQ Version: 11.1.1.7.4
OWS version 11.1.1.7.3
Platform and Version: Tomcat: 6.0
Java Version: jdk1.7.0_79 / jre7

Symptoms

In the real-time screening process, messages are not being cleared on the hub server message queue after being passed across from the filter server. This only applies in limited circumstances, such as when messages are sent by the filter server while the web service process is not running on the hub server. The queue size becomes greater than zero when the process starts on the hub and remains at this size, or grows if more requests are received, and is not cleared. The effect of this is to cause this information to be re-screened each time the job is restarted This is causing unnecessary review flags where Watchlist data changes for any of these records.

The content of the messages on the queue appears to be irrelevant as long as they are well-formed within the defined data types, hence the supplied process to generate simple messages to send across the queue is sufficient for recreating the issue. A ‘real’ message format can be supplied, if required.

When messages are passed between the filter and hub servers when the receiving hub process is running and the initial queue size is zero, the behavior is correct where the queue size remains zero as new messages are received and processed and removed automatically. Note, however, that this is not an acceptable workaround as outputs are required for real-time reporting.

Modifying the real-time process to remove the groups spigot connections and deleting the two group and merge processors restores the correct behavior regarding the queue. Messages are cleared appropriately. However, if the group and merge processors are merely disconnected but not deleted, the incorrect behavior persists.

Running the real time process with one line of data per input data feed, via the supplied reference data mappings, causes the correct behavior.

One exemplary scenario of this behavior when running a real-time process with full volume (~45k+ records) is with the Dow Jones input files, which causes the incorrect behavior. (You should be able to generate these input files by running the OWS Watchlist Management project to prepare sanctions records and pointing the DJW Entities SAN and DJW Individuals SAN snapshots at the produced .jmp files.)

Changes

 The issue appears to be present whether or not patch 21312966 is installed. Even after attempting to rollback using OPatch and redeploy, the problem persists.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms