kcd

"Dates and date/times must be represented as the number of milliseconds since January 1, 1970, 00:00:00 GMT."

I too had this problem with non-unique conditional style names in JasperReport Server 4.5.0. I renamed the style in all 21 subreports as a workaround. I encountered a "Date cannot be cast to java.lang.Boolean" as well as String. The reality is my conditions are all of type Integer, mostly automated REPORT_COUNT and group_COUNT variables.

org.quartz.jobStore.misfireThreshold and org.quartz.jobStore.clusterCheckinInterval appear to be very short (3 and 15 minutes) http://community.jaspersoft.com/questions/541168/missing-duplicate-reports-being-sent

Lame undocumented configuration thing as per http://www.jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=94158 and http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=85833 This is probably because your reports run for "too long" (as little as 3 minutes by default!)If you have few, long running reports like I do I suggest you modify js.quartz.base.properties and set 1 thread only with 150 minute timeouts\WEB-INF\js.quartz.base.propertiesline 9:org.quartz.jobStore.clusterCheckinInterval = 9000000line 11:org.quartz.threadPool.threadCount=1line 14:org.quartz.jobStore.misfireThreshold=9000000

This is probably because your reports run for "too long" (as little as 3 minutes by default!) If you have few, long running reports like I do I suggest you modify js.quartz.base.properties and set 1 thread only with 150 minute timeouts \WEB-INF\js.quartz.base.properties line 9:org.quartz.jobStore.clusterCheckinInterval = 9000000 line 11:org.quartz.threadPool.threadCount=1 line 14:org.quartz.jobStore.misfireThreshold=9000000 Read this: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=85833

For anyone else who finds this, here is the link to bug report -http://jasperforge.org/plugins/mantis/view.php?id=5609 Occurs when there are non-unique conditional style names between the subreports.

Bug listed here - http://jasperforge.org/plugins/mantis/view.php?id=5661 I also found ireport played up when editing XML so I had to edit it in another text editor Code:<band height="30" splitType="Prevent">

I am running into a similar problem occassionally with slow queries. The latest time my report ran indefinitely and I had to shut down Tomcat and clear the work and temp directories to save it from itself. Code:2012-05-25 10:35:53,972 ERROR ReportExecutionJob,quartzScheduler_Worker-0:310 - The job was not completed. A system error occurred while running it.java.lang.NullPointerException at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.createOutputs(ReportExecutionJob.java:588) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:427) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:233) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

I'm not sure if this works correctly anyway. If I supply three "Months" 2012-01-01 123 2012-02-01 234 2012-03-01 345 I get three data points but the category axis labels are as follows 4-jan, 11-jan, 18-jan, 25-jan, 1-feb, 8-feb, 15-feb, 22-feb, 29-feb $F{Month} != null "Total Accounts" $F{Month} $F{Users}

Still getting this issue of forgetting the time scale in 4.5.1. I needed timePeriod="Hour" or it would miss points despite showing labels for every second hour (I had big data gaps)

Any update on this? Code: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAN13718 tomcat 20 0 5474m 471m 17m S 0.3 4.0 0:41.23 java13718 tomcat 20 0 5538m 636m 17m S 98.0 5.4 0:44.18 java13718 tomcat 20 0 5538m 640m 17m S 62.5 5.4 0:46.06 java13718 tomcat 20 0 5538m 632m 17m S 1.0 5.3 0:46.09 java13718 tomcat 20 0 5538m 626m 17m S 2.3 5.3 0:46.16 java13718 tomcat 20 0 5538m 628m 17m S 25.3 5.3 0:46.92 java13718 tomcat 20 0 5474m 552m 17m S 0.7 4.6 0:46.94 java

This is a validation error. Perhaps either your timezone doesn't match that regex or perhaps that email address Anonymous:null@unknown ... I'm just skim reading it :) If you think your inputs are valid here are some helpful links to change the validation. http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=94962&page=2 http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94923&topid=95560 http://gskinner.com/RegExr/ Code:org.owasp.esapi.errors.ValidationException: trigger.timezone-ViewRepository_Schedule_OutputSettings_context: Invalid input. Please conform to regex ^[\p{L}\p{M}\p{Pc}\/]*$ with a maximum length of 100

I'm trying to use Font Extensions default fonts as recommended and export PDFs. I'm not having problems with DejaVu fonts but I am with Serif and Monospaced. Firstly when I deployed Jasperserver 4.5.1 I had to deploy Times New Roman for any reports to work (my reports do not use this font it must be required by Serif?). Secondly when previewing PDF's in Ireport on my windows machine all Monospaced fonts came out as the default Helvetica. DejaVu Sans Mono works. Shouldn't these default fonts work anywhere anyhow? Code:I'm not using pdf embedding and my iReport settings arenet.sf.jasperreports.default.font.name SansSerifnet.sf.jasperreports.default.font.size 10net.sf.jasperreports.default.left.indent 0net.sf.jasperreports.default.line.spacing.size 1net.sf.jasperreports.default.pdf.embedded falsenet.sf.jasperreports.default.pdf.encoding Cp1252net.sf.jasperreports.default.pdf.font.name Helvetica

I think this is what Font Extensions > Monospaced is supposed to resolve but I'm having problems with that http://jasperreports.sourceforge.net/sample.reference/fonts/index.html

Thanks, that does look relevant. I also found this which presumably hides the temp directory, changing it had not effect. <property name="outputFolderFilterList"> <list><value><![CDATA[(/organizations/[^/]+)*/temp(/[^/]+)*]]></value></list> </property> But the CE edition doesn't seem to have that temp folder The revelant form entry is <input id="outputLocation" type="hidden" value="/reports" name="contentRepositoryDestination.folderURI"> Found in WEB-INF\jsp\modules\reportScheduling\jobOutput.jsp <legend class=""><span><spring:message code="report.scheduling.job.edit.output.label.output.location"/></span></legend> <spring:bind path="job.contentRepositoryDestination.folderURI"> <input type="hidden" id="outputLocation" name="${status.expression}" value="${status.value}"/> But I cannot find where the default is populated. Any ideas?

I believe Chrome is following autocomplete="off". You could remove it? <form id="loginForm" autocomplete="off" action="j_spring_security_check" method="POST">

The default for file location Scheduled or Run in background reports is the currenct directory (/reports). Obviously for many users it is wise to make this a read only folder and therefore the default will not work. I first starting looking for how change the default directory to something suitable but couldn't find how. Anyone know? I did find reference to a /temp directory which would also mean we don't need to store endless reports just so they can be emailed once. Is this a legacy option or can we have a special temp directory? Thanks in advance Output Location– The folder for saving the report output. This field is required and you must have write permission to the folder. If you email the report and do not want to save it, specify the Temp folder. http://help.jaspersoft.com/#../Subsystems/jrs-user-help/Content/JasperReports-Server-User-Guide/schedules/schedules-introduction.htm%3FTocPath%3DWorking%2520with%2520JasperReports%2520Server%7CScheduling%2520Reports%2520and%2520Dashboard%2520Exports%7C_____0 Output Location The job output folder /Temp cannot be found. It might have been deleted or moved.

Whoops, didn't see there was a page 2 when I hit reply.... mgeise has a more complete answer

Here is a fix below. Actually Jasperserver should be spliting the email addresses and validating them individually but this will work. You might as well fix queries too, also below Or if you get sick of it, effectively disable a validator like so Validator.Email=^.*$ Code:# Validator.Email=^[\\p{L}\\p{M}\\p{N}._%'-]+@[\\p{L}\\p{M}\\p{N}.-]+\\.[a-zA-Z]{2,4}$# Allow multiple emailsValidator.Email=^[\\p{L}\\p{M}\\p{N}._%'-]+@[\\p{L}\\p{M}\\p{N}.-]+\\.[a-zA-Z]{2,4}[\\s*,\\s*[\\p{L}\\p{M}\\p{N}._%'-]+@[\\p{L}\\p{M}\\p{N}.-]+\\.[a-zA-Z]{2,4}]*$# Validator.ValidSQL=^\\s*((?i)select)\\s+[^;]+$# Fixed for stored procedures etcValidator.ValidSQL=^\\s*(?i)(with\\s+.*)?(select|call|exec(ute)?)\\s+[^;]+$

I cannot get the "repo:" expression handling to behave with the iReport JRXML validation tool when uploading. Two scenarios in iReport 4.5.1 Repository Navigation > localhost > Reports > Some report> Main.jrxml (rightclick) > Replace with current 1 - JRXML validation window for Image says local: "imageslogo.jpg" proposed: "repo:logo.jpg"This is ok because it uploads the image. BUT it changes the local file to "repo:logo.jpg" so you can no longer preview it. Why does it change the local image expression? ...Or choose linked resource 2 - JRXML validation window for Linked Resource says local: "imageslogo.jpg" proposed: "repo:/images/logo.jpg"This seems good because it doesn't change the local file and you can preview it. BUT it leaves the repository file as "imageslogo.jpg" so you cannot run it on Jasperserver. You'll get the error below. As far as I can tell both options are broken. Also see http://jasperforge.org/projects/ireport/tracker/view.php?id=5539 Anyone got this working sensibly? Post Edited by kcd at 03/20/2012 22:41

Yes the proposed new names shouldn't change the local copy of the report. Workaround by mdahlman, thanks http://stackoverflow.com/questions/7413216/linking-subreports-in-ireport-so-they-also-work-in-jasper-server

Agreed. Vote here: jasperforge.org/projects/ireport/tracker/view.php?id=5539 Post Edited by kcd at 03/13/2012 03:36

Also check your file permissions, they can cause similar errors uploading from ireport e.g. check jasperserver.log or catalina.out and look for file io errors. ll chmod -R tomcat webapps/ chgrp -R tomcat webapps/

Thank you mmanica, this is exactly what I was looking for when I first posted on the forum! To clarify the following regex fix should work for most cases. webapps\jasperserver\WEB-INF\classes\esapi\security-config.properties\validation.properties Validator.ValidSQL=^\\s*(?i)(with\\s+.*)?(select|call|exec(ute)?)\\s+[^;]+$ Alternatively turn off validation - security.validation.sql.on=false Lucian, I hadn't realised I landed in the library bug tracker and unfortunately I don't see how to move this bug.

Solution found - there are security configuration options to amend or disable the validation. 1 - The following regex fix should work for most cases. webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties/validation.propertiesValidator.ValidSQL=^s*(?i)(withs+.*)?(select|call|exec(ute)?)s+[^;]+$ 2 - Alternatively turn it off webapps/jasperserver/WEB-INF/classes/esapi/security-config.propertiessecurity.validation.sql.on=false Post Edited by kcd at 02/14/2012 23:00 Post Edited by kcd at 02/14/2012 23:01