Tel:  +44 (0)2920 02 04 05
e-Mail: info@planitcpm.com

IBM Cognos Technical Blog

December 14, 2011

“Switch error decoding URL” in IBM Cognos 10.1 Controller Client

A very spurious error occurred this week at a customer site when attempting to use some of the newer Java based features of the IBM Cognos 10.1 Controller Local Client.

The error contained the message “Switch error decoding URL” when attempting to run some of the following tasks:

"Company -> Reports -> Intercompany Reports"
"Maintain -> System Audit Log -> Configuration"
Switch error decoding URL

IBM Cognos 10.1 Controller error - Switch Error Decoding URL

This occurred because of an inaccessible folder having been set for the CCR CACHE directory at install time.

To resolve the problem, remove the “IBM Cognos Controller Local Client” and re-install it specifying a valid path during the URL input screen.

Typically we use %appdata%\ccr as all users should have full rights to their own user profiles, however this will cause a 200mb or so download for each user logging on to Controller on a given computer.


August 23, 2011

Say No to multiple Admin Servers

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.
This is a typical symptom of having multiple Administration Servers configured in the environment, what is happening here is that a different Admin Server is processing each of the file copies, then when switching to the “load” tab just one of the servers is being used and so only a selection of the copied files are being detected.
The fix for this is a simple one, disable the Planning Administration Console Service on all but one of the Application Servers in your Planning server environment.

June 28, 2011

Controller 10.1 – DBCONV.EXE error – ERROR 429 (HEX 1AD)

During a recent upgrade to IBM Cognos 10.1 Controller we discovered that it was necessary to use the bundled “legacy” version of the DBCONV.EXE utility to upgrade databases from 8.4 or below.

This was all very well, the files are easy to find in the c10\legacy folder of the installation, but unfortunately on running the utility against our database we came up against the following error:

ERROR 429 (HEX 1AD):
ActiveX Component can't create object.

It turns out that the error message is caused by a .DLL file that has not been correctly registered.  The details to fix this as below:

  1. Launch a command prompt by clicking “Start” – “Run” and then typing in “CMD” <Enter>
  2. Change directory to the c10\common folder (for example using: cd “C:\Program Files\ibm\cognos\c10\common”)
  3. Register the DLL file using: regsvr32.exe FrCrypto.dll
  4. Test”