COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: sagar_d125 on 09 Mar 2015 02:34:22 PM

Title: Query Studio Freezes after selecting a package
Post by: sagar_d125 on 09 Mar 2015 02:34:22 PM
Hi Cognos Experts,

I'm facing intermittent issue with the Cognos 10.2.1. It works fine but sometimes when we try to select query studio and then a package it keeps spinning ( it won't show up the query reporting page)

Eeverything works fine after restarting the server. But the issue happens all the time.

I've increased the queue timeout limit and java heap size but nothing helped. Even running a package in CQM mode creates a issue.
Can someone please share the toughts how to captures the detail logs to see what's going on with the environment

Below is the error message which i get the during the issue, but the error does not say what is causing the issue

Audit.dispatcher.caf   Request         Failure      SecureErrorId: 2015-03-06-15:45:31.404-#39  Original Error: DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.  Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler [the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler [warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_warp] com.cognos.pogo.handlers.logic.ChainHandler [warpmta] com.cognos.pogo.reportservice.ReportServerHandler

Spoke with DBA"S to see if content store is an issue but they say everything looks good with Database.

Thanks,
Krishna.
Title: Re: Query Studio Freezes after selecting a package
Post by: MFGF on 10 Mar 2015 05:55:06 AM
Quote from: sagar_d125 on 09 Mar 2015 02:34:22 PM
Hi Cognos Experts,

I'm facing intermittent issue with the Cognos 10.2.1. It works fine but sometimes when we try to select query studio and then a package it keeps spinning ( it won't show up the query reporting page)

Eeverything works fine after restarting the server. But the issue happens all the time.

I've increased the queue timeout limit and java heap size but nothing helped. Even running a package in CQM mode creates a issue.
Can someone please share the toughts how to captures the detail logs to see what's going on with the environment

Below is the error message which i get the during the issue, but the error does not say what is causing the issue

Audit.dispatcher.caf   Request         Failure      SecureErrorId: 2015-03-06-15:45:31.404-#39  Original Error: DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.  Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler [the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler [warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_warp] com.cognos.pogo.handlers.logic.ChainHandler [warpmta] com.cognos.pogo.reportservice.ReportServerHandler

Spoke with DBA"S to see if content store is an issue but they say everything looks good with Database.

Thanks,
Krishna.

How much temp disk space is available on the Cognos application server?

Just a thought...

MF.
Title: Re: Query Studio Freezes after selecting a package
Post by: bdbits on 10 Mar 2015 09:06:20 AM
Is this in an environment that was working and started failing without any changes? Do you have more than one server? Is it possible you have multiple content managers active?

Is that error from the cognos server log? I would look back through the entries preceding the error, sometimes that gives a clue to the root cause.
Title: Re: Query Studio Freezes after selecting a package
Post by: sagar_d125 on 01 Jul 2015 06:35:03 PM
Thanks for your response bdbits,

after doing enough research, it turned out to be Cognos 10.2.1 issue, after upgrading to patch 2 issue got fixed.


Basically it was a bug.

Thanks,
Sagar