Skip to Content
avatar image
Former Member

Single sign on between EP and BI

Hi Experts.

Here i have problem with SSO between EP and BW 7.0.

We have implemented BI-IP templete installer while ago it worked fine but now it is giving error message saying.SYSTEM RECEIVED AN EXPIRED SSO TICKET.

I checked all the certificate in portal and visual admin they have long period to expire.Even i reimported all the certificates between portal and Bi system and tested the connection.

I am getting the same error mesage.

Do i need to do any setting in system landscape of SAP BI system like coneection,logon tickets type and any other properties related SSO

When i am doing test in BW system using RSPOR_SETUP program.

Status 12: Maintain User Assignment in Portal System failure during call of function module RSWR_RFC_SERVICE_TES

This is the message i am getting.I tested all the RFC connection between portal and BI .Everything is looks fine.

Could anyone answer for this question that would be great help.we need to do it this in all DEV.QUA and PRD systems.

Regards

Janakiram

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 13, 2009 at 01:30 AM

    Janakiram,

    My 2 cents. If you have already deleted and reimported the certificates, then it could be a problem with the time synchronization between the server OS and SAP. Check to make sure that they are the same. I don't know your landscape, so I cannot be absolutely sure that the time is/isn't the problem here. Also, if you are in the US, the change in DST could've triggered this off.

    Where do you see the error ? In the default trace ? Go ahead and post the complete error and some more detailed information about how you get the error and/or steps that you do before you get the error.

    Check Note 947376; could help. Especially point 3.

    Kunal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kunal..

      Nice to see your reply..

      I have checked all the settings as per note 947376 POIT 3.Every thing is in place.I did not see any inconsistency.

      if you are in the US, the change in DST could've triggered this off.

      I did not understand this point could you please explain briefly about this .What exactly i need to do here.

      #1.5^H#C0000A4ED6B600000000000100A33CE2000458290B8B90D0#1222833217440#com.sap.engine.services.adminadapter.gui.tasks.LoginTask##com.sap.engine.services.admina

      dapter.gui.tasks.LoginTask#######Thread[Thread-3,5,main]##0#0#Error#1#/System/Server/VisualAdministrationTool#Java###Error while trying to login to amdssapjep

      : Cannot authenticate the user.

      [EXCEPTION]

      #1#com.sap.engine.services.security.exceptions.BaseLoginException: Cannot authenticate the user.

      at com.sap.engine.services.security.login.ModulesProcessAction.run(ModulesProcessAction.java:178)

      at java.security.AccessController.doPrivileged(Native Method)

      at com.sap.engine.services.security.login.FastLoginContext.login(FastLoginContext.java:181)

      at com.sap.engine.services.security.remoteimpl.login.RemoteLoginContextHelperImpl.login(RemoteLoginContextHelperImpl.java:72)

      at com.sap.engine.services.security.remoteimpl.login.RemoteLoginContextHelperImplp4_Skel.dispatch(RemoteLoginContextHelperImplp4_Skel.java:64)

      at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:319)

      at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:200)

      at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:136)

      at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

      at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

      at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

      at java.security.AccessController.doPrivileged(Native Method)

      at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102)

      at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172)

      Caused by: com.sap.engine.services.security.exceptions.BaseLoginException: Authentication did not succeed.

      at com.sap.engine.services.security.login.ModulesProcessAction.run(ModulesProcessAction.java:175)

      ... 13 more

      -


      predecessor system -


      com.sap.engine.services.security.exceptions.BaseLoginException: Cannot authenticate the user.

      at com.sap.engine.services.security.login.ModulesProcessAction.run(ModulesProcessAction.java:178)

      at java.security.AccessController.doPrivileged(Native Method)

      at com.sap.engine.services.security.login.FastLoginContext.login(FastLoginContext.java:181)

      at com.sap.engine.services.security.remoteimpl.login.RemoteLoginContextHelperImpl.login(RemoteLoginContextHelperImpl.java:72)

      at com.sap.engine.services.security.remoteimpl.login.RemoteLoginContextHelperImplp4_Skel.dispatch(RemoteLoginContextHelperImplp4_Skel.java:64)

      at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:319)

      at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:200)

      at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:136)

      at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

      at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

      at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

      at java.security.AccessController.doPrivileged(Native Method)

      at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102)

      at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172)

      Caused by: com.sap.engine.services.security.exceptions.BaseLoginException: Authentication did not succeed.

      at com.sap.engine.services.security.login.ModulesProcessAction.run(ModulesProcessAction.java:175)

      ... 13 more

      how you get the error and/or steps that you do before you get the error

      I have assigned BEX roles to the users when they are try to execute BEX Web application from portal we are getting the error

      message:

      Regards

      Janakiram

  • avatar image
    Former Member
    Nov 13, 2009 at 01:32 AM

    Hi,

    If your portal system is the ticket issueing system then check the portal certificate.

    Also check if there is any time differnece between two sytems?

    If your bi system is a ticket issuing system then check the certificate. Did you import the portal certificate into your

    bi system and add this into ACL? Also check the validity time of the certificate generally it will be 8 hrs.

    Regards,

    Vamshi.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 11, 2010 at 12:48 PM

    Hi

    Do you use JCo connection for this SSO to BW ?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12, 2010 at 09:53 AM

    Hi Janakiram,

    Please check below document if your problem has not resovled. this is very good doc's for Single sign on between EP and BI configurations.

    Click here BI [Configuration|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00c4742a-3a4b-2b10-b4ae-b03d08bcde6e?overridelayout=true].

    Hope this will helps you.

    Thanks

    Arun Jaiswal

    Add comment
    10|10000 characters needed characters exceeded