If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Running Forever

Started by ghostraider, 16 Sep 2008 07:11:41 PM

Previous topic - Next topic

ghostraider

Hi All, I have a simple list report which i have joined at the report level using master detail relationship. When i paste the query in TOAD i get the data in less than 20 seconds. However, in Cognos the report runs and runs and runs without any output. I have tried changing the processing option to Database Only, but it doesn't work. Any ideas why this is happening? Please let me know.

Thanks!!

shri

try creating simple report with just one or two columns and then try to run, see how long it will take. check your database connection, try and use native connection type.

hauge9

Have you tried pasting the SQL you are using in TOAD into a query, and use the "Pass-Through SQL" option. This should pass everything directly to TOAD.