Analysis for Office SSO issues (HTTP request unouthorized, SSO ticket expired)

[Former Member]

Hello,

We configured Windows AD SSO and SAP BW SSO, both working fine so far with BO Analysis for office (BO 4.1 SP1 Patch3, Analysis for Office 1.4).

Unfortunately after a while of inactivity (around 30-60min) in the excel client, the users receive the following error message when inserting a new query in analysis for office. I assume that it's a timeout issue, but I already increased the session.timeout-parameter in dsws.properties.

Any other ideas what the reason for that error could be? Thanks!

Log Entries:

- Error:

General .NET Exception:

The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate'.The remote server returned an error: (401) Unauthorized.

and also sometimes

>> General .NET Exception:

System received an expired SSO ticket

   at SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()

   at SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count)

   at SAP.Middleware.Connector.RfcConnection.ReadRfcIDBegin(Int32& length)

   at SAP.Middleware.Connector.RfcConnection.ReadUpTo(RFCGET readState, RfcFunction function, RFCID toRid)

   at SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)

   at SAP.Middleware.Connector.RfcConnection.ConnectAsClient(RfcDestination destination, Boolean forRepository)

[IngoH · Accepted solution]

Hello Hans,

I would suggest you check with your BW admin on the logout based in inactivity as that is a configuration on the BW backend. You should see the same behavior when you login with the SAP GUI.

regards

Ingo Hilgefort

[former_member184682]

hello

was this solved

we have the same problem now . increasing the session timeout in the dsws does not help

[torsten_wirth]

For us the <session-timeout> in tomcat_home/conf/web.xml was the solution.

[Former Member]

Hi Hans,

have you tried to insert the parameter "session.timeout" to dsws.properties in "X:\SAP BusinessObjects\tomcat\webapps\dswsbobje\WEB-INF\classes"? It is described in SAP NOTE: 1917624 - How to increase session timeout for Web Service in BI 4.0 or BI 4.1

Best Regards, Benni

[Former Member]

We solved this once by replacing the BOESystems.xml file in the users machine with the copy from the BO Server.