Skip to Content
0
Former Member
Feb 23, 2014 at 01:06 PM

ConnectionServer stops CR4E from creating reports on relational connections

214 Views

Greetings,

We are in continuous development phase, and often create CR reports on top of secure connections which are created from IDT and published to repo.

Since couple of days this functionality stopped working and started giving an error as below screenshot:

same CR4E can be used to connect other systems on same patch level within the same network just fine.

So it came down to connectionserver running on this environment.

Following are the error message found from crj trace and connectionserver trace:

CRJ:

|48E86E79FAE54A97B3CDFCD8D0AFAC8Ae|2014 02 23 16:38:48.932|+0530|Information|Error|>=|E| |crj| 5232| 1|main | ||||||||||||||||||||||EXCEPTION [unknown |unknown |ID:0]com.sap.connectivity.cs.remoting.corba.proxy.ConnectionServer{com.businessobjects.connectionserver.Environment}.CreateConnectionManager: [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:293)

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

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

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

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

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.CSEnvironment.initializeConnectionManager(CSEnvironment.java:136)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.CSServerModeEnvironment.doInitialize(CSServerModeEnvironment.java:119)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.CSEnvironment.initialize(CSEnvironment.java:123)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.CSServerModeEnvironment.<init>(CSServerModeEnvironment.java:88)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.CSServerModeEnvironment.Create(CSServerModeEnvironment.java:76)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.CSEnvironmentFactory.create(CSEnvironmentFactory.java:92)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.logonui.CSLogonUI.createEnvironment(CSLogonUI.java:94)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.logonui.CSLogonUI.fetchLogonUI(CSLogonUI.java:42)

at com.crystaldecisions.reports.queryengine.driverImpl.csbridge.CSConnection.fetchLogonUI(CSConnection.java:1090)

at com.crystaldecisions.reports.queryengine.JDBConnectionWrapper.fetchLogonUI(JDBConnectionWrapper.java:161)

at com.crystaldecisions.reports.queryengine.Connection.getLogonUIProperties(Connection.java:930)

at com.crystaldecisions.reports.queryengine.Connection.processConnectionUI(Connection.java:3519)

at com.businessobjects.reports.sdk.ConnectionAdapter.processConnectionUIRequest(ConnectionAdapter.java:918)

at com.businessobjects.reports.sdk.ConnectionAdapter.request(ConnectionAdapter.java:256)

at com.businessobjects.reports.sdk.ConnectionAgent.doCommand(ConnectionAgent.java:46)

at com.businessobjects.reports.sdk.ConnectionAgent.execute(ConnectionAgent.java:58)

at com.crystaldecisions.sdk.occa.report.application.ConnectionManager.send(ConnectionManager.java:165)

at com.crystaldecisions.sdk.occa.report.application.ConnectionExplorer.processConnectionUI(ConnectionExplorer.java:98)

at com.businessobjects.crystalreports.designer.core.elements.data.property.ConnectionUIProxy.processConnectionUI(ConnectionUIProxy.java:132)

at com.businessobjects.crystalreports.designer.core.elements.data.property.ConnectionUIProxy.initializeConnectionUI(ConnectionUIProxy.java:80)

at com.businessobjects.crystalreports.designer.core.elements.data.property.ConnectionUIProxy.<init>(ConnectionUIProxy.java:69)

at com.businessobjects.crystalreports.designer.core.elements.data.property.ConnectionUIPropertyHelper.<init>(ConnectionUIPropertyHelper.java:63)

at com.businessobjects.crystalreports.designer.core.elements.data.property.DatabaseConnectionExplorer.<init>(DatabaseConnectionExplorer.java:120)

at com.businessobjects.crystalreports.designer.core.elements.data.property.DatabaseConnectionExplorer.attachToConnection(DatabaseConnectionExplorer.java:105)

at com.businessobjects.crystalreports.designer.data.wizards.NewCSLConnectionWizard.createManagedRelationalConnection(NewCSLConnectionWizard.java:219)

at com.businessobjects.crystalreports.designer.data.wizards.NewCSLConnectionWizard.getNextPage(NewCSLConnectionWizard.java:141)

at org.eclipse.jface.wizard.WizardPage.getNextPage(WizardPage.java:172)

at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:813)

at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:369)

at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)

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

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

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

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

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

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

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

at com.businessobjects.crystalreports.designer.uibase.wizard.DefaultWizardDialog.LaunchWizard(DefaultWizardDialog.java:76)

at com.businessobjects.crystalreports.designer.data.actions.CreateNewConnectionHandler.runNewConnectionWizard(CreateNewConnectionHandler.java:72)

at com.businessobjects.crystalreports.designer.data.actions.CreateNewConnectionHandler.run(CreateNewConnectionHandler.java:60)

at com.businessobjects.crystalreports.rcputilities.actions.StateAwareHandler.execute(StateAwareHandler.java:42)

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

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

at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:178)

at com.businessobjects.crystalreports.rcputilities.actions.CommandHelper.executeCommandWithNoParameters(CommandHelper.java:196)

at com.businessobjects.crystalreports.rcputilities.actions.CommandHelper.executeCommand(CommandHelper.java:188)

at com.businessobjects.crystalreports.designer.fieldexplorer.FieldExplorerDatabaseFieldsContainer$3.widgetSelected(FieldExplorerDatabaseFieldsContainer.java:182)

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

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

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

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

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

at org.eclipse.swt.widgets.Link.wmNotifyChild(Link.java:1002)

at org.eclipse.swt.widgets.Control.wmNotify(Control.java:4718)

at org.eclipse.swt.widgets.Composite.wmNotify(Composite.java:1756)

at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4348)

at org.eclipse.swt.widgets.Control.windowProc(Control.java:3841)

at org.eclipse.swt.widgets.Display.windowProc(Display.java:4541)

at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)

at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:2274)

at org.eclipse.swt.widgets.Link.callWindowProc(Link.java:171)

at org.eclipse.swt.widgets.Widget.wmLButtonUp(Widget.java:1901)

at org.eclipse.swt.widgets.Control.WM_LBUTTONUP(Control.java:4142)

at org.eclipse.swt.widgets.Link.WM_LBUTTONUP(Link.java:840)

at org.eclipse.swt.widgets.Control.windowProc(Control.java:3823)

at org.eclipse.swt.widgets.Display.windowProc(Display.java:4541)

at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)

at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2371)

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

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2384)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2200)

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

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

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

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

at com.bobj.crystalreports.designer.Application.start(Application.java:46)

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

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

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

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

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

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

]

Connectionserver:

|e1d5b293-d699-c704-39c8-29fc1b8b6c7c|2014 02 23 06:08:48:705|-0500|Error|Error|>>|E| |connectionserver_DEV.ConnectionServer| 4364|17908|| |0|0|0|0|-|-|-|-|-|-||||||||||||[CS] SATL call failure - HRESULT = -2147467259

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 443

|e3db7916-6edd-5224-79ad-63c3409b14e0|2014 02 23 06:08:48:705|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17908||{|0|1|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:132|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:132||||||||||||Step :Terminating

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 444

|44bbe109-0dec-a6d4-8a6c-2e15c06c84ff|2014 02 23 06:08:48:705|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17908||}|0|1|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:132|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:132||||||||||||Step :Terminating: 0

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 445

|a8ee01e7-f14a-f5f4-48cb-954f54bda531|2014 02 23 06:08:48:705|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17908||{|0|3|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:133|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:133||||||||||||Step :Terminating

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 446

|1ed566d2-a57e-4864-e9b5-255c2e9d2b99|2014 02 23 06:08:48:705|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17908||}|0|3|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:133|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17908.18138:133||||||||||||Step :Terminating: 0

../../shared/infostore_facade.cpp:81:unsigned long __cdecl InfoStoreFacade::GetConnectionServerNames(const class ATL::CComPtr<struct ISEnterpriseSession> &,class std::vector<class ATL::CAdapt<class ATL::CComBSTR>,class std::allocator<class ATL::CAdapt<class ATL::CComBSTR> > > &): TraceLog message 447

|166355a7-3972-29d4-0b4e-66115e7c9d40|2014 02 23 06:08:48:705|-0500|Error|Error|>>|E|X|connectionserver_DEV.ConnectionServer| 4364|17908|| |0|4|0|0|-|-|-|-|-|-||||||||||CS||Uncaught Exception in SilentScope: InfoStoreFacade::GetConnectionServerNames: 0.406 Args=(session="3&1=System Account,0P&W={},2z&2r=DLEXWBOBJ002.na.ds.lexmark.com:6400,8P&35=System Account,0P&3k=@DLEXWBOBJ002.na.ds.lexmark.com,8P&4E=3816847Jwisv3ZgnkTcqMrVI2alM0p,0P&4F=10,0P&5U=3816848JWTHSGqUPDP6byNmsoBcxVI3816847Jwisv3ZgnkTcqMrVI2alM0p,0P&63=server-token,0P&?u=1392915994828,9L&S5=1,08&Tm=36500,03&lu=1033,83&pa,0P&ua=AWmaEx4Z.NVPpAEthuTGAjc,0P&ub=AeLq4SaDG0dEqgPyY4C1Tp8,0P&ux=AUS3FrhJYIVHrrGB1zkKGig,0P&uy=-1391523078834,0L")

networklayer_lookup.cpp:42:void __cdecl NetworkLayerLookup::GetServices(class std::vector<class OBObjVar<class CS_NetworkLayer>,class std::allocator<class OBObjVar<class CS_NetworkLayer> > > &): TraceLog message 448

|54bceda1-0e01-ef84-3950-6d4f0aa135b8|2014 02 23 06:08:48:705|-0500|Error|Error|>>|E|X|connectionserver_DEV.ConnectionServer| 4364|17908|| |0|4|0|0|-|-|-|-|-|-||||||||||CS||Uncaught Exception in SilentScope: NetworkLayerLookup::GetServices: 0.406

|8e958301-35fb-7544-db85-ee7576efda18|2014 02 23 06:08:49:204|-0500|Error|Error|>>|E| |connectionserver_DEV.ConnectionServer| 4364|17108|| |0|0|0|0|-|-|-|-|-|-||||||||||||[CS] SATL call failure - HRESULT = -2147467259

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 450

|218204dd-36ee-d6c4-c9d3-d390a227e473|2014 02 23 06:08:49:204|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17108||{|0|1|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:132|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:132||||||||||||Step :Terminating

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 451

|2bbcb3e8-8e12-94c4-3a13-4eb4f5d74cba|2014 02 23 06:08:49:204|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17108||}|0|1|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:132|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:132||||||||||||Step :Terminating: 0

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 452

|1d82c00e-7d77-de84-ab3c-3ad677665079|2014 02 23 06:08:49:204|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17108||{|0|3|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:133|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:133||||||||||||Step :Terminating

.\encomsession.cpp:1279:long __cdecl EnCOMEnterpriseSession::Terminating(struct IUnknown *): TraceLog message 453

|3c0649ab-8a37-bd74-68c8-4670ff74be25|2014 02 23 06:08:49:204|-0500|Debug|Error|<<|E|X|connectionserver_DEV.ConnectionServer| 4364|17108||}|0|3|0|1|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:133|-|-|EnCOMEnterpriseSession.Terminating|localhost:4364:17108.18141:133||||||||||||Step :Terminating: 0

../../shared/infostore_facade.cpp:81:unsigned long __cdecl InfoStoreFacade::GetConnectionServerNames(const class ATL::CComPtr<struct ISEnterpriseSession> &,class std::vector<class ATL::CAdapt<class ATL::CComBSTR>,class std::allocator<class ATL::CAdapt<class ATL::CComBSTR> > > &): TraceLog message 454

|eb1a3b09-5562-e304-49a4-d40e0ff92ca2|2014 02 23 06:08:49:204|-0500|Error|Error|>>|E|X|connectionserver_DEV.ConnectionServer| 4364|17108|| |0|4|0|0|-|-|-|-|-|-||||||||||CS||Uncaught Exception in SilentScope: InfoStoreFacade::GetConnectionServerNames: 0.421 Args=(session="3&1=System Account,0P&W={},2z&2r=DLEXWBOBJ002.na.ds.lexmark.com:6400,8P&35=System Account,0P&3k=@DLEXWBOBJ002.na.ds.lexmark.com,8P&4E=3816847Jwisv3ZgnkTcqMrVI2alM0p,0P&4F=10,0P&5U=3816848JWTHSGqUPDP6byNmsoBcxVI3816847Jwisv3ZgnkTcqMrVI2alM0p,0P&63=server-token,0P&?u=1392915994828,9L&S5=1,08&Tm=36500,03&lu=1033,83&pa,0P&ua=AWmaEx4Z.NVPpAEthuTGAjc,0P&ub=AeLq4SaDG0dEqgPyY4C1Tp8,0P&ux=AUS3FrhJYIVHrrGB1zkKGig,0P&uy=-1391523078834,0L")

networklayer_lookup.cpp:42:void __cdecl NetworkLayerLookup::GetServices(class std::vector<class OBObjVar<class CS_NetworkLayer>,class std::allocator<class OBObjVar<class CS_NetworkLayer> > > &): TraceLog message 455

|1cca7bd6-9c3b-5894-79cb-a5502f52fe12|2014 02 23 06:08:49:204|-0500|Error|Error|>>|E|X|connectionserver_DEV.ConnectionServer| 4364|17108|| |0|4|0|0|-|-|-|-|-|-||||||||||CS||Uncaught Exception in SilentScope: NetworkLayerLookup::GetServices: 0.421

Already submitted logs to SAP. No progress since 4 days.

Any ideas folks?

Thanks in advance.

Regards,

Prakhar T

PS: its windows 2k8 r2 x64 box with BI4.0 SP5 Pat6. CR4E on windows 2k3 sp2 x64.

Attachments

CR4E.PNG (10.3 kB)