lovetide

this problem still exists in JS 2.0.0:huh:

be aware that there is a syntax error in upgrade-mysql-1.2.1-2.0.0.sql file (line 28): Code: 27 alter table JIReportUnit 28 controlslayout tinyint; -- should be 28 ADD controlslayout tinyint;

I'm a newbie for JasperServer. It seems JasperServer use JPivot to render the OLAP result, so we need to know the usage of tags of JPivot and WCFthen we need to modify the %JASPER_SERVER_WEBAPP_ROOT%/WEB-INF/jsp/olap/viewOlap.jsp file to change the macro UI layoutand it seems JPivot use some XSL to render it's own component (I called it micro UI), so we need to know XSL knowledge[/ul] I'm a newbie for JPivotã€Mondrianã€OLAPã€MDX too, I'm learning JPivot and Mondrian these days, we need advises from experts:lol: Post edited by: lovetide, at: 2007/05/25 02:19

I've upgraded JasperServer from 1.2.0 to 1.2.1 I do not use the .exe installer, I use the .zip version, and upgrade it manually. I only do the following 2 jobs, then it works for me: read 2.5.4 section of JasperServer-WarFile-Install-Guide.pdf, upgrade the database by executing 'mysql --user=user --password=password -D jasperserver < jasperserverPatch-1.2.0-1.2.1.ddl' shell commanddelete the old JasperServer web application, and install the new one[/ul]

similar problem, JS1.2.1, Tomcat 6.0.13, MySQL5.0.41 Code: java.lang.IllegalArgumentException: bean "${requestScope" not found at com.tonbeller.wcf.expr.ExprUtils.getModelReference(ExprUtils.java:89) at com.tonbeller.wcf.controller.RequestContextImpl.getModelReference(RequestContextImpl.java:106) at com.tonbeller.wcf.form.FormComponentTag.createComponent(FormComponentTag.java:61) at com.tonbeller.wcf.component.ComponentTag.doStartTag(ComponentTag.java:58) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_wcf_005fform_005f1(viewOlap_jsp.java:525) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:192) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 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:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) 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:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:140) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:272) 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.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.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 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:136) 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 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:83) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508) at java.lang.Thread.run(Thread.java:619)

I have encountered the same error after upgrade 1.2.0 to 1.2.1, see here:http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=23723&catid=10

This is a good idea. How about the 'average time-length costed' ? How about the 'top N reports' which measured in 'costed time-length' and/or 'report times/count' and/or 'total output file size stored in repository (which produced by scheduled report)' and/or ...:lol:

swood wrote: The access denied problem is related to the user the report is running as does not have the required access rights to the report. We have changed the default security model in 1.2.1 to be more restrictive - normal users have no access. Sherman JasperSoft Thank you for your reply swood. I use 'jasperadmin' account to operate it, and, I can successfully make the report manually(I mean, by click the report name), but when I try to schedule it or 'run in background', it will failed with the previous error log. Does 'run in background' use a different account do it? Post edited by: lovetide, at: 2007/04/13 03:22

I upgraded JI1.2.0 to JI1.2.1 yesterday, then I encoutnered some problems. 1. The scheduled report does work after upgrade. the following is an exception log from jasperserver.log file: Code: 00:01:46,158 ERROR ReportExecutionJob,JasperServerScheduler_Worker-1:186 - org.acegisecurity.AccessDeniedException: Access is denied org.acegisecurity.AccessDeniedException: Access is denied at org.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:68) at org.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:275) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy3.getResource(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.saveToRepository(ReportExecutionJob.java:441) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendToDestinations(ReportExecutionJob.java:295) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:138) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) :( 2. Another little problem is about the default value of 'visible' field of 'JIInputControl' table. I use 'jasperserverPatch-1.2.0-1.2.1.ddl' file to upgrade database(I have some InputControls before upgrade). The problem is that when I try to report, I will got an exception: Code:[code] Error Message: org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@18787c9 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@11775bc, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[empty]]'; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible Error Trace: org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@18787c9 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@11775bc, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[empty]]'; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@18787c9 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@11775bc, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[empty]]'; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible Caused by: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible at ....... I have resolved this problem by updating 'visible' field of all records to TRUE(original value is NULL value) after upgrade.

This problem is still exists. If the file path or file name contains multibytes characters on a Windows system, the recent file menu will not shown the recent file list.

try to replace $R(vars1) with new String($R{vars1}.getBytes("ISO-8859-1"),"UTF-8"):laugh:

If you use iReport to design your report, you can type/input or copy/paste Chinese characters directly. But if you use resource bundle to store Chinese characters, I have a experience like the following: 1. type/input or copy/paste Chinese characters directly in your .properties file #example: chinese_surname.king=金 chinese_surname.liu=刘 2. save .properties file in UTF-8 or GB18030/GBK/GB2312 or BIG5 encoding as you need 3. after you readed from .properties file, convert the encoding of result string from "ISO-8859-1" to the encoding you choosed at step 2, then, you'll get what you want I think... :laugh:

jmurray wrote: I had this problem with an earlier release of iReport. It turned out to be an incompatible version of Sun's SDK. If you are still using version 1.4 then get on over to Sun and grab version 5: http://java.sun.com/javaee/downloads/index.jsp Once you've installed it, make sure you copy the new tools.jar file to iReport's lib directory Thanks for your reply jmurray. In fact, I installed both jdk1.5.0_10(with public JRE installed) and jdk1.6.0(without public JRE installed), because iReport auto detect and select the newest jvm to startup, so I'm actually using 1.6.0 now (this can be confirmed from the Help-->About iReport-->System properties). I've also copied the tools.jar to %IREPORT_HOME%lib directory, then restart ireport 1.3.0, then reopen that file, but the problem still exist. Some other simple jrxmls will not cause this problem, I don't know what's wrong with this one. Post edited by: lovetide, at: 2006/12/27 16:20

I have a jrxml file which is created by older version iReport, the file is last saved from iReport 1.2.6 When I opened this file by iReport v1.3.0, the usage of CPU keeps 100% even if I closed this file from iReport, I must close the whole iReport application to get a normal CPU usage. The attachment is that CPU usage murderer... [file name=CallAmount_100865x_Daily_Report.jrxml size=21639]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/CallAmount_100865x_Daily_Report.jrxml[/file]

Due to the chinese translation is not completed, I'd like to use english as the GUI language, but it seems the 'english' selection is missing in iReport 1.3.0, so I can't configure the GUI language to english. size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/iReport1.png Post edited by: lovetide, at: 2006/12/26 01:46