If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cubes randomally fail and dont copy fully to directory

Started by Redrichmond, 28 Nov 2008 10:52:37 AM

Previous topic - Next topic

Redrichmond

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.

durnik

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?

Stephane Lambert

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,
------------------------------
Stephane Lambert | Senior Business Analyst / IBM-BI Cognos Mentor