My Oracle Support Banner

LERG ( - Looping Process Problem In Location And Routing Gateway Query Window. The application hangs. (Doc ID 2490102.1)

Last updated on MAY 10, 2022

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.


MetaSolv Solution version

The LERG client application infinitely executes a query while the mouse cursor focus remains on the Criteria tab of the Location And Routing Gateway Query window (w_lerg_query_monster). The Windows Task Manager shows the lerg.exe process consumes 25-45% of the CPU. Selecting the Results or Properties tab immediately stops the looping process. Returning back to the Criteria tab immediately restarts it.

The problem started after applying Patch 24007321: MSS_6_2_1_B1135. The behavior is only observed when the new LERG Import type System Preference is set to Monthly or Quarterly Updates. The behavior does NOT occur when the preference is set to Comprehensive Updates.

Below is the query associated to the process as parsed directly from V$SQLAREA.

SQL_ID = 14gtt27xu28bc

Business Impact

Confusion. The application appears as if it is processing. Enough control is provided in the window to select the other tabs as well as close the window altogether.



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

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