Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB error - Ran out of memory retrieving results - (Code: 200,302) (Code: 209,879)

sgunturuOct 30 2013 — edited Nov 4 2013

I am encountering an error while running a big job of about 2.5million records running thru the EDQ cleansing/match process.

 

Process failed: A database error has occurred : Ran out of memory retrieving query results.. (Code: 200,302) (Code: 209,879)

The server has 8gb memory with 3gb allocated to Java for processing. I could not see any PostgreSQL configuration files to tune any parameters. Need some help with configuring the PostgreSQL database I guess. Appreciate any suggestions!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2013
Added on Oct 30 2013
2 comments
2,479 views