Cognos Report Running for a Long Time and Not Fetching the Output

[eniranjan]

I have a report with queries in query explorer as below:

A
B
C

And, join queries as below:

Join Query1: A.id=b.id and fetch columns of A and count(B.id) and a filter is used as (count(B.id))>0

Join Query2: Join Query1.id(A.id)=C.id and fetch columns of Join Query1 and count(C.id)

Now, my report page looks like this:

Columns of A , Count(B.id) and Count(C.id)

When I Generate SQL from Join Query2 and run in the database, it is coming in 30secs. But, the same when I run the Cognos report, it is not all fetching the output.

I have tried all properties like Processing, Execution Method and Execution Optimization which failed to get the output.

Please help to resolve this issue.   

Thanks in Advance

[Francis aka khayman]

right click Join Query 2 and check tabular data. does it return all data you need from your db run?

[Invisi]

Firstly check on your database if there are queries running that are related to your report. For SQL Server you can find this script on Internet easily. I assume similar scripts exist for other database types. Then you can see if your report is still busy getting data and how. Secondly check the activity on your Cognos machine. Is it actually doing something? Thirdly: how many rows does the final report contain on one page and how complex is that one page to render? I have a similar issue here at a client where after a certain number of rows the report became too complex to be rendered by the browser or it took ages to render.