Failed to intialize Query Panel Error in Design Studio

[Former Member]

Hi Experts,

In BO design studio while adding Data source I am getting error like Failed to initialize query panel error like

Thanks,

Mubarak

[Former Member · Accepted solution]

Hi Mubarak,

I looked around and found someone who seemed to have faced the same issue, with a fix that they tried out. Please refer to the following post:

http://scn.sap.com/thread/3520284

From what I can see, restarting the BO server might be one of the first steps you can take to resolve the issue. Do let me know if you are still facing this issue afterwards.

Thanks and Regards,

Eshwar

[Former Member · Accepted solution]

Hi Eshwar,

While clicking "Edit Query Specification" only i am getting this error

For your reference provided error log and error screen

exception stack trace:

com.businessobjects.dsl.services.workspace.impl.WorkspaceException: Error on request to the InfoStore :

  at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.createDataSource(AbstractDataProviderWithUniverse.java:437)

  at com.businessobjects.dsl.services.dataprovider.impl.QuerySpecDataProvider.createInitialDataSource(QuerySpecDataProvider.java:609)

  at com.businessobjects.dsl.services.dataprovider.impl.QuerySpecDataProvider.finalizeCreation(QuerySpecDataProvider.java:852)

  at com.businessobjects.dsl.services.workspace.impl.AbstractBuiltInDataProviderBuilder.buildDataProvider(AbstractBuiltInDataProviderBuilder.java:36)

  at com.businessobjects.dsl.services.dataprovider.impl.DataProviderFactory.createDataProviderWithUniverse(DataProviderFactory.java:190)

  at com.businessobjects.dsl.services.dataprovider.impl.DataProviderFactory.createAndAddDataProvider(DataProviderFactory.java:108)

  at com.businessobjects.dsl.services.workspace.impl.WorkspaceServiceImpl.addDataProvider(WorkspaceServiceImpl.java:83)

  at com.businessobjects.dsl.services.workspace.impl.WorkspaceServiceImpl.addDataProvider(WorkspaceServiceImpl.java:45)

  at com.sap.ip.bi.zen.backends.bip.ui.dialogs.QueryPanelDialog.createQueryPanelContext(QueryPanelDialog.java:137)

  at com.sap.ip.bi.zen.backends.bip.ui.dialogs.QueryPanelDialog.createDialogArea(QueryPanelDialog.java:101)

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

  at com.sap.ip.bi.zen.ui.internal.dialogs.ZenTrayDialog.createContents(ZenTrayDialog.java:63)

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

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

  at com.sap.ip.bi.zen.ui.internal.dialogs.ZenTrayDialog.open(ZenTrayDialog.java:110)

  at com.sap.ip.bi.zen.ui.internal.dialogs.datasource.DataSourceDialogController.editDataSourceClickedInternal(DataSourceDialogController.java:158)

  at com.sap.ip.bi.zen.ui.internal.dialogs.datasource.DataSourceDialogController$1.run(DataSourceDialogController.java:147)

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

  at com.sap.ip.bi.zen.ui.internal.dialogs.datasource.DataSourceDialogController.editDataSourceClicked(DataSourceDialogController.java:144)

  at com.sap.ip.bi.zen.ui.internal.dialogs.datasource.DataSourceSelectionPane.editQueryButtonClicked(DataSourceSelectionPane.java:253)

  at com.sap.ip.bi.zen.ui.internal.dialogs.datasource.DataSourceSelectionPane$6.widgetSelected(DataSourceSelectionPane.java:233)

  at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

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

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

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

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

  at org.eclipse.jface.window.Window.runEventLoop(Window.java:826)

  at org.eclipse.jface.window.Window.open(Window.java:802)

  at com.sap.ip.bi.zen.ui.internal.dialogs.ZenTrayDialog.open(ZenTrayDialog.java:112)

  at com.sap.ip.bi.zen.ui.internal.commands.AddDataSourceHandler.execute(AddDataSourceHandler.java:22)

  at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)

  at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)

  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.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)

  at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)

  at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)

  at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)

  at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)

  at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)

  at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)

  at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)

  at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:420)

  at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:401)

  at com.sap.ip.bi.zen.ui.ZenUiPlugin.executeCommand(ZenUiPlugin.java:382)

  at com.sap.ip.bi.zen.ui.internal.outline.AddDataSourceAliasAction.run(AddDataSourceAliasAction.java:22)

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

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

  at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)

  at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)

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

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

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

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

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

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

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

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

  at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610)

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

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

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

  at com.sap.ip.bi.zen.ui.internal.application.ZenApplication.start(ZenApplication.java:36)

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

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

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

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

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

  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:636)

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

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

Caused by: com.businessobjects.mds.services.solver.ConnectionSolverException: Error on request to the InfoStore :

  at com.businessobjects.mds.services.solver.AbstractConnectionSolver.addCredentialInfo(AbstractConnectionSolver.java:238)

  at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solve(AbstractConnectionSolver.java:136)

  at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solveRelational(AbstractConnectionSolver.java:151)

  at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solveRelational(AbstractConnectionSolver.java:147)

  at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solveRelational(AbstractConnectionSolver.java:143)

  at com.businessobjects.mds.services.helpers.DataFoundationHelper.getConnection(DataFoundationHelper.java:892)

  at com.businessobjects.mds.services.helpers.DataFoundationHelper.isErpDataFoundation(DataFoundationHelper.java:2896)

  at com.businessobjects.mds.services.helpers.UniverseHelper.isErpUniverse(UniverseHelper.java:1554)

  at com.businessobjects.dsl.services.datasource.DataSourceFactory.createQueryCapability(DataSourceFactory.java:286)

  at com.businessobjects.dsl.services.datasource.DataSourceFactory.fillQueryCapability(DataSourceFactory.java:959)

  at com.businessobjects.dsl.services.datasource.DataSourceFactory.getDataSource(DataSourceFactory.java:839)

  at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.createDataSourceFromUniverse(AbstractDataProviderWithUniverse.java:572)

  at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.retrieveDataSource(AbstractDataProviderWithUniverse.java:542)

  at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.buildDataSource(AbstractDataProviderWithUniverse.java:448)

  at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.createDataSource(AbstractDataProviderWithUniverse.java:432)

  ... 76 more

Caused by: com.sap.connectivity.cs.core.CSError: Error on request to the InfoStore :

  at com.sap.connectivity.cs.remoting.conversion.ErrorHelper.newInstance(ErrorHelper.java:46)

  at com.sap.connectivity.cs.remoting.conversion.ErrorSetHelper.fetch(ErrorSetHelper.java:31)

  at com.sap.connectivity.cs.remoting.conversion.ErrorSetHelper.newInstance(ErrorSetHelper.java:22)

  at com.sap.connectivity.cs.remoting.corba.proxy.ConnectionServer.getDataBaseAliases(ConnectionServer.java:334)

  at com.sap.connectivity.cs.core.Environment.resolveAlias(Environment.java:379)

  at com.sap.connectivity.cs.core.Environment.CreateConnectionManager(Environment.java:528)

  at com.sap.connectivity.cs.core.Environment.CreateConnectionManager(Environment.java:504)

  at com.sap.connectivity.cs.api.trace.EnvironmentLogger.CreateConnectionManager(EnvironmentLogger.java:368)

  at com.businessobjects.mds.services.relational.CsService.getAuthenticationMode(CsService.java:180)

  at com.businessobjects.mds.services.relational.CsService.addCredentialInfo(CsService.java:485)

  at com.businessobjects.mds.services.solver.AbstractConnectionSolver.addCredentialInfo(AbstractConnectionSolver.java:235)

  ... 90 more

Thanks,

Mubarak

[Former Member · Accepted solution]

Hi Mubarak,

Have you taken a look at the link I provided in my previous post? Also, contact your BO admin to try and restart your BO server to see if this error subsides.

Thanks and Regards,

Eshwar Prasanna

[Former Member · Accepted solution]

Hi Eshwar,

I have looked that..

Actual I can log-in but while adding Data Source it asking to select the universe from repository after selecting universe only it shows error like above screen

and problem is

Edit query specification form is appearing with blank for a long time

Thanks,

Mubarak

[Former Member]

Hello Mubarek and Murat:

I created incident ticket regarding this issue and will let you know once it is resolved. In our case, the same error occures not only on client, but also when DS is run on server side...

Cheers!

Tim

[former_member581483]

Hello Tim,

In my case, I have same error both on server and on client,too.

What is the solution?

Thanks,

Murat

[Former Member]

Hi Murat,

Its connection server error actual from BOE server..just check your BOE servers are up and running

Thanks,

Mubarak

[former_member581483]

Hi Mubarek,

Have you solved this problem? Or have you ever created incident for this problem?

I have same error.

Please, update this note.

Thanks and Regards,

Murat