cancel
Showing results for 
Search instead for 
Did you mean: 

Blank report

Former Member
0 Kudos
67

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

clearing DB cache more frequently may help...

Thanks,

Ganesh