Error when open BICs OLAP connection in Web intelligence

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

alexdc12 · ‎2014 Apr 22

I Too am facing this issue, I have had a message raised with SAP for 2 months almost.

I can recreate the error every time when creating a new user.

I Currently am facing the issue myself as my BW password changed today, Not sure how long it takes to figure out it changed but I have updated the Users and alias' for SAP etc.

Previous attempts that have fixed this, were to turn on tracing on the APS Core server (Worked once) restart the APS Core server( Worked once)

There is a BUG somewhere in the BI Platform and its making my job very difficult!

Former Member · ‎2014 Apr 02

I had a simular issue, openned aa SAP Ticket and this was the solution

Our basis team divided our APS servers into many server for performance reasons, and in that process they forgot to include the

Security Token Service.

And as soon as we added that to the same server where our DSL bridge was, it started working.

Hopefully it would do tha trick for you too.

Best

Leandro

Henry_Banks · ‎2011 Oct 17

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

bhat_vaidya2 · ‎2011 Oct 17

I checked with other queries and there was no issue. Also I changed Authentication from Prompt to Pre-Defined.

thanks

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My SAP Profile

My SAP Profile

Error when open BICs OLAP connection in Web intelligence

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (4)

Answers (4)