COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Query Studio => Topic started by: dgj on 12 Feb 2014 11:40:35 AM

Title: Query Studio error
Post by: dgj on 12 Feb 2014 11:40:35 AM
Hi,
When opening up QS at present in our Production environment, we sometimes get a RSV-SRV-0040 error on connecting to any package. This is random and happens for all users, seems to be getting worse.
We are on 10.1.1 running on windows with MSSQL 2008.
Has anyone else had this issue?
With thanks
Title: Re: Query Studio error
Post by: dgj on 05 Mar 2014 08:44:44 AM
 :) Additional information:
2014-03-05 14:23:17.971   +0   71FBBA3F7120A203E557DFE663F1F4765AB8DC7D   GjhGGslwhhqqC22dh984swCqd4j9s89MqG4ddlyM   0      http-9300-23   DISP   6235   2   Audit.Other.dispatcher.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler   Request         Failure   <messages><message><messageString>Server Error</messageString></message></messages>   cognosViewer
10.10.2.56:9300   1216   2014-03-05 14:23:17.986   +0               http-9300-23   caf   2047   2   Audit.dispatcher.caf   Request         Warning      secure error - found userCapabilities
Title: Re: Query Studio error
Post by: dgj on 26 Mar 2014 10:01:23 AM
Further update, I've been busy carrying out some testing where by I've got QS working correctly!
•   By setting up a routing rule to the BI reporting (Active Content Manager) server.
•   Setting up routing on the 5 other servers/dispatchers fails
•   But Planning fails due to the routing rule.
IBM have investigated and they think it maybe is an issue with the Dispatchers, of which there are 6, also that 4 of the servers have the Presentation Service disabled via Cognos Config.
So I've got further testing to carry out! ::)