Skip to Content
author's profile photo Former Member
Former Member

BW Portal problems

We have a report that is not working correctly. We have a report on a BW portal that users enter in the parameters for the query and the report is supposed to display on the screen .Sometimes the report shows up and sometimes it does not. The user gets the "clocking" or rotating gear like symbol and the page never returns. Sometimes they get the report within 2 or 3 minutes. We can see the processing on the back end BW system without any problems.

There are no error messages returned to the page. Log files show no timeouts or errors. The page will show the "clocking" symbol forever if you do not close the browser. We have determined that it is not a large amount of data and the portal server is not running out of memory or processes.

The best data we can find on the problem so far is that it seems to be stuck in this component:

BICS_PROV_GET_RESULT_SET.

Any ideas? Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Aug 24, 2011 at 07:40 PM

    Is your report working properly with same selection criteria if you run it in TA RSRT in BW backend?

    What version of BW you are running?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2011 at 07:56 PM

    I am not sure but the message you have given seems to suggest that the issue is with the BICS configuration and the JAVA Stack in the BW system.

    Check the JAVA WAS in the BW system and see if there are any issues there. You should be able to get a log for the same.

    Also try changing the timeouts on the portal to force a timeout on portal.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2011 at 08:32 PM

    The report runs fine every time in RSRT on back end. We are running this on BW:

    SAP_BW 701 0006 SAPKW70106 SAP Business Warehouse

    I can't find anything wrong on the Java WAS. The log files do not show errors when this occurs.

    Where can you do BICS config? Not sure what timeout to change because there are so many. Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.