Crystal Report URL gives internal error

[Former Member]

Hello,

I'm trying to use crystal report URL for viewing report.

URL looks like this:

http://hp-exscore-sql.msk.vtb24.ru:8080/BOE/CrystalReports/viewrpt.cwr?id=27307&apsuser=<admin>&apsp...

Every time I use this URL, it opens with following error:

2015-07-08 14:53:38

com.businessobjects.report.web.shared.WebReportingException: The viewer could not process an event. Internal error. Please contact your system administrator. [RASPROCREPORT0195] ---- Error code:0 [CRWEB00000119]

    at com.businessobjects.report.web.shared.WebReportingException.throwWebReportingException(WebReportingException.java:71)

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

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

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

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

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

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

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

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

    at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)

    at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)

    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)

    at com.businessobjects.webutil.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:32)

    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

    at com.businessobjects.swd.shared.tracelog.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38)

    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

    at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)

    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

    at com.businessobjects.swd.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26)

    at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

    at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

    at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)

    at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)

    at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)

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

    at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)

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

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:166)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

    at java.lang.Thread.run(Thread.java:662)

Caused by: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Internal error. Please contact your system administrator.---- Error code:-2147217395 [RASPROCREPORT0195] Error code name:serverProgrammingError

    at com.crystaldecisions.sdk.occa.report.lib.ReportSDKException.throwReportSDKException(ReportSDKException.java:120)

    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.SendRequestHelper.sendRequest(SendRequestHelper.java:141)

    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.sendRequest(CacheReportSource.java:1780)

    at com.crystaldecisions.sdk.occa.managedreports.ps.internal.CacheReportSource.getPage(CacheReportSource.java:1275)

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

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

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

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

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

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

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

    ... 45 more

Can anyone advise workaround?

[Former Member · Accepted solution]

Guys,

I figured out:

I'm trying to view WID report with Crystal URL, which is not correct.

I will have to re-create my report as RPT.

[former_member202789]

Are you trying Crystal URL for the 1st time in this BO installation? Was it working before?

Are you able to open these crystal reports directly from BI Launchpad?

[Former Member]

Hello Animesh,

Yes, this is the first time I'm using Crystal URL. Previously I used OpenDoc URL, and by the way it works just fine, but it's not convenient for us to work with logon token, so I decided to switch to Crystal.

This report is perfectly working both in BI Launch Pad and via OpenDoc URL.

[former_member182521]

Have you checked whether your Crystal reports services are available, enabled, up and running?

[Former Member]

Hello Manikandan,

Yes, servers in CMC are all up and running - two for Crystal reports and two for Crystal Reports 2011.