Friendly User

[toc on_off::hide=1] Issue Description:How can we control the justification of the barcode (left/right etc) or the position within the cell. Resolution:Barcodes use the font from the style associated to the report element. Note though that fonts from font extensions will not work, you need to use a font that's installed in the system/JVM. That's due to a limitation of the Barcode4J API. Setting the horizontal alignment in the style associated to the element affects the position of the barcode. Ref. Case #00027903

This article describes how to change your default topic folder. Issue Description:[toc on_off::hide=1] I've created a topic following these steps: 1. Add new report 2. Select the event manager domain in the event manager folder. 3. Selected the 'events' which are now under 'Selected fields'. 4. Click on 'save as topic' and put it in the myfolder/manager-topics/ folder. 5. I then clicked table, added a few fields, and then saved. I can see the topic in the folder of type 'Domain Topic'. It's not showing up when I want to create 'Add new Report' and select topics. I've done it even as superuser in case it was a permissions issue. What makes a topic appear in this list? Resolution:for topics to be considered topics they should be put into Adhoc Components/topics folder of the repository. In all other location they'll be considered ordinary reports (since they are a simple JRXML). The folder where topics are to be stored to be considered as topics is defined as a search pattern. By default everything with the path %/adhoc/topics will be used. If you want to modify this you need to change these configurations: file: applicationContext-adhoc.xml bean: adhocEngineService properties: realmsURI, realmsURIParentSQLPatternList If they should be allowed to save their domain topics in the home folder then you'd need to extend file: applicationContext-semanticLayer.xml bean: slConfig properties: saveTopicURIPatternList Ref. Case #00028126

Issue:I would like to set the "Sequential Filenames" checkbox on the "Output Settings" page of the create schedule screen to be checked by default, but I can't find where the default value is set. Could you let me know how I can change the default value of this field? Resolution:[toc on_off::hide=1] please try the following approach: edit WEB-INF/flows/reportJobFlow.xml. Find this section: <action-state id="checkJob"> <evaluate expression="reportOptionsJobEditAction.setupForm"/> <transition on="success" to="initReportOptions"/> <transition on="notFound" to="jobNotFound"/> </action-state> replace <transition on="success" to="initReportOptions"/> with <transition on="success" to="setDefaults"/> Then add after this section the following: <action-state id="setDefaults"> <evaluate expression="flowScope.isNewMode and flowScope.job.contentRepositoryDestination.setSequentialFilenames(true)"></evaluate> <transition to="initReportOptions"/> </action-state> Ref. Case #00028169

Business scenario:[toc on_off::hide=1] You have a report that is to be localized into number of languages (locales) To display text in these languages you have to use different codepagesIssue Description:Report has fields to be localized for locales en_US, pl_PL, ru_RU and vi_VN. When you export the report to PDF in any non-English locale the text or some symbols do not get displayed. If you change the field's pdfEncoding property in the report, the text gets displayed. Resolution:To resolve this issue you need to create a font extension which will contain localized font for each intended codepage. To do this in iReport: Go to Tools->Options->Fonts. Click Install Font. Select desired font (for example let's take Times New Roman). Go to Family details section. Name the font family something like Times New Roman Localzied or Localized Font Family (the name itself isn't important, important is to use same name in Font Family section for each bundle we are going to create). Add italic, bold and bolditalic fonts. First font we will use with Western European locales. So in this section set pdfEncoding to cp1250 (Western European). Go to Locales section. In this section add all the Western European locales you are intending to use (en_GB, de_DE, fr_FR, etc.). Finish installing font. Now we need to take the same font we used, create copies of font files and rename them. Reason we need to do this is that font extensions cannot reference files with same font names, it'll create a conflict. So in our sample we want to export report to Polish, Russian and Vietnamese languages. Copy the font Times New Roman.ttf and rename it to something like Times New Roman .ttf Now install the fonts again. In the first section let's pick Times New Roman Russian.ttf. In the Family Details section name the font family the same as you did in step 3 (Times New Roman Localized or whatever name you picked). Add italic, bold and bolditalic versions (they should also have the names altered). Set pdfEncoding property to cp1251 (Cyrillic). Go to locales section. Add locales for the font - ru_RU, uk_UA, be_BY, bg_BG, etc. Finish installing the font. Repeat these steps for each language you are inteding to use. Once you've did that select all installed fonts in Fonts list using control-click and click Export as Extension. Now you can put this extension in classpath of JRS or your application and use those fonts there. For each field to be localized ($R field) select font Localized Font Family (or whatever you called your font in step 3), don't explicitly set the PDF Encoding property. Now for each locale you will have correct pdf encoding selected and correct font picked.Ref. Case #00028337

This article is NO LONGER VALID in versions 6.x and beyond IssueHow we can use built in parameters? Please give some example of using built in parameter (LoggedInUser). We want to use "LoggedInUser" in query and in scriptlet class. ResolutionTo use LoggedInUser parameter you need to first define it in your report like this: <parameter name="LoggedInUser" isForPrompting="false" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User">[/code]Now you can use the parameter in same fashion as you use parameters and can access methods of this object like this: $P{LoggedInUser}.getRoles()[/code]You can check the list of parameters in chapter 4.4 - Built-in Parameters for Query-based Input Controls of JasperReports Server Administrator Guide. For list of methods you should refer to our javadoc (Jasperserver-ce public API), specifically User class. In scriptlet you'll have to call this method: public java.lang.Object getParameterValue(java.lang.String parameterName, boolean mustBeDeclared) throws JRScriptletException[/code]To get the User object from parameter and then you'll be able to use it's methods. More info on scriptlet methods can be also found in public API here: http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRAbstractScriptlet.html Ref. Case #00024935 -- 16:42, 26 June 2012 (UTC) See AlsoBuilt-in Parameters for Logged In UserUsing report parametersCreating additional built-in parameters

Issue:We observer that there is a large number of temp files being created and remaining in directory xxx. Over a day 300.000 to 800.000 files remain in the temp directory (per day! We purge the temp files every night). We suspect that this causes (directly or indirectly) severe performance impacts and other strange behavours (e.g. same report is being emailed several times - same reports 16 times over 4 hrs.) making the system unusable (login takes 20min). Once we bring down Jasper/Tomcat and purge all tempfiles the system is ok again (if we restart tomcat only - no temp file purge) the situation stays poor. Sometimes we do not survive a business day and have to restart Japser over the day causing not acceptable interruptions! Why does Japser not remove it's tempfiles properly? What can be done? Technical Details Temp directory: /opt/PREP/temp Temp filename example: virt1218620063_846062934_1209681_77850186 Resolution:This problem may be caused by some report going into infinite loop which results in huge amount of virt files. Can you try adding the following property in your /WEB-INF/classes/jasperreports.properties file: net.sf.jasperreports.governor.max.pages.enabled=true net.sf.jasperreports.governor.max.pages=[arbitrary integer] Replace arbitrary integer with a maximum number of pages after which the report will be considered to hit infinite loop and it's execution will be terminated. Try entering a big number, marginally bigger than your biggest reports usually produce. When report hits the limit of the governor you should first of all check whether there are any overflows and stretches with overflow in report. Usually this results in endless cycles. Ref. Case #00025731 -- 16:23, 26 June 2012 (UTC)

Issue:Hi, we want to setup a report into the "Getting Started" page like the Demo shows it with the SuperMart Dashboard. But we did not find documentation to that subject, how to do it. Can you provide a step-by-step manual? Resolution:if you have installed our samples you can take a look here: <JRS WAR>/WEB-INF/jsp/modules/home there are three jsp's there: home.jsp homeForNonDemo.jsp homeForDemo.jsphome.jsp contains definition on which jsp to use for which role. You can create your custom jsp and define the redirection there for certain role. Then you put the code from homeForDemo.jsp to your new jsp but replace the path to dashboard. Ref. Case #00025754 -- 16:16, 26 June 2012 (UTC)

Issue:we have added a tJasperServerExec component to our TIS (4.2.3) installation and we are using it on a job execution with succes results. But when we deploy the project in the TAC and try to execute the same job in the server, we can't see any error in the execution, but the job doesn't work. We added the specific component jar libraries in the commandline-workspace and we restarted the commandline. What can we do? Resolution:It looks like you did not deploy the tJasperServerExec component in the command line. You could use the UserComponentPath to tell the command line where to find it, but it seems to have some bugs in 4.2.3. The workaround we found for this is to deploy the component directly in the command line folder structure, in the plugins/org.talend.designer.components.localprovider_4.2.3.r67267/components/ folder. Ref. Case #00025981 -- 16:13, 26 June 2012 (UTC)

Recommended reading before upgradingSupported platforms spreadsheetRelease notesInstall guide chapter 9 (upgrading from v3.7)[toc]Error FAQCannot instantiate abstract class or interfaceWhen exporting the repository you may encounter the error like this: java org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource This error means some element in your repository got corrupted. To troubleshoot the error do the following: Hibernate logging should be enabled for the import/export tool. The file to edit is buildomatic/conf_source/iePro/log4j.properties (in 3.7.x version it is buildomatic/conf_source/import_export_config_pro). Add the following log configuration: log4j.logger.org.hibernate.SQL=debug, stderr log4j.additivity.org.hibernate.SQL=false log4j.logger.org.hibernate.type=trace, stderr log4j.additivity.org.hibernate.type=false Run the export script again and you should get a more detailed log file this time. It'll contain debug information about resources being exported.You should get something like this in the debug logs right before the exception: 2012-06-04 16:02:31,208 TRACE LongType:193 - returning '612' as column: id2_1_ 2012-06-04 16:02:31,208 TRACE IntegerType:193 - returning '0' as column: clazz_1_ Open your database in your database explorer, find the resource with id '612' in JIResource table and delete it.Export the repository again.Exception in thread "main" java.lang.OutOfMemoryError: Java heap spaceThis error means you've exceeded the memory limit dedicated to buildomatic application. The solution for this in 3.7.1 would be: Find the file js-import-export.sh and back it up before editing. Edit this file.Find line # run javaAdd the following before this line (the -Xms and -Xmx values I've put here are arbitrary. You may have to increase them in your enviornment): # Add the java memory options to JAVA_OPTS export JAVA_OPTS="$JAVA_OPTS -Xms512m -Xmx1024m -XX:PermSize=32m" Modify the #run java command to $JAVA_EXEC -cp "$EXP_CLASSPATH" $JAVA_OPTS $JS_EXP_CMD_CLASS $JS_CMD_NAME --configResources $JS_EXPORT_IMPORT_CONFIG $CMD_LINE_ARGS that's for the shell script. Then try to export the file again.In js-export.bat file those memory options are exposed like this: REM Set the java memory options set JAVA_OPTS=%JAVA_OPTS% -Xms128m -Xmx512m -XX:PermSize=32m In v4.x, the sequence for the js-export.sh would be the following: go to buildomatic/bin/js-import-export.shsearch for line: # Add the java memory options to JAVA_OPTS The line below has java memory settings: export JAVA_OPTS="$JAVA_OPTS -Xms128m -Xmx512m -XX:PermSize=32m" Increase the Xms and Xmx values to 512 and 1024 respectively. run js-export.sh again.Should you get the OOM error again during the export - increase those values even further and increase PermSize a bit more. Error closing stream java.io.IOException: No space left on deviceThis error says you don't have enough space to store the exported archive. This may be caused by the fact that you indeed don't have enough space or in case of linux system - your /tmp folder space is too small. Clear you temp directories and monitor the diskspace during export. If your /tmp/ isn't large enough - increase it's size. java.lang.NullPointerException at java.util.zip.ZipFile.getInputStream when running js-upgradeWhen you encounter this error this means either your archive wasn't generated correctly during export or is somehow corrupted. Please check your export logs for any errors you can find and fix them. If you don't have any errors - try unzipping the archive and point the upgarde script to a folder rather than archive. Make sure the archive is extracted correctly and you have structure like this <folder>/<archive-content>

Issue: I was given this to add to reprots because of writing temp files net.sf.jasperreports.file.buffer.os.memory.threshold=-1 We added it and still temp files were written - see below Plus we got these errors - why [toc] Fill 1714476720: exceptionErrors were encountered when compiling report expressions class file:2012-04-30 20:24:44,477 WARN FileBufferedOutputStream,Finalizer:237 - Error while deleting the temporary file2012-04-30 20:26:02,619 ERROR JRThreadSubreportRunner,http-intgjasper-1.arc.com%2F10.164.104.156-6060-4:108 - Fill 1714476720: exceptionjava.lang.InterruptedException at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.waitResult(JRThreadSubreportRunner.java:100) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.resume(JRThreadSubreportRunner.java:87) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:623) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:327) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:402) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:361) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryOverflow(JRVerticalFiller.java:1736) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterNewPage(JRVerticalFiller.java:1196) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1029) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:156) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923) at com.jaspersoft.ji.engine.ProEngineServiceImpl.fillReport(ProEngineServiceImpl.java:251) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:727) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:385) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:872) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:319) at com.jaspersoft.ji.engine.ProEngineServiceImpl.execute(ProEngineServiceImpl.java:132) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:461) at com.jaspersoft.ji.report.options.actions.ReportOptionsViewAction.executeReport(ReportOptionsViewAction.java:96) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:451) at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:284) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction. at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) 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 java.lang.Object.wait[/code]Resolution:net.sf.jasperreports.file.buffer.os.memory.threshold is superseded by a hidden Spring configuration property, so you'll need to change both to make it effective. Also, -1 doesn't work so you should use a big value like 2147483647. To change the Spring configuration property, you need to edit WEB-INF/applicationContext-report-scheduling.xml, find a bean of type com.jaspersoft.jasperserver.api.metadata.common.domain.FileBufferedDataContainerFactory and add a memoryThreshold property to it: <entry key="dataContainerFactory"> <bean class="com.jaspersoft.jasperserver.api.metadata.common.domain.FileBufferedDataContainerFactory"> <property name="memoryThreshold" value="2147483647"/> </bean> </entry> Ref. Case #00026056 16:04, 26 June 2012 (UTC)

Issue:Hi, We have a problem with using HTML components in iReports. We have a complicated iReport with many nested sub reports but to demonstrate the error I have managed to reproduce the bug...please find the jrxml attached. [toc]The server has encountered an error. Please excuse the inconvenience.Error Messagecom.jaspersoft.jasperserver.api.JSExceptionWrapper: org.xml.sax.SAXParseException: schema_reference.4: Failed to read schema document 'http://jasperreports.sourceforge.net/xsd/htmlcomponent.xsd', because 1) could not find the document; 2) the document could not be read; 3) the root element of the document is not <xsd:schema>. I did find the article to create the jar file but get errors running the ant build file... C:JavaiReport-Professional-4.5.1demosampleshtmlcomponent>c:javaapache-ant-1.8.2binant clean javac Resolution:to build HTML component try this sequence: Download latest JR Pro distro.Go to <Jr Pro distro>/jasperreports and do ant clean jarGo to <Jr Pro distro>/jasperreports/demo/samples/htmlcomponent and do ant clean jar there too.Now you should have the htmlcomponent jar in htmlcomponent/dist folder.The error message: Failed to read schema document 'http://jasperreports.sourceforge.net/xsd/htmlcomponent.xsd' Usually is thrown when you're missing the htmlcomponent in your classpath. Please check that the jar you've compiled is in both iReport's and JRS's classpath (depending on context you're running it in). iReport 3.5.1 should have the HTML component in it's classpath from the go. JRS doesn't. Please try to check the following: you have HTML component jar file in ireportireportmodulesext. Additionally you can add jar file to classpath in iReport->Tools->Options->Classpathyou have HTML component jar file in <jasperserver WAR>/WEB-INF/lib folder.The jar file you generated can be placed there. Ref. Case #00026588 -- 15:14, 26 June 2012 (UTC)