Live Office very slow when inserting reports, InfoView fine

system · August 16, 2011, 11:24am

Hey everyone,

did anybody ever have this issue? we can connect to our BO server just fine using live office, listing reports, browsing folders etc. works just fine, but when selecting a report from which to insert data into excel/word, it takes forever (~5 minutes) until the report is shown and data sets to insert can be select.
opening the same report in InfoView works ok, no delays like this.

what is the difference in communication between using InfoView and Live Office? Something has to be different, but I don’t know what it might be, so it’s very hard trying to find the bottleneck…

any help would be greatly appreciated.

thanks, hendrik

berlinerbolle (BOB member since 2011-07-01)

system · September 15, 2011, 10:08am

Hi,

Even I am facing the same issue. The MS Office version used by me is Office XP with Live Office XI 3.1.

A very simple report takes like forever to be fetched in the excel using live office. I also tried to pull in a scheduled Web Intelligence report but that too takes long time. This ultimately effects the Xcelsius Dashboard loading time.

Can someone put some light on this?

Regards,
Kunal

kdvora23 (BOB member since 2009-07-07)

system · October 5, 2011, 3:14am

Any update with this? I have the same problem, I’ve updated the time out value in the registry to 20 mins. Oddly using a universe query directly form Excel via Live Office is fine, but as soon as a webi report is inserted or refreshed it all goes pear shaped!

jydub (BOB member since 2010-02-05)

system · October 5, 2011, 9:05am

Hi,

I found the reason behind the problem. It was because my tomcat server (or the web server which would host your live office services) was overloaded and hence the processing was very slow.

The alternative which I used was to use the services of a less loaded server.

kdvora23 (BOB member since 2009-07-07)

system · October 6, 2011, 5:30pm

I am also facing the same issue with FP3.5 , and with SP4 also. I testing with webserver where load is not there and still having the same issue.

vinspune (BOB member since 2008-04-17)

system · October 28, 2011, 7:51pm

Hello,

I have the same issue here. Have no clues of what to do. My CMS.exe goes 100% when running Live-Office.

ruyneto (BOB member since 2010-04-22)

system · January 27, 2012, 10:22pm

Check out this post: http://www.forumtopics.org/busobj/viewtopic.php?t=183571&start=0&postdays=0&postorder=asc

It might help. Worked for us.

siph7 (BOB member since 2011-12-19)

system · March 30, 2012, 7:28pm

The problem occurs when you try to access the BO dashboards from the invoview and this takes a long time as usual.

Refers to Performance problem.
The webintelligence running on live office timeout distributed cluster apache 2.2 tomcat 6 complex LiveOffice Hang.
Refered to note 1542343 - Importing Web Intelligence report using Live Office is slow and hangs, and just tried the workaround instead importing the fix pack.

Replacing dsws-common-provider.jar and dsws-reportengine-provider.jar files attached in the notes on foloowing location C:\Program Files\Business Objects\Tomcat55\webapps\dswsbobje\WEB-INF\lib, had a big change on performance. https://cw.sdn.sap.com/cw/ideas/9762?back=false

Moderator note:
Edited, and removed many blank/empty lines, whoich just bloated your post Thanks, Andreas.

poojarychetan (BOB member since 2011-05-05)

system · August 9, 2012, 11:27am

Same problem on SAP BI 4 Live Office SP4

gary_scott (BOB member since 2004-12-17)

system · December 13, 2012, 1:53pm

@Gary, and which Patch level please? Current is Patch 7 for SP4.

Andreas (BOB member since 2002-06-20)

system · December 16, 2012, 2:03pm

Hi Andreas,

Vanilla SP4. No patches applied as yet. Will have a look through the ADAPT notes for the latest patches and see if any of them resolve.

Will re-update here if this is the case.

Cheers,
Gary

gary_scott (BOB member since 2004-12-17)

system · February 23, 2013, 5:29am

@gary

we are facing similar issue while inserting WebI into Excel. Crystal and Universe Query work fine.

Did you get anywhere close to figuring this one out?

Please advise.

BI4.0 Sp05

zephyrous (BOB member since 2007-01-12)

system · July 8, 2013, 7:03am

Dear All,

We are also facing the same error.

The webi report takes armd 50 - 60 secs to refresh . . . but when it comes to live office object the same takes more than 6 - 7 mins.

It gets stuck on the phase “Retrieving data from the server”.

After say abt 6 - 7 mins it finds the object and refreshes it very fast.

The problem is locating the object. The time taken just to locate the object is too huge… which is really too much…

BI 4.0 SP5 Patch 4.

Regards,

Aditya Tanak

adityatanak (BOB member since 2011-04-20)