Failed to create CMS session (see error log for details)

[Former Member]

Hi,

I am trying to use a universe to come up with a dashboard using design studio. I managed to login on BI Enterprise. After logging in, I could see list of universes available. After selecting a universe, when I tried to configure query, I got error as "

Failed to create CMS session (see error log for details)

Anybody has idea, how to resolve this error?

Regards,

Girish Oak

[Former Member]

Hi All,

Sorry for replying late.

Yes, problem got resolved by SAP. I had to mention FQDN entry in host file. So my host file entry contains IP address, server and fully qualified domain name (FQDN), earlier I was mentioning IP and server name only.

A point to note here is that the entry should be in following order only.

IP Name      FQDN      servername

Regards,

Girish Oak

[Former Member]

This message was moderated.

[Former Member]

Hi,

I just had the exact same issue and the solution proposed works fine after updating my hosts file!

Just want to say thank you

Guillaume

[CHickman72]

I encountered this same problem while working on the SAP Design Studio 1.6 SP1 Patch 1 client on my desktop.  I am trying to connect to a client's SAP BI platform.  Once I updated my hosts file with the IP Address, FQDN and server name then restarted the Design Studio desktop app, I was able to edit data sources.

Thank you!

Chris

[deb_nugent2]

Girish,

  Did you have to add the FQDN into the hosts file of the server running your SBOP or on each individual PC that was using Design Studio?

  We are facing the same problem so thank-you very much for sharing this solution with us.

Deb Nugent

[TammyPowlas]

Hi Girish - see and see if that helps; I also encourage you to search SCN for this error message if this doesn't resolve it.

[Former Member]

Hi Tammy,

I have tried all mentioned solutions, but it still doesn't work.

Regards,

Girish Oak

[TammyPowlas]

Could you share the BI version you are using, the version of Design Studio you are working with?

[Former Member]

SAP BusinessObjects BI Platform 4.1 Support Pack 3 Version: 14.1.3.1257 SAP BusinessObjects Design Studio - 14.0.5 Regards, Girish Oak

[TammyPowlas]

Girsh - the error message says see error log for details.  When you go to View > Error logs what does it say?

[Former Member]

Following is the error log

Could not bind a reference of component com.sap.ip.bi.base.application.DeclaredServiceActivator. The reference is: Reference[name = IActivatorBase, interface = com.sap.ip.bi.base.bundle.IActivatorBase, policy = dynamic, cardinality = 0..n, target = null, bind = addRICActivator, unbind = removeRICActivator]

Exception Trace - An exception stack trace is not available.

Regards,

Girish Oak

[Former Member]

Sorry Ignore...earlier post. com.sap.ip.bi.zen.connectivity.ConnectivityException: Failed to create CMS session at com.sap.ip.bi.zen.backends.bip.BiPlatformSystem.createCmsSession(BiPlatformSystem.java:1865) at com.sap.ip.bi.zen.backends.bip.ui.BiPlatformUiHandler.getEditDataSourceDialog(BiPlatformUiHandler.java:138) at com.sap.ip.bi.zen.ui.internal.dialogs.datasource.DataSourceDialogController.editDataSourceClickedInternal(DataSourceDialogController.java:156) 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:113) 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:482) 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:140) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611) 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:37) 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.dsl.framework.session.SessionException$InvalidLogonTokenException: Invalid Logon Token INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM:6400@100025JOJ2y1ROGp227Mwbyam8C6v100024JqCPamhcdYf2haI63DjGbm7ONEOFF, {1} at com.businessobjects.mds.repository.cms.CMSSessionManager$EnterpriseSessionHelper.logon(CMSSessionManager.java:406) at com.businessobjects.mds.repository.cms.CMSSessionManager.createByLogonTokenInternal(CMSSessionManager.java:202) at com.businessobjects.dsl.framework.session.AbstractSessionManager$DefaultManagedSessionBuilder.createManagedSession(AbstractSessionManager.java:564) at com.businessobjects.dsl.framework.session.AbstractSessionManager.createManagedSession(AbstractSessionManager.java:313) at com.businessobjects.dsl.framework.session.AbstractSessionManager.createByLogonToken(AbstractSessionManager.java:62) at com.sap.ip.bi.zen.backends.bip.BiPlatformSystem.createCmsSession(BiPlatformSystem.java:1863) ... 63 more Caused by: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Communication error occurred when trying to connect to server INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM:6400 (FWM 01009) cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM:6400 (FWM 01009) cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: gethostbyname() failed: java.net.UnknownHostException: INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM  minor code: 0x4f4f000e  completed: No detail:Communication error occurred when trying to connect to server INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM:6400 (FWM 01009) gethostbyname() failed: java.net.UnknownHostException: INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM detail:Communication error occurred when trying to connect to server INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM:6400 (FWM 01009) gethostbyname() failed: java.net.UnknownHostException: INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM at com.crystaldecisions.sdk.exception.SDKException.map(SDKException.java:140) at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureTokenServiceStub(LogonService.java:616) at com.crystaldecisions.sdk.occa.security.internal.LogonService.logonWithTokenHelper(LogonService.java:367) at com.crystaldecisions.sdk.occa.security.internal.LogonService.logonWithToken(LogonService.java:341) at com.crystaldecisions.sdk.occa.security.internal.LogonService.logonWithToken(LogonService.java:151) at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.logonWithToken(SecurityMgr.java:86) at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.logonWithToken(SecurityMgr.java:63) at com.crystaldecisions.sdk.framework.internal.SessionMgr.logonWithToken_aroundBody6(SessionMgr.java:510) at com.crystaldecisions.sdk.framework.internal.SessionMgr.logonWithToken_aroundBody7$advice(SessionMgr.java:512) at com.crystaldecisions.sdk.framework.internal.SessionMgr.logonWithToken(SessionMgr.java:1) at com.businessobjects.mds.repository.cms.CMSSessionManager$EnterpriseSessionHelper.logon(CMSSessionManager.java:403) ... 68 more Caused by: com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM:6400 (FWM 01009) cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: gethostbyname() failed: java.net.UnknownHostException: INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM  minor code: 0x4f4f000e  completed: No detail:Communication error occurred when trying to connect to server INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM:6400 (FWM 01009) gethostbyname() failed: java.net.UnknownHostException: INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM at com.crystaldecisions.enterprise.ocaframework.RawAPSDirectory.find(RawAPSDirectory.java:256) at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildAPSClusterInfo(APSServerHandler.java:581) at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildServerInfo(APSServerHandler.java:192) at com.crystaldecisions.enterprise.ocaframework.ServerController.redirectServer(ServerController.java:534) at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.redirectServer(ServiceMgr.java:959) at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:258) at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:520) at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1) at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureTokenServiceStub(LogonService.java:588) ... 77 more Caused by: com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: gethostbyname() failed: java.net.UnknownHostException: INBLRAPPCOE12.ITC.IN.KWORLD.KPMG.COM  minor code: 0x4f4f000e  completed: No at com.crystaldecisions.thirdparty.com.ooc.OCI.IIOP.Connector_impl.connect(Connector_impl.java:104) at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClient.createTransport(GIOPClient.java:233) at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClientWorkersPool.next(GIOPClientWorkersPool.java:122) at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClient.getWorker(GIOPClient.java:105) at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClient.startDowncall(GIOPClient.java:409) at com.crystaldecisions.thirdparty.com.ooc.OB.Downcall.preMarshalBase(Downcall.java:181) at com.crystaldecisions.thirdparty.com.ooc.OB.Downcall.preMarshal(Downcall.java:298) at com.crystaldecisions.thirdparty.com.ooc.OB.PIDowncall.preMarshal(PIDowncall.java:198) at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.preMarshal(DowncallStub.java:265) at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.setupRequest(DowncallStub.java:545) at com.crystaldecisions.thirdparty.com.ooc.CORBA.Delegate.request(Delegate.java:556) at com.crystaldecisions.thirdparty.com.ooc.CORBA.Delegate.is_a(Delegate.java:373) at com.crystaldecisions.thirdparty.org.omg.CORBA.portable.ObjectImpl._is_a(ObjectImpl.java:88) at com.crystaldecisions.enterprise.ocaframework.idl.ImplServ.OSCAFactoryExHelper.narrow(OSCAFactoryExHelper.java:100) at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getOSCAFactory_aroundBody8(ServiceMgr.java:552) at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getOSCAFactory(ServiceMgr.java:1) at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getUnmanagedService_aroundBody16(ServiceMgr.java:654) at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getUnmanagedService(ServiceMgr.java:1) at com.crystaldecisions.enterprise.ocaframework.RawAPSDirectory.find(RawAPSDirectory.java:155) ... 85 more

[TammyPowlas]

Girish - two options:

1) we can move this thread to the BI platform space to see if anyone has ideas, since it seems to be related to the BI platform

2) you can create an incident for SAP Support and attach the above error log

I can't find anything on this

Tammy

[Former Member]

Thanks Tammy for quick responses.

I will raise an incident that will be quicker, I believe.

[Former Member]

Any luck with that Girish?

[Former Member]

Girish,

Check your entries in the hosts file; specifically the IP address of your BO server.

Location of hosts file: c:\WINDOWS\system32\drivers\etc\

[chandrasekhar6]

Hi Umar,

I had raise same issue, as our host entries are already defined.

Save as application in different folder and then open that new application shows above error in both applications.

Design studio : 1.5 Version

SAP BO 4.2 SP 02

Data source: Universe

Please share valuable inputs

Thanks,

Chandra.K