Blank report

[Former Member]

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.

[Former Member]

Update:

On testing today, we have found that Database is heavily loaded and takes more than 10 mins to execute the query. and the report history says 'timeout'.

The query otherwise doesnt' take more than 300 ms.

I guess, the solution is to incerase the 'execution time'.

Please suggest if there is any other way out.

TIA,

-Vishi

[Former Member]

The better way to do this is to use Events before you kick of your scheduled report to run.

Creating a file based event to set the schedule of the report will work out perfectectly.

[Former Member]

Well, thanks for you kind suggestion. However, the report is directly is linked with the loads, and we have some data comparisn as the files are loaded, to generate the report. And hence the file event may not help.

I am attempting to successfully generate it, on time, and during pick hours.

regards,

-Vishi

[Former Member]

clearing DB cache more frequently may help...

Thanks,

Ganesh