Hello,
I got the following error message below when I tried to use web intelligence to open BICs OLAP connection.
Another issue is that I have created many BICs under Connections folder but I can only see one OLAP connection when I try to select BEX query as data source in Web intelligence.
how do I resolve the following.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Error while fetching: BEX Query_01
Java.util.concurrent.ExecutionException: com.google.protobuf.UninitializedMessageException: Message missing required fields: bytesValue
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:801)
at com.sap.webi.ui.dialog.bex.OpenBexPanel.propertyChange(OpenBexPanel.java:1009)
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.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.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
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:116)
at com.sap.webi.ui.dialog.bex.OpenBexDialog.setVisible(OpenBexDialog.java:94)
at com.sap.webi.ui.data.BexQueryDataSourceProvider.createDataSourceInfo(BexQueryDataSourceProvider.java:85)
at com.sap.webi.ui.context.managers.DataManager.createDataSourceInfo(DataManager.java:264)
at com.sap.webi.ui.tasks.workflows.CreateDataSourceInfoUITask.doneProcess(CreateDataSourceInfoUITask.java:127)
at com.sap.webi.toolkit.ui.tasks.WebITask.done(WebITask.java:123)
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.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.google.protobuf.UninitializedMessageException: Message missing required fields: bytesValue
at com.google.protobuf.AbstractMessage$Builder.newUninitializedMessageException(AbstractMessage.java:531)
at com.sap.sl.olap.sapbw.protobuf.generated.SapbwService$msgBytesValue$Builder.build(SapbwService.java:567)
at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processDoIt(SapBwBrowsingServiceImpl.java:299)
at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processInvocation(SapBwBrowsingServiceImpl.java:246)
at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processOpenSession(SapBwBrowsingServiceImpl.java:229)
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$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
thanks
Bhat
Edited by: Bhat Vaidya on Oct 17, 2011 9:18 AM
Request clarification before answering.
Hi,
we have been seeing this problem increasingly in Support. it's actually a kinda login issue.
btw - authentication type "prompt" is singularly for Analysis-OLAP use case. It won't work with WebI ..
It may be something as simple as your bw password has changed, and needs to be maintained (updated) in the OLAP .cns definition.
infact, you should be considering SAP authentication for tools, and SSO in your connections. (so that you leverage BW roles and authorization-relevant infoobjects)
importantly, i believe there is a bug in the product currently. It is linked to the Platform Search Indexing continuously crawling and intercepting the authentication step with the APS' DSLBridge service.
I'd recommend you turn OFF the Search application, create a new dedicated APS service for just DSLBridge only, + modify the old APS to remove the previous DSLBridge instance, implement SAP authentication, use SSO in the connections ...
and try again
Regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I facing a similar issue. I have created an OLAP connection to BW to leverage SSO. When I put in the fixed credentials of an SAP user I can browse through the BW environment when selecting a BEx query as dataprovider for Web Intelligence. When I set the option to use SSO it fails and I get the following error message.
Anybody any ideas? I have already created a seperate APS with the DSL bridge but no luck yet...
-
java.util.concurrent.ExecutionException: com.google.protobuf.UninitializedMessageException: Message missing required fields: bytesValue
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:801)
at com.sap.webi.ui.dialog.bex.OpenBexPanel.propertyChange(OpenBexPanel.java:1009)
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.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.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
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:116)
at com.sap.webi.ui.dialog.bex.OpenBexDialog.setVisible(OpenBexDialog.java:94)
at com.sap.webi.ui.data.BexQueryDataSourceProvider.createDataSourceInfo(BexQueryDataSourceProvider.java:85)
at com.sap.webi.ui.context.managers.DataManager.createDataSourceInfo(DataManager.java:264)
at com.sap.webi.ui.tasks.workflows.CreateDataSourceInfoUITask.doneProcess(CreateDataSourceInfoUITask.java:127)
at com.sap.webi.toolkit.ui.tasks.WebITask.done(WebITask.java:123)
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.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.google.protobuf.UninitializedMessageException: Message missing required fields: bytesValue
at com.google.protobuf.AbstractMessage$Builder.newUninitializedMessageException(AbstractMessage.java:531)
at com.sap.sl.olap.sapbw.protobuf.generated.SapbwService$msgBytesValue$Builder.build(SapbwService.java:567)
at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processDoIt(SapBwBrowsingServiceImpl.java:299)
at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processInvocation(SapBwBrowsingServiceImpl.java:246)
at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processOpenSession(SapBwBrowsingServiceImpl.java:229)
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$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Edited by: M. van Foeken on Dec 28, 2011 2:44 PM
HI, any solution to this?
even I m getting similar error when trying to connect through Bex connection in Webi.
Urgent help appreciated.
Thanks in advance
--------- ERROR MESSAGE ----
com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: [[error.openSapBwBrowsingSessionFailed] 0] <<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ConnectionString>
<Properties>
<Initial Catalog>ZFIGL_C14</Initial Catalog>
<Language>en_US</Language>
<Data Source>DSAPD247</Data Source>
<Cube Type>Query</Cube Type>
<User ID />
<SaveLanguage>true</SaveLanguage>
<Password />
<Initial Cube>ZFIGL_C14_Q0004</Initial Cube>
<TargetProvider>SAPNETWEAVER7X</TargetProvider>
<NetworkLayer>SAPBW_BICS</NetworkLayer>
<Authentication Mode>2</Authentication Mode>
</Properties>
<ExtendedProperties>
<JCO_ASHOST>DSAPD247</JCO_ASHOST>
<SapLoginMode>0</SapLoginMode>
<JCO_R3NAME>BID</JCO_R3NAME>
<JCO_CLIENT>300</JCO_CLIENT>
<JCO_LANG>EN</JCO_LANG>
<JCO_SYSNR>00</JCO_SYSNR>
</ExtendedProperties>
</ConnectionString>>
--------------------------------------------
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.