BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

Report from BCA takes a lot of time to refresh


 
Search this topic... | Search Broadcast Agent (BCA)... | Search Box
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> Broadcast Agent (BCA)  Previous TopicPrint TopicNext Topic
Author Message
cruise
Forum Member
Forum Member



Joined: 20 Jul 2008

Posts: 13



PostPosted: 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.

Any help on this would be appreciated.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> Broadcast Agent (BCA)  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0085 seconds using 17 queries. (SQL 0.0021 Parse 0.0002 Other 0.0062)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo