Tel:  +44 (0)1792 224 330
e-Mail: info@planitcpm.com

IBM Cognos Technical Blog

April 15, 2010

A few thoughts on using IBM Cognos 8 products on Virtual Servers

Filed under: Cognos Planning,IBM Cognos,Virtual Server,Virtualisation,VMware — Blog Admin @ 6:27 pm

With more and more customers using VMware lately it’s becoming a somewhat futile effort to keep on battling against the virtualisation march. So maybe it is time to stop fighting it and instead embrace the VMware onslaught. Rather than banging on about why you should not run IBM Cognos Planning software on VMware, lets just discuss its use in a more balanced way.

Virtualisation has got its feet well under the table.  IT departments us virtualisation products not only for the consolidation of existing servers, but also for the deployment of new products in the server room.  The lure of greater ease of management, lower energy usage, savings in rack space and the opportunity to gain some new skills is proving too strong to resist.

The virtualisation platforms are constantly evolving and improving brining “near-native” performance, which is a good thing.  Utilising those wasted CPU cycles can seem like a great idea.  And it is.  In most cases.
As with any software product there are very good reasons virtualise your IBM Cognos servers, but there are also some instances where it should be avoided.

IBM Cognos Planning on VMware?

The IBM Cognos 8 Planning product set is made up of two core products.  IBM Cognos 8 Analyst and IBM Cognos 8 Contributor.  Analyst is frequently used stand-alone in smaller deployments, the server-side product requires very little server resource, though with the introduction of IBM Cognos 8 (not including the 8.1 release) customers now need to find a Web Server (usually IIS) and a database server (usually SQL Server) purely for the provision of authentication.

In these cases VMware is a no-brainer.  Who wants to spend cold hard cash on a physical bit of kit that’s doing little more than logging users on and providing a shared folder?

So Analyst only clients wanting to use VMware? Go ahead.  It’s perfect for you.  If you have Contributor, things suddenly get a little more interesting.  Contributor is the biggest problem when considering virtualisation, the reason for this is that the software is already designed to make the most of any CPU power you can throw at it.  Ok, so in most cases it’s not making use of these CPU’s for 24 hours a day, but it can certainly be running jobs for several hours at a time all at 100% CPU usage.

This is not great for the other systems on your VMware host server. It also kind of defeats the purpose of using VMware if you are providing your Virtual Guest with a one-to-one CPU relationship to the host system.

This brings me on to my second point.  A lot of mid-to-large sized installations of IBM Cognos Planning are built using multiple servers to provide the best possible performance and scalability.  This means separate Web, Admin, Job and Database servers.
Many large clients have multiple Job Servers, each with 8 core CPU’s and 16 GB of RAM, and they are still heavily utilised thank you very much.  Putting all of these servers inside of VMware has been shown to degrade performance significantly as various servers which seem separate are infact on the same host and so cause job scheduling clashes.

I want to stop sounding like a VM-basher.  I guess its a good time to point out that there are severaly customers who are now very happily running IBM Cognos Planning on VMware.  Some even have these multi-server installs.  There are a few reasons for this.

  • They have a small user base
  • They have small, uncomplex planning models
  • They don’t run many Job processes
  • They are keeping the number of competing virtual guests low

Another reason may be that many of the more recent VMware based installations also have been completed using the most modern hardware available, the newer CPU’s are so powerful that processing these planning jobs takes much less time than it used to, so jobs that would previously have taken hours to complete now finish within minutes.  Whilst its still quicker to run on native hardware, the difference is starting to get a little harder to notice.

Important considerations when running IBM Cognos 8 Planning on VMware

Some things that we have found when working with customers running VMware platforms, from those who have succeeded and from those who have failed.

  • Keep the number of Virtual Guests low. When the Contributor jobs are running you don’t want the rest of your servers to suffer.
  • Do not throttle the CPU or Memory usage on the IBM Cognos Planning servers, on software designed to make the most out of the hardware available to it this really is defeating the object. It has caused many deployments on VMware to fail.
  • Consider targetting your use of virtualisation, be open to the fact that maybe not all servers should be virtualised. IBM Cognos 8 Planning Job Servers are likely to be better off on good, high-powered physical servers. Good targets for virtualisation are:
    • IBM Cognos 8 Gateway Server
    • IBM Cognos 8 BI servers (in some cases)
    • IBM Cognos 8 Planning Administration Server
    • Microsoft SQL Server or Oracle Server (assuming they are dedicated for IBM Cognos use)
    • Citrix Servers (On a case by case basis)
  • Spread out the IBM Cognos Planning Job servers. By this we mean, keep them spread over as many physical hosts as possible, the end users may create job server clusters and use these to schedule their jobs, if their job servers are using the same physical hardware, attempts at job scheduling will fail as multiple jobs compete for CPU resources.

Cognos Planning Development on VMware

Where VMware pretty much always comes in to its own is in development environments, the ability to quickly bring up clean server builds that have been stored away on a hard drive somewhere is a huge advantage, you get the server operating system, database server and applications all installed and configured just the way you need them, archive the virtual machine off somewhere and start your development. Any time you need a clean set of servers again, you just dig out the archive and start again.

In these environments where performance is not a prime concern, the use of a virtualisation product is likely to be a winner.

Even IBM are now starting to ease up on their harsh tone on VMware, there is a general acceptance that customers want to run the software in this environment and so they are starting to be a bit more open to providing support for this.

March 23, 2010

Remembering the importance of server reboot.

Filed under: Contributor,IBM Cognos,Reboot,Server — Blog Admin @ 11:02 am

Too often in a support situation people poke fun  and make sarcastic comments about the requests for screenshots and reboots to clear problems, seen as being either delaying tactics or lazy troubleshooting, so sometimes the humble server reboot is overlooked, as we try too hard to find another fix for the problems at hand.

Earlier this week a client got in touch about a problem they encountered following some issues with their Cognos service account on their Windows 2003 servers.  Initially all of the Contributor applications were unavailable, each giving a message on the web page stating that:
“The application definition is being updated on the server.  Please try again in a little while”
Very polite, but not too helpful.  As far as we knew the application definition was in no need of being updated.  But try again in a little while we did.
Four out of five applications did indeed become available but the last one refused.  So we viewed the error logs only to find there was no specific help there, we tried to GTP, Synchronise, GTP again, each time the GTP successful, unless a reconcile job was required, at which point the reconcile failed to complete even a single e.list item.
“The application must be corrupted” we declared.  ”I suggest that you restore the database from a backup file”.  And so within 30 minutes a backup file from Friday night was restored and we tried again.
“The application definition is being updated on the server.  Please try again in a little while” the server responded.
By now time was getting on, nobody wanted to stay on the phone so we offered that it may be worthwhile getting the databases off-site to try some testing on our own servers, to limit the drain on the customers time of course.  And so we suggested the following:
  1. Try a reboot of all the servers if possible
  2. If the reboot is unsuccessful, please upload the backup files so we can try them ourselves
An hour later we received an email saying the servers had been rebooted and the application was now working.  The customer quite rightly said it was a bit of a shame in a way, that we had not tried this earlier in the day.  Though I have to wonder if we had suggested rebooting the servers as a first stab at finding a fix for the solution if it would have been greeted so warmly.
So maybe we should remember that rebooting the server is not always the lazy option, but simply a way of ensuring that all the cobwebs have been blown out before resorting to more thorough investigations.

March 19, 2010

IBM Cognos 64bit Oracle Woes!

Filed under: 10g,64-bit,Business Intelligence,IBM Cognos,Oracle Client,Windows 2008 — Blog Admin @ 4:43 pm

…Phew… what a title.  But I think it correctly describes (without the use of my signature bad-language) the state of affairs during yesterday’s Technical Consultancy assignment.

A seemingly straight forward, albeit last minute engagement to install IBM Cognos 8.4 Business Intelligence to a single server turned into at least half a day of head scratching, in no small part thanks to the following unexpected requirements:

  • To run on a 64-bit Server
  • Which was also Windows 2008
  • Which required a connection to datasources on Oracle 10g

None of this should have been a problem in its self, and in fact, most of it did not cause any problems beyond having to download the correct 64-bit enabled version of IBM Cognos 8.4.1 Business Intelligence rather than the supplied 8.4 32-bit version.  Of course, Windows 2008 Server or more specifically, the use of IIS7 does indeed make things trickier (perhaps another post on this to come?) but the real problem was finding the right version of the Oracle client to allow connection to our Oracle data server.

The customer had previously used the Oracle 9.2 client with their old Cognos server and had decided that as this worked in the past they would proceed with this version on the new server.  This turned out to be the first mistake.

Lesson Number 1:  Oracle 9.2 client does not play well on Windows 2008 Server; in fact, after it had installed, removal required that we run the OUI (Oracle installer) in XP Compatibility Mode just to get rid of it.

The error message we encountered when trying to test a new datasource connection was:

ORA-12154:TNS:Could not resolve service name  

This was unusual because we could use the Oracle command line tools to TNSPING and SQLPlus into the instance.  So we went looking for a 10g client, 64-bit naturally, because we had a 64-bit OS.  After 30 minutes downloading we tried to install this, it did not run.  So for a while we wondered why this may be before turning to trusty Google to tell us that we actually needed to search for a Windows 2008 certified version of the Oracle 10g client.  In 64-bit.  The link is here should you need the download:

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10204_winx64_vista_win2k8.html

So we waited another 30 minutes for the download to complete.

This one installed perfectly, hooray!  We were now ready to test creating the Datasource connection in Cognos 8.

Damn, an error.  Again.  But this one was different so we were making progress right?

QE-DEF-0285 Logon failure.
QE-DEF-0325 The cause of the logon failure is:
QE-DEF-0068 Unable to connect to at least one database during a
multi-database attach to 1 database(s) in:
[Database Name]

UDA-SQL-0432 Unable to locate the gateway “cogudaor”.

Ok, what does this mean?  Well, back to Google we went and found that the answer was quite simple in fact.  We had the wrong Oracle client.  Again.  This was something that had crossed my mind as the 64-bit version of IBM Cognos 8.4.1 is not entirely 64-bit.  Just parts of it are.  So we need the right version of the Oracle client for the right bits of Cognos to talk to.  This happened to be the 32-bit version.  But specifically, a Windows 2008 certified 32-bit version.

30 minutes of download later… (here is the link…)

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html

Finally it worked!  So the end result is, for 64-bit IBM Cognos BI on a 64-bit Windows 2008 Server to be able to connect to an Oracle instance we need 32-bit Oracle client software!

I wonder why I didn’t think of that first!

March 15, 2010

TM1 – Ahem, technical issues…

Filed under: Contributor,IBM Cognos,Installation,IntegratedSecurityMode,TM1 — Blog Admin @ 6:47 pm

There has been quite a bit of TM1 work about lately, most interesting of all is the latest 9.5 work with the TM1 Contributor component.  It’s been somewhat easier to implement within the localised VMware environments with no complicated Active Directory or anything like that to get in the way but even so, its not exactly rocket science… or is it?

I mean, its really giving me a bit of a rough time on a particular customer implementation that I am working on right now, its just not playing nice.  On the surface it is all working nicely.  Navigating around, looking at the web etc.  But just you try publish an application to Contributor… oh yes… and that’s where it starts giving a headache.

First of all it spend a long while complaining that you really do want to be using “IntegratedSecurityMode=5″ with TM1 Contributor.  Ok, thats a fair point.  What I had actually done was mistakenly put it to “IntegratedSecurityMode=4″ – this I could not resolve for even when the setting had been corrected, TM1 still wanted to tell me that I can’t use 4.  I got around it in the end by copying the sample application from another installation over to the problematic server.  But now its complaining again and I have my work cut out for me.

The very annoying error is some JAVA.NULL.EXCEPTION.POINTER or some thing similar.  Seems to only happen with the Planning Sample App for now anyway as I just got it to work with the customer’s own data.  #win!

« Newer Posts