Error trapping: how to handle connection loses to db

[DVH_75]

Hi All,

I have an intresting question:
If for example I have three SLQ servers A, B, C and I want to create a report with consolidated data from the three servers.
Let's say that during the day server B goes offline.
How can I manage those connection losses and still be able to run the report with the data from server A and C without having a connection error?
Anyone has an idea on this?

DVH

[MFGF]

You cannot - if the target pointed to by a data connection defined in Cognos 8 becomes unavailable, you will get errors when you try to access it.  Cognos 8 is not designed to handle this, as the outage is happening outside of the Cognos 8 architecture.  IBM would most likely class it as "SEP" (Someone Else's Problem :)) and tell you that database failover should be handled by the database.

You do get failover for a Content Store outage, and for individual application server outages within the Cognos 8 architecture, and a list of alternate web server gateways to try for web server outage, but this is as far as the Cognos 8 failover extends (ie within the Cognos 8 architecture).  Security and data sources are external to this, and are only as robust as the vendor's architecture permits.

Regards,

MF.

[DVH_75]

Txs MFGF!

I was hoping on an 'On Error' type of function but couldn't find it. Now I know why...It simply doesn't exists...

Thanks for the quick reply!

DVH