cancel
Showing results for 
Search instead for 
Did you mean: 

webi report keep on refreshing

Ganesha
Participant
0 Kudos

hello Everyone,

we have one strange webi performance issue, webi report based oracle database is refreshed successfully in 6-8 minutes for some users, but few users it keep on refreshing and never end... we have checked SQL query execution at back end, even after the response from database webi report is keep on refreshing...there is no user based data level security in database as well in universe..

It seems to client side or WIPS memory leakage, if we change universe parameter, does it helps???

we are using BO4.1 SP05 Patch 3.

do you have any input on this issue???

Regards,

Ganesh

Accepted Solutions (0)

Answers (2)

Answers (2)

CdnConnection
Active Contributor
0 Kudos

Ganesha,

     Depending on ## of rows being retrieved you may want to change connection settings to increase the Fetch Array, see example below for large queries.

Regards,

Ajay

amitrathi239
Active Contributor
0 Kudos

Hi,

Edit the universe connection and check the connection pool mode.If  "Keep the connection alive for whole session" option is not selected then select this and try.

Amit

Ganesha
Participant
0 Kudos

Hello All,
one of the reason why the report is keep refreshing for some user is:

In our platform, we have increased BI Launchpad/CMC session time out is one hour, When users just close the browser without doing log off, those users inactive session will open for next one hour, when again user open BI launchpad, new session is opens..... doing like this when user keeping so many inactive sessions in BI plate from and then when user try to refresh big report then user face this problem of keep on refreshing, this issue only for Big WEBI report which normally runs more than 8-10 minutes.

The solution proposed is, user should always do log off instead just close browser.

But ideally when user close the browser, user session should close automatically  But why it is waiting till time-out, do we have any option that make user session ends when user close browser.

Regards,

Ganesh

former_member185603
Active Contributor
0 Kudos

This feature is included in SP6 onwards. Session is closed when the user closes the browser

Check SP6 relase notes

SAP BusinessObjects Business Intelligence platform 4.1 – SAP Help Portal Page

Ganesha
Participant
0 Kudos

thanks for the info.

which note is related one???

Regards,

Ganesh