E-IB: Asynchronous Services Unresponsive or Stalling when Huge Amounts of Integration Broker Transactions Data Accumulate or Data Get Corrupted (Doc ID 1917465.1)

Last updated on APRIL 13, 2023

Applies to:

*** Latest revision: 12-Jul-2016 ***

Symptoms

Integration Broker setup is in place and messaging service operation flow works, but some Service Operation Monitor paths become very slow or completely unresponsive.
In particular, Monitor Overview does work, but non-filtered view of Operation Instances do not fetch results, and from a filtered view drilling into Sub Queue Link hangs, too.
Monitor Overview shows transactions of different service operations with different transaction counters, with the estimated total being over a million or more transactions.

Replication Steps for Unresponsive Monitor Scenario:
1. Navigate People Tools > Integration Broker > Service Operations Monitor > Monitoring; Asynchronous Services
2. Switch to tab Operations Instances
3. Wait for response, try Refresh,
4. Observe the operation never finishes
5. Set filters on Date to cover only a day or two, and optionally only specific service operation, hit Refresh
6. See the returned list 300 (out of many thousands, depending on filter)
7. Try to drill down into Sub Queue Link on any row, for example the first.
8. Observe that it hangs, the page spins and no results are returned, expected behavior is to see the instances and Sub Queue link to show data.

On systems with lesser (though still big) amount of accumulated transactions, or with more resources, SO Monitor may remain responsive, but other issues may arise.
In particular, service operation publication or subscription contracts may fail to be created from the operation instances, as the dispatchers stall on selecting next item.

Changes

Usually happens after the environment ran for a considerable period of time with high Integration Broker traffic and no Integration Broker live tables maintenance.

Cause