kashoory

Hi, We are using Jaspersoft reporting for AWS (Hourly) for some years. So far I was able to update my Jaspersoft Studio Pro whenever it became expired. But this time I cannot find anyway to do that? Does anyone know how to get an updated license? I used to be able to get a license by going to this link http://support.jaspersoft.com/support_my.php and create a new account (entering my instance id). But it does not seem to be working anymore. Any help would be appreciated. Regards, Keivan

I have a scheduled report with result saved into PDF file. The report has a static google maps. Everything was perfect during last couple of years until recently that I started to experience failures intermittently. The scheduler fails to export the report into PDF file apparently due to 403 error accessing Google Maps static API. But I'm quite sure I have not changed anything in my side. I can open the static map in my browser without any issue. I also can get map content with curl on the same ec2 instance of jasperserver without http error. And just mind you that the error is intermitent. I found the following exception in logs in /var/log/jasperserver/: 2018-01-17 16:45:04,929 ERROR ReportExecutionJob,quartzScheduler_Worker-1:309 - The export to pdf was not completed. An error interrupted the process.java.lang.RuntimeException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL : http://maps.google.com/maps/api/staticmap?center=-37.905525,145.12576&size=490x650&zoom=13&maptype=roadmap&format=png&scale=1&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&sensor=false&language=en at net.sf.jasperreports.components.map.MapElementPdfHandler.exportElement(MapElementPdfHandler.java:56) at net.sf.jasperreports.engine.export.JRPdfExporter.exportGenericElement(JRPdfExporter.java:2801) at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:969) at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:920) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:797) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:514) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.exportToPdf(EngineServiceImpl.java:559) at sun.reflect.GeneratedMethodAccessor760.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy49.exportToPdf(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.PdfReportOutput.getOutput(PdfReportOutput.java:88) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:516) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:220) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:49) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL : http://maps.google.com/maps/api/staticmap?center=-37.905525,145.12576&size=490x650&zoom=13&maptype=roadmap&format=png&scale=1&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&sensor=false&language=en at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:117) at net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:48) at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:155) at net.sf.jasperreports.repo.RepositoryUtil.findInputStream(RepositoryUtil.java:176) at net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(RepositoryUtil.java:192) at net.sf.jasperreports.engine.RenderableUtil.getRenderable(RenderableUtil.java:121) at net.sf.jasperreports.components.map.MapElementImageProvider.getImage(MapElementImageProvider.java:211) at net.sf.jasperreports.components.map.MapElementPdfHandler.exportElement(MapElementPdfHandler.java:52) ... 22 moreCaused by: net.sf.jasperreports.engine.JRException: Error opening input stream from URL : http://maps.google.com/maps/api/staticmap?center=-37.905525,145.12576&size=490x650&zoom=13&maptype=roadmap&format=png&scale=1&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&sensor=false&language=en at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:302) at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:100) ... 29 moreCaused by: java.io.IOException: Server returned HTTP response code: 403 for URL: http://maps.google.com/maps/api/staticmap?center=-37.905525,145.12576&size=490x650&zoom=13&maptype=roadmap&format=png&scale=1&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&markers=label:N%7Cicon:http://labs.google.com/ridefinder/images/mm_20_orange.png%7C-37.878597,145.16536&sensor=false&language=en at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1628) at java.net.URL.openStream(URL.java:1048) at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:298) ... 30 more[/code]

Hi ovais, In adHoc design view, do you put the data/time field in "Rows"? If yes, right-click on the date/time field that located in "Rows", from "Change Grouping" choose the option suits you which in your case it looks like "Hour By Day" is the right option. Please note that if you choose "Hour", result would be aggregated on hours which does not seem to be what you want. If you do not put date/time in "Rows" please give more detail. Regards, Keivan

Sorry, that's my bad. Everything is alright now!

Changed Assigned User from @User_306070 to @anonymous Lucian,Thanks for your solution. It solved my problem. But do you know why it does not put line-break after ? I actually had to put a , but I expected a line-break after automatically.I again appreciate your help.KeivanIn relation to "PS": Apparently with the license that we have for our product, help/support must be done using this website and community.

It's a bit late I know, but I just answer in case that someone else gets to this page with the same question! In Jasper Studio Professional 5.6.1: Double click on the chart. Press the button "Show Advanced Properties". Select the tab "Context specific". Press "Add" and select yAxis from the "Name". Add different yAxis for your y-axes and assign different _jrAxisIndex to them. For each yAxis add a property "id" and assign a unique string to it. Now you can customise every yAxis separately by adding properties like min, max, etc. It is the time to assign yAxis to measures: Go to Configuration, select a measure, using "Advance propertis" add a contributor "SeriesProperty", with property name "yAxis", in constant value type string id (without quote) of the yAxis you want to use for the measure (you already set this id in previous step). Do it for all measure to assign them to the right axis. I hope it helps! Keivan

I really appreciate that you shared your nice methodical solution.

Is there anyway to disable "Always Prompt" through URL?

Another solution is to use port 25 instead of 465 and 58. It worked on Amzon SES and gmail. Find the detail on my answer to previous post.

Hi Ghayes, Thanks for the response. I had the SSLException problem with both Gmail and Amazon SES on ports 465 and 587 even with the magic string for report.scheduler.mail.ssl.ciphersuites ! However, port 25 worked for me on both gmail and SES without the magic string because it is apparently not using SSL at all. I reckon the problem is with SSL only, I am not expert though. For port 25, I did NOT use the following settings: true true "${report.scheduler.mail.ssl.ciphersuites}" My settings on are: -------------------------------------------------- true true -------------------------------------------------- report.scheduler.mail.sender.host= AMAZON=> email-smtp.us-west-2.amazonaws.com , GOOGLE=> aspmx.l.google.com report.scheduler.mail.sender.username=Amazon=> AWS_ACCESS_KEY , GOOGLE=> gmail account report.scheduler.mail.sender.password=Amazon=> AWS_SECRET_ACCESS_KEY , GOOGLE=> gmail password report.scheduler.mail.sender.from=Amazon=> amazon ses registered email address , GOOGLE= mail address report.scheduler.mail.sender.protocol=smtp report.scheduler.mail.sender.port=25 Te problem I faced with gmail was "Mail can only be sent to Gmail or Google Apps users" according to https://support.google.com/a/answer/176600?hl=en. As a result, I preferred to use Amazon SES. Keivan

I receive exactly the same assertion! Everything was alright in JasperServer 5.5.1 AWS. I installed a new instance JasperServer 5.6.1 AWS through CloudFormation and used the same setting for mail server and received this exception.

I found the reason. There is an ugly incorrect definition in files: jasperserver-pro/scripts/common/util/parse/date.js jasperserver-pro/scripts/common/util/parse/time.js ISO_8601_TIME_PATTERN is defined as "hh:mm:ss" while it must be "HH:mm:ss"! Just correct it in both files and go through reoptimization procedure if optimazation is enabled (refer to section "Customizing JavaScript Files" in JasperServer Ultimate Guide).

I created a report in Jasper Studio 5.6.1 that used a time input control. Published it on JasperReports Server AWS. Created an input control for my report with the type time. I happened to find that when I enter time between 12AM and 12:59:59PM, the return value is okay, while after that it is entered_time-12hours. i.e. it returns 01:25:28 for both 01:25:28 and 13:25:28. Is it known issue? Any workaround?

It is excellent! Thank you.