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
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.
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