SSO - Connection failed,Make sure user mapping is set correctly and all....

[Former Member]

Hi SSO Experts,

We configured single sign on settings between EP 7.0 SPS11 and BW 3.5 according the following document:

http://help.sap.com/saphelp_nw04/helpdata/en/84/30984076b84063e10000000a1550b0/frameset.htm

We are getting a problem when we tried connection tests for the System Object Connector properties and SAP Web AS connection properties.

The test for Web AS connection was passed result

SAP Web AS Connection Test Details:

*******************************************************************

The test consists of the following steps:

1. Checks the validity of system ID in the system object.

2. Checks if the system can be retrieved from the PCD.

3. Check whether a SAP system is defined in the system object

4. Validate the following parameters: WAS protocol; WAS host name

5. Checks if the host name of the server can be resolved.

6. Pings the server to see if it is alive.

7. Pings the WAS ping service; works only if the service is activated on the ABAP WAS.

8. Checks HTTP/S connectivity to the defined back-end application

Results

******************

1. The system ID is valid

2. The system was retrieved.

3. The system object represents an SAP system

4. The following parameters are valid: Web AS Protocol (http) Web AS Host Name (HSEA-PDC-S015.hsea.com:8000)

5. The host name HSEA-PDC-S015.hsea.com was resolved successfully.

6. The server HSEA-PDC-S015.hsea.com was pinged successfully.

7. The Web AS ping service http://HSEA-PDC-S015.hsea.com:8000/sap/bc/ping was pinged successfully.

8. An HTTP/S connection to http://HSEA-PDC-S015.hsea.com:8000/sap/bw/bex was obtained successfully.

But we are getting the failed result for Connection test for Connectors.

Test Connection with Connector Test Details:

*********************************************************************

The test consists of the following steps:

1. Retrieve the default alias of the system

2. Check the connection to the backend application using the connector defined in this system object

Results

***********************

Retrieval of default alias successful

Connection failed. Make sure user mapping is set correctly and all connection properties are correct.

What may be the reason?

User mapping has done.

Both Enterprise portal and BW System are in the same domain (hsea.com).

We are using the Dedicated Application Server for R3 System (SAP_R3_Dedicated)

The Connector properties for the System Object are as follows:

**********************************************************************************

Application Host: HSEA-PDC-S015.hsea.com

Gateway Host: HSEA-PDC-S015.hsea.com

Gateway Service: sapgw00

Logical System Name: BWTCLNT600

Remote Host Type: 3

SAP Client: 600

SAP System ID (SID): BWT

SAP System Number: 00

System Type: SAP_BW

The User Management properties for the System Object are as follows:

***************************************************************************************

Logon Method: UIDPW

User Mapping Type: admin, user

The Web Application Server (WAS) properties for the System Object are as follows:

*****************************************************************************************************

Web AS Description: EP-BW for SSO

Web AS Host Name: HSEA-PDC-S015.hsea.com:8000

Web AS Path: /sap/bw/bex

Web AS Protocol: http

Please kindly analyze the problem and let us know the solution at the earliest.

Kind Regards

Abhisheik...

[former_member218672]

Hi,

Try creating a JCo whether your uidpw logon to the backend is working properly or not. JCo should be able to connect successfully if ur uidpw is correct.

Regards,

Sen

[p330068]

Hi Abisheik,

Please check the [SAP NetWeaver BI Diagnostics & Support Desk Tool |http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/15515] [original link is broken]; to find the root cause of the issue.

Refer to [Setting up BEx Web|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00c4742a-3a4b-2b10-b4ae-b03d08bcde6e?overridelayout=true] for more details.

Regards, Arun Jaiswal

[Former Member]

Hi ,

We are facing the same issue after the Portal (EP 15 - 22) support pack upgrade.

Do you have this issue resolved ?

it will be great if you share some suggestion on this issues.

Thanks and regards

Ganesh S Bhondave

[pramod_gopisetty1]

Hi,

Try running the FM in the system where you want to setup SSO.

RSBB_URL_PREFIX_GET

Execute the FM and give the correct WAS Properties. Case Sesitive.

URL Path : /sap/bw/BEx

and try doing connection test.

It should work.

Hope this helps.

Cheers-

Pramod