Skip to Content
avatar image
Former Member

BOXI Data Federator Insufficient memory issue

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 14, 2017 at 01:47 PM

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

    Add comment
    10|10000 characters needed characters exceeded

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