synchro

I ended up finding leap seconds was the culprit for this too. Restarting jasper won't fix that; it appears that simply setting the date or rebooting will. More info.

When trying to run the reports manually, I discovered that they're not working because its failing to open an X11 session. This strikes me as a bug since it's running headless and should have no need for an X11 environment. I don't know why this has suddenly appeared. java.lang.InternalError: Can't connect to X11 window server using 'localhost:10.0' as the value of the DISPLAY variable. sun.awt.X11GraphicsEnvironment.initDisplay(Native Method) sun.awt.X11GraphicsEnvironment.access$100(X11GraphicsEnvironment.java:52) sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:155) java.security.AccessController.doPrivileged(Native Method) sun.awt.X11GraphicsEnvironment.(X11GraphicsEnvironment.java:131) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:169) java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:68) net.sf.jasperreports.engine.util.JRStyledTextParser.(JRStyledTextParser.java:90) net.sf.jasperreports.engine.fill.JRBaseFiller.(JRBaseFiller.java:184) net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:78) net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:88) net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:58) net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:142) net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:114) net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:773) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:731) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:389) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:890) com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:320) com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:495) com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:485) com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:318) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) org.springframework.webflow.engine.State.enter(State.java:194) org.springframework.webflow.engine.Transition.execute(Transition.java:227) org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230) org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) org.springframework.webflow.engine.Flow.resume(Flow.java:545) org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) $Proxy17.resumeExecution(Unknown Source) org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394) com.jaspersoft.jasperserver.war.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:77) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185) org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) This also doesn't explain the excessive CPU usage as that's happening all the time even when reports are not being generated. Post Edited by synchro at 07/02/2012 09:06 Post Edited by synchro at 07/02/2012 09:10

My JasperServer (4.2.1 on Ubuntu Lucid 64) has gone a bit nuts, with the /opt/jasperreports-server-cp-4.2.1/java/bin/java process consuming > 450% CPU. If I stop it and restart it, it carries on doing the same. It started spontaneously at midnight on July 1st (see attached graph). As far as I can see it's not doing anything different (config has not been touched for > 1 year) - running two small reports perhaps once per day - but there seems to be no way of telling what it's doing since there is no status page or log file. How can I tell what it's doing? Are runaway processes like this common? Is this a known problem?

Thanks, that worked a treat. Why does everything in Java have to be so verbose!

I want to format two or more variables into a single text field. I've made this work by having this as a text expression: new java.lang.String().concat($P{EnterStartingDate}.toString()).concat(" to ").concat($P{EnterEndDate}.toString()) the two vars are dates, so it comes out like this: Sun Jan 01 00:00:00 GMT 2012 to Sun Jan 29 00:00:00 GMT 2012 Both the code and the result are horribly ugly! So, a) is there a nicer mechanism for embedding multiple variables in a single output string? b) is there a date formatting method? Something like $P{EnterStartingDate}.dateFormat("y-M-d") would be ideal. Is there a straightforward reference guide for iReports? I've seen there is a paid-for user guide, but I'm not really after a user guide, just a reference.

Fixed the second problem too. It was adding up the wrong values.

I've got the same thing happening. My query works fine, the report runs (and asks me for input values), it waits for a bit, then flips back to design view. My JDBC connection works fine when I test it, and nothing is shown in the 'report problems' window. In the IDE log console I get various different things: Charset used: UTF-8!!!! Prop3: net.sf.jasperreports.xpath.executer.factory: net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory Missing resouce key: language.sql Missing resouce key: language.SQL Missing resouce key: language.xPath Missing resouce key: language.XPath Missing resouce key: language.mdx Missing resouce key: language.MDX Missing resouce key: language.ejbql Missing resouce key: language.EJBQL Missing resouce key: language.xmla-mdx Missing resouce key: language.xpath2 Missing resouce key: language.json Missing resouce key: language.JSON Missing resouce key: language.plsql Missing resouce key: language.HiveQL Missing resouce key: language.sql Missing resouce key: language.SQL Missing resouce key: language.xPath Missing resouce key: language.XPath Missing resouce key: language.mdx Missing resouce key: language.MDX Missing resouce key: language.ejbql Missing resouce key: language.EJBQL Missing resouce key: language.xmla-mdx Missing resouce key: language.xpath2 Missing resouce key: language.json Missing resouce key: language.JSON Missing resouce key: language.plsql Missing resouce key: language.HiveQL Missing resouce key: language.sql Missing resouce key: language.SQL Missing resouce key: language.xPath Missing resouce key: language.XPath Missing resouce key: language.mdx Missing resouce key: language.MDX Missing resouce key: language.ejbql Missing resouce key: language.EJBQL Missing resouce key: language.xmla-mdx Missing resouce key: language.xpath2 Missing resouce key: language.json Missing resouce key: language.JSON Missing resouce key: language.plsql Missing resouce key: language.HiveQL Prop3: net.sf.jasperreports.xpath.executer.factory: net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory I'm running iReport 4.5 on OS X.

Ignore that first problem, just an iReport newbie at work...

I have a report (originally created in iReports, now imported and running in JS 4.2.1) whose query returns around 2800 rows from the database, and the report generated from it is intended to present all of them, however, I only get around 500 rows in the report. Is there some limit to the number of rows in a report? As a secondary problem, the report includes a total of one of the columns which is placed below the last row of report output. This number is just plain wrong. If I load the report into excel and add up the column values myself, I get a completely different answer. Right next to it there is another column that's defined and summed in the same way, and that gets the right answer. Any ideas for fixing either of these problems?

I've done this and can confirm that the file option now appears in my resource submenu, so thanks for the fix.

You could just not worry about that name and set up a proxy (e.g. apache, nginx) in front of it which you can call what you like and not have to worry about the port 8080 part either. I run it at a URL like http://jasper.example.com/ which is a proxy to http://localhost:8080/jasperserver

I didn't import a respository. I started with an empty repo (with no example content), created new reports and imported the jrxml files into them. The system they were exported from was also running 4.2.1.

Those scripts won't work as supplied as the paths are all wrong, and the bundle doesn't include apache anyway (it's supplied by the OS). Since jasper does have a functional control script, I've rewritten the control script to use it and match the paths used by the install bundle, saved it at /etc/init.d/jasperserver and given it execute permissions: #!/bin/sh### BEGIN INIT INFO# Provides: jasperserver# Required-Start:# Required-Stop:# Default-Start: 2 3 4 5# Default-Stop: 0 1 6# Short-Description: Start JasperServer at boot time# Description: Enable service provided by JasperServer.### END INIT INFOJASPER_HOME="/opt/jasperreports-server-cp-4.2.1"case "$1" in start) if [ -f $JASPER_HOME/ctlscript.sh ]; then echo "Starting JasperServer" $JASPER_HOME/ctlscript.sh start fi ;; stop) if [ -f $JASPER_HOME/ctlscript.sh ]; then echo "Stopping JasperServer" $JASPER_HOME/ctlscript.sh stop fi ;; restart) if [ -f $JASPER_HOME/ctlscript.sh ]; then echo "Restarting JasperServer" $JASPER_HOME/ctlscript.sh restart fi ;; status) if [ -f $JASPER_HOME/ctlscript.sh ]; then $JASPER_HOME/ctlscript.sh status fi ;; *) echo $"Usage: $0 {start|stop|restart|status}" exit 1 ;;esac I don't think it's a good idea to name tomcat separately in this context as it may get confused with any system supplied script, and the jasper script controls more than one thing. I think the jasper control script would actually work directly as an init.d script, however it supports many other options that are possibly hazardous to normal operations, so this wrapper limits access to start/stop/restart/status. The correct way to create startup links is not to manually create them as that article suggests, but to use one of the utilities provided by the OS to do it. Tomcat doesn't need apache in order to run jasper, though if you're proxying via apache (in order to avoid the :8080 URL) it won't work until apache is running, but since it's not a functional requirement I don't think it's necessary to describe it as a startup dependency as it will work if apache is started before or after tomcat, so the default startup priority should work fine. On Debian/Ubuntu you would do this: update-rc.d jasperserver defaults Controlling Jasper can then be done like this: service jasperserver startservice jasperserver stopservice jasperserver restartservice jasperserver status The headers in the startup script are for the upstart startup system that has been the recommended method on Ubuntu for the last few years. If you list an OS as 'supported', I would really expect this to be there out of the box. Mind you, this is oddly common amongst Java apps - none of Atlassian's products have sensible startup scripts. BTW the FCKEditor in this forum is an old and buggy version. Any chance of an update? I had to edit this post's source in an external editor to stop it messing it up. Post Edited by synchro at 11/30/2011 10:10

1) No, I installed it with the binary installer 2) Ubuntu Lucid 10.04, Jasper using bundled postgres and tomcat, connecting to MySQL 5.5. 3) None. 4.2.1 was my first install of Jasper. When I said 'The original server', that was a server belonging to another company that I don't have access to. They exported jrxml files and gave me the image files to go with them. The jrxml files do not include definitions for input controls, datatypes or images for a report, so they are not a complete packaging of reports and their dependencies need to be recreated manually, which isn't very impressive. I know where the file resource menu is supposed to be, it's just not there. I have write permission (I'm an admin) and I can create all other resource types. I attached a screen shot of what I see to my original post - inline image insertion on this forum's editor is broken.

What is the suggested mechanism for starting JasperServer auromatically on boot on Debian/Ubuntu? There seems to be no init.d script installed - can the ctlscript.sh be used for that or do I need to cobble something together?