2078772 - Various intermittent errors when refreshing dashboard based on BI Web service (BIWS) in BI Launchpad

SAP Knowledge Base Article - Public

2078772 - Various intermittent errors when refreshing dashboard based on BI Web service (BIWS) in BI Launchpad

Symptom

  • Several errors when refreshing dashboard based on BI Web service connections
  • Error: An internal error occurred while calling 'getSessionInfosEx' API. (Error:ERR_WIS_30270)
  • Error: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException

Environment

  • Dashboard 4.1 SP03
  • BI 4.1 SP03

Reproducing the Issue

  1. Create a WEBI report.
  2. Create 2 - 3 BI Web Services on top of that WEBI report.
  3. Schedule the WEBI report, so the data could be retrived from the latest instance.
  4. Create dashboard by importing the Web Services created in Step 2.
  5. In the Connection settings in Dashboard Designer, make the input Parameter - "getFromLatestDocumentInstance" as True or 1.
  6. Run the Dashboard and keep refreshing it. 
  7. Error is re-produced.

Cause

The issue is due to webi reports not being scheduled the right way. Webi reports should be scheduled via Publishing, when used in Dashboard via BI Web Services.

Resolution

When connecting Dashboard to BI Web Service (Latest Instance), follow the steps below to get the correct data, especially the steps about Publication.

  1. Create a WEBI Report, that will be used for BI Web Service (BIWS)
  2. Create a new publication on the WEBI report created (Enterprise Recipient: Select User Group, Destination: Default Enterprise Location and BI Inbox). For 'Show options for selected Destinations’ select BI Inbox and enable Send As Shortcut.

 BIWS_Blog.jpg

3. Publish the report block as a web service.

4. Create a dashboard using the WSDL URL obtained.

  1. In Dashboards use the QAAWS option to call the webservice .Use Get method.
  2. Map or enter the credentials.
  3. In connections have set getFromLatestDocumentInstance and GetFromUserInstance to True.
  4. Set Refresh before Components are loaded.
  5. Map the output.
  6. Rest all are the default options.

5. Schedule the publication.

6. View the instance from BI Inbox and the result in the dashboard. It should be same.

7. Now change the data in db.

8. Schedule the publication again and view the instance in Inbox ,also view the dashboard.

Keywords

Scheduled BIWS, Get latest instance, BI Web service connections, Error:ERR_WIS_30270, intermittent errors, getSessionInfosEx, CommunicationException, Dashboards, Xcelsius , KBA , inconsistent , latestinstance , getfromuserinstance , getfromlatestinstance , BI-RA-XL-DSL , Dashboards, design-time, design on multi-source , Problem

Product

SAP BusinessObjects Dashboards 4.1