BO 4.1 SSO Issue Webi

[Former Member]

Hello,

BO 4.1 SP03 Patch 9 on Windows server

SSO is configured with SAP authentication on BW system.

OLAP connection is configured (and server information are also fine).

As long than 'Authentication' was on 'Predefined', no issues.

Now, with "SSO" I'm facing an issue.

ANALYSIS for OLAP is working fine, I can select Queries from BW.

But WEBI is not working, I'm facing error when trying to create a new report (and running an existing one), please see below the copy from error.

It is happening on WEBI rich client also.

Can you tell me how and where to check logs file that could be relevant for this on the server?

Could it be a problem with the version?

Thanks in advance.

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

   <Properties>

      <Initial Catalog>NRMCOPA02</Initial Catalog>

      <Language>en_US</Language>

      <Data Source>**IP**</Data Source>

      <Cube Type>Cube</Cube Type>

      <User ID />

      <SaveLanguage>true</SaveLanguage>

      <Password />

      <Initial Cube>NRMCOPA02</Initial Cube>

      <TargetProvider>SAPNETWEAVER7X</TargetProvider>

      <Authentication Mode>2</Authentication Mode>

      <NetworkLayer>SAPBW_BICS</NetworkLayer>

   </Properties>

   <ExtendedProperties>

      <SapLoginMode>0</SapLoginMode>

      <JCO_ASHOST>**IP**</JCO_ASHOST>

      <JCO_R3NAME>BI1</JCO_R3NAME>

      <JCO_CLIENT>100</JCO_CLIENT>

      <JCO_LANG>DE</JCO_LANG>

      <JCO_SYSNR>01</JCO_SYSNR>

   </ExtendedProperties>

</ConnectionString>>

  at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)

  at java.util.concurrent.FutureTask.get(Unknown Source)

  at javax.swing.SwingWorker.get(Unknown Source)

  at com.sap.webi.ui.dialog.bex.OpenBexPanel.endFetchNode(OpenBexPanel.java:825)

  at com.sap.webi.ui.dialog.bex.OpenBexPanel.propertyChange(OpenBexPanel.java:1036)

  at java.beans.PropertyChangeSupport.fire(Unknown Source)

  at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)

  at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport.firePropertyChange(Unknown Source)

  at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport$1.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)

  at sun.swing.AccumulativeRunnable.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)

  at javax.swing.Timer.fireActionPerformed(Unknown Source)

  at javax.swing.Timer$DoPostEvent.run(Unknown Source)

  at java.awt.event.InvocationEvent.dispatch(Unknown Source)

  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

  at java.awt.EventQueue.access$200(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

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

  at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

  at java.awt.EventQueue.dispatchEvent(Unknown Source)

  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.WaitDispatchSupport$2.run(Unknown Source)

  at java.awt.WaitDispatchSupport$4.run(Unknown Source)

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

  at java.awt.WaitDispatchSupport.enter(Unknown Source)

  at java.awt.Dialog.show(Unknown Source)

  at com.jidesoft.dialog.StandardDialog.show(Unknown Source)

  at java.awt.Component.show(Unknown Source)

  at java.awt.Component.setVisible(Unknown Source)

  at java.awt.Window.setVisible(Unknown Source)

  at java.awt.Dialog.setVisible(Unknown Source)

  at com.sap.webi.toolkit.ui.dialog.GenericDialog.setVisible(GenericDialog.java:128)

  at com.sap.webi.ui.dialog.bex.OpenBexDialog.setVisible(OpenBexDialog.java:115)

  at com.sap.webi.ui.data.BexQueryDataSourceProvider.createDataSourceInfo(BexQueryDataSourceProvider.java:95)

  at com.sap.webi.ui.context.managers.DataManager.createDataSourceInfo(DataManager.java:380)

  at com.sap.webi.ui.tasks.workflows.CreateDataSourceInfoUITask.doneProcess(CreateDataSourceInfoUITask.java:127)

  at com.sap.webi.toolkit.ui.tasks.WebITask$PrivateWorker.done(WebITask.java:378)

  at javax.swing.SwingWorker$5.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)

  at sun.swing.AccumulativeRunnable.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)

  at javax.swing.Timer.fireActionPerformed(Unknown Source)

  at javax.swing.Timer$DoPostEvent.run(Unknown Source)

  at java.awt.event.InvocationEvent.dispatch(Unknown Source)

  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

  at java.awt.EventQueue.access$200(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

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

  at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

  at java.awt.EventQueue.dispatchEvent(Unknown Source)

  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

  at java.awt.EventDispatchThread.run(Unknown Source)

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

   <Properties>

      <Initial Catalog>NRMCOPA02</Initial Catalog>

      <Language>en_US</Language>

      <Data Source>**IP**</Data Source>

      <Cube Type>Cube</Cube Type>

      <User ID />

      <SaveLanguage>true</SaveLanguage>

      <Password />

      <Initial Cube>NRMCOPA02</Initial Cube>

      <TargetProvider>SAPNETWEAVER7X</TargetProvider>

      <Authentication Mode>2</Authentication Mode>

      <NetworkLayer>SAPBW_BICS</NetworkLayer>

   </Properties>

   <ExtendedProperties>

      <SapLoginMode>0</SapLoginMode>

      <JCO_ASHOST>**IP**</JCO_ASHOST>

      <JCO_R3NAME>BI1</JCO_R3NAME>

      <JCO_CLIENT>100</JCO_CLIENT>

      <JCO_LANG>DE</JCO_LANG>

      <JCO_SYSNR>01</JCO_SYSNR>

   </ExtendedProperties>

</ConnectionString>>

  at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)

  at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)

  at com.sap.sl.sdk.requests.doit.DoItRequestHandler.afterProcessing(DoItRequestHandler.java:54)

  at com.businessobjects.sdk.core.server.internal.AbstractServer.processIt(AbstractServer.java:178)

  at com.businessobjects.sdk.core.server.internal.AbstractServer.process(AbstractServer.java:133)

  at com.businessobjects.sdk.core.server.internal.InstanceServer.process(InstanceServer.java:94)

  at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processDoIt(SapBwBrowsingServiceImpl.java:228)

  at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processInvocation(SapBwBrowsingServiceImpl.java:186)

  at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processOpenSession(SapBwBrowsingServiceImpl.java:169)

  at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.openSession(SapBwBrowsingServiceImpl.java:59)

  at com.sap.webi.ui.dialog.bex.ExpandRepositoryItemWorker.getBrowsingSession(ExpandRepositoryItemWorker.java:63)

  at com.sap.webi.ui.dialog.bex.ExpandRepositoryItemWorker.doInBackground(ExpandRepositoryItemWorker.java:40)

  at com.sap.webi.ui.dialog.bex.ExpandRepositoryItemWorker.doInBackground(ExpandRepositoryItemWorker.java:15)

  at javax.swing.SwingWorker$1.call(Unknown Source)

  at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

  at java.util.concurrent.FutureTask.run(Unknown Source)

  at javax.swing.SwingWorker.run(Unknown Source)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

  at java.lang.Thread.run(Unknown Source)

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

   <Properties>

      <Initial Catalog>NRMCOPA02</Initial Catalog>

      <Language>en_US</Language>

      <Data Source>**IP**</Data Source>

      <Cube Type>Cube</Cube Type>

      <User ID />

      <SaveLanguage>true</SaveLanguage>

      <Password />

      <Initial Cube>NRMCOPA02</Initial Cube>

      <TargetProvider>SAPNETWEAVER7X</TargetProvider>

      <Authentication Mode>2</Authentication Mode>

      <NetworkLayer>SAPBW_BICS</NetworkLayer>

   </Properties>

   <ExtendedProperties>

      <SapLoginMode>0</SapLoginMode>

      <JCO_ASHOST>**IP**</JCO_ASHOST>

      <JCO_R3NAME>BI1</JCO_R3NAME>

      <JCO_CLIENT>100</JCO_CLIENT>

      <JCO_LANG>DE</JCO_LANG>

      <JCO_SYSNR>01</JCO_SYSNR>

   </ExtendedProperties>

</ConnectionString>>

  at com.sap.sl.sdk.requests.doit.DoItRequestHandler.afterProcessing(DoItRequestHandler.java:50)

  ... 17 more

[former_member187153]

Hi,

Hope you generated BO Keytab.cert and added BW system.

Have you tested SSO using IDT, creating BICS connection with SSO option.

Are you able to connect SAP system, imported all SAP alias?

Have you configured DSL service which is added STS service etc..

Basis team can help you to find more logs if your BO request is really hitting BW queries or not.
If everything is done, try to generate new certificate and request Basis team to upload into BW system. Make they added correctly.

Regards,

Pulendar