systemsam

How are you calling the subreport? Are you saving the report changes under the same name?

I'm trying to run a report that uses the following query: start transaction; SET @variable = select statement; Select stuff, including @variable as variable_name; commit; I'm 100% sure my queries are right - I've tested them plenty of times. It seems that Jaser isn't doing well with the multiple semi-colons or something. I get an error saying I have an error at line - and its the next line of the query. Can iReports/Jasper server run transactions? I need top be able to commit the top query once (for performance reasons) and then just return that value. I know I could make a sub report and return it that way - just seemed like this should work. Any thoughts? Sam

I have seen something similar when the page first loads. If I don't wait just a second once the parameter page loads, and I click in say the third parameter, it will jump back to the first field. Sam

I have the following statement HAVING $X{IN,tag_status,ic_status} Which produces HAVING tag_status IN (?) when its run against my mysql server The input control is names correctly - set as Multiselect list of values and has manual values defined as Label Value Status 0 STATUS0 Status 1 STATUS1 I would expect to get the follow - say if both were select HAVING tag_status IN (STATUS0, STATUS1) Any clue as to why that's not evaluating? Sam

I have the following statement HAVING $X{IN,tag_status,ic_status} Which produces HAVING tag_status IN (?) when its run against my mysql server The input control is names correctly - set as Multiselect list of values and has manual values defined as Label Value Status 0 STATUS0 Status 1 STATUS1 I would expect to get the follow - say if both were select HAVING tag_status IN (STATUS0, STATUS1) Any clue as to why that's not evaluating? Sam

Has anyone found a way to find the query - our report designs don't allow for the alignment needed to get CSV to work and I don't want to have to create two reports for each report. The log4j can grab the query so you think that somehow you could grab this a execution time. Has anyone build a funtion to export the raw data returned into a CSV without all the grouping/sorting applied? Sam

Any consultants willing to be paid to help with this? Sam

I've gotten as far as to find stuff like com.mysql.jdbc.MysqlIO.sqlQueryDirect and seeing if I can get it out of jdbc but I can't figure out I need to get the query text into a variable.I'm not well versed in java but I feel like this shouldn't be too tough? Any words of wisdom?Sam

Is there a simple way to display the query that a report used at execution time? I know you can see it in the logs (for trouble shooting purposes) but we wanted to be able to use it on the report itself - either set as a variable or just printed as a string. Can someone point me in the right direction? If not - is there a way to pull the SQL from the querystring in the XML? Thanks for your help - Sam

I have around 50 reports that I need to allow users to export to excel (or csv). However, their request is to have just the raw data available to the report. They want to then be able to do their own grouping, sorting, etc. They have requested just the data that makes up the reports and column headings. I've read a good bit on this and I have a couple questions: 1) It seems that you can hide bands with a line simular to this: net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader However - not all my reports have the data in the detail band - and they have a different number of bands. etc. Is there any simply way to get the most "inner" band and ignore the others? 2) I've seen lots on excel exports - do CSV follow the same specs? Would it be easier to ingnore spacing, groups, etc here? Thanks for the help! Sam

Thanks for the help Ramnik Related to this - is the garbage collector an important setting for this as well? (per this article) http://www.jaspersoft.com/ibm-jvm-garbage-collection-tuning

This is the full trace - its suddenly happening on a handful of our reports org.springframework.webflow.execution.repository.snapshot.SnapshotNotFoundException: No flow execution snapshot could be found with id '1'; perhaps the snapshot has been removed?org.springframework.webflow.execution.repository.snapshot.SnapshotNotFoundException: No flow execution snapshot could be found with id '1'; perhaps the snapshot has been removed? at org.springframework.webflow.execution.repository.impl.SimpleFlowExecutionSnapshotGroup.getSnapshot(SimpleFlowExecutionSnapshotGroup.java:74) at org.springframework.webflow.execution.repository.impl.DefaultFlowExecutionRepository.getFlowExecution(DefaultFlowExecutionRepository.java:108) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:162) at sun.reflect.GeneratedMethodAccessor293.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:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy17.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) 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.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524) 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)

We've had users getting the following error when trying to run a report from jasperserver org.springframework.webflow.execution.repository.snapshot.SnapshotNotFoundException: No flow execution snapshot could be found with id '1'; perhaps the snapshot has been removed? I did some googling and found items related to spring but not spring and jasper. Any clues to what this could be? If someone was sharing a username would that create a problem? Thanks Sam

Thanks for the quick response.. Just to confirm - I should set the line in my setenv.sh file to this JAVA_OPTS="$JAVA_OPTS -Xms2048m -Xmx2048m -XX:PermSize=64m -XX:MaxPermSize=265m " Just modifying the Xms and Xmx settings right - are the PermSize's okay? - thanks - Sam

I have a JasperServer (ver 3.7) and it has crashed a couple times on me now. I'll warn you that I'm not a java/tomcat expert by any means but I've gotten this far. I got the following error in my log: 2010-06-23 00:39:11,378 ERROR [jasperserver],http-80-Processor42:253 - Servlet.service() for servlet jasperserver threw exception java.lang.OutOfMemoryError: Java heap space Since that time the server we completely un-responsive until I restarted it. I've included the error prior to the heap message - it starts like this (and there are several of them) but its from an hour before the crash so I'm not thinking its the issue. 2010-06-22 23:22:47,035 ERROR JSErrorPage_jsp,http-80-Processor49:327 - com.jaspersoft.jasperserver.api.JSException: jsexception.jasperprint.not.found at com.jaspersoft.jasperserver.war.control.ReportImageController.handleRequest(ReportImageController.java:97) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) Based on forum posts, etc I've adjusted my memory to setting in setenv.sh to these (I assume this is the right place for a bundled install???) JAVA_HOME=/opt/jasperserver-ce-3.7.0/java JRE_HOME=/opt/jasperserver-ce-3.7.0/java JAVA_OPTS="$JAVA_OPTS -Xms768m -Xmx768m -XX:PermSize=64m -XX:MaxPermSize=265m " export JAVA_HOME export JRE_HOME export JAVA_OPTS Which I thought might solve the problem. This is a x64 box with 4gb of Ram. I've read little bits about the garbage collection but haven't test any of those settings. 1) Is there any recommendation to extended logging that might help us understand the root cause of this issue? 2) Any words of advice on the memory setting (ie - just crank it up - which I'm completely okay doing - whart are accceptable maxes?) Its not a terribly high traffic server accept at shift change - could be 20 people running reports. 3) I'm getting ready to configure this in a redundant setup (using a load balancer in front of them with session persistance) but has anyone created a "cluster" of sorts they would be willing to expound on? Thanks for your help!

Is there a way to "monitor" how many users and/or who is currently logged into JasperServer? I've done some reading on things like LoggedInUser and LoggedInUsername but they seem to be related to getting user information a report. I'd either like to query (SQL) or have a report I can run that would show me who is logged in. I did find the "Permissions Of Users with a role shared by LoggedIn" in the samples, but I couldn't see how to modify it to find if any of those users logged in. I guess I could look at the JIAccessEvent table and query for something less than say 10min login. Any thoughts - anyone done something like this before? Thanks -Sam

Has anyone added a progress indicator that they would be willing to share? Hints on how to do it (I'm a PHP guy)? Thanks

I noticed that the CE version doesn't have the "Retrieving ..." progress box that the pro version does along with the cancel button. Is there an option burried somewhere to turn this on or is it a pro only feature? Thanks for the help!