LERG Utility (lerg.exe) Throws Out Of Memory Error Loading NPA/NXX Into MetaSolv Solution (Doc ID 1619683.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Symptoms

When attempting to load an NPA/NXX into the database, the MetaSolv Solution Location and Routing Gateway client (lerg.exe) throws an "Out of Memory" error after clicking the Import button.

Error 1

Out Of Memory

Error 2

Insufficient memory to continue.

STEPS 

-----------------------

1. Open MetaSolv Solution Location and Routing Gateway client (lerg.exe)

2. Click Query

3. Select NPA/NXX radio button

4. Enter desired NPA and NXX values

5. Click Retrieve

6. Highlight all of the returned rows

7. Click Import and the Out of Memory error will occur

Changes

Data growth in ASAP.LERG13 table over time.  The problem is directly proportional to the number of rows in the ASAP.LERG13 table.

Cause

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