Skip to Content
avatar image
Former Member

BICS_PROV_GET_RESULT_SET

Hi,

I am getting the following error while running a Broadcasting Setting over a web template. This template has approximately 15 to 20 queries. I am publishing this dashboard report to the Portal.

The error is ,

Error while executing function module: BICS_PROV_GET_RESULT_SET

Message no. RSBOLAP014

Please help me to solve this error.

Regards,

Hoa

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 24, 2013 at 07:27 AM

    Hi

    (BICS_PROV_GET_RESULT_SET) is a runtime  error that occurs in the OLAP processor when the result set is retrieved. You need to isolate the query that causes the problem. Try to run each of them on its own to find out which one cause you the problems.

    Also check  if 1821462 and 1822113 are relevant for you..

    hope it helps

    Martin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2013 at 07:31 AM

    I guess its a performance issue, you can view recorded traces using the transaction RSTT or add the extension "&trace=X‟ to the url of your dashboard application and restart the application.

    So you need to validate ossnote:

    Note 598891 - Tools for analyzing SAP JCo and RFC errors in WebAS. Please check with Java Connectors.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ben,

      run the queries in RSRT  and check which query is giving error, if it gives error "Shared memory the cache overflow when writing. Check the memory settings" or "Errors found retrieving data"

      then Click "Properties" in RSRT and change cache mode to 5 Query-Aggregate Cache.

      Please refer note 1863002.

      Regards,

      Rathish