jongr
-
Posts
12 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by jongr
-
-
I have installed jasperserver-2.0-windows-installer.exe
and iReport-2.0.0-windows-installer.exe
The report I have created works in iReport and also after it was installed in JasperServer
However, I find that if I set the iReport 'properties, scriptlet language' to groovy it will run ok in iReport but fails with the message below when I run it from JasperServer
This message is from the iReport JasperServer plugin:
1 - Could not initialize class org.codehaus.groovy.ast.ClassHelper
java.lang.Exception:Â1Â-ÂCouldÂnotÂinitializeÂclassÂorg.codehaus.groovy.ast.ClassHelper ÂÂÂÂatÂcom.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) ÂÂÂÂatÂcom.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) ÂÂÂÂatÂcom.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:73) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource)Â
This message is when the report is run from JasperServer:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class org.codehaus.groovy.ast.ClassHelper
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:860)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
root cause
java.lang.NoClassDefFoundError: Could not initialize class org.codehaus.groovy.ast.ClassHelper
org.codehaus.groovy.antlr.AntlrParserPlugin.makeType(AntlrParserPlugin.java:2129)
org.codehaus.groovy.antlr.AntlrParserPlugin.classDef(AntlrParserPlugin.java:322)
org.codehaus.groovy.antlr.AntlrParserPlugin.convertGroovy(AntlrParserPlugin.java:204)
org.codehaus.groovy.antlr.AntlrParserPlugin.buildAST(AntlrParserPlugin.java:180)
org.codehaus.groovy.control.SourceUnit.convert(SourceUnit.java:305)
org.codehaus.groovy.control.CompilationUnit$4.call(CompilationUnit.java:505)
org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:773)
org.codehaus.groovy.control.CompilationUnit.convert(CompilationUnit.java:492)
org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:425)
net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:97)
net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:190)
net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105)
net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:212)
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:711)
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$CacheableCompiledReports.getData(EngineServiceImpl.java:153)
com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.saveData(HibernateRepositoryCache.java:179)
com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.getCachedItem(HibernateRepositoryCache.java:125)
com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.cache(HibernateRepositoryCache.java:71)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
$Proxy5.cache(Unknown Source)
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getCompiledReport(EngineServiceImpl.java:720)
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getJasperReport(EngineServiceImpl.java:547)
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlDefaultValues(EngineServiceImpl.java:908)
com.jaspersoft.jasperserver.war.action.ReportParametersAction.loadDefaultInputValues(ReportParametersAction.java:354)
com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:418)
com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:119)
com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:121)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103)
org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)
org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)
org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)
org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)
org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)
org.springframework.webflow.engine.State.enter(State.java:200)
org.springframework.webflow.engine.Flow.start(Flow.java:557)
org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195)
org.springframework.webflow.engine.SubflowState.doEnter(SubflowState.java:120)
org.springframework.webflow.engine.State.enter(State.java:200)
org.springframework.webflow.engine.Transition.execute(Transition.java:229)
org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112)
org.springframework.webflow.engine.Flow.onEvent(Flow.java:572)
org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207)
org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:214)
org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
$Proxy11.resume(Unknown Source)
org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115)
org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
-
Thanks to jmurry, it works fine
note: I had to change
DATE_FORMAT(datefield,'%Y%c')
to DATE_FORMAT(datefield,'%Y%m')
so that I got two digit months
-
Ok, I will try that, but before I do I will need to convert my Parameter date into YYYYMM so that I can use it in MySQL
(The parameter is using the type java.util.Date)
Can you suggest the best way ?
Thanks
-
I want to create an expression to calculate the number of months between two dates (preferably in groovy)
and then multiply the result by a field value.
Can anyone help - thanks
-
I am beginning to think that there is a conspiracy to hide the information on how to call a JasperReport from a web browser.
Jasper reports is billed as being able to replace Crystal Reports (which can be run directly from the database application.)
There seems to be loads on stuff out there - all written by java programmers who forget that us lesser mortals haven't a clue about java or how to call it.
I have Tomcat and Apache and intranet pages.
I have JasperServer and have built a report using Ireport (requesting a couple of parameters like date and customer) and have a .jrxml file and a compiled .jasper file.
I can use the JasperServer page to navigate to my report and run it from there (after entering my login and password) but I would like to run it directly from my html web page.
I have a web page with a form on it and can input the date and customer parameters mentioned above.
So, what next ?
Please spill the beans
-
I have a problem with ..jasperscripts>js-import.bat
This is referenced in JasperServer Installation Manual (Appendix B.1.8).
I get the following error.
C:appsjasperscripts>js-import.bat --input-dir js-db-1.2-dump.sql
12:17:16,718 ERROR BaseExportImportCommand:46 - org.springframework.beans.factor
y.BeanDefinitionStoreException: IOException parsing XML document from class path
resource [config/applicationContext-export-import.xml]; nested exception is jav
a.io.FileNotFoundException: class path resource [config/applicationContext-expor
t-import.xml] cannot be opened because it does not exist
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from class path resource [config/applicationContext-export-impo
rt.xml]; nested exception is java.io.FileNotFoundException: class path resource
[config/applicationContext-export-import.xml] cannot be opened because it does n
ot exist
Caused by: java.io.FileNotFoundException: class path resource [config/applicatio
nContext-export-import.xml] cannot be opened because it does not exist
at org.springframework.core.io.ClassPathResource.getInputStream(ClassPat
hResource.java:135)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:334)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:317)
at com.jaspersoft.jasperserver.export.BaseExportImportCommand.registerCo
nfig(BaseExportImportCommand.java:121)
at com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpri
ngContext(BaseExportImportCommand.java:93)
at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(Ba
seExportImportCommand.java:70)
at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.j
ava:43)
-
I also have just downloaded jasperserver-2.0-windows-installer.exe and it crashed just before end.
Error message print is attached
Post edited by: jongr, at: 2007/07/11 09:59
Post edited by: jongr, at: 2007/07/11 10:00
well, I tried to upload gif and jpg file but it was not accepted
OK - More info
I successfully installed it by excluding the mySQL database examples
Post edited by: jongr, at: 2007/07/11 11:12
-
The database that I wish to report on uses dates (Long integers) in reverse order with the base in the year 1900.
i.e. The 19 March 2007 is held as 1070319
How can I input the date using the datatype calendar and convert it for use in the report query ?
-
I have upgraded to JasperServer 1.2.1 and find that my existing reports in the mySQL database have disappeared.
I can find no reference as to how existing data can be kept when upgrading.
-
The database that I wish to report on uses dates (Long integers) in reverse order with the base in the year 1900.
i.e. The 19 March 2007 is held as 1070319
How can I input the date and convert it for use in the report query ?
-
I have built a report using Ireport and can run it in JasperServer.
Is there a method to run it directly from Visual Basic6
in a similar way to Crystal Reports ?
Error when using Groovy
in Products
Posted