stchan

Issue Description:The reload button ("refresh report with latest data") is present at the top menu of the report. Trying to force a click from JavaScript as an HTTP component in the report, but doesn't work as expected when the button is clicked. Used the following event in coding, document.getElementById('dataRefreshButton').click();[/code] Resolution:In this case we are using 'mouseup' event instead of 'click' event, something like: var mouseupEvent = new Event('mouseup');document.getElementById('dataRefreshButton').dispatchEvent(mouseupEvent);[/code]

Issue Description: Jaspersoft Studio v7.5.0, at the final step of installing additional community/commercial/customer created plug-ins in Studio, the installation failed with the following entries in the installation window: Cannot complete the install because one or more required items could not be found. Software being installed: Test2 1.0.0.202007171002 (com.xxx.test2.feature.group 1.0.0.202007171002) Missing requirement: Test 1.0.0.202007171002 (com.xxx.test 1.0.0.202007171002) requires 'osgi.ee; (&(osgi.ee=JavaSE)(version=1.8))' but it could not be found Cannot satisfy dependency: From: Test2 1.0.0.202007171002 (com.xxx.test2.feature.group 1.0.0.202007171002) To: org.eclipse.equinox.p2.iu; com.xxx.test [1.0.0.202007171002,1.0.0.202007171002] Resolution:When installing additional community/commercial/customer created plugins, we need to add two items from Eclipse repository as below: Into the installation dialog click on the "Manage" button. It will take you to the preference page where you can play with the update sites available.You should see only the "local" plug-in file you added when trying to install the customer pluginProceed in adding the following two a) Eclipse Repository - http://download.eclipse.org/releases/2019-06 b) The Eclipse Project repository - http://download.eclipse.org/eclipse/updates/4.12 NOTE: we need these specific two because JSS 7.5.0 PRO is built on an Eclipse 4.12 platform. (A fixed pending in the next Jaspersoft Studio release. Internal reference number #JSS-2881).

Issue DescriptionFound report title shifted to the left overlapping with input parameter panel and date selection drop-down list distorted and appeared down the page. Using in-page or pop-window iput controls showed similar issue. ResolutionThis is CSS theme related problem, most likely default theme got corrupted somehow or imported an incompatible version of theme that mess up displays. Restored default theme using the procedure below to resolve problem. https://community.jaspersoft.com/wiki/how-restore-tibco-jasperreports-server-750-default-theme Quick ReferenceThis link discuss potential issue when import Themes between versions https://community.jaspersoft.com/wiki/do-not-include-themes-when-importing-repository-content-btw-versions-tibco-jasperreports-server

Issue DescriptionAfter upgrade to 7.5.0, few reports are failing with exception below: Report design not valid : 1. java.lang.ClassNotFoundException: oracle.sql.OPAQUE net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. java.lang.ClassNotFoundException: oracle.sql.OPAQUE at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:280) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:152) at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:358) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:618) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:2155) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:2818) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.CacheableCompiledReports.getData(CacheableCompiledReports.java:58) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.saveData(HibernateRepositoryCache.java:257) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.getCachedItem(HibernateRepositoryCache.java:112) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.cache(HibernateRepositoryCache.java:71) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at ... ... ResolutionFound a field in the report, which requires the class "oracle.sql.OPAQUE" that caused the exception. <field name="PAYLOAD" class="oracle.sql.OPAQUE"/> To resolve this, an Oracle library contains the "oracle.sql.OPAQUE" class needs to be added in the classpath. In this case, added ojdbc7.jar to the classpath and the problem resolved. The library required could be different in different environment.

Issue DescriptionInstallation / upgrade failed with the following entries at the end of installation log [toc][java] -- JasperServer: EhCacheImpl shutdown called. This normal shutdown operation. [java] -- JasperServer: EhCacheImpl calling cleanerTimer.cancel(). This normal shutdown operation. [java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'customJDBCReportDataSourceServiceFactory' defined in file [/opt/jasperpkg/overlay/buildomatic/conf_source/iePro/applicationContext.xml]: Cannot resolve reference to bean 'virtualDataSourceHandler' while setting bean property 'virtualDataSourceHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'virtualDataSourceHandler' defined in file [/opt/jasperpkg/overlay/buildomatic/conf_source/iePro/applicationContext-virtual-data-source.xml]: Cannot resolve reference to bean 'teiidVirtualQueryService' while setting bean property 'virtualDataSourceQueryService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'teiidVirtualQueryService' defined in file [/opt/jasperpkg/overlay/buildomatic/conf_source/iePro/applicationContext-virtual-data-source-query-service.xml]: Invocation of init method failed; nested exception is java.lang.UnsupportedClassVersionError: org/infinispan/manager/EmbeddedCacheManager : Unsupported major.minor version 52.0 ResolutionThis is due to mismatch of installed Java version. Need to refer to Support Platform doc of the Jasperreport Server release, re-install the supported Java version first and then re-install TIBCO JasperReports® Server. In this case, the major.minor version 52.0 error is because the jar was compiled in JSE 8, but trying to run it in a JSE 7 environment. The errored version number 52.0 is referring to the required version, which is 52.0=SE 8 in this case. Below are the assigned major numbers: Java SE 12 = 56 Java SE 11 = 55 Java SE 10 = 54 Java SE 9 = 53 Java SE 8 = 52 Java SE 7 = 51 Java SE 6.0 = 50 Java SE 5.0 = 49

Issue DescriptionGetting error response “Import of an organization to the root is not allowed", when trying to import resources to root folder: [toc]./js-import.sh --input-zip organization_1.zip --organization organizations --merge-organization --keyalias deprecatedImportExportEncSecret Result: 128 Validating JasperServer database connection at jdbc:postgresql://localhost:5432/jasperserver. Phase: [import-export-test] Connection OK Keystore OK VALIDATION COMPLETED Total time: 3 seconds Executing Pro version First resource path: /opt/jasperreports-server/jasperreports-server-pro-7.5.0-bin/buildomatic/conf_source/iePro Loading configuration resources Initialization complete Processing started Import of an organization to the root is not allowed. ResolutionTo import resources to Root folder, you need to use organization option and specify target as Organizations, with capital "O". Otherwise, it will fail with the error as in this case. The correct command is: ./js-import.sh --input-zip organization_1.zip --organization Organizations --merge-organization --keyalias deprecatedImportExportEncSecret If you like to import to other Organization, you can use command as below ./js-import.sh --input-zip organization_1.zip --organization organization_2 --merge-organization --keyalias deprecatedImportExportEncSecret More import / export options can be found at https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v750/import-and-export-through-command

Issue:Attempted to move folder in Japanese characters but failed with “404 Not Found” exception Resolution:It was a defect. A hotfix was developed for this on JRS 7.5.0 and is available via https://support.tibco.com/s/hotfixes?id=a012L00000OEiQMQA1 as hotfix_JRSPro7.5.0_cumulative_20200228_0035.zip With the patch, you can move multi-byte resources. As an example to move a folder in Japanese characters テストフォルダ (translate to %E3%83%86%E3%82%B9%E3%83%88%E3%83%95%E3%82%A9%E3%83%AB%E3%83%80 in UTF-8 encoding ) from /organizations/organization_1 to /public. 1) Use PUT method with the target destination ( …/rest_v2/resources/<path_to_dest>) 2) Specify the source resource as Content-Location key-value pair, resources label needs to be encoded. By default uses UTF-8 encoding.

Issue DescriptionException only occurs with a specific parameter input. The report always shows correctly in browser. However, if we change the input parameter which then changes the report output, export to PDF generally successful, but at times failed with "No snapshot data found" exception as below. net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.data.cache.DataSnapshotException: No snapshot data found for position [{datasetUUID:2598179e-8f26-402f-8d7c-a0d194fbfc2e,queryMD5:7ae5d8b6e1fb354a8d434a70744b6ea2,},{datasetRunUUID:de20dd8a-a122-44a2-9571-c2ef8131ea29,rowIndex:38,datasetUUID:1c4bea0a-0c12-477e-9b0d-b91b248c9e65,queryMD5:fb71252749bfe40aa346e0b7b858359d,}]. at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:150) at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:152) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:542) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:411) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:413) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:373) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:2185) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:2269) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:726) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:260) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:103) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:607) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)… …[/code]ResolutionThe problem comes from the fact that the datasnapshot is recorded when the report is run in HTML and is not paginated. In the datasnapshot, JRS keeps not only the data of the master dataset, but also ramifications for all the subdataset instances that have occurred during the report run. If report has a list component in the page header/footer, which uses a subdatset with a query. As an example, in the non-paginated run (HTML), the header appears only once and JRS registered only an instance of its data. When the report is run paginated (PDF), and the header appears twice with certain parameter inputs (report with at least two pages). The program cannot find any data recorded for the second occurrence of the subdataset. Hence, ended with the exception. The solution is to either disable snapshots, or refactor the report to eliminate the list component from the page header/footer. There are two options to disable snapshots for report: - 1. Globally/server-wide, in /WEB-INF/applicationContext-data-snapshots.xml you can set the following to "false" instead of true. <property name="snapshotRecordingEnabled" value="false"/>[/code] 2. The second option, which we recommend, is to disable snapshots for individual report. Set these two properties within JRXML to false. net.sf.jasperreports.data.cache.recordable=falsenet.sf.jasperreports.data.cache.persistable=false[/code]

Issue DescriptionIs there a way to change default font color for the text of input control? Resolution You can update the input controls form with JSP file. WEB-INFjspmodulesinputControlsInputControlTemplates.jsp You can update the relevant section(s) of the JSP to set default input color of element(s). The changes will apply to all reports. For example, (Inserted style="color:blue" as below to set "singleValueNumber" input to be blue.) <script id="singleValueNumber" type="template/mustache"> <div id="{{-id}}" class="leaf"> <js:xssNonce/> <label class="control input text" title="{{-description}}"> <span class="wrap">{{if (mandatory) { }}* {{ } }}{{-label}}</span> <input class="" type="text" value="" style="color:blue" {{if (readOnly) { }}disabled{{ } }} /> <span class="warning">{{-message}}</span> </label> </div></script>[/code]

Issue DescriptionWe have a tenant with hundreds of reports. We found that rest service is not retrieving the whole report listing via API. Is there any limit on the retrieval? ResolutionTo promote performance, TIBCO JasperReports® Server resources service paginating search results. By default resources service returns the first page which holds approximately 100 repository items. Therefore, it gives an impression that there is a limit on the retrieval. If the result set is more than a page, then you need to use pagination parameters to obtain more pages or change pagination strategy when submitting request. There are three different pagination strategies can be applied: Default Pagination – need multiple requests for multi-pages result, each page could be of different lengthFull Page Pagination - need multiple requests for multi-pages result, each page (except the last one) is of same length No Pagination – turn off pagination with argument limit=0, return all results in one hitPlease refer to the quick reference below for more detailed arguments options Quick ReferenceThis link covers more details in various arguments that can be applied for different pagination strategy. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v750/resources-service

Issue DescriptionTIBCO Jasperreport® Server 7.5.0 platform support quide listed JVM 'Adopt OpenJDK 11 with IBM J9'. However, unable to find the installer online. ResolutionThe formal name for IBM J9 is OpenJ9. OpenJ9 is also known as IBM J9 as IBM purchased Object Technology International whom developed OpenJ9 in 1996. Until 2017, OpenJ9 became an Eclipse Foundation project and named as Eclipse OpenJ9. The certified J9 VM is available in link below as choice OpenJDK 11 (LTS) with OpenJ9 https://adoptopenjdk.net/releases.html?variant=openjdk11&jvmVariant=openj9 Quick ReferenceJaspersoft platform support guide for 7.5.0 https://community.jaspersoft.com/sites/default/files/docs/tib_js-jrs_7.5_jaspersoft_platform_support-commercial-edition.pdfAdditional steps required for using IBM JDK https://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v750/additional-steps-using-ibm-jdk

Issue DescriptionHow to move a folder with cURL command ResolutionThe resources Service provides methods to manipulate resources. Below example moves source folder from /organizations/organization_1/toBeMoved to /public/toBeMoved 1) You can logon with plain password and perform the move curl -v -u superuser:superuser -X PUT "http://localhost:8080/jasperserver-pro/rest_v2/resources/public?createFolders=true&overwrite=false" -H "Content-Location:/organizations/organization_1/toBeMoved"[/code]2) Or you can create cookie and use it for subsequence commands curl -v -c ./cookie.txt -X GET "http://localhost:8080/jasperserver-pro/rest_v2/j_spring_security_check?j_username=superuser&j_password=superuser"curl -v -b ./cookie.txt -X PUT "http://localhost:8080/jasperserver-pro/rest_v2/resources/public?createFolders=true&overwrite=false" -H "Content-Location:/organizations/organization_1/toBeMoved"[/code]Sample Output: * About to connect() to localhost port 8080 (#0)* Trying 127.0.0.1...* Connected to localhost (127.0.0.1) port 8080 (#0)> PUT /jasperserver-pro/rest_v2/resources/public?createFolders=true&overwrite=false HTTP/1.1> User-Agent: curl/7.29.0> Host: localhost:8080> Accept: */*> Cookie: userLocale=en_US; JSESSIONID=4F2BF029CD1B958D7AAF9BE4F83B9AC0> Content-Location:/organizations/organization_1/toBeMoved>< HTTP/1.1 200< Cache-Control: private…< Content-Type: application/repository.folder+xml[/code]

Issue DescriptionWhere to download Jaspersoft Product Documentation. ResolutionJaspersoft documentation is avaiable from the following two locations: TIBCO Product Documentation website https://docs.tibco.com/This website is exculsively used to host COMMERICAL product documentation (offical certified /supported products) including Jaspersoft. You can obtain the entire Jaspersoft products listing via link https://docs.tibco.com/products/search#q=tibco%20jasper&t=Product&sort=relevancy Once you selected a product, you will be redirected to the page contains documentation of the latest release. On the page, you can also navigate to previous releases by selecting desired item from the release dropdown list available on the top right hand section. You can report missing documentation or share comments about any product document via the orange Feedback button appears on the right side of the page. Here is the direct link to the latest Jaspersoft Documentation, you should also be able to change the version for a specific documentation related to a specific version: https://docs.tibco.com/products/jasperreports-server-latest Jaspersoft Community website https://community.jaspersoft.com/The Jaspersoft Community site hosts both Community/free open source product docs AND commerical Japsersoft docs (in both HTML and PDF format). You can access documentation of current and previous releases via the “Docs” tab right below the Jaspersoft Community banner. Quick ReferenceThis FAQ link tips on bookmark favorite products and how to provide feedback on documentation https://docs.tibco.com/faq