dnaboka

Issue DescriptionDuring JasperReports server start-up following error is observed: [toc]2019-12-05 13:09:17,648 ERROR CastorSerializer,main:88 - org.exolab.castor.mapping.MappingException: A mapping for class com.jaspersoft.jasperserver.export.modules.mt.beans.TenantBean already exists 2019-12-05 13:09:17,898 ERROR EhCacheImpl,main:557 - -- JasperServer: EhCacheImpl shutdown called. This normal shutdown operation. 2019-12-05 13:09:17,898 ERROR EhCacheImpl,main:560 - -- JasperServer: EhCacheImpl calling cleanerTimer.cancel(). This normal shutdown operation. 2019-12-05 13:09:17,945 ERROR ContextLoader,main:350 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantImportMergeUtil' defined in ServletContext resource [/WEB-INF/applicationContext-export-import-web-pro.xml]: Cannot resolve reference to bean 'multiTenancyExportConfiguration' while setting bean property 'tenantModuleConfiguration'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'multiTenancyExportConfiguration' defined in ServletContext resource [/WEB-INF/applicationContext-export-import-web-pro.xml]: Cannot resolve reference to bean 'tenantSerializer' while setting bean property 'tenantSerializer'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantSerializer' defined in ServletContext resource [/WEB-INF/applicationContext-export-import-web.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: A mapping for class com.jaspersoft.jasperserver.export.modules.mt.beans.TenantBean already exists Arguments: at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359) ResolutionThis is know issue running JasperServer 7.2.0 or 7.1.x on Tomcat 9.0.29 and 8.5.49. We certify up to Tomcat 9.0.17 and 8.5.39 Please downgrade to supported version of application server DockerIf you are using Docker container please change Dockerfile to pull Tomcat 9.0.17: FROM tomcat:9.0.17-jre8

Issue DescriptionWe need to use MySQL database table with JSON column "json_value "in a Domain. When we add "json_value" column in Ad Hoc designer empty value is being displayed. When'd like to show JSON value as String. Resolution<property name="codeToJdbcTypeMapping"> in /WEB-INF/applicationContext-jdbc-metadata.xml is responsible for vendor-specific JDBC type mapping. JSON in MySQL is represented by "1111". However, in JasperServer 7.2.0 "1111" is cosidered TIMESTAMP WITH PRECISION OF FRANCTIONAL SECONDS in Oracle, mapped to TIMESTAMP. Please edit line 83 and restart your server: <entry key="1111" value="VARCHAR"/>

Issue DescriptionWe are migrating our ETL jobs using Jaspersoft® ETL studio. We exported jobs from Jaspersoft® Studio 6.4.1 but when we try to import them into Studio 7.1.1 in log file we can see following messages: [toc]!ENTRY org.talend.platform.logging 2 0 2019-11-13 11:07:09.805 !MESSAGE 2019-11-13 11:07:09,805 WARN org.talend.commons.exception.CommonExceptionHandler - Can't find any signature !ENTRY org.talend.platform.logging 2 0 2019-11-13 11:07:09.806 !MESSAGE 2019-11-13 11:07:09,806 WARN org.talend.commons.exception.CommonExceptionHandler - The signature of item Job Designs commit_interval_CONTEXT 0.1 is invalid.ResolutionStarting from 7.0.1 version, after the installation of Talend Studio 7.0.1 customers have 90 days to import jobs created in previous version of Talend Studio. After this period, Talend Studio will not be able to validate and import project elements: https://community.talend.com/t5/Migration-Configuration-and/Migrating-to-Talend-7-0/ta-p/132017 If you have a valid ETL license we can request Talend to deliver a migration token key, allowing you to import your jobs. Please note, that the approval can take some time.

Issue DescriptionWe have a requirement to separate records with odd IDs (1, 3, 5 ..) from even IDs (2, 4, 6 ..) and store them in 2 separate Excel files. ResolutionYou could utilize tMap filter expression using "row1.id % 2 == 0" for even IDs and "row1.id % 2 != 0" for odd IDs respectively. Attached ETL job demonstrates a simple use-case using random text generator and 2 resulting Excel files.

Issue DescriptionI'd like to replace/link my table "ID" field with corresponding key-value pairs from CSV file, e.g. user_id,user_type 1098,sales 1051,engineer 307,customer ResolutionYou should use Lookup connection with tMap component. Once 2 (or more) input sources are joined you can perform transformation (if necessary) and output result for further processing or storing in DB, file, buffer etc tmap_lookup.zip

Issue DescriptionWe have some old Ad Hoc views that no longer work. We get NPE errors when we try to run, edit, delete them using web UI. Also, these broken views prevent us from exporting repository. ResolutionSuch broken views could be result of previous product customizations that no longer work or we not migrated to current version of JasperServer. It is possible to manually delete these Ad Hoc views from repository DB. However, you need to be very careful to not brake any dependencies! Example below demonstrated how to remove "Ad_Hoc_View" resource located in /public/Test folder with all the dependent bundles, queries, filters and hidden files: DELETE FROM "jiadhocdataviewresource" WHERE adhoc_data_view_id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri='/public/Test' ) AND jiresource.name='Ad_Hoc_View' ); DELETE FROM "JIAdhocDataViewInputControl" WHERE adhoc_data_view_id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri='/public/Test' ) AND jiresource.name='Ad_Hoc_View' ); DELETE FROM "jiadhocdataview" WHERE id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri='/public/Test' ) AND jiresource.name='Ad_Hoc_View' ); DELETE FROM jiresource WHERE jiresource.id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri='/public/Test' ) AND jiresource.name='Ad_Hoc_View' ); DELETE FROM jifileresource WHERE id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri like '/public/Test/Ad_Hoc_View%' ) ); DELETE FROM JIInputControlQueryColumn WHERE input_control_id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri like '/public/Test/Ad_Hoc_View%' ) ); DELETE FROM JIInputControl WHERE id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri like '/public/Test/Ad_Hoc_View%') ); DELETE FROM JIQuery WHERE id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri like '/public/Test/Ad_Hoc_View_files%' ) ); DELETE FROM jiresource WHERE jiresource.id IN ( SELECT jiresource.id FROM jiresource JOIN jiresourcefolder ON jiresource.parent_folder = jiresourcefolder.id WHERE jiresource.parent_folder IN ( SELECT id FROM jiresourcefolder WHERE uri like '/public/Test/Ad_Hoc_View_files%' ) ); DELETE FROM jiresourcefolder WHERE uri like '/public/Test/Ad_Hoc_View_files%' Ref. Case 01809349

Issue DescriptionJasperReports Server installation (or upgrade) stopped with following errors in buildomaticlogsjs-install-pro_2019-11-01_17-04-16523.log [toc][select-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [java] Error occurred during initialization of VM [java] Could not reserve enough space for 2097152KB object heap [java] Picked up JAVA_TOOL_OPTIONS: -Djava.vendor="New Oracle" BUILD FAILED C:\jasperreports-server-pro-7.1.1-bin\buildomatic\bin\db-common.xml:1351: The following error occurred while executing this line: C:\jasperreports-server-pro-7.1.1-bin\buildomatic\bin\import-export.xml:312: The following error occurred while executing this line: C:\jasperreports-server-pro-7.1.1-bin\buildomatic\bin\import-export.xml:196: Java returned: 1ResolutionYou are running 32-bit Java. Please install 64-bit version JRE/JDK, make sure system variables are set up correctly and restart your command line. JVM requirements are outlined in the article below: https://community.jaspersoft.com/wiki/hardware-requirements-jasperreports-server#Hardwarerequirements-JVMHeapMemory Ref. Case 01530669

Issue DescriptionA simple Ad Hoc view/report (crosstab) that returns only 10 rows takes more than 10 seconds to finish. Adding filters takes additional time as well. ResolutionAd Hoc Crosstab generates query similar to the one below: select count(`annual_revenue`) as `CountAll_annual_revenue`, `assigned_user_id` from `default`.`accounts` group by `assigned_user_id` order by `assigned_user_id` limit 200001;You could optimize Hadoop/Hive to speed up execution of queries containing ORDER BY, GROUP BY and LIMIT statements: https://support.treasuredata.com/hc/en-us/articles/360001450788-Hive-Performance-Tuning http://hadooptutorial.info/hive-performance-tuning/#3_Avoid_Global_Sorting_in_Hive https://dzone.com/articles/how-to-improve-hive-query-performance-with-hadoop However, you can make JasperServer Ad Hoc engine generate queries like this instead by disabling "Optimize Queries for Domain-based Reports": select `account_type`, `annual_revenue`, ... from `default`.`accounts` limit 200001Ref. Case 01806988

Issue Description:I'd like to enable mail notifications DEBUG messages to analyze scheduled job notifications. I've enabled <prop key="mail.debug">true</prop> but messages are not being logged in Tomcat and JasperServer log files only console output. Solution: First of all make sure you enable <prop key="mail.debug">true</prop> in applicationContext-report-scheduling.xml correctly by following article below: https://community.jaspersoft.com/wiki/gmail-smtp-report-jobs-failing-smtp-authentication-error-despite-correct-username-and-password If you would like to re-direct Tomcat console output to a file you could following suggestion below: https://stackoverflow.com/a/6864212/2569608 For example, syntax below will output "mail.debug" messages (as well messages from other Java classes) to logstomcat.log if your Tomcat root dir is C:optapache-tomcat-8.5.32: C:\opt\apache-tomcat-8.5.32\bin>catalina.bat run > C:\opt\apache-tomcat-8.5.32\logs\tomcat.log 2>&

Issue Description:I'd like to modify calendar drop-down to show only current Year and next 5 years. Solution: You will need to customize JavaScript files to achieve this. In particular, file jasperserver-pro/scripts/bower_components/jquery-ui/ui/jquery.ui.datepicker.js. Lines 1833 - 1835 are responsible for this functionality. For example, by changing values "10" to "5" and removing "-" from match() method regex your calendar will dispaly current and next 5 years in the drop-down: var year = (value.match(/c[+].*/) ? drawYear + parseInt(value.substring(1), 5) : (value.match(/[+].*/) ? thisYear + parseInt(value, 5) : parseInt(value, 5)));Then, you will have to run JavaScript optimization to introduce these changes to file(s) in ./optimized-scripts folder: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v710/customizing-javascript-files This articles helps you automate this process: https://community.jaspersoft.com/wiki/automate-tibco-jasperreports-server-javascript-customization-linux-using-bash Please keep in mind this change will also affect Date calendar as well as Ad Hoc filters and Report input controls.

Issue Description:We are trying to apply TAC license using following API call: [toc]./MetaServletCaller.sh --tac-url=http://localhost:8080/org.jasper.administrator --json-params={"actionName":"setLicenseKey","authPass":"admin","authUser":"security@company.com","licenseKeyPath":"/vagrant/license"} but facing an error: {"error":"A JSONObject text must begin with '{' at character 1","returnCode":2} Explanation: Json-params (or "-json") should be enclosed in single quotes, e.g. ./MetaServletCaller.sh --tac-url=http://localhost:8080/org.jasper.administrator --json-params='{"actionName":"setLicenseKey","authPass":"admin","authUser":"security@company.com","licenseKeyPath":"/vagrant/license"}'You can find full documentation on MetaServlet API using links below: https://help.talend.com/reader/YcEtLnE30CM8SeOxtXyHYQ/p4dbJNuFkgFs0_~GMUWdmA https://help.talend.com/reader/XKiHN_uvNCRjt1~QcNn4fw/URmRoWm7YAuFC06smWxO9g

Issue Description:We can't log in to Database configuration page when accessing TAC. Defautl 'admin' password doesn't work: Explanation: Talend Talend Administration Center passwords are stored in .jacapache-tomcatwebappstacWEB-INFclassesconfiguration.properties For this setting specifically we are looking at database.config.password property. It is encrypted but we can use plain text to reset the password. For example, if we shut down Tomcat and set database.config.password=admin[/code]after restart plain text string will be automatically encoded into database.config.password=8c6976e5b5410415bde908bd4dee15df,Encrypt[/code]Now we can log in using 'admin' password.

Technical Support calls for TIBCO Jaspersoft® ETL products are accepted based on time lines established by our technical partners Talend. Please refer to the following page for these time lines: http://www.talend.com/support/support-statements VersionRetiredEnd-Of-Life6.2.1January 2018August 20196.3.1July 2018January 20206.4.1December 2018June 20207.1.1 Jaspersoft® ETL version 6.0.1 has reached End-of-life on September 1, 2018

Issue Description:After upgrading to MacOS 10.14, we experience Jaspersoft® ETL Studio crashing when loading or using a Job containing a tMap component. Explanation: This is a known issue in Talend Data Integration Studio: https://community.talend.com/t5/Migration-Configuration-and/Talend-Studio-crashes-on-OS-X-Mojave-MacOS-10-14-when-using-a/ta-p/143193#toc-hId--1741766888 If you are running Jaspersoft® ETL Studio 7.1.1 please edit Talend-Studio-macosx-cocoa.ini file and add the following line:-Dos.version=10.14[/code]If you are running Jaspersoft® ETL Studio 6.4.1 please download attached patch Patch_20181119_TPS-2774_v1-6.4.1.zip and follow instructions in readme.txt file to apply it.If you still experience any issues after following steps above, please contact support@tibco.com to log a ticket with TIBCO Jaspersoft support.

Issue Description:We have upgraded to recent version of Jaspersoft® ETL Studio. We noticed that all of our jobs take a lot of time to execute. There were no changes introduced into job design. Explanation: Jaspersoft® ETL Studio (which is a re-branded Talend Data Integration Studio) doesn't ship a number of third-party libraries that require to execute a lot of ETL components. When you first launch Jaspersoft ETL Studio you are prompted to download and install required and optional third-party libraries: Depending on your Internet speed and PC processing power this process might take some time to complete: Please make sure the installation has finished and check if you still experience performance issues. If you do, please contact support@tibco.com to log a ticket with TIBCO Jaspersoft support.

Issue Description:We can't launch Jaspersoft® ETL TAC due to problem with Tomcat. We can see that tomcat can't locate /logiciels/tomcat/tomcat-8.5/conf/btm-config.properties file. [toc]Caused by: bitronix.tm.utils.InitializationException: error loading configuration at bitronix.tm.Configuration.<init>(Configuration.java:122) at bitronix.tm.TransactionManagerServices.getConfiguration(TransactionManagerServices.java:105) at bitronix.tm.TransactionManagerServices.getJournal(TransactionManagerServices.java:120) at bitronix.tm.BitronixTransactionManager.<init>(BitronixTransactionManager.java:100) at bitronix.tm.TransactionManagerServices.getTransactionManager(TransactionManagerServices.java:75) at bitronix.tm.integration.tomcat55.BTMLifecycleListener.lifecycleEvent(BTMLifecycleListener.java:18) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:395) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:149) ... 10 more Caused by: java.io.FileNotFoundException: /logiciels/tomcat/tomcat-8.5/conf/btm-config.properties (No such file or directory) at java.io.FileInputStream.open0(Native Method) at java.io.FileInputStream.open(FileInputStream.java:195) at java.io.FileInputStream.<init>(FileInputStream.java:138) at java.io.FileInputStream.<init>(FileInputStream.java:93) at bitronix.tm.Configuration.<init>(Configuration.java:85) ... 18 moreSolution: By default btm-config.properties should be placed in <TomcatPath>/conf folder. However, you can also configure different path in <TomcatPath>/bin/setenv.bat: set "CATALINA_OPTS=-Dbtm.root=%CATALINA_HOME% -Dbitronix.tm.configuration=%CATALINA_HOME%/conf/btm-config.properties

Issue Description:Jaspersoft Studio has built-in HyperSQL DB data source called "Sample DB". I'd like to use HSQLDB for data input in JasperServer as well as JRIO. Explanation: 1) HyperSQL in JasperReports ServerFirst of all, start by adding HyperSQL JDBC driver to application classpath. If you are hosting JasperServer on Tomcat, simply add hsqldb-2.4.0.jar (or similar JAR file of different version) to apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib/ folder and reboot. Then, you need to make sure HyperSQL DB server is up and running and there is data to be retrieved. Quoting HSQLDB documentation: "A uniform method is used to distinguish between different types of connection. The common driver identifier is jdbc:hsqldb: followed by a protocol identifier (mem file res hsql http hsqls https) then followed by host and port identifiers in the case of servers, then followed by database identifier. Additional property / value pairs can be appended to the end of the URL, separated with semicolons" For the purpose of this demonstration, I'm using Northwind DB accessed as Resource Database URL: jdbc:hsqldb:res:hsqldb/northwind;shutdown=trueIn order to do that, I'm also adding hsqldb-northwind.jar to application server classpath (apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib/) 1.1. Data Adapter approach on JasperReports ServerData adapter approach is described in details in following articles: https://community.jaspersoft.com/wiki/how-create-report-uses-remote-json-data-source https://community.jaspersoft.com/wiki/using-data-adapters-fill-reports-json-data-remote-url Main idea is to reference data adapter using "repo:" syntax, e.g.: <property name="net.sf.jasperreports.data.adapter" value="repo:/public/customer_cases/HsqldbDataAdapter"/> You can use data adapter definition below for HSQLDB Northwind use case: <?xml version="1.0" encoding="UTF-8" ?> <jdbcDataAdapter class="net.sf.jasperreports.data.jdbc.JdbcDataAdapterImpl"> <name>HyperSQL Northwind DB</name> <driver>org.hsqldb.jdbcDriver</driver> <username>sa</username> <password></password> <savePassword>true</savePassword> <url>jdbc:hsqldb:res:hsqldb/northwind;shutdown=true</url> <database></database> <serverAddress></serverAddress> </jdbcDataAdapter>Also, please find example JasperReports Server ZIP export in the end of this article. 1.2. JDBC data source on JasperReports ServerYou can also create a domain based on HSQLDB. Simply create JDBC data source based on your HSQLDB using driver/url/credential above and create a domain accordingly. 2) HyperSQL in JasperReports IO (Data Adapter approach only)JRIO only provides you ability to work with data adapters. The key different between JRXML executed on JasperReports Server and the one of JRIO is "data.adapter" path value. Here I'm using syntax below <property name="net.sf.jasperreports.data.adapter" value="/samples/data/HsqldbDataAdapter.xml"/>Hence, you need to make sure that - HsqldbDataAdapter.xml is present in respective folder (e.g. /opt/jrio-1.0.0/repository/samples/data/HsqldbDataAdapter.xml) - JAR files are in JRIO classpath (e.g. /opt/jrio-1.0.0/repository/samples/JR-INF/context.xml), for example <context xmlns=""> <classpath> <entry> <path>/samples/JR-INF/lib/hsqldb-2.4.0.jar</path> </entry> <entry> <path>/samples/data/hsqldb-northwind.jar</path> </entry> ... </classpath> ... </context>For more information on JRIO functionality please refer to "JasperReports IO - Getting Started" project page. 3) HyperSQL and dummy query in JasperReports IO/JasperReports ServerFor compatibility purposes you might want to avoid using Northwind DB and consider using dummy query. Such query can be executed against any HyperSQL (and traditional RDBMS like PostgreSQL/MySQL) database. Jaspersoft Studio provides functionality to automatically generate such query: https://community.jaspersoft.com/wiki/create-mock-or-sample-query-data-using-jaspersoft-studios-export-sql After modifying dataset query in JRXML file, you need to update data adapter respectively. HyperSQL provides ability to (create in-memory DB on-the-fly and we will utilize this approach to create "empty" in-memory DB. To do that, please change connection URL string in data adapter XML file to: jdbc:hsqldb:mem:empty; I'm also attaching TEST_charts_HSQLDB.jrxml report that contains HighCharts and utilizes dummy query approach with HsqldbDataAdapter_inMemory_dummy.xml data adapter. hsqldb_address_jrs.jrxml hsqldb_address_jrio.jrxml hsql_on_jrs.zip hsqldbdataadapter.xml hsqldb-northwind.jar hsqldb-2.4.0.jar hsqldbdataadapter_inmemory_dummy.xml test_charts_hsqldb.jrxml

Issue Description:UI is limited when I log in to TAC (Talend Administration Center). I don't see Conductor, Monitoring and Configuration menu is limited: Explanation: By default, your Data Integration user is assigned single role Security Administrator. You have to add additional roles to be able to access full TAC functionality. To do that please select your active user, click 'Edit' icon next to Role: text box and add additional roles like Administrator, Designer and Operation manager Plase find demo below:

Issue Description:When I'm trying to set TIBCO Jaspersoft® ETL licences in TAC (Talend Administration Center) I'm receiving error: License: Not a valid 6.4 version Explanation: Talend requires a new license for each version of Jaspersoft® ETL. The license you are using is not a 6.4 license. Please contact support@tibco.com and we will upgrade your license. For more information about license management in TAC (Talend Administration Center) please refer to Talend Administration Center User Guide

Issue DescriptionI need to introduce additional timezones in my TIBCO JasperReports® Server. Can I only use continent/city notation like Asia/Tel_Aviv or can use things like IST, UTC, Etc/GMT+7, Jamaica as well? ExplanationTimezones are subject to change. Raul Luna demonstrated how to list all timezones available in Java using simple code. You can try it out yourselves by using JAR file attached $ java -jar timeZone.jar[/code]You should be able to use any timezoneID available for your JVM on server hosting JasperReports® Server. However, please note Oracle don't recommend using three-letter timezones like "PST", "CTT", "AST" and "EST", "HST", "MST" for Eastern, Hawaii, and Mountain summer time: https://docs.oracle.com/javase/8/docs/api/java/util/TimeZone.html https://www.oracle.com/technetwork/java/javase/dst-faq-138158.html#threeletter Please refer to TIBCO JasperReports Server Administrator Guide » Localization » Configuring JasperReports Server to Offer a Locale for information on how to add additional timezones.