Crystal Reports -HTTP Status 500 - Filter execution threw an exception

ReportServer (EN)
1

Hi,

Just downloaded and trying out ReportServer to work with our Crystal Reports we have. I have got it installed and can connect to the ReportServer web interface. I have successfully setup a datasource to our MS SQL server (confirmed with the Test Connection button), Inserted a test Crystal Report file tried to assign the datasource (however I don’t think I need to do this?), this stays blank. I’m not sure what I should put in the Key field, if anything?

When I try to run the report I get the error below. If I try using the SAP Crystal Reports free viewer, it works with no issues. Any ideas?

HTTP Status 500 - Filter execution threw an exception

type Exception report

message Filter execution threw an exception

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Filter execution threw an exception

root cause

java.lang.NoClassDefFoundError: [Ljava/util/HashMap$Entry;
java.lang.Class.getDeclaredMethods0(Native Method)
java.lang.Class.privateGetDeclaredMethods(Unknown Source)
java.lang.Class.getDeclaredMethods(Unknown Source)
org.codehaus.groovy.reflection.CachedClass$3$1.run(CachedClass.java:84)
java.security.AccessController.doPrivileged(Native Method)
org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:81)
org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:79)
org.codehaus.groovy.util.LazyReference.getLocked(LazyReference.java:46)
org.codehaus.groovy.util.LazyReference.get(LazyReference.java:33)
org.codehaus.groovy.reflection.CachedClass.getMethods(CachedClass.java:250)
groovy.lang.MetaClassImpl.populateMethods(MetaClassImpl.java:338)
groovy.lang.MetaClassImpl.fillMethodIndex(MetaClassImpl.java:288)
groovy.lang.MetaClassImpl.initialize(MetaClassImpl.java:2922)
org.codehaus.groovy.reflection.ClassInfo.getMetaClassUnderLock(ClassInfo.java:176)
org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:192)
org.codehaus.groovy.runtime.metaclass.MetaClassRegistryImpl.getMetaClass(MetaClassRegistryImpl.java:309)
org.codehaus.groovy.runtime.InvokerHelper.getMetaClass(InvokerHelper.java:806)
org.codehaus.groovy.runtime.callsite.CallSiteArray.createCallConstructorSite(CallSiteArray.java:84)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:57)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:186)
Script3.run(Script3.groovy:53)
org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:332)
org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:132)
net.datenwerke.rs.scripting.service.scripting.engines.GroovyEngine.eval(GroovyEngine.java:65)
net.datenwerke.rs.scripting.service.scripting.ScriptingServiceImpl.executeScript(ScriptingServiceImpl.java:205)
net.datenwerke.rs.scripting.service.scripting.ScriptingServiceImpl.executeScript(ScriptingServiceImpl.java:251)
net.datenwerke.rs.scripting.service.scripting.ScriptingServiceImpl.executeScript(ScriptingServiceImpl.java:299)
net.datenwerke.rs.scriptreport.service.scriptreport.generator.ScriptReportGenericOutputGenerator.export(ScriptReportGenericOutputGenerator.java:66)
net.datenwerke.rs.scriptreport.service.scriptreport.ScriptReportEngine.executeReport(ScriptReportEngine.java:91)
net.datenwerke.rs.scriptreport.service.scriptreport.ScriptReportEngine.doExecute(ScriptReportEngine.java:76)
net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:127)
net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186)
net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:527)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:407)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:333)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportById(ReportExportServlet.java:270)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportByIdViaRequest(ReportExportServlet.java:261)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:162)
com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

root cause

java.lang.ClassNotFoundException: java.util.HashMap$Entry
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1713)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1558)
java.lang.Class.getDeclaredMethods0(Native Method)
java.lang.Class.privateGetDeclaredMethods(Unknown Source)
java.lang.Class.getDeclaredMethods(Unknown Source)
org.codehaus.groovy.reflection.CachedClass$3$1.run(CachedClass.java:84)
java.security.AccessController.doPrivileged(Native Method)
org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:81)
org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:79)
org.codehaus.groovy.util.LazyReference.getLocked(LazyReference.java:46)
org.codehaus.groovy.util.LazyReference.get(LazyReference.java:33)
org.codehaus.groovy.reflection.CachedClass.getMethods(CachedClass.java:250)
groovy.lang.MetaClassImpl.populateMethods(MetaClassImpl.java:338)
groovy.lang.MetaClassImpl.fillMethodIndex(MetaClassImpl.java:288)
groovy.lang.MetaClassImpl.initialize(MetaClassImpl.java:2922)
org.codehaus.groovy.reflection.ClassInfo.getMetaClassUnderLock(ClassInfo.java:176)
org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:192)
org.codehaus.groovy.runtime.metaclass.MetaClassRegistryImpl.getMetaClass(MetaClassRegistryImpl.java:309)
org.codehaus.groovy.runtime.InvokerHelper.getMetaClass(InvokerHelper.java:806)
org.codehaus.groovy.runtime.callsite.CallSiteArray.createCallConstructorSite(CallSiteArray.java:84)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:57)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:186)
Script3.run(Script3.groovy:53)
org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:332)
org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:132)
net.datenwerke.rs.scripting.service.scripting.engines.GroovyEngine.eval(GroovyEngine.java:65)
net.datenwerke.rs.scripting.service.scripting.ScriptingServiceImpl.executeScript(ScriptingServiceImpl.java:205)
net.datenwerke.rs.scripting.service.scripting.ScriptingServiceImpl.executeScript(ScriptingServiceImpl.java:251)
net.datenwerke.rs.scripting.service.scripting.ScriptingServiceImpl.executeScript(ScriptingServiceImpl.java:299)
net.datenwerke.rs.scriptreport.service.scriptreport.generator.ScriptReportGenericOutputGenerator.export(ScriptReportGenericOutputGenerator.java:66)
net.datenwerke.rs.scriptreport.service.scriptreport.ScriptReportEngine.executeReport(ScriptReportEngine.java:91)
net.datenwerke.rs.scriptreport.service.scriptreport.ScriptReportEngine.doExecute(ScriptReportEngine.java:76)
net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:127)
net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186)
net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:527)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:407)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:333)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportById(ReportExportServlet.java:270)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportByIdViaRequest(ReportExportServlet.java:261)
net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:162)
com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.39 logs.

Apache Tomcat/7.0.39

2

Hi,

did you set up the Crystal libraries?

The key field is only meant for specifying a unique key in case you want to, for example, access the report via a URL. The datasource field can
also be left blank in which case ReportServer will try to use the datasource specified in the Crystal report.

Regards
Arno

3

OPPSss. I rechecked the Crystal files that needed to copy over to the server and I found that I missed one. Copied it over and now it works!! Thanks for the prompt. Great product so far.

Thanks..

4

OK, sort of fixed. When I’m in my Teamspace and I select my imported Crystal Report I get the same Error 500 when looking at the Details and History tab. When I click on the Preview tab, it works and my report opens. The report also opens when double clicking on the report on the left window so it opens full screen. Any ideas why I get errors on these 2 tabs?

5

Details and History are usually configured to point to specific script reports. Have you checked, that this is correctly set up? The config for the tabs is in /fileserver/etc/ui/urlview.cf

Arno

6

I have quite the same scenario. my report opens and executes right, even when it shows the same Error 500 at the Details and History tabs. I’m running reportserver on a Windows server 2008 machine, and in my case it is not a Crystal Report but an Eclipse-BIRT Report.

7

Take a look at this topic it explains how to restore the reports that are displayed in these tabs:
http://forum.reportserver.net/viewtopic.php?pid=424#p424

Cheers
Thorsten