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

[Former Member]

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>

😎 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"

[former_member142702 · Accepted solution]

Hi Mike,

do you use a full domain name for your BOBJ server in the InfoView URL you open in your browser?

Regards,

Stratos

[Former Member · Accepted solution]

Our logon to InfoView has the following:

http://myserver99:8080/InfoViewApp/logon.jsp

[former_member142702 · Accepted solution]

Hi,

please try to use the full qualified domain name in the URL and see if the error persists.

eg. http://bobjserver.SAP.COM:8080/InfoViewApp

Regards,

Stratos

[Former Member · Accepted solution]

we tried using the fully qualified domain name and the error persists.

[former_member142702 · Accepted solution]

Hi,

can you please check one more thing. Did you define the application server (BW Server) in the universe connection using the full qualified name or not? Is this the same domain where your BOBJ server also resides?

Regards,

Stratos

[Former Member · Accepted solution]

yes, same domain. I added the fully qualified domain name in the universe connection and the error persists.

[former_member142702 · Accepted solution]

Hi,

I have solved a similar problem (same error message) with a CR report using an SAP BW source, so I thought it may help also in your case.

Can you restart your webI services and retry? I just want to make sure that the new version of the universe is retrieved.

Regards,

Stratos

[Former Member · Accepted solution]

no problem. I appreciate the help

Restarted WebI services and retried. same error.

Also tried creating a new connection and same error occurs

[IngoH · Accepted solution]

Hi,

might be not an important question but is this done with TEMP keycodes or full keycodes ? in case it is temp keycodes can you check that the keycodes for the SAP Integration kit did not expire ?

thanks

Ingo

[Former Member · Accepted solution]

we are running the full keycode and are not getting any error messages related to expired keys.

the error persists

==========

my original post had the following questions... any ideas on these questions?

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

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

c) Is there another way/place to check SSO is working? (manual or otherwise)

Edited by: MIghty Mike on Jun 9, 2009 10:43 PM

[ImtiazKaredia · Accepted solution]

Hi,

Is your SSO setup correctly on SAP.

Can you check in SAP ->Tcode STRUSTSSO2 , whether the logon tickets are accepted from your BOE machine.

Did you import BOE certificate in SAP Access control list in STRUSTSSO2.

[IngoH · Accepted solution]

Hi Mighty, Hi Imtiaz

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

>> no. if JCo would not be deployed properly you would not be able to import the roles and logon with SAP Credentials to InfoView

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

>> see below

c) Is there another way/place to check SSO is working? (manual or otherwise)

>> see below

Imtiaz: SSOTRUST and is not needed here because the BOE Server is passing it on.

just to clarify a couple of items:

- you are able to logon to InfoView and CMC with your SAP Credentials

- I assume you entered all the correct SYSTEM ID and CLIENT numbers and not some testing IDs

- does the user have the necessary rights to create reports with Web Intelligence ?

- can you create Web Intelligence reports based on other data sources like the sample universes without any issues ?

thanks

Ingo

[Former Member · Accepted solution]

>

> Hi Mighty, Hi Imtiaz
> 
> 
> a) If Java Connector was not installed properly, would we even be able to get this far?
> 
> >> no. if JCo would not be deployed properly you would not be able to import the roles and logon with SAP Credentials to InfoView
> 
> b) Are there some log file we can check to get further details on the failure
> 
> >> see below
> 
> c) Is there another way/place to check SSO is working? (manual or otherwise)
> >> see below
> 
> Imtiaz: SSOTRUST and is not needed here because the BOE Server is passing it on.
> 
> 
> just to clarify a couple of items:
> 
> - you are able to logon to InfoView and CMC with your SAP Credentials
> 
> - I assume you entered all the correct SYSTEM ID and CLIENT numbers and not some testing IDs
> 
> - does the user have the necessary rights to create reports with Web Intelligence ?
> 
> - can you create Web Intelligence reports based on other data sources like the sample universes without any issues ?
> 
> 
> thanks
> Ingo

answer to your questions:

- Yes, I am able to log on to CMC using my SAP credentials, which is same userid that I create the connection and universe with.

- Yes, I did enter all the correct System ID and Client information. I have no problems connecting to BW using same userid, as well as in BO when I am using "specified username and password", it is only when I am using "Use Single Sign On when refreshing reports" that it does not work

- Yes, this user can create reports in Web Intelligence when using "specified username and password", which confirms his rights are sufficient, it is only when trying to use sso that this problem occurs.

- Yes, This user is able to create universe and webi reports with sap and non sap data sources when using "specified username and password"

[IngoH · Accepted solution]

Hi,

whats the version and fixpack level for the BusinessObjects products ?

take a look here:

Ingo

[Former Member · Accepted solution]

The other issue is slightly different. I installed patches and the issue still persists.

Their scenario is that they could not create a connection at all when choosing the SSO option in designer, whereas my issue is that piece works fine for me. It is not until I save and export the universe and connection with SSO setting and then try to run the report from InfoView where it does not work.

I am checking the authorization objects and going to turn on BO trace logs as my next steps.

[IngoH · Accepted solution]

can you run any non-SAP universes with Web Intelligence reports without any issues ?

Do you have Crystal Reports as well ? Does SSO work for those inInfoView ?

Ingo

[Former Member · Accepted solution]

>

> can you run any non-SAP universes with Web Intelligence reports without any issues ?
> 
> Do you have Crystal Reports as well ? Does SSO work for those inInfoView ?
> 
> Ingo

Yes, I am able to run all other non-SAP universe and reports on them without any problems. Again, it is important to understand, we can connect to SAP universe without any problems when using a connection with type "specified user name and password", it is only when we set the connection as "Use Single Sign On" and then attempt to run the report via InfoView that we have this problem.

We also tried fresh install of all the client side tools on another machine, the entire client tools suite, sap integ kit, etc and it did not work still.

We have not tried SSO with Crystal, though Crystal to BW would not use a universe, hence there would be no connection to configure in a uninverse, so I dont know if that would be an equal test. I will check into SSO from Crystal side and respond back.

[IngoH · Accepted solution]

HI,

which versoin and fixpack of BusinessObjects are you using ?

Ingo

[Former Member · Accepted solution]

Although the release notes do not identify my issue, I did install the following fix packs:

BO XI 3.1 Client Tools - FP 1.2

BO XI 3.1 Integration Kit for SAP - FP 1.2

[Former Member · Accepted solution]

I just installed Fix Pack 1.3 for BO Client Tools as well as Fix Pack 1.3 for SAP Integration Kit....

The problem still occurs in FP 1.3.

Edited by: MIghty Mike on Jun 17, 2009 8:41 PM

[IngoH · Accepted solution]

Hi,

just to clarify :

- does the SSO work in InfoView ?

- does SSO work in the Universe Design ?

ingo

[Former Member · Accepted solution]

- does SSO work in the Universe Design ?

1) Logging in to Designer using authentication type "SAP" works fine...

2) While in Designer and during creation of the connection......We select SSO as the connection type, we are able to view the BW query and cubes, point to the object, save the connection. Once it is saved, we then select the "Test" button... the response is always "Server Responding". We are then able to create, save and export the universe. (Keep in mind, it is reading the Query/Cube metadata, but not executing the BW query).

- does the SSO work in InfoView ?

1) Logging in to InfoView using authentication type "SAP" works fine...

2) While in InfoView and creating a new WebI report via Universe (with SSO connection type), the WebI report fails with message: "DBD:Unable to connect to SAP BW server Incomplete logon data"

[IngoH · Accepted solution]

do you have the SAP GUI on the server ?

or Crystal Reports ?

thanks

Ingo

[Former Member · Accepted solution]

Yes, SAP Gui is installed on the server.

Being that we can execute a report using an OLAP universe, built on a BW query when using a connection type "specfied user id and password" aka hard coded, confirms the required SAP Gui, Client Tools, Integration kit are installed and it can connect. It is only when using the SSO method that causes the failure. We also tried this from the BO server.

=======================================

BW system logs report an RFC connection attempt coming from the BO server, which provides further details that the connection attempt was empty and did not pass the client #, the user id or the password.

Runtime Errors CALL_FUNCTION_SIGNON_INCOMPL

Short text

Incomplete logon data.

Error analysis

The logon data for the user " " is incomplete.

How to correct the error

If, during an RFC (Remote Function Call), an explicit user

or an explicit client is requested, you must enter an explicit

password for the user (see Transaction SM59).

Client.............. "###"

User................ "############"

=================================

Again, I want to be clear that this ONLY occurs when setting the connection type in Designer as "SSO". When using a specified userid and password, all works perfectly.

Edited by: MIghty Mike on Jun 18, 2009 9:14 PM

[IngoH · Accepted solution]

and you have the SAP authentication configured and it works for other tools ?

do you have Crystal Reports deployed ?

Ingo

[Former Member · Accepted solution]

Yes, Crystal is installed along with FP 1.3.

[Former Member · Accepted solution]

and you have the SAP authentication configured and it works for other tools ?

.................. SAP Authentication works properly in Designer and InfoView.

Without it configured, we wouldnt be able to use the SAP logonid in InfoView or Designer.

[IngoH · Accepted solution]

does SSO work for Crystal Reports objects via InfoView ?

Ingo

[Former Member · Accepted solution]

We dont have any built yet.

[IngoH · Accepted solution]

can you give it a quick try to exclude any general issues either on the SAP or BusinessObjects side ?

ingo

[IngoH · Accepted solution]

Hi,

what do you mean with "no built" yet ? whats your current environment ?

thanks

ingo

[Former Member · Accepted solution]

Hello

Have you resolved this issue ?

If yes could you please share the solution on this issue .I have a same issue and we are on BOXI 3.1 SP2 and fixpack 2.3 and i have a support case open form last 2 months and we are unable to figure it out .

Please help me on this .

Thanks

Rahul

Edited by: Rahul2121 on Jan 26, 2010 11:12 PM

[IngoH · Accepted solution]

Hi Rahul,

I would suggest you open a new entry and describe your problem

Ingo

[Former Member]

Hello,

We have installed SAP BI4.1 SP2 recently. It's a fresh system.

When I created a test connection to BEx query with fixed credentials, and then created a report from launchpad, it worked.

But if I change the connection type to SSO and try to use this query, then it throws error.

Please help.

-Prathamesh

[Former Member]

We have de same issue, have you found the problem?

thanks in advance