BOXI Data Federator Insufficient memory issue

[Former Member]

Hi,

We are using BOXI 3.1 sp2 and Data Federator on our production environment. Recently, some of our schedules were getting failed due to below error. Can anyone help to point out what we need to do in order to solve this error? Thanks in advance.

A database error occured. The database error text is: [Data Federator Driver] [Server] Insufficient memory : Operator 'HashFullOuterJoin' cannot execute because it cannot allocate the minimal number of memory pages. Please contact the system administrator to change system parameter settings.. (WIS 10901)

[denis_konovalov · Accepted solution]

It means 2 things :
1. Your server doesn't have enough memory for the DF process need
or
2. Your DF jobs are too big for the 32bt process 2gb memory limit.

To figure out which it is - you need to monitor your server memory usage. See if it is total server physical memory that is being eaten up or the DF/job servers running at or close to 2gb....

[Former Member · Accepted solution]

Our physical server has 24gb memory, windows 2003 64bit server and java 1.5.0_14-b03. We have 4 query server processes running on the server, each query server has consumed about 1500mb memory. How can we change the configuration to avoid this error? Thanks in advance.

[denis_konovalov · Accepted solution]

Xi 3.1 is a 32 bit application, this means all its processes are limited to 2gb memory max, in real life its lover due to various factors.

You need to either increase number of DF processes or redesign your jobs, so they consume less memory.
Basically, you need to properly size your system to the current usage.

On another hand, you're using very old product - so maybe its time to move to Bi4.x, which is 64 bit and is new and shiny and chrome 🙂