COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: Redrichmond on 28 Nov 2008 10:52:37 AM

Title: Cubes randomally fail and dont copy fully to directory
Post by: Redrichmond on 28 Nov 2008 10:52:37 AM
Hi , we have an intermittant fault with Cubes not fully building to the location specified.

They run on a batch file which is scheduled by the scheduler in Windows 2003 Server.

In the log files. All seems well they seem to build.

However when we look at the file size of the completed Cube it should be 54,000kb it only shows 20,000 for example.

We then know this has failed. There is no pattern. Some weeks 2 fail ,or 1 fails. Different cubes.

We have to reboot the machine and delete the tmp files.

We have 26gb Free space on the server 91 gb full space

We have to rebuild the Cube again manually. This works.

We are using Transformer 7.1.708

Could this be a Cognos Bug? We dont have Anti virus installed to complicate things.
Title: Re: Cubes randomally fail and dont copy fully to directory
Post by: durnik on 06 Jan 2009 09:49:53 AM
Maybe someone is working with the Cube meanwhile you build up a new version.
Mayby another Transformer process is running, using the TMP. You start processes parallel?
Title: Re: Cubes randomally fail and dont copy fully to directory
Post by: Stephane Lambert on 28 May 2009 09:26:45 AM
Hi,

I got the same problem with one of my customers and I changed the generation process as follow:

First of all, you must build you new cube on a local disk (a disk locally attached on the server where TS is installed) in order to minimize network traffic glitches.

After the build is done, disconnect all remaining connections on your old cube, then copy then new one over the old one.

Hope this will help,