Skip to Content
0

BOXI Data Federator Insufficient memory issue

Jun 14, 2017 at 02:50 AM

63

avatar image

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)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Denis Konovalov
Jun 14, 2017 at 01:47 PM
1

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....

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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 :)

0