Blank report

27 Views

Hi,

We have a report scheduled to run from monday to friday, picking data for two previous business days. It's emailed to few receipients. The underlaying database is Oracle 9i and BO is XIR2.

Report gets generated, everyday, except for monday. and a blank XLS is emailed.

When we executed the query from the Database Client, it generates data.

The condition to pick previous days data is:

For (T-1): TO_DATE ( TRUNC (SYSDATE - 1, 'IW') + LEAST ( TRUNC (SYSDATE -1)- TRUNC (SYSDATE - 1, 'IW'),4))

For (T-2): TO_DATE ( TRUNC (SYSDATE - 2, 'IW') + LEAST ( TRUNC (SYSDATE - 2)- TRUNC (SYSDATE - 2, 'IW'),4))

We have also checked if there is any timezoen issue, it isn't. Both the BO and DB servers are in same tiemzone.

Also, the tables are not locked by processes.

Please share your views, if you have faced some similar issue. Is there a way to know if the query is getting timed out when fired from BO? Though, it hardly takes 300 ms, when executed from DB client.

Regards,

-Vishi.