SAP Knowledge Base Article - Preview

2156919 - Receive various errors possibly only affecting some reports or connections when using SSO (specifically STS) to connect to SAP BW

Symptom

  • Receive the following error inn webi when connecting to BEX connection in BI launchpad. Connection is set for SSO, and user is forced to use STS via KBA 1767629 

sts CAPS.jpg

full error is 

"com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: [[error.openSapBwBrowsingSessionFailed] 0] <<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ConnectionString>

<Properties>
<Initial Catalog>Z_BOBJ</Initial Catalog>
<Language>en_US</Language>
<Data Source>BW application or message server</Data Source>
<Cube Type>Query</Cube Type>
<SaveLanguage>true</SaveLanguage>
<Initial Cube>REYTEST001</Initial Cube>
<TargetProvider>SAPNETWEAVER7X</TargetProvider>
<NetworkLayer>SAPBW_BICS</NetworkLayer>
<Authentication Mode>2</Authentication Mode>
</Properties>
<ExtendedProperties>
<JCO_ASHOST>BW application or message server</JCO_ASHOST>
<SapLoginMode>0</SapLoginMode>
<JCO_R3NAME>lower case server</JCO_R3NAME>
<JCO_CLIENT>client#</JCO_CLIENT>
<JCO_SYSNR>00</JCO_SYSNR>
<JCO_LANG>EN</JCO_LANG>
</ExtendedProperties>
</ConnectionString>>"

  • To note IDT will not allow lower case system ID, but if you attempt to test one that was created in the CMC then you may see the following error
  • com.businessobjects.mds.olap.OlapException: Could not find a username alias for SystemId:lower case system ID see below

sts CAPS IDT.jpg


Read more...

Environment

Reproduced on multiple patches of SAP BusinessObjects Business Intelligence Platform 4.1 but could occur in all BI 4.0 $.1, and 4.x systems as it appears to be an STS standard.

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

zie single sign on sign-on automatic logon web intelligence WRC , KBA , biauth , emkb , emkba , BI-BIP-AUT , Authentication, ActiveDirectory, LDAP, SSO, Vintela , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.