Skip to Content
0
Former Member
Jun 09, 2009 at 06:23 PM

Issue with SSO using SAP credentials (BO XI R3.1) from InfoView

61 Views

We are getting an error when using u201CUse Single Sign On when refreshing reports at runtimeu201D. <p>

Error message is: "A database error occurred. The database error text is: Unable to connect to SAP BW server Incomplete logon data. (WIS 10901).u201D

<p>

Steps to recreate the issue:

<p>

1) Follow steps in u2018SAP Integration Kit Install and Configuration Guideu2019 (install SAP Transports, etc)<p>

2) Created an SAP u2018testidu2019 that has access specified in step 1.<p>

3) Logged in to BW directly using u201Ctestidu201D and confirmed access to query u201Cxyzu201D<p>

4) Enable SAP Authentication in the CMC, Imported SAP roles, and gave u2018testidu2019 full access to Designer and InfoView. <p>

5) Logged in to Designer and InfoView using SAP Authentication with user: u201Ctestidu201D.<p>

6) Created a connection to SAP BW Query using the u201CUse specified username and passwordu201D option and were successfully able to test the connection in designer. <p>

7) Created OLAP universe using connection created in step 6, saved and exported.<p>

8) Logged in to InfoView and created new WebI report using universe from step 7. Successfully executed the report with fresh data<p>

**************************************************************************************************<p>

  • At this point, we know our connection is good and the SAP credentials are valid***<p>

***Next, we want to now change the connection type to use SSO ************************<p>

**************************************************************************************************<p>

9) Logged in to Designer with u201Ctestidu201D, imported universe, edit connection and changed from u201CUse specified username and passwordu201D to u201CUse Single Sign On when refreshing reports at runtimeu201D.<p>

10) Upon changing the connection type and saving, used the u201CTest Connectionu201D button and it works fine<p>

11) Saved the universe and re-exported.<p>

12) Logged in to InfoView using SAP Authentication and "testid", we attempt to execute previously saved report and get the following error: "A database error occurred. The database error text is: Unable to connect to SAP BW server Incomplete logon data. (WIS 10901).u201D<p>

Questions: <p>

a) If Java Connector was not installed properly, would we even be able to get this far?<p>

b) Are there some log file we can check to get further details on the failure<p>

c) Is there another way/place to check SSO is working?<p>

d) Anyone experience the same problem and find a solution? This was tried on several machines.<p>

  • Additional Details*****<p>

- We are not running any fixpacks, as none of the release notes mention our problem.<p>

- SAP Credentials were used as defined in the SAP System "testid", we have also tried logging in using the id assigned in BO. Example: "R37~800/testid" and still not working<p>

- we are not using a message server<p>

- SAP GUI is installed (7.10 Patch 6) as noted above. We are able to connect to BW via designer using "specified user and password"