1777096 - No values for SAP NetWeaver BW connection / Error #2032 / unable to get list of universes in Dashboards when using https / SSL

SAP Knowledge Base Article - Public

1777096 - No values for SAP NetWeaver BW connection / Error #2032 / unable to get list of universes in Dashboards when using https / SSL

Symptom

  • No input values and output values appear for SAP NetWeaver BW connection in Data Manager of Dashboards Design if SAP BW is configured with SSL.
  • Error #2032 error when refreshing Web services using https
  • Unable to get list of universes in query browser when accesssing the BOE server configured with SSL.
  • If you run Fiddler in the background then the workflow is successful.

Environment

  • Dashboards 4.0 Support Package 04
  • SAP NetWeaver Business Warehouse 7.3
  • Adobe Flash Player ActiveX 11.4

Reproducing the Issue

Workflow 1:

  1. Launch Dashboards Design
  2. Go to Data menu and select Connections
  3. Add SAP NetWeaver BW connection
  4. Click on Browse button and login to BW system
  5. Select BEx query

no io.JPG

Workflow 2:

  1. Launch Dashboard Designer
  2. Go to Query browser and click on 'Add query'
  3. In the authentication window, enter the details of a BI4 server configured with SSL
  4. Click 'Next'
  5. Error: "Failed to connect to the BI platform. If this error keeps occurring then refer to SAP Note 1668437 for troubleshooting"

Cause

  • This issue occurs if SSL (Secure Sockets Layer) is implemented on servers and SSL certificate is missing on client machine.

 

Resolution

  • Deploying SSL certificate on client machine resolves the issue:

http://windows.microsoft.com/en-gb/windows/import-export-certificates-private-keys#1TC=windows-7

N.B: if using web services with https, ensure to re-import the web services url in data manager

See Also

What is SSL (Secure Sockets Layer protocol)?

  • SSL protocol ensures secure transactions between servers and browsers/client tools. 
  • This protocol uses a third party, a Certificate Authority (CA), to identify one end or both end of the transactions.
  • SSL Certificates are deployed on both server side and client side.

When Fiddler is running in the background, it works fine since Fiddler is installing a dummy certificate onto the client machine. (For more information, refer to http://www.enhanceie.com/fiddler/help/httpsdecryption.asp )

Keywords

2032, https, ssl, cannot access external data universes query browser add query , KBA , BI-RA-XL-DSL , Dashboards, design-time, design on multi-source , Problem

Product

SAP BusinessObjects Dashboards 4.0