Recently a customer requested that we review their self-installed IBM Cognos Planning environment due to poor performance and regular job failures. There were a number of installation, configuration and sizing issues with the environment (which was on a vastly underpowered VMware platform), but one of the key recommendations that we made was to disable the Planning Administration Console Service on all but one of the Application Servers.
Additional CPU’s were added, but beyond that most of our recommendations are yet to be implemented. In the meantime the environment continues to perform poorly and job failures are almost as frequent.
One of the latest issues that has been reported to us is that during the copy-load-prepare process, once you have completed the “copy” stage and switch to the “load” tab they are finding that different cubes are displayed each time.
- Copy five files, switch to the load tab and find that cubes “A, C, D” show.
- Try again with the same five files and find that cubes “D and E” show.
