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.

Thanks marianol. I had to use that formatter eventually. It has a bug in it but you can get it working somehow.

mgeise, It happened for a quiet simple report and it is intermittent. However we are still at very beginning level and we do not have lots of users and heavy concurrent usage at the moment. The server instance is medium and just a couple of guys are using reports time to time. Next time I will check memory usage and server status. Thanks for your help.

Hi hozawa I actually did tag it with AWS. But in the list "Related Projects" I could not find AWS and the closest item was JasperReport Server.

I am using HTML5 charts in Jasper Studio Professional. I want to set the tooltip to show a whole number and the percentage and set the decimals just for percentage. I found something like this from an example: <spanstyle="color:{series.color}">{series.name}</span>:<b>{point.y}</b>(<b>{point.percentage:.0f}%</b>)<br/>[/code]but it does not work correctly. After running the report in Jasperserver AWS, I can see the text "{point.percentage:.0f}%" in the tooltip instead of formatted number! Anybody knows what is the problem and the solution? Regards, Keivan

I am using MultiAxisSpline from HTML5 charts to create a report by Jasper Studio Professional . I have a problem with title of one of the y-axes. I set the title of the left-side yAxis by assigning the expression new ArrayList(Arrays.asList("My Title"))[/code] to the property yAxis.title.text using the dialog box "HTML5 Charts properties". When I load the report by Jasperserver AWS everything is okay, however after changing some input controls and pressing apply button, the title returns back to the default value "Y-Values"! Is there anything wrong with the way I set the title? Any help would be appreciated. Regards, Keivan

I am using jasper studio and Ad Hoc to create some reports. I have an intermittent problem with converting reports to PDF on jasper server AWS. While it usually goes well, it sometimes takes a long long time as I give up time to time and have to retry. Does anyone have the same problem? Is there anyway to fix it?