Skip to Content
0
Former Member
Apr 22, 2016 at 08:36 AM

BO 4.1 SSO Issue Webi

128 Views

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