UNX issue : Failed to initialize Query Panel (service issue?)

[Former Member]

Hello all,

For a couple off days now we are trying to use universe(s) in Desing studio with no luck.

We use the Efashion single source relational universe on which we can run Webi's without a problem . When we add a datasource in DS we see and can select the unx but when we push the "edit query specification" button DS freezes and return the error : Failed to initialize Query Panel

We just upgrade tot DS1.2 SP01 both on server side as on client side.

This is the error from the error log : which seems to have a connection problem to a certain service:

Any of you have an idea how to proceed?

All servers run fine when we check the CMC and an APS is added for Design studio (analysis) .DS works fine with BEX queries...

Thanks in advance.

!ENTRY com.sap.ip.bi.zen.ui 4 0 2014-03-14 12:43:33.876

!MESSAGE Failed to initialize Query Panel

!STACK 0

1. com.businessobjects.dsl.services.workspace.impl.WorkspaceException: Unable to find servers in CMS vyouboxd01.you.com:6400 and cluster @vyouboxd01.you.com:6400 with kind connectionserver and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014)

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

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

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

       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.e4.ui.workbench.renderers.swt.HandledContributionItem.executeItem(HandledContributionItem.java:850)

       at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.handleWidgetSelection(HandledContributionItem.java:743)

       at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem.access$7(HandledContributionItem.java:727)

       at org.eclipse.e4.ui.workbench.renderers.swt.HandledContributionItem$4.handleEvent(HandledContributionItem.java:662)

       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: Unable to find servers in CMS vyouboxd01.you.com:6400 and cluster @vyouboxd01.you.com:6400 with kind connectionserver and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014)

       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)

       ... 72 more

Caused by: com.sap.connectivity.cs.core.CSError: Unable to find servers in CMS vyouboxd01.you.com:6400 and cluster @vyouboxd01.you.com:6400 with kind connectionserver and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014)

       at com.sap.connectivity.cs.remoting.corba.proxy.ConnectionManager.<init>(ConnectionManager.java:81)

       at com.sap.connectivity.cs.remoting.corba.proxy.ConnectionServer.getConnectionManager(ConnectionServer.java:125)

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

       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)

       ... 86 more

Caused by: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Unable to find servers in CMS vyouboxd01.you.com:6400 and cluster @vyouboxd01.you.com:6400 with kind connectionserver and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014)

cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$AllServicesDown: Unable to find servers in CMS vyouboxd01.you.com:6400 and cluster @vyouboxd01.you.com:6400 with kind connectionserver and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014)

detail:Unable to find servers in CMS vyouboxd01.you.com:6400 and cluster @vyouboxd01.you.com:6400 with kind connectionserver and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014)

       at com.crystaldecisions.sdk.exception.SDKException.map(SDKException.java:140)

       at com.sap.connectivity.cs.remoting.bip.SvcFactoryBase.getManagedService(SvcFactoryBase.java:183)

       at com.sap.connectivity.cs.remoting.bip.SvcFactoryBase.getManagedService(SvcFactoryBase.java:128)

       at com.sap.connectivity.cs.remoting.corba.svchelpers.NetworkLayerSvcFactory.getServiceFromCriteria(NetworkLayerSvcFactory.java:53)

       at com.sap.connectivity.cs.remoting.corba.svchelpers.NetworkLayerLookup.getServiceFromCriteria(NetworkLayerLookup.java:114)

       at com.sap.connectivity.cs.remoting.corba.svchelpers.NetworkLayerLookup.getService(NetworkLayerLookup.java:83)

       at com.sap.connectivity.cs.remoting.corba.proxy.ConnectionManager.<init>(ConnectionManager.java:68)

       ... 93 more

Caused by: com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$AllServicesDown: Unable to find servers in CMS vyouboxd01.you.com:6400 and cluster @vyouboxd01.you.com:6400 with kind connectionserver and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014)

       at com.crystaldecisions.enterprise.ocaframework.ServerController.redirectServer(ServerController.java:664)

       at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.redirectServer(ServiceMgr.java:959)

       at com.crystaldecisions.enterprise.ocaframework.ManagedSession.redirectServer(ManagedSession.java:338)

       at com.crystaldecisions.enterprise.ocaframework.ManagedSession.get(ManagedSession.java:247)

       at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:299)

       at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:520)

       at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody5$advice(ServiceMgr.java:512)

       at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1)

       at com.sap.connectivity.cs.remoting.bip.SvcFactoryBase.getManagedService(SvcFactoryBase.java:164)

         ... 98 more

[Former Member · Accepted solution]

Do you see the same issue when you stop all servers except the original APS (containing all services)? Like Tammy, I also have used that unx, did not encounter any issue.

Here two notes worth checking:

http://service.sap.com/sap/support/notes/1894504

http://service.sap.com/sap/support/notes/1948311

Best regards,

Victor

[Former Member · Accepted solution]

Dear Victor,

We've tried your proposition without succes.

This monday i succeeded to import a UNX correctly (after some changes to the ASP server ports (we made them fixed ports) but today it's not working agian.

I'll update the post if we find the cause solution..

Kind regards

Bram

[Former Member · Accepted solution]

Hi Bram,

I had a look in your Java-Exception and there a connectionserver is missing.

I know that there are two kind of connection servers 32 and 64 Bit. Do one of your APS Servers have connectivity and connectivity 32 Bit ???

I had an issue when i first wanted to use a .unx connection with DS with my splitted APS.

I had one APS only containing the Analysis service. To get to run my .unx access i had to add the Adaptive connectivity Service to the APS containing the analysis service.

On top of that i had to add the DSL Bridge (otherwise my adaptive connectivity Service did not start)

Perhabs this helps you out.

Good luck

Manfred

[Former Member]

same issue here...

my system information is

BO: 4.2 SP02

DS: 1.6 SP01

any update yet?

[TammyPowlas]

Hello, this is an old thread

Please see  SAP Note 1983117 to see if it covers your issues or note https://launchpad.support.sap.com/#/notes/1983117/E

[Former Member]

Hi, I had same problem. In my case I didnt have APS server on BI

Try log on to CMC, and start "system configuration wizard". Choose Analysys servers and other what you need. After completed error "Failed to initialize Query Panel" was resolved

.

[Former Member]

same issue here, try the repair and restart didn't  work.

[Former Member]

I experienced this issue as well.

First I solved it by repairing the BIP add-on on the Business Objects Server (- run installation file and choose "repair").

I am running Design Studio 1.2 SP1 and BO 4.1 SP3.

I have then later on experienced the issue again and solved it by simply restarting the BO server.

[Stefan_Backhaus]

I had exactly the same error: DS on MS SQL via ODBC driver 64 bit worked in local mode but not on the server.

First, I followed the steps from Manfred

• (add the Adaptive connectivity Service to the APS containing the analysis service.
• On top of that i had to add the DSL Bridge (otherwise my adaptive connectivity Service did not start)

I restared the APS and connection server but that didn't help.

Thanks to all!

Best regards

Stefan

[TammyPowlas]

Hi Bram,

Just to confirm you are using eFashion.unx (not .unv)?

I am using Design Studio 1.2 SP01 and not experiencing this issue.

Perhaps you need to open a ticket with SAP Support to look further into the issue.

Tammy

[Former Member]

Hi Tammy,

Yes, we are using UNX files. I've tried several different UNX universes. The problem keeps popping up. We also tried different PC's thinking it was a client side issue..but no luck here as well.

Kind regards

Bram