My Oracle Support Banner

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:

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


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.




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


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



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.