Skip to Content
avatar image
Former Member

webi report keep on refreshing

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 20, 2015 at 02:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2015 at 01:02 PM

    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


    Add comment
    10|10000 characters needed characters exceeded