COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: M on 01 Aug 2013 07:37:36 AM

Title: No data returned
Post by: M on 01 Aug 2013 07:37:36 AM
Good day,

From today our reports returning nothing .

when we query the database we have data. Even the reports which ran fine yesterday doesn't return data today.

Couldn't get a clue what went wrong ?

How to figure out the issue guys?

Thanks
Title: Re: No data returned
Post by: Lynn on 01 Aug 2013 07:44:57 AM
Perhaps get the generated SQL from one of your reports to see what might be causing the issue?
Title: Re: No data returned
Post by: M on 01 Aug 2013 07:54:01 AM
Thanks for the response Lynn.

I test with the generated SQL and there is nothing funny. Sql looks perfect and working.  The Same report brings data yesterday and this issues started from today.

Server becomes extremely slow . It's taking lot of time to bring a prompt page . 

Is server slow response may be causing this issue?