carminez

Server has 3.5GB RAM. JVM settings in Tomcat are: Initial Memory Pool = 128MB, Max Memory Pool = 1024MB, Thread Stack Size 2048KB. Memory usage on tomcat6.exe does decrease back down to normal levels after about 30 seconds or so. My concern is how high it will get if a folder has many large files and multiple users browsing similar sized folders.

I'm not sure if those options work, they aren't listed here: http://jasperforge.org/website/jasperreportswebsite/trunk/config.reference.html?group_id=252 Also, maybe you have a spelling error, you have "cvs" instead of "csv" in what you paste from your properties file.

Is there any way to control the label that is displayed for the timezones? For example, right now I have America/New_York defined in userTimeZonesList, and at the login and scheduling pages, it displays as "America/New_York - Eastern Standard Time". How would I go about having it display as "North America/US/New York" for example?

I have noticed that when you browse folders using the Repository explorer, if you click into a folder that has a large file (example: A folder someone scheduled a report to save as PDF), it takes a longer time (> 5 secs) to display the contents of the folder and Tomcat memory spikes. I had a folder with one file, a 57MB PDF file and saw the Tomcat process jump to > 500MB. It also took 7 seconds to display the content of the folder. I'm using JasperServer Pro 3.1, Tomcat 6.0.18, Windows 2003.

Thanks Bob, that solved it. But it was actually cacheAdmin.jsp not cacheDetail.jsp :)

Yes. I can create them from both Topics and Domains. I'm using the samples. I just can't get the Ad Hoc Cache admin page to display.

I have JasperServer 3.1 installed on Windows 2003 with Tomcat 6.0.18 and Java 1.5.0.16. I am getting this error when I try to navigate to the Manage > Ad Hoc Cache menu. Any ideas? This is a fresh install of 3.1 from the WAR file. Dec 4, 2008 3:53:35 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet jasperserver threw exception org.apache.jasper.JasperException: /WEB-INF/jsp/adhoc/cacheAdmin.jsp(26,2) "${! empty(cache.dataSets)}" contains invalid expression(s): javax.el.ELException: Function ':empty' not found at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40) at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407) at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:198) at org.apache.jasper.compiler.Validator$ValidateVisitor.checkXmlAttributes(Validator.java:1151) at org.apache.jasper.compiler.Validator$ValidateVisitor.visit(Validator.java:821) at org.apache.jasper.compiler.Node$CustomTag.accept(Node.java:1512) at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2343) at org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2393) at org.apache.jasper.compiler.Validator$ValidateVisitor.visit(Validator.java:840) at org.apache.jasper.compiler.Node$CustomTag.accept(Node.java:1512) at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2343) at org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2393) at org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2399) at org.apache.jasper.compiler.Node$Root.accept(Node.java:489) at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2343) at org.apache.jasper.compiler.Validator.validate(Validator.java:1739) at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:166) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:315) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:295) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:282) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509) at java.lang.Thread.run(Unknown Source)

This looks to be a problem again with 3.1 The following is not a valid MDX Query: Internal error: Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[2006]" in Hierarchy "Time.Weekly"

Is repositoryFlow supported in JasperServer Pro 3.0, or has it been replaced by repositoryExplorerFlow? The reason I ask is when I try to access flow.html?_flowId=repositoryFlow it does not seem to see any Dashboards that might be in a folder. I am using the demo version of JasperServer Pro 3.0.

Any chance of getting this on an enhancement list? Controlling the values of parameters is important to be able to deploy a solution in a multi-tenet environment. So then there is no other way to pull this off, outside of building my own parameter entry page? Which really probably only works for running reports, not when users are building an ad-hoc from a saved topic.

You need to define 2 parameters. 1. New parameter named LoggedInUser with a class type of com.jaspersoft.jasperserver.api.metadata.user.domain.User 2. New parameter named UserName with class type java.lang.String and with a Default Value Expression of $P{LoggedInUser}.getUsername() 3. Then you can use something like Table.FieldName = $P{UserName} in your query to filter the data.

Here's what I'm trying to do, please someone let me know if this is possible, and maybe some ideas how or maybe some sample code to help would be great... I need to be able to show different values in an Input Control based on which User is logged into JasperServer. I was hoping to be able to use the UserName as a filter for the query for the Input Control, but parameters to an Input Control don't seem possible. So I was wondering is this is possible with a Bean Data Source or some other method? I suppose maybe this Bean or Custom data source would be able to determine the User and then have its own JDBC connection to the database and run SQL and apply the User to the SQL to filter the data.

Maybe try removing the single quotes around the parameters in the WHERE? I'm new to this too, but the stuff I've done I've just used $P{parameter_name} and not quoted it. I haven't used dates yet for parameters, so not sure if that will work, and maybe you quoted it since you can pass dates as quoted text in SQL, but I don't think it would matter here as should be handled by the execution engine. Are the datatypes of the parameters and the input controls the same?

The slashes got removed from the path to copy the jtds.jar file... /apache-tomcat/webapps/jasperserver/WEB-INF/lib

I had problems with the existing MSSQL JDBC driver in JasperServer and used the jTDS MSSQL driver instead. http://jtds.sourceforge.net/ Just copy the jtds*.jar file to the apache-tomcatwebappsjasperserverWEB-INFlib folder. When you are developing using iReport, you can also use the same driver, you will have to copy that same jtds driver to the appropriate lib folder where ireport is installed. I've been able to get the pre-installed MSSQL driver to work with ireport, so not using jtds there, I used "com.microsoft.sqlserver.jdbc.SQLServerDriver" driver instead. When you are setting up the JDBC data source in JasperServer, here are sample Driver and URL entries: DRIVER = net.sourceforge.jtds.jdbc.Driver URL = jdbc:jtds:sqlserver://192.168.1.1/yourdatabasename;instance=

What is the status of this? Is Auditing available in 3.0? Professional/Community?