returned BCA file size

Has anyone come across a problem with large data file being returned by the BCA even though the report does not have enough data in it?

We are using ver 6.5 with oracle 10g and when you schedule a document from full client and retrieve it from BCA, even though the report does not contain enough data, a .rep file which would ideally be few hundred KB returns as 70- 100 MB. If you do a ‘save as’ and save it again it comes down to few hundred KB.

Also, the users are used to scheduling the document using Full Client and upon refreshing, sending it as a report to their own Business Objects accounts.

Any ideas??


ashish_bo (BOB member since 2006-06-21)

Welcome to B:bob:B! This is quite unusual. However, I have seen this when the BCA’d job is one that uses the query on query feature.


Steve Krandel :us: (BOB member since 2002-06-25)

Hi and welcome to B :mrgreen: B

What BO version do you use and what version is BCA?

It looks that you experience a known BO bug that causes the report originally saved in BO 6.5.2 and then open and saved in 6.5.1 becomes very large.

Have a look here and here.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Thank you Steve and Marek,

The BCA version shows 6.5 SP2 and the client reporter tool is 6.5.1.


ashish_bo (BOB member since 2006-06-21)