cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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

0 Likes
View Entire Topic
Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Likes

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

Former Member
0 Likes

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

m_jun
Explorer
0 Likes

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>>

--------------------------------------------