Eclipse Community Forums: BIRT » Connect MS SQL Analysis services Cubes via BIRT tool

Home » Archived » BIRT » Connect MS SQL Analysis services Cubes via BIRT tool

Connect MS SQL Analysis services Cubes via BIRT tool [message #1791830]

Thu, 05 July 2018 13:45

Eclipse User

I am using Birt report and MS-SQL cube for generation of report.

I am trying to create Data Source in Birt by configuring MS-SQL Cube. for that I followed URL ("https:// docs.microsoft.com/en-us/sql/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=sql-server-2017") to setup HTTP access to MS-SQL Cubes.

I am using org.olap4j.driver.xmla.XmlaOlap4jDriver driver to connect MS SQL Cubes through BIRT tool.

Now to design report in BIRT I have created Data Source to access existing MS-SQL Cubes via url ("jdbc:xmla:Server=http://localhost/olap/msmdpump.dll;") Ref: Capture1.PNG

Now I am creating Data Set with above Data Source "Cube" I am getting below mentioned error. Ref:Capture2.PNG, Capture3.PNG

Please suggest any solution to solve this problem.

Thanks in advance.

org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: Data Set
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[]
IConnection.getMaxQueries()

at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:355)

at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:464)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)

at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:159)

at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:142)

at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:138)

at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:120)

at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:104)

at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRuntimeMetaData(DataSetMetaDataHelper.java:196)

at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRealMetaData(DataSetMetaDataHelper.java:155)

at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getDataSetMetaData(DataSetMetaDataHelper.java:117)

at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.getDataSetMetaData(DataRequestSessionImpl.java:244)

at org.eclipse.birt.report.designer.data.ui.util.DataSetProvider.populateAllOutputColumns(DataSetProvider.java:221)

at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.populateOutputColums(OutputColumnsPage.java:430)

at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.updateOutputColumns(OutputColumnsPage.java:374)

at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.pageActivated(OutputColumnsPage.java:245)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showPage(AbstractPropertyDialog.java:588)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showSelectionPage(AbstractPropertyDialog.java:482)

at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.showSelectionPage(DataSetEditor.java:913)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2$1.run(AbstractPropertyDialog.java:438)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:71)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2.selectionChanged(AbstractPropertyDialog.java:433)

at org.eclipse.jface.viewers.Viewer$1.run(Viewer.java:155)

at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)

at org.eclipse.ui.internal.JFaceUtil.lambda$0(JFaceUtil.java:44)

at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:173)

at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:152)

at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:2179)

at org.eclipse.jface.viewers.StructuredViewer.setSelection(StructuredViewer.java:1716)

at org.eclipse.jface.viewers.TreeViewer.setSelection(TreeViewer.java:1081)

at org.eclipse.jface.viewers.Viewer.setSelection(Viewer.java:380)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.initTreeSelection(AbstractPropertyDialog.java:408)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.createDialogArea(AbstractPropertyDialog.java:299)

at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.createDialogArea(DataSetEditor.java:124)

at org.eclipse.jface.dialogs.Dialog.createContents(Dialog.java:768)

at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.createContents(DataSetEditor.java:602)

at org.eclipse.jface.window.Window.create(Window.java:426)

at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1096)

at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:107)

at org.eclipse.birt.report.designer.data.ui.actions.NewDataSetAction.editDataSet(NewDataSetAction.java:238)

at org.eclipse.birt.report.designer.data.ui.actions.NewDataSetAction.createNewDataSet(NewDataSetAction.java:197)

at org.eclipse.birt.report.designer.data.ui.actions.NewDataSetAction.run(NewDataSetAction.java:182)

at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)

at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:565)

at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:397)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4118)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1052)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3931)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3534)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1170)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1059)

at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:153)

at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:667)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:597)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)

at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:152)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:656)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:592)

at org.eclipse.equinox.launcher.Main.run(Main.java:1498)

Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[]
IConnection.getMaxQueries()

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)

at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:303)

at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:197)

at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:302)

at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:296)

at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:621)

at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:351)

... 72 more

Caused by: java.lang.UnsupportedOperationException: IConnection.getMaxQueries()

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaObject.handleUnsupportedOp(OdaObject.java:388)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaObject.handleUnsupportedOpAndRetZero(OdaObject.java:396)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.getMaxQueries(OdaConnection.java:156)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.canSupportMoreOpenedStatements(OdaConnection.java:135)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.newQuery(OdaConnection.java:564)

at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:285)

... 77 more

Attachment: Capture1.PNG
(Size: 56.06KB, Downloaded 113 times)
Attachment: Capture2.PNG
(Size: 60.43KB, Downloaded 129 times)
Attachment: Capture3.PNG
(Size: 68.96KB, Downloaded 158 times)

Previous Topic:	Chart Interactivity hyperlink Drilltrough
Next Topic:	PDF Generation with external CSS for html inside a text element

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Mar 26 10:42:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter