The request failed because the associated report service process is unavailable

[sridhar_cheepu]

Hi ,

when we are running the drill through report we are getting error like “Report server not responding” and some times “The request failed because the associated report service process is unavailable”.

Could you please any one help me to resolve this error.  Please review the Attachement for clear understanding of error.

Thanks.
Sridhar

[BIsrik]

Is this error coming whenever you run the drill?...

Srik

[Mpotla]

chek the below if that helps you


•   Error Message: DPR-ERR-2077 The request failed because the associated report service process is unavailable.

Root Cause:
Report has a graph using a query that has "Processing" set to "Database Only".
Solution:

In Report Studio, for any queries that are used by a graph, make sure Processing is set to Default or Limited Local.

[sridhar_cheepu]

Yah i have checked the queries and those are all set to default and this error is coming while i am runnig the drilthrough(details) report And as well i am getting the same error even while running detail report independently.

[Mpotla]

what if u explicitly enable local processing  and also try extracting th native query and using it as passthrough/native .... may be try these and see if ur still getting those errors?

[josepherwin]

We've had exactly the same issue... although in our case, none of our reports is actually a drill-through report, it's just a simple list report.

Is your cognos architecture contain multiple app servers by any chance?