COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: sap on 24 Sep 2006 11:57:50 PM

Title: error on unix
Post by: sap on 24 Sep 2006 11:57:50 PM
hi all

while building a cube on Unix AIX we are geting the following error

TE CUBE),01:49:57
Sun 24 Sep 2006 21:29:51        2       0000023D        (TR1901) Out of memory.
(Data) in /data2/cognos/powercubes/aname_Group.mdc. [->OK]
Sun 24 Sep 2006 21:29:51        3       0000023D        Closing model file /ppd4
5230.qyi
Sun 24 Sep 2006 21:29:51        3       0000023D        Transformer Server exiti
ng - operation failed

-- sometimes  error An error occurred while
sorting temporary data file. Cognos debug info: rswrkfil.cpp (384)--

we have  total 65000 records,
we successfully build the cube for 45000 records

when we are building cube withh all records we are getting above errors
we checked memory available on server,

can anyone give solution for this ,
its urgent

thanks all
Title: Re: error on unix
Post by: Christenhusz on 05 Oct 2006 04:37:04 PM
the server has enough memory but what about the user account which is used to generate the cube ???

use ulimit -a to see the system resource that account may use.

good luck,
christenhusz