maggix

This thread helped me a lot, check if it's useful for you http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=59680&page=1

Hello mdahlman, thank you for your suggestion! It's always good to look at problems from a different perspective:your solution works great. I assigned the "No Access" permissions to the "SharedElements" folder (which does not contain reports) and then assigned "Read Only" to the child folers inside "SharedElements" (which contain queries, images and so on). Users now can see only the Reports folder but are allowed to run reports. However, the "Execute" privilege would definitely be a nice addition to JAsperServer, so (after a check to avoid duplicates) I posted this issue to the tracker as you suggested: http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4550 For the moment I will keep this configuration waiting for the next JS release. At least I avoided manual edit of XML files, which would make upgrade more difficult. Regards, Giovanni

Hello, I was wondering if there was a way to hide some of the folders in Jasperserver without using the "no access" setting in permissions. I created a folder containing the reports and another one which contains the resources for those reports (images, input data types, queries and such). If I set "no access" to the "Shared Resources" folder, users cannot run reports because they can't access those resources, however if I set the "hidden" flag in the database, no one is able to see that folder (not even administrators) for editing purposes. There are other threads in this forum that deal with this problem, but none of them has a solution. I was wondering if someone knew how to change the applicationContext-security.xml to change the way Jasperserver deals with permissions on resources: I'd like to be able to achieve a setting that does not display folders to the users but allows the reports ran by those users to access the resources contained. I hope I explained what I mean :) Thank you in advance Giovanni

Hello, I'd like to inform you that the problem did apply in my case only when Inputcontrol had reference to an external "datatype", so the MultiSelect Queries and such were not affected. However I solved my problem by recreating the input controls, case can be closed for me

Hello, I attached an image of my working Jaspersoft 3.5 configuration. As you can see, the Input controls of each report are links to the shared input controls, which in turn use the shared data types in /datatypes Same goes for the images and for the scriptlets I am not sure that attaching the .sql dump of the database could be of any help, since many of the input controls are Multiple selects that feed data from database with SQL Selects...

Hello, as lucianc wrote, the problem may be related to input controls. Check name consistency and try to see if deleting and recreating input controls solve your problem, as it seems to work for me. Regards, Giovanni

I am quoting here a reply I wrote on the JasperForge forums, as it seems I found the solution to the problem. Seems like the references to the shared (linked) Inputcontrol, DataTypes, Queries was broken during upgrade. " Hello, after further investigation it turned out that I concentrated my searches on the Scriptlet variables, while the problem was in the migration of DataTypes , InputControls and Queries, which references were broken during the upgrade. Our JasperServer installation heavily takes advantage of the fact that JS allows linking to resources and controls. So I created a structure like |-Reports |-ProductionReports |-..... |-SharedElements |-InputControls |-ProductionReportsInputConrols |- ... |-DataTypes |-Queries I hope I gave the idea :) Which means that data types are shared among many input controls, and each input control is shared among many reports. Each report has at least 6 InputControls associated with it. While the names were correct, it turned out that the references to those elements were somehow broken during migration, resulting in missing references when running the report. When I run the report in iReport, the error does not show up because iReport does not take in account the Inputcontrols defined on the server, and it relies only on the Input Parameters specified in the jrxml (correct me if I'm wrong). I took a test report and had to delete the references then create a set of "Local" inputcontrols to get it working. It seems that I'll have to delete and create again all the shared resources, because simply editing those resources doesnt seem to get it working.Only the shared resources that I deleted and created as new worked again. Should I have done something to avoid this? Did it happen to someone else? Thank you for helping me, now I am stopping my test of JS 3.7 RC and waiting for the release to come out before trying again and see if migration works. Tell me if I should update this topic or consider the issue solved (In my opinion it is not, because other people may find themselves in the same situation, but at least now I know how to somewhat fix it) Regards, Giovanni "

Hello, after further investigation it turned out that I concentrated my searches on the Scriptlet variables, while the problem was in the migration of DataTypes , InputControls and Queries, which references were broken during the upgrade. Our JasperServer installation heavily takes advantage of the fact that JS allows linking to resources and controls. So I created a structure like |-Reports |-ProductionReports |-..... |-SharedElements |-InputControls |-ProductionReportsInputConrols |- ... |-DataTypes |-Queries I hope I gave the idea :) Which means that data types are shared among many input controls, and each input control is shared among many reports. Each report has at least 6 InputControls associated with it. While the names were correct, it turned out that the references to those elements were somehow broken during migration, resulting in missing references when running the report. When I run the report in iReport, the error does not show up because iReport does not take in account the Inputcontrols defined on the server, and it relies only on the Input Parameters specified in the jrxml (correct me if I'm wrong). I took a test report and had to delete the references then create a set of "Local" inputcontrols to get it working. It seems that I'll have to delete and create again all the shared resources, because simply editing those resources doesnt seem to get it working. Only the shared resources that I deleted and created as new worked again. Should I have done something to avoid this? Did it happen to someone else? Thank you for helping me, now I am stopping my test of JS 3.7 RC and waiting for the release to come out before trying again and see if migration works. Tell me if I should update this topic or consider the issue solved (In my opinion it is not, because other people may find themselves in the same situation, but at least now I know how to somewhat fix it) Regards, Giovanni

I also attached the server.log file from Glassfish of an unsuccessful run of a report

I got help from user lucianc on Jasperforge forums: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=69386 A more detailed error log: HTTP Status 500 - type Exception report message descriptionThe server encountered an internal error () that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [ViewReportAction@325b5 formObjectName = 'formObject', formObjectClass = [null], formObjectScope = Flow] in state 'checkForParams' of flow 'viewReportFlow' -- action execution attributes were 'map[[empty]]' root cause org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [ViewReportAction@325b5 formObjectName = 'formObject', formObjectClass = [null], formObjectScope = Flow] in state 'checkForParams' of flow 'viewReportFlow' -- action execution attributes were 'map[[empty]]' root cause java.lang.NullPointerException

Thank you for your time, I am going to look into it and post my findings as a reply on this topic!

I did as told (I commented the lines you asked me to remove) and the result is that the jasperserver.log does not display any error, while on the server page I get the following error. I attach the server.log file HTTP Status 500 -type Exception report message descriptionThe server encountered an internal error () that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [ViewReportAction@19a6d0b formObjectName = 'formObject', formObjectClass = [null], formObjectScope = Flow] in state 'checkForParams' of flow 'viewReportFlow' -- action execution attributes were 'map[[empty]]' root cause org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [ViewReportAction@19a6d0b formObjectName = 'formObject', formObjectClass = [null], formObjectScope = Flow] in state 'checkForParams' of flow 'viewReportFlow' -- action execution attributes were 'map[[empty]]' root cause java.lang.NullPointerException note The full stack traces of the exception and its root causes are available in the Sun GlassFish Enterprise Server v2.1 logs. Sun GlassFish Enterprise Server v2.1

Hello, the installation went smoothly using the Buildomatic script provided in the Jasperserver distribution. Yes, all the reports I created stopped working after the update. I used Java SDK 1.6u17 installed on my system. The war file is deployed in the /autodeploy folder in the GlassFish "domain1" directory, as it should be. I also opened a thread in the forums to see if someone can provide some suggestions I could not think of. Regards, Giovanni

The jasperserver log file is called jasperserver.log and is located at C:SunAppServerdomainsdomain1autodeployjasperserver.warWEB-INFlogs on my machine. I am attaching you the logfile I get after a server restart, as well as server.log which is the Glassfish logfile located in domain1logs directory. This logfile is obtained with the server running in Debug Mode. As for the app server itself, with some noteworth log entries such as the one I attached in the CODE section below due to its length and this one: [#|2010-01-13T18:12:29.632+0100|WARNING|sun-appserver2.1|javax.enterprise.system.tools.admin|_ThreadID=10;_ThreadName=main;_RequestID=b253dd7c-bbb7-4ea3-b9c1-cd62ea5186d6;|Not registering AMX MBean against old MBean "com.sun.appserv:j2eeType=WebModule,name=jasperserver,J2EEServer=server,J2EEApplication=null,category=runtime" due to malformed composite WebModule name.|#] I also attached the server log. I know that this doesn't add much informations but I can assure I am clueless and I'm trying to be as helpful as possible. Thank you Giovanni Code: Post Edited by maggix at 01/13/2010 17:06

Hello, thank you for replying! Attached in the "code" section is the logfile from Glassfish V2. Action I took for this logfile: 1- I logged in as jasperadmin/jasperadmin on localhost (first 2 lines) 2- I clicked on the report Could it be something regarding scriptlets? I had a custom scriptlet named dateUtilitiesScriptlet in the package I called dateUtilitiesScriptletP, which imports net.sf.jasperreports.engine.JRDefaultScriptlet and extends JRDefaultScriptlet.( public class DateUtilitiesScriptlet extends JRDefaultScriptlet ) It was compiled using jasperreport included in the 3.5.0 distribution, should it be recompiled for the libraries included in 3.7.0 RC? [EDIT] I tried uploading the .jrxml again, and checking all Resources from within JasperServer 3.7 , but still no luck. The error is the same as before Regards Giovanni Code: Post Edited by maggix at 01/13/2010 13:30

Hello, I set up JasperServer 3.5 running on Sun GlassFish server 2.1 with MySQL 5.1 in a Windows environment (Windows 7 x64 as a dev machine, to be more precise). Everything worked correctly so I tried the upgrade to 3.7 RC, following the procedure using the js-ant scripts provided in the "bin" distribution. The upgrade went succesfully, users and roles were restored as well as, apparently, all resources. Which means that there are no missing images/datasources/input controls. However, when I select "View" on the report I created in 3.5, the following error appears: Error Message: An error occurred. Please contact your system administrator. As for the error trace, I am attaching it to this message as "code", in case someone wants to try to have a look at it. Please note, however, that running the same report from the JasperServer browser in iReport shows no error, and that editing the report and then saving it in JasperServer reports "no error", which means that validation of the report is succesful. I was wondering if someone else had this problem and, if that's the case, how it was solved. Thank you in advance Giovanni Code:org.apache.jasper.JasperException: java.lang.NullPointerExceptionorg.apache.jasper.JasperException: java.lang.NullPointerException at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:418) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:427) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:333) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:873) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:723) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:558) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:490) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:382) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:236) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257) at org.springframework.webflow.mvc.servlet.ServletMvcView.doRender(ServletMvcView.java:50) at org.springframework.webflow.mvc.view.AbstractMvcView.render(AbstractMvcView.java:179) at org.springframework.webflow.engine.ViewState.render(ViewState.java:282) at org.springframework.webflow.engine.ViewState.doEnter(ViewState.java:186) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.support.TransitionExecutingFlowExecutionExceptionHandler.handle(TransitionExecutingFlowExecutionExceptionHandler.java:110) at org.springframework.webflow.engine.FlowExecutionExceptionHandlerSet.handleException(FlowExecutionExceptionHandlerSet.java:113) at org.springframework.webflow.engine.Flow.handleException(Flow.java:608) at org.springframework.webflow.engine.impl.FlowExecutionImpl.tryFlowHandlers(FlowExecutionImpl.java:643) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleException(FlowExecutionImpl.java:600) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:224) at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:140) at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) 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 $Proxy39.launchExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) 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.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:427) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:333) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) 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:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) 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:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:313) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94) at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:647) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:579) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:831) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265) at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)Caused by: java.lang.NullPointerException at org.apache.jsp.WEB_002dINF.jsp.JSErrorPage_jsp._jspService(JSErrorPage_jsp.java from :51) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) ... 124 morejava.lang.NullPointerExceptionjava.lang.NullPointerException at org.apache.jsp.WEB_002dINF.jsp.JSErrorPage_jsp._jspService(JSErrorPage_jsp.java from :51) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:427) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:333) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:873) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:723) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:558) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:490) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:382) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:236) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257) at org.springframework.webflow.mvc.servlet.ServletMvcView.doRender(ServletMvcView.java:50) at org.springframework.webflow.mvc.view.AbstractMvcView.render(AbstractMvcView.java:179) at org.springframework.webflow.engine.ViewState.render(ViewState.java:282) at org.springframework.webflow.engine.ViewState.doEnter(ViewState.java:186) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.support.TransitionExecutingFlowExecutionExceptionHandler.handle(TransitionExecutingFlowExecutionExceptionHandler.java:110) at org.springframework.webflow.engine.FlowExecutionExceptionHandlerSet.handleException(FlowExecutionExceptionHandlerSet.java:113) at org.springframework.webflow.engine.Flow.handleException(Flow.java:608) at org.springframework.webflow.engine.impl.FlowExecutionImpl.tryFlowHandlers(FlowExecutionImpl.java:643) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleException(FlowExecutionImpl.java:600) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:224) at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:140) at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) 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 $Proxy39.launchExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) 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.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:427) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:333) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) 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:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) 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:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:313) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94) at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:647) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:579) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:831) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265) at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)

Hello Matt, thank you for your reply. I actually tried using a second parameter with the default expression containing the scriplet I wanted to call to execute my calculation, however the "parameter inside parameter" way didn't work for me. Using a Variable instead of a Parameter was my solution, that's why I felt I needed to share such information, because it took me a while to figure out and I thought someone could need it. Regards Giovanni

Hello, I solved the problem without the help from anyone in this forum and I am posting my solution hoping that would be helpful to someone. Using parameters in queries is OK as long no calculations are to be applied to such parameters. For example, a "static" parameter works but not a calculated one. Instead of parameter in query, I used a Variable. I defined a Variable without any kind of calculation, and wrote the Expression as follows: $P{MYSCRIPTLET_SCRIPTLET}.methodToCall{ $P{ input_control_parameter } } By doing this I got the variable evaluated inside the query, by writing SELECT ..... FROM .... WHERE .... field = $V{ myVariable } (without the "!" ) Best regards Giovanni

Hello, first of all I'd like to excuse myself if this topic has already been discussed, however I could not find any helpful information in this forum. For my other problems, I used the search function or refered to other tutorials found googling, that's why this is my first topic. I am currently working with iReport 3.6.0 from the day of release, and I'm stuck with a problem that involves using a custom scriptlet which works on a parameter in a query.The report I am working on is to be deployed on a JasperServer setup, which I currently use on a local server for testing. The iReport and JasperServer setups are OK (Libraries, JDBC, and so on). The scriptlet setup is OK, I created a Java class which extends the JRDefaultScriptlet class. I tested it on some text fields, and the result of the expression is correct. Also, there are no errors or warnings on the scriptlet itself. In the SQL SELECT query (which, by the way, is executed on a Oracle 10g database connected with JDBC) I have this code: AND ROUND(JULIAN_DATE) Between $P!{DateConverter_SCRIPTLET}.dateToJde($P{fromDateForm}) And $P!{DateConverter_SCRIPTLET}.dateToJde($P{toDateForm}) where DateConverter_SCRIPTLET is the name of my custom scriptlet (which calls the DateUtilitiesPackage.DateUtilitiesScriptlet class I included as a JAR file) and the names fromDateForm and toDateForm are 2 parameters which are marked as "PROMPT" in iReport, and have a corresponding Input Field in JasperServer. The query is a SELECT query on a database which uses Julian date (CYYDDD) instead of the usual DATE field , and the prompt field is shown to the user as a normal DATE INPUT (dd/MM/yyyy) which is to be converted in the other format. This script is provided by my Java custom scriptlet, which takes a Java.Util.Date value as input and returns a Integer value, which is supposed to be substituted in the above query. Please note that I already tried using the "!" in $P{fromDateForm} ($P!{fromDateForm}) but nothing changed. What I want to obtain is that the value I fill in the prompt fields (the Input Fields as called in JasperServer) is to be processed when the query is executed, but I get an error java.SQL.SQLException; the complete resulting error is attached as CODE in this topic. I don't know if my script does actually perform what is intended, but I dont know if it's possible in iReport to show the executed query somewhere (I didn't find anything about that...) so I can't check what's actually executed. I just need a way to get that value processed somewhere between the insertion of the value in the field by the user action and the query execution. I also attach as "Code" to this topic the method dateToJde which converts the Date format to an Integer corresponding to the date used in JDEdwards, so that you can check for any mistake. I hope that my topic explains correctly my problem, please feel free to ask for more details if needed. Thank you in advance for you attention Giovanni Code: Post Edited by maggix at 10/05/2009 12:56 Post Edited by maggix at 10/05/2009 12:59