Skip to Content
0
Former Member
Jan 29, 2015 at 09:16 AM

Webi 4.1 SSO - Error at the selection of BEX query

70 Views

Hi experts,

we have configured the SSO following the step described in the manual, but when we tried to select a BEX Query by OLAP connection in Webi, occur this error:

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>ZIS_M_01</Initial Catalog>

<Language>en_US</Language>

<Data Source>172.31.240.13</Data Source>

<Cube Type>Query</Cube Type>

<SaveLanguage>true</SaveLanguage>

<Initial Cube>ZZIS_M_01_Q020</Initial Cube>

<TargetProvider>SAPNETWEAVER7X</TargetProvider>

<NetworkLayer>SAPBW_BICS</NetworkLayer>

<Authentication Mode>2</Authentication Mode>

</Properties>

<ExtendedProperties>

<JCO_ASHOST>172.31.240.13</JCO_ASHOST>

<SapLoginMode>0</SapLoginMode>

<JCO_R3NAME>DWZ</JCO_R3NAME>

<JCO_CLIENT>001</JCO_CLIENT>

<JCO_SYSNR>01</JCO_SYSNR>

<JCO_LANG>EN</JCO_LANG>

</ExtendedProperties>

</ConnectionString>>

at java.util.concurrent.FutureTask.report(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$500(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.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:383)

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$500(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>ZIS_M_01</Initial Catalog>

<Language>en_US</Language>

<Data Source>172.31.240.13</Data Source>

<Cube Type>Query</Cube Type>

<SaveLanguage>true</SaveLanguage>

<Initial Cube>ZZIS_M_01_Q020</Initial Cube>

<TargetProvider>SAPNETWEAVER7X</TargetProvider>

<NetworkLayer>SAPBW_BICS</NetworkLayer>

<Authentication Mode>2</Authentication Mode>

</Properties>

<ExtendedProperties>

<JCO_ASHOST>172.31.240.13</JCO_ASHOST>

<SapLoginMode>0</SapLoginMode>

<JCO_R3NAME>DWZ</JCO_R3NAME>

<JCO_CLIENT>001</JCO_CLIENT>

<JCO_SYSNR>01</JCO_SYSNR>

<JCO_LANG>EN</JCO_LANG>

</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:96)

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

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

at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processOpenSecureSession(SapBwBrowsingServiceImpl.java:190)

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

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

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

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

at javax.swing.SwingWorker$1.call(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>ZIS_M_01</Initial Catalog>

<Language>en_US</Language>

<Data Source>172.31.240.13</Data Source>

<Cube Type>Query</Cube Type>

<SaveLanguage>true</SaveLanguage>

<Initial Cube>ZZIS_M_01_Q020</Initial Cube>

<>SAPNETWEAVER7X</TargetProvider>

<NetworkLayer>SAPBW_BICS</NetworkLayer>

<Authentication Mode>2</Authentication Mode>

</Properties>

<ExtendedProperties>

<JCO_ASHOST>172.31.240.13</JCO_ASHOST>

<SapLoginMode>0</SapLoginMode>

<JCO_R3NAME>DWZ</JCO_R3NAME>

<JCO_CLIENT>001</JCO_CLIENT>

<JCO_SYSNR>01</JCO_SYSNR>

<JCO_LANG>EN</JCO_LANG>

</ExtendedProperties>

</ConnectionString>>

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

... 16 more

The SSO works correctly on Analysis for OLAP.

The Authentication used is the SAP authentication.

Thanks.

Andrea