Skip to Content
0
Former Member
Jul 07, 2015 at 04:04 AM

ReportViewer can not display report which has DB connection

86 Views

Hi all,

I created the webpage to use the ReportViewer to view report generated by Crystal Report Server 2013.

I got the error below when display report template which has query to Database.

= INFO Control Name: CrystalInteractiveViewer

= INFO Own Page: false

= INFO Unable to get HTML page

java.lang.UnsupportedOperationException

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getHTMLPage(AdvancedReportSource.java:848)

at com.businessobjects.report.web.event.PageListener.renderContentRemotely(PageListener.java:344)

at com.businessobjects.report.web.event.PageListener.getPage(PageListener.java:175)

at com.businessobjects.report.web.event.PageListener.updatePage(PageListener.java:120)

at com.businessobjects.report.web.event.UpdatePageEvent.processListener(UpdatePageEvent.java:47)

at com.businessobjects.report.web.event.ViewerBroadcaster.broadCastEvent(ViewerBroadcaster.java:136)

at com.businessobjects.report.web.event.ViewerBroadcaster.broadcast(ViewerBroadcaster.java:110)

at com.businessobjects.report.web.event.EventQueue.processEvents(EventQueue.java:53)

at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1457)

at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:372)

at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:274)

at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:107)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerUpdater._processHttpRequest(CrystalReportViewerUpdater.java:61)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(ServerControl.java:345)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doUpdate(CrystalReportViewerServlet.java:206)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doPost(CrystalReportViewerServlet.java:194)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:221)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3287)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2089)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

= ERROR Unable to process listener

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Failed to open the connection.

Failed to open the connection.

profile 4296_4300_{A428CBF1-4B83-41BD-80D6-B70125818313}.rpt---- Error code:-2147482892 [CRSDK00000000] Error code name:failed

at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(ReportSDKServerException.java:109)

at com.crystaldecisions.proxy.remoteagent.ExceptionHelper.throwResultInfoException(ExceptionHelper.java:192)

at com.crystaldecisions.sdk.occa.report.application.ControllerBase.send(ControllerBase.java:208)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.sendRequest(ReportSource.java:1759)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(ReportSource.java:968)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(AdvancedReportSource.java:345)

at com.businessobjects.report.web.event.PageListener.renderContentLocally(PageListener.java:377)

at com.businessobjects.report.web.event.PageListener.getPage(PageListener.java:178)

at com.businessobjects.report.web.event.PageListener.updatePage(PageListener.java:120)

at com.businessobjects.report.web.event.UpdatePageEvent.processListener(UpdatePageEvent.java:47)

at com.businessobjects.report.web.event.ViewerBroadcaster.broadCastEvent(ViewerBroadcaster.java:136)

at com.businessobjects.report.web.event.ViewerBroadcaster.broadcast(ViewerBroadcaster.java:110)

at com.businessobjects.report.web.event.EventQueue.processEvents(EventQueue.java:53)

at com.businessobjects.report.web.component.ViewerContainer.processEvents(ViewerContainer.java:1457)

at com.businessobjects.report.web.WorkflowController.doEventProcessing(WorkflowController.java:372)

at com.businessobjects.report.web.WorkflowController.doLifecycle(WorkflowController.java:274)

at com.businessobjects.report.web.WorkflowController.doAsyncLifecycle(WorkflowController.java:107)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerUpdater._processHttpRequest(CrystalReportViewerUpdater.java:61)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(ServerControl.java:345)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doUpdate(CrystalReportViewerServlet.java:206)

at com.crystaldecisions.report.web.viewer.CrystalReportViewerServlet.doPost(CrystalReportViewerServlet.java:194)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:221)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3287)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2089)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

= ERROR Unable to process events

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Failed to open the connection.

Failed to open the connection.

profile 4296_4300_{A428CBF1-4B83-41BD-80D6-B70125818313}.rpt---- Error code:-2147482892 [CRSDK00000000] Error code name:failed

I tried with simple report without Database connect, it displayed OK.

Can you know the root cause ?

Attachments

Error.png (41.7 kB)
No_Error.png (52.1 kB)