Solved: Intermitent error Has anyone else seen this?

Former Member · ‎09-11-2008

Hi and thanks for reading this,

We've had an intermittant issue with our application using Crystal Reports which we'd like some help with. This is going to be a long one so please bear with me.

First Configuration:

We have a typical MVC application running Spring2.0, jdk5.5, on Tomcat55. Among the processes, many output reports. We have developed on Eclipse3.3 running C4E version 1.0.4v1094.We're running against Oracle9i using a mixture of Stored Procs and embedded sql. Based on a prior piece of documentation from Diamond, we have a set of jars which comprise JRC placed in %CATALINA_HOME%\common\lib\crystal. I wanted to attach a jpg showing the jar files, but it doesn't look like attachments are allowed; too bad.

Process:

We have all of our report templates in a separate folder. When a report is run from the application, the configuration directs the Crystal engine to the template folder, we pass the data via POJO's bound to the report template; the POJO gets the repeating data, and we also pass in parameters for fixed data, for example state name or company name. The report is displayed in a pdf format and then saved to a hierarchical static folder structure on the server.

Issue:

Occasionally the Crystal engine will throw an exception such as the stack trace is at the bottom of this post. It appears to emanate from deep within the engine, and provides very little detail; we try to capture the details, but look at the log. This occurs in Production and forces us to bounce Tomcat. We bounce Tomcat on a nightly basis just as a matter of precaution, however this has not appeared to have solved our issue. When it occurs our clients workflow is disrupted, and quite frankly, when we don't have an answer, it reflects badly.

I can provide additional information if required. However, we need this issue to go away.

Thank you for reading this,

Peter Adelmann

Stack Trace:

08 Sep 2008 19:34:43.917 [http-443-Processor20] ERROR reports.adapters.CrystalAdapter (136) - CrystalAdapter.generateReport() encountered exception writing out report.

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: An error occured while exporting the report---- Error code:-2147467259 Error code name:failed

at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)

at reports.adapters.CrystalAdapter.generateReport(CrystalAdapter.java:130)

at reports.adapters.ReportRouterImpl.runAdapter(ReportRouterImpl.java:95)

at reports.PolicyDetailsRpt.generateReportDocuments(PolicyDetailsRpt.java:272)

at reports.PolicyDetailsRpt.runReport(PolicyDetailsRpt.java:237)

at service.ReportingImpl.runReport(ReportingImpl.java:66)

at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:203)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)

at $Proxy6.runReport(Unknown Source)

at service.SurplusLinesImpl.runReport(SurplusLinesImpl.java:2335)

at sun.reflect.GeneratedMethodAccessor271.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:203)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)

at $Proxy8.runReport(Unknown Source)

at web.helpers.ReportHelper.runReport(ReportHelper.java:222)

at web.helpers.ReportHelper.runPolicyDetailsReport(ReportHelper.java:353)

at web.controllers.CreatePolicyController.submitPolicy(CreatePolicyController.java:2379)

at web.controllers.CreatePolicyController.processFormSubmission(CreatePolicyController.java:1052)

at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:250)

at web.controllers.CreatePolicyController.handleRequestInternal(CreatePolicyController.java:1438)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:806)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:736)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360)

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

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

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

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

at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

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

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

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

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

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

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

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

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

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

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

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

Caused by: com.businessobjects.reports.sdk.d: An error occured while exporting the report

at com.businessobjects.reports.sdk.b.b.int(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

... 60 more

Caused by: com.crystaldecisions.reports.exporters.format.page.pdf.a.a: Unexpected exception thrown

at com.crystaldecisions.reports.exporters.format.page.pdf.b.a(Unknown Source)

at com.crystaldecisions.reports.a.e.if(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.if(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)

... 67 more

Caused by: java.lang.IllegalArgumentException

at com.crystaldecisions.reports.exporters.destination.disk.c.a(Unknown Source)

... 71 more

Caused by:

com.businessobjects.reports.sdk.d: An error occured while exporting the report