Posted: Thu Nov 19, 2009 12:02 am Post subject: Report from BCA takes a lot of time to refresh
I have a BO 6.5 report scheduled through BCA using macro on a daily basis. The report was able to run in 10 mins till sometime ago. Off late the report is taking around 6 hours to run.
When I run the report in my local machine, it runs within 10 mins, I ran the report where BCA is installed and it took the same 10 mins. But through BCA it takes around 6 hours. I tried running through BCA for testing and it took once 10 mins and the next time when I sent it to BCA it took again 6 hours.
The queries used in the report take not more than 10 mins in toad.