Skip to Content
0

Accessing HANA from Webi using "SAP HANA" datasource in BOE 4.2 error

Jan 27, 2017 at 09:46 AM

156

avatar image

Hi, we run HANA 1.00.122.03.1475845474 (fa/hana1sp12) and BOE 4.2SP3P3. A user with ODBC/JDBC access and role RESTRICTED_USER_xxxx_ACCESS and Object privileges SELECT for some databases.

I created a relational JDBC connection in IDT using this user. The test button say's that the connection works. Look good.

I start Webi and try to create a new report based on "SAP HANA" data source. I am able to browse the connections and I see my predefined connection.

When I try to select it the following error pops-up:

java.util.concurrent.ExecutionException: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Fehler beim Abrufen des Root-Knotens.
Ursache: com.businessobjects.mds.olap.protocol.QueryRunnerException: com.sap.connectivity.cs.java.drivers.DBDError: SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at javax.swing.SwingWorker.get(SwingWorker.java:602)
at com.sap.webi.ui.dialog.bex.OpenBexPanel.endFetchNode(OpenBexPanel.java:927)
at com.sap.webi.ui.dialog.bex.OpenBexPanel.propertyChange(OpenBexPanel.java:1151)
at java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:335)
at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:327)
at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport.firePropertyChange(SwingWorker.java:854)
at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport$1.run(SwingWorker.java:860)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(SwingWorker.java:832)
at sun.swing.AccumulativeRunnable.run(AccumulativeRunnable.java:112)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(SwingWorker.java:842)
at javax.swing.Timer.fireActionPerformed(Timer.java:313)
at javax.swing.Timer$DoPostEvent.run(Timer.java:245)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
at java.awt.Dialog.show(Dialog.java:1084)
at com.jidesoft.dialog.StandardDialog.show(Unknown Source)
at java.awt.Component.show(Component.java:1673)
at java.awt.Component.setVisible(Component.java:1625)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at com.sap.webi.toolkit.ui.dialog.GenericDialog.setVisible(GenericDialog.java:128)
at com.sap.webi.ui.dialog.bex.OpenBexDialog.setVisible(OpenBexDialog.java:109)
at com.sap.webi.ui.data.BexQueryDataSourceProvider.createDataSourceInfo(BexQueryDataSourceProvider.java:75)
at com.sap.webi.ui.context.managers.DataManager.createDataSourceInfo(DataManager.java:389)
at com.sap.webi.ui.tasks.workflows.CreateDataSourceInfoUITask.doneProcess(CreateDataSourceInfoUITask.java:131)
at com.sap.webi.toolkit.ui.tasks.WebITask$PrivateWorker.done(WebITask.java:378)
at javax.swing.SwingWorker$5.run(SwingWorker.java:737)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(SwingWorker.java:832)
at sun.swing.AccumulativeRunnable.run(AccumulativeRunnable.java:112)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(SwingWorker.java:842)
at javax.swing.Timer.fireActionPerformed(Timer.java:313)
at javax.swing.Timer$DoPostEvent.run(Timer.java:245)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Fehler beim Abrufen des Root-Knotens.
Ursache: com.businessobjects.mds.olap.protocol.QueryRunnerException: com.sap.connectivity.cs.java.drivers.DBDError: SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.
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.relational.browsing.service.RelationalBrowsingServiceImpl.processDoIt(RelationalBrowsingServiceImpl.java:250)
at com.sap.sl.sdk.relational.browsing.service.RelationalBrowsingServiceImpl.processInvocation(RelationalBrowsingServiceImpl.java:232)
at com.sap.sl.sdk.relational.browsing.service.RelationalBrowsingServiceImpl.getRootNodes(RelationalBrowsingServiceImpl.java:100)
at com.sap.webi.ui.dialog.bex.ExpandRelationalItemWorker.doInBackground(ExpandRelationalItemWorker.java:33)
at com.sap.webi.ui.dialog.bex.ExpandRelationalItemWorker.doInBackground(ExpandRelationalItemWorker.java:10)
at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at javax.swing.SwingWorker.run(SwingWorker.java:334)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.businessobjects.sdk.core.server.ServerException: Fehler beim Abrufen des Root-Knotens.
Ursache: com.businessobjects.mds.olap.protocol.QueryRunnerException: com.sap.connectivity.cs.java.drivers.DBDError: SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.
at com.sap.sl.sdk.requests.doit.DoItRequestHandler.afterProcessing(DoItRequestHandler.java:50)
... 14 more

Do you have any idea how to solve this error?

Thx in advance

Stephan

10 |10000 characters needed characters left characters exceeded
Former Member

Hi Stephan

Did you find the reason for the above error and the solution to fix this? I'm having exactly the same issue with BOE but the connection validates fine from Information Design Tool and does show me the schemas and tables.

Will appreciate your help.

Thanks

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Jun 15, 2017 at 06:31 PM
0

Hi,

Check if you have latest version of JAVA installed on your local machine.

Verify Java properties.

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded