Skip to Content

BO 4.1 SP6 Refresh blocked (Webi)

Jan 25 at 09:19 AM


avatar image


I have a problem with a client, which uses BO 4.1 SP6.

The anomaly is present on a Webi document, which includes 10 requests, there is also a prompt, which allows you to select a period.

When it is refreshed by the user (1 year period), the update seems to be blocked on the "refreshing data" page (The query is executed on the Oracle database, but the update at BO level is not performed after the end of the execution).

The problem is not present if the browser (IE, Firefox or chrome) is launched in administrator mode.

In addition, there is no problem if the user selects a shorter period (for example 6 months) or if we use the Rich client.

Do you have an idea of the cause of this problem?

Thanks in Advance,

Cros Franck

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Denis Konovalov
Jan 25 at 01:03 PM

So the question is - what is the difference in browser functionality between running it in user mode vs. administrator mode.
My guess it has to do with UAC settings and access to resources.

10 |10000 characters needed characters left characters exceeded
Jan 25 at 09:30 AM

It seems issue is with data volume.Check how many records are in the database for 1 year duration.Seems because of data volume report is taking much more time.

Copy the webi report sql and run on database directly and see how much time sql query is taking at database level

other option you can try to schedule the report in BI Launch pad and see how much time report is taking.

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Query execution at the database level is not a problem, even over a period of 1 year (about 2 or 3 minutes).


schedule the same report in BI lauch pad and check the timing.


There is no problem when the document is scheduled.


it means issue is only with webi rich client?Your BO client and BO server are on same service pack level BI 4.1 SP06?

if data volumne is huge then run the report in structure mode and see.