on 2010 Nov 12 5:09 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.