Ravi Kumar

Hi KKriplani, thanks for your sugession! issue with port number, i am using my company mail ID so i should use port number is 465, and also protocal should be smtps earlier i used smtp Change:1 report.scheduler.web.deployment.uri=http://localhost:8080/jasperserver report.scheduler.mail.sender.host=smtp.gmail.comreport.scheduler.mail.sender.username= <My company Mail Address>report.scheduler.mail.sender.password= <Password>report.scheduler.mail.sender.from=<My company Mail Address>report.scheduler.mail.sender.protocol=smtpsreport.scheduler.mail.sender.port=465Change:2 <property name="javaMailProperties"> <props> <prop key="mail.smtps.sendpartial">true</prop> <prop key="mail.smtps.auth">true</prop> <prop key="mail.smtps.starttls.enable">true</prop> </props> </property> it works fine now , thanks for your help.

Subject:The job failed to execute. Review its parameters. Date:Today Component:Report Scheduler Message:Job: TestReportJob1 (ID: 9737) Report unit: /reports/TestReport Quartz Job: ReportJobs.job_9737 Quartz Trigger: ReportJobs.trigger_9734_0 Exceptions: The job error notification was not completed. An error occurred while sending it. org.springframework.mail.MailAuthenticationException: Authentication failed; nested exception is javax.mail.AuthenticationFailedException at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:392) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:340) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:336) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl.sendMailNotification(ReportExecutionJobMailNotificationImpl.java:135) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:1063) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:557) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:236) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Caused by: javax.mail.AuthenticationFailedException at javax.mail.Service.connect(Service.java:306) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:389) ... 8 more

Any Help ?

Hi Hozawa, this is what my requirement, please observe the below screen shots. also the settings that i used, please let me know the changes Thanks...

Hi Every one, i have a requirement , i have two independent reports, i want to show both as single report, for this as we know i created a main report and placed Sub Report elements and mapped those two sub reports, but i want to display at a time single report, for the second report i just want to place a text field (Static Text field)in my main report and it should be clickable, this Requiremet is not like as drilldown kind of report, because both are independent reports. but uses the same number and kind of input parameters. when i click on that text field then only i want to show the second report. like a webpage we can use anchor tag , is there any possibility to achive this? Thanks in advance..!!

Hi Every one, Greetings for the day! i am using Jasper server Comminity Edition CP 6.1.0, I have created a Report and i am trying to schedue it, as per the schedule report Report gets generated and saved into "/reports" folder, but i am unable to get this report into Mail as i scheduled under notification. following are the properties i am using for Jasper server mail settings. "js.quartz.properties" report.scheduler.web.deployment.uri=http://localhost:8080/jasperserver report.scheduler.mail.sender.host = smtp.gmail.comreport.scheduler.mail.sender.username = <my Mail Id>report.scheduler.mail.sender.password = <my Mail Id Password>report.scheduler.mail.sender.from = <my Mail Id>report.scheduler.mail.sender.protocol = smtpreport.scheduler.mail.sender.port = 587 i tried with the port no 25 and 465 and in "applicationContext-report-scheduling" <property name="javaMailProperties"> <props> <prop key="mail.smtp.sendpartial"> true </prop> <prop key="mail.smtp.auth"> true </prop> <prop key="mail.smtp.starttls.enable">true</prop> </props></property> still i am unable to get mail, is there any other changes / Setting i need to do ? Please help, thanks in advance.

Hi hozawa, i need to show the charts and logo in exported Excel, so i need to set false for the above properties, and javier, i used the property "net.sf.jasperreports.export.xls.one.page.per.sheet:true" and also i need to use Property "net.sf.jasperreports.page.break.no.pagination:apply" then only Report getting splitted into two different sheets, but my report tabular data having 3800 + Records, when i used the property "net.sf.jasperreports.page.break.no.pagination:apply" , while i am trying to export into excel i am getting the following exception.. what is the root cause for this ? with out this property ("net.sf.jasperreports.page.break.no.pagination:apply" ) i can able to export data , but all in a single sheet, The server has encountered an error. Please excuse the inconvenience. Error Messagenet.sf.jasperreports.engine.JRRuntimeException: Error occured during report generation Error Tracenet.sf.jasperreports.engine.JRRuntimeException: Error occured during report generation at net.sf.jasperreports.web.servlets.AsyncJasperPrintAccessor.getFinalJasperPrint(AsyncJasperPrintAccessor.java:192) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitResult.getJasperPrint(ReportUnitResult.java:97) at com.jaspersoft.jasperserver.war.action.AbstractReportExporter.getJasperPrint(AbstractReportExporter.java:123) at com.jaspersoft.jasperserver.war.action.AbstractReportExporter.export(AbstractReportExporter.java:94) at com.jaspersoft.jasperserver.war.action.ReportExporterAction.export(ReportExporterAction.java:147) at sun.reflect.GeneratedMethodAccessor1025.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionList.execute(ActionList.java:155) at org.springframework.webflow.engine.State.enter(State.java:193) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) 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:393) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:560) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) at sun.reflect.GeneratedMethodAccessor312.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy144.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:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:94) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:182) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:209) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:209) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.OutOfMemoryError: Java heap space Error Messagejava.lang.OutOfMemoryError: Java heap space Error Tracejava.lang.OutOfMemoryError: Java heap space

Hi Crystopher, Check the ULR you have given in Address bar weather you are able to access the image or not , you cant access it because it is Server hosted URL, Pls observe below image if you want to access Remote Hosted Image you can use the URL in Image Expression as follows <imageExpression><![CDATA["http://www.mascotdesign.com/_dev/images/famous-cartoon-character-mickey-mouse.png"]]></imageExpression dont consider Jasper Server installed path is the Remote Server Path for Images/fiels. if you want to Access Image from your local Machine then you need to Use your local Directory Path Eg: (C:ImagesPenguins.jpg). and while uploading the report into Jasper server you need to change the Image Expressions as follows <imageExpression><![CDATA["repo:Penguins.jpg]]></imageExpression while uploading the Report into Jasper server, under Controlls and Resources it will list out the name of the Image under Resources Section, Pls observe the below screen shot. then again you need to add that image to Jasper server by clicking Add Now and browsing it from the local repository.

Hi Hozawa, i tried with the following Properties to the Report, but i am unable to achieve full Requirement like Sorting and filtering the data in Excel, i get some shpe but sorting and filtering are not working as expected in the excel, net.sf.jasperreports.export.xls.ignore.graphics -- False net.sf.jasperreports.export.xls.collapse.row.span -- False net.sf.jasperreports.export.xls.ignore.cell.border -- False or else is there any possibility to export each sub report into different sheets ? is there any property for this ?

Hi , Select the Image Element from Palette, and drag and drop into Report , it will prompt a window "Create New Image Element", it will list the Image Creation Mode, select the appropriate option, if you find Browse option then select the image from the local or Remote file directory, before uploading the Report to Jasper Server, you need to Replace the Image Path to "Repo:Image1.jpg" like this. in JRXML Source code while uploading the Report it under resources section it will list the Image name and then again you need to click on it and select the image from your machine repository.

Hi Everyone, Greeting for the day!!,, i have a MainReport , it consists of three sub reports, Report1 and Report2 are two charts and Report3 is Tabular Report, After creating these three reports in IReport designer, i uploaded them into Jasper server, when i ran that Report and exported that into Excel, i am unable to do sorting and filtering in Excel, because all Columns and rows are Merged with Charts and Images and Title, is there any solution for this to Get sorting and filtering the data in Exccel after Exported the report into Excel.. thanks in advance for your support and help..

Ya thanks for your Sugessions Hozawa and Elizam, My requirement is like as follows, i want to apply a branding on my report and also wanted to Apply Row Level security, i want to format my report using IReport or Jasper Studiio like by putting images, Boarders, etc. while uploading my Report(JRXML file)in to the Jasper server , i want to make use of Domain Designer Feature so that i can apply this Domain Level Security(Row or Column level) security. is this approach will possible by JSS/IReport and Jasper Report server. if there is any alternative solution could you please sugest me to achive this. thanks in advance..

Please see the post http://community.jaspersoft.com/questions/874046/problem-design-report-using-batch-processed-query

Hi All, Greeting for the day... is there any possibility to apply Domain (Row Level or Column Level security) for the Report which is designed by using IReport or Jasper Studiio. Thanks in Advance.. if there any solution can you please guide me to achieve this Requirement.

Hi Hozawa, as you told i reinstalled in C:JasperServer folder, now i am not getting that exception, but when i try to access any other links first time it is showing the same exception, but after refreshing the page i am getting the page properly.. do i need to do any changes still?