Jim W

This is Part 1 of a two part tutorial explaining the details on how to use the Log Collector on TIBCO JasperReports® Server v7.5. In this video, we will explore. a) what you can do with the Log Collector, b) how to turn off encryption, c) where to find the log zip package, d) what is in the log zip package. In Part 2, we will dive into more Log Collector related details on encryption/decryption, data snapshot and verbosity. video_log_collector_explained_part_i.swf

QuestionIf I am using CAS authentication with TIBCO JasperReports® Server, is there any impact on JasperReports® Server side as a result of this expiration? ADDTrust External Root Expiration May 2020 https://calnetweb.berkeley.edu/calnet-technologists/incommon-sectigo-certificate-service/addtrust-external-root-expiration-may-2020 https://support.sectigo.com/articles/Knowledge/Sectigo-AddTrust-External-CA-Root-Expiring-May-30-2020 AnswerJasperReports® Server is a CAS client. It does not have CAS related certs within it. The process is happening on the Application Container / Java level. Therefore, JasperReports® Server does not have any control over this process. If you want to be sure, best is to contact Sectigo directly to confirm what certificate you have and the impact.

Problem Description: Suppose you have the following simple scenario [up to as recent as v7.5.0]. You want to substitute the value from X to Y. <parameter name="X" class="java.lang.String"> </parameter> <parameter name="Y" class="java.lang.String"> <defaultValueExpression><![CDATA[$P{X} + "abc"]]></defaultValueExpression> </parameter> $P{X} has a single/multiple select query input control that retrieves some value(s), "111" for example. This value is not passed to parameter "Y" if an input control is created for the parameter "Y". You will get null as a value of $P{Y} Workaround: If you delete the input control for parameter "Y", the value will be passed from parameter "X".

Problem Description: If you are running JaspeerETL TAC v7.1.1 and you are finding jobs stuck in Basic Status = Running... and Task duration = 0ms. Try the following patch described below. Solution: https://talend-update.talend.com:443/nexus/service/local/repositories//Talend_Patches_For_Release_7.1.1/content/org/talend/tac/patch/full/Patch_20200305_TPS-3735_v3/7.1.1/Patch_20200305_TPS-3735_v3-7.1.1.zip Contact TIBCO/Jaspersoft Technical Support if you have trouble accessing the patch.

Problem Description:You are trying to connect to a TIBCO JasperReports® Server repository via TIBCO Jaspersoft® Studio using the following URL: https://localhost:8443/jasperserver-pro You are getting this error: nested exception is: javax.net.ssl.SSLException: hostname in certificate didn't match: != AxisFault faultCode: { http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: javax.net.ssl.SSLException: hostname in certificate didn't match: != faultActor: faultNode: faultDetail: { http://xml.apache.org/axis/}stackTrace:javax.net.ssl.SSLException: hostname in certificate didn't match: != at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:238) at org.apache.http.conn.ssl.BrowserCompatHostnameVerifier.verify(BrowserCompatHostnameVerifier.java:54) at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:159) at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:140) at org.apache.http.conn.ssl.SSLConnectionSocketFactory.verifyHostname(SSLConnectionSocketFactory.java:301) at org.apache.http.conn.ssl.SSLConnectionSocketFactory.createLayeredSocket(SSLConnectionSocketFactory.java:291) at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:259) at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:125) at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:319) at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:363) at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:219) at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:195) at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:86) at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:108) at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:184) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57) at org.apache.http.client.fluent.Executor.execute(Executor.java:206) at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender.invoke(JSSCommonsHTTPSender.java:220) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.ireport.jasperserver.ws.RepositorySoapBindingStub.list(RepositorySoapBindingStub.java:328) at com.jaspersoft.ireport.jasperserver.ws.WSClient.getVersion(WSClient.java:150) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.getServerInfo(SoapConnection.java:104) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.connect(SoapConnection.java:145) at com.jaspersoft.studio.server.protocol.ProxyConnection.connect(ProxyConnection.java:102) at com.jaspersoft.studio.server.WSClientHelper.checkConnection(WSClientHelper.java:92) at com.jaspersoft.studio.server.wizard.ServerProfileWizard.connect(ServerProfileWizard.java:94) at com.jaspersoft.studio.server.wizard.ServerProfileWizard.access$1(ServerProfileWizard.java:89) at com.jaspersoft.studio.server.wizard.ServerProfileWizard$2.run(ServerProfileWizard.java:68) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) {http://xml.apache.org/axis/}hostname:JW javax.net.ssl.SSLException: hostname in certificate didn't match: != at org.apache.axis.AxisFault.makeFault(AxisFault.java:101) at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender.invoke(JSSCommonsHTTPSender.java:289) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.ireport.jasperserver.ws.RepositorySoapBindingStub.list(RepositorySoapBindingStub.java:328) at com.jaspersoft.ireport.jasperserver.ws.WSClient.getVersion(WSClient.java:150) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.getServerInfo(SoapConnection.java:104) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.connect(SoapConnection.java:145) at com.jaspersoft.studio.server.protocol.ProxyConnection.connect(ProxyConnection.java:102) at com.jaspersoft.studio.server.WSClientHelper.checkConnection(WSClientHelper.java:92) at com.jaspersoft.studio.server.wizard.ServerProfileWizard.connect(ServerProfileWizard.java:94) at com.jaspersoft.studio.server.wizard.ServerProfileWizard.access$1(ServerProfileWizard.java:89) at com.jaspersoft.studio.server.wizard.ServerProfileWizard$2.run(ServerProfileWizard.java:68) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) Caused by: javax.net.ssl.SSLException: hostname in certificate didn't match: != at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:238) at org.apache.http.conn.ssl.BrowserCompatHostnameVerifier.verify(BrowserCompatHostnameVerifier.java:54) at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:159) at org.apache.http.conn.ssl.AbstractVerifier.verify(AbstractVerifier.java:140) at org.apache.http.conn.ssl.SSLConnectionSocketFactory.verifyHostname(SSLConnectionSocketFactory.java:301) at org.apache.http.conn.ssl.SSLConnectionSocketFactory.createLayeredSocket(SSLConnectionSocketFactory.java:291) at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:259) at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:125) at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:319) at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:363) at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:219) at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:195) at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:86) at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:108) at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:184) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57) at org.apache.http.client.fluent.Executor.execute(Executor.java:206) at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender.invoke(JSSCommonsHTTPSender.java:220) ... 19 moreSolution:Try adding the following to the hosts file. For example: On Windows: C:/Windows/System32/drivers/etc/hosts Linux /etc/hosts Add the IP address of your client machine to the file as administrator using an editor. On Linux, sudo nano /etc/hosts, for example: 127.0.0.1 jw.org.com 192.168.1.143 jw.org.com Use this URL to connect to TIBCO JasperReports® Server using the Repository Explorer [server Profile Wizard->JasperReports Server Access Configuration]: https://jw.org.com:8443/jasperserver-pro

Problem Description:If you are trying to log into TIBCO JasperReports® Server via SSL and you believe you have configured the connector port in Tomcat correctly, but you are getting this error from any browser. Bad Request This combination of host and port requires TLS Solution:Check your URL. Most likely you have left out the s in https. For example, http://localhost:8443/jasperserver-pro/login.html [/code]Correct URL is: https://localhost:8443/jasperserver-pro/login.html[/code]

Problem Description:You are attempting to upgrade from 7.2 to 7.5 through buildomatic update-samedb method. However, this system was upgraded from v3x to v3x then to v7x. Everything seems to be working except for saving on the scheduling screen. It appears that the query is trying to update JIReportJobRepoDest and insert somthing that can not fit into the columns. The full response from the server is: { "message". : "could not execute batch: String or binary data would be truncated.", "errorCode" : "illegal.parameter.value.error" } 2020-03-18T16:01:23,277 ERROR SqlExceptionHelper,http-nio-8080-exec-4:131 - String or binary data would be truncated. JRS | 2020-03-18T16:03:45,532 ERROR BatchingBatch,http-nio-8080-exec-1:120 - HHH000315: Exception executing batch [java.sql.BatchUpdateException: String or binary data would be truncated.], SQL: update JIReportJobRepoDest set version=?, folder_uri=?, sequential_filenames=?, overwrite_files=?, save_to_repository=?, output_description=?, timestamp_pattern=?, using_def_rpt_opt_folder_uri=?, output_local_folder=?, user_name=?, password=?, server_name=?, folder_path=?, ssh_private_key=? where id=? and version=? ERROR SqlExceptionHelper,http-nio-8080-exec-1:131 - String or binary data would be truncated. Workaround:The table affected is as follows, see below. Check the following column. It should have a width of 250. During one of the various upgrades, it might have missed the change from 50 to 250. The workaround for v7.2.0 or v7.5.0 would be to change this value manually on the database. password character varying(250) CREATE TABLE jireportjobrepodest ( id bigint NOT NULL, version integer NOT NULL, folder_uri character varying(250), sequential_filenames boolean NOT NULL, overwrite_files boolean NOT NULL, save_to_repository boolean NOT NULL, output_description character varying(250), timestamp_pattern character varying(250), using_def_rpt_opt_folder_uri boolean NOT NULL, output_local_folder character varying(250), user_name character varying(50), password character varying(250), server_name character varying(150), folder_path character varying(250), ssh_private_key bigint, CONSTRAINT jireportjobrepodest_pkey PRIMARY KEY (id), CONSTRAINT fkba2wg3iix8mr5wcjq6004ekvw FOREIGN KEY (ssh_private_key) REFERENCES jiresource (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE jireportjobrepodest OWNER TO postgres; GRANT ALL ON TABLE jireportjobrepodest TO postgres; GRANT ALL ON TABLE jireportjobrepodest TO jasperdb;

Problem Description: You are getting a 404 error when trying to connect to jasperserver using a later version of Jaspersoft Studio. You checked the access log, the URL appears to be correct. Workaround: There might be other reasons for this error. First thing to check is whether you are entering the user name with exactly the same upper case and lower case letters in Jaspersoft Studio connection dialog. If that does not resolve the issue. Look for other causes.

Problem Description:After installing jasperserver v7.5.0, scheduler files written to Linux has no read permission in "other" with v7.5.0. For example, -rw-r----- There was no such problem in preivous versions of jasperserver. Workaround:The trouble is with Tomcat 9. See this link for the following comment, http://tomcat.apache.org/tomcat-9.0-doc/changelog.html Tighten up the default file permissions for the .tar.gz distribution so no files or directories are world readable by default. Configure Tomcat to run with a default umask of 0027 which may be overridden by setting UMASK in setenv.sh. (markt) Workaround is to set UMASK to your requirements in setenv.sh.

Problem Description: You had just upgraded jasperserver from v6x to v7x. Everything in the repository works fine. But, when running a report, you can see the input controls, you cannot see the values in the list. If you change the input control placement type, you might see the values displayed in an incorrect position. That means, the values got to the browser OK, but the list is displayed in an incorrect location, hidden or cut off some how. If you hit F12, select the Network tab to see the HAR trace, and look at the input control transmission, you can see the values in the response. Solution: Export the Themes folder from a fresh copy of v7x jasperserver. Import into the v7x instance that is having the problem with overwrite option. Restart jasperserver. If that does not work, look for a different cause.

Problem Description: Suppose you have a jasperserver instance which has been running fine for many months. Suddenly, you get hangs on doing some normal operations in the repository. Or, it is getting exceedingly slow. If you restart the system, it works fine for a while, then it slows down again. You cannot identify a specific operation or specific report that is causing the problem. There were no changes to the system recently. Solution: Since the system has been running fine for a long time and there were no changes recently, although you may not get a specific message, the problem could be out of disc space. The biggest clue is probably the number of general non-specific errors rather than a single point failure error. You can check disc space quickly by issuing the df command on Linux, or just check the drive storage property in Windows. If your jasperserver is up, you can also run the diagnostic report in public/diagnostics to see how much disc space you have. You can also check -Xmx to see if you are also low on heap memory. There could be other reasons for the failure, this is an easy one that should be eliminated quickly.

Problem Description:In a Crosstab reports, the Summary Function defaults to 'Count All' . How do I change it to 'Distinct Count'. Solution:By default, CountAll is set for numerics, and CountDistinct is set for non-numerics. You can change the default for numerics by modifying getDefaultAggregateFunction() in WEB-INF/groovy/com/jaspersoft/commons/dataset/expr/DomELMetadataHelper.groovy

Problem Description:If you are using TIBCO JasperReports® Server 7 and trying to display a dashboard using Visualize.js, you may get the following error only when using a newer version of Safari. For example, High Sierra & Safari 11, Catalina & Safari 13. You don't see this error when using other browsers such as Chrome and Firefox. [toc]Failed to load resource: the server responded with a status of 40112:19:26.9 "bi/dashboard/Dashboard]" - "[visualize.js:95]" - "[ERROR] - "-"authentication.error: Authentication error"[/code]Workaround:In newer versions of Safari, a new feature was added. By default, the new option, Prevent Cross-site Tracking, is checked. Uncheck this option and see if the error disappears. It is not clear if this problem is a result of Safari restricting/deleting cookies in error, but at least you can uncheck this option as a workaround for now. The following links contain some helpful information about this new feature. https://www.howtogeek.com/327773/how-safaris-new-intelligent-tracking-prevention-works/ https://www.macworld.com/article/3338152/apple-safari-removing-do-not-track.html https://webkit.org/blog/9521/intelligent-tracking-prevention-2-3/

Problem Description:You installed TIBCO Jaspersoft® Studio v7.5.0 or v7.1.0. You then downloaded the certificate and imported it into Jaspersoft Studio's cacerts. You then tried to create a server connection to a jasperserver repository over https on port 8443, for example. A new pop-up appeared asking to trust the certificate you had just imported. You clicked "Trust" and got the following pop-up error: "Exception, if you want to see more information look into details. Reason: ; nested exception is: javax.net.ssl.SSLPeerUnverifiedException: Certificate for <172.16.78.100> doesn't match any of the subject alternative names: [*.abc.org, abc.org]". This seems to mean that the certificate is valid for connections to anything.abc.org or to abc.org itself. Unfortunately, you are not connecting to abc.org; you are connecting directly over IP, which renders the certificate invalid. With TIBCO Jaspersoft® Studio 5.6, you can still connect via https even with this mismatch. Solution: Jaspersoft® Studio 5.6 is a less secure implementation, it accepts such a mismatch. Jaspersoft® Studio 7.5.0 uses new libraries, security is more strict. For long term, a less secure implementation is not desirable. Therefore, the current behavior for Jaspersoft® Studio v7.1.0 and new releases forward will continue this trend for stricter implementations. To avoid the error, we recommend solving the problem by configuring the infrastructure correctly instead of trying to change Jaspersoft® Studio. For example, setup a correct certificate for these IP's. Perhaps using matching hostnames in *.abc.org for these IP's.

Problem Description:You might be getting an error when running js-import after upgrading TIBCO JasperReports® Server to a new version. For example, [toc]java.lang.RuntimeException: Failed to decrypt java.lang.RuntimeException: Failed to decrypt at com.jaspersoft.jasperserver.crypto.EncryptionEngine.decrypt(EncryptionEngine.java:163) at com.jaspersoft.jasperserver.crypto.EncryptionEngine.decrypt(EncryptionEngine.java:125) at com.jaspersoft.jasperserver.api.common.properties.DecryptingPropertyPlaceholderConfigurer.convertPropertyValue(DecryptingPropertyPlaceholderConfigurer.java:66) at org.springframework.beans.factory.config.PropertyResourceConfigurer.convertProperty(PropertyResourceConfigurer.java:121) at org.springframework.beans.factory.config.PropertyResourceConfigurer.convertProperties(PropertyResourceConfigurer.java:104) at com.jaspersoft.jasperserver.api.common.properties.DecryptingPropertyPlaceholderConfigurer.convertProperties(DecryptingPropertyPlaceholderConfigurer.java:38) at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:81) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:694) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:669) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpringContext(BaseExportImportCommand.java:129) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:82) at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43) Caused by: javax.crypto.BadPaddingException: Given final block not properly padded at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:811) at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:676) at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:313) at javax.crypto.Cipher.doFinal(Cipher.java:2087) at com.jaspersoft.jasperserver.crypto.EncryptionEngine.decrypt(EncryptionEngine.java:160) ... 12 moreSolution:In the file default_master.properties file update dbPassword and sysPassword to plain text passwords, and set encrypt=truerun ./js-ant refresh-configtry import again

Description:Your new v7x jasperserver repository works fine in general with one exception. When you run a report and click on the Export icon in the menu to select Excel as output, it hangs forever. There could be many possible causes for this problem. The following is one thing that you can check quickly to see if it is the cause for your case. Solution:Check Manage->Server Settings->Ad Hoc Settings If this setting is unchecked, Optimize Queries for Domain-based Reports it may fail for some domain designs. Try checking it again and see if it works for you. If yes, you are good to go. If not, you will need to continue to troubleshoot and look for a different cause.

Problem Description:You are using the following property in a TreeMap chart, but you cannot see the Back button: <hc:chartProperty name="plotOptions.treemap.drillUpButton.text"> <hc:propertyExpression><![CDATA["Back"]]></hc:propertyExpression> </hc:chartProperty>Solution:There might be various reasons for the Back button not showing up in the TreeMap. If you had followed the instructions correctly in the following link, it should work fine. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v750/example-tree-map-using-multiple-levels-and Remember that this is a drill up button. You would not see it when the TreeMap is first shown. You have to click on one of the rectangles, you will see the Back drill up button in the subsequent page.

Problem Description:On v6x, you created domains using field names that might have contained special characters such as %. It worked fine on v6x jasperserver. When you upgraded to v7.2.0, you get the following error when opening the domain. You are unable to continue or edit the domain. x There are problems with the domain: The following name(s) contain invalid characters. A name must not start with a digit, or contain a space or any of the characters *()-+=:;.,"/<>[]'!{}%: "somefieldname%" "somefield-name" Solution:There was an overt change in v7.2.0 to flag certain charactes in a field name to prevent potential problems in other areas. In Domain Designer v7.2.0, if data source metadata (data source name, schema name, table name, column name) has special symbols, there is a restriction for some special symbols. The table and column definitions have ID and sourceName. ID is identifier used for referencing an item internally in the system including DOM EL expressions. SourceName is name of the entity in the database which is used for SQL generation. Because ID is used as a variable in DOM EL expressions, it can not contain certain symbols which have special meaning in DOM EL, they are: spacedot (.)arithmetic operators (+ - * / %)characters used in comparison operators (< > ! =)characters used in sets and ranges (: , parentheses)square brackets ([])double quotes (")single quote (')Also, digit 0-9 cannot be the first character in a variable name If you need a temporary workaround. You can change the following setting in applicationContext-semanticLayer.xml to bypass certain characters. <bean id="schemaElementNameNotSupportedSymbols" class="java.lang.String"> <constructor-arg type="java.lang.String"> <value>\*\(\)\-\+=:;\.\,"\\/&lt;&gt;\[\]'!\{\}%</value> </constructor-arg> </bean>In the above example where a field contains the % character, you can remove % from the value in constructor-arg to avoid the block. However, in the long run, the recommendation should be followed, that is, avoid using these characters in a field name.

Problem Description: You are unable to increase the number of ticks in an HTML5 TimeSeriesLine chart using the usually recommended properties such as: tickAmount tickInterval Solution: Try decreasing the font size: <hc:chartProperty name="xAxis.labels.style.fontSize" value="5 px"/>

Problem Description:You have a Jaspersoft ETL v7.1.1 installation and you are replacing SVN with Git, hosted on Bitbucket. Following these steps: https://community.talend.com/t5/Design-and-Development/Connecting-Talend-with-Git-SSH/ta-p/30570 you were able to successfully establish connection between Jaspersoft ETL server and your Git repository using deployment keys. However, you have trouble making TAC connect to it. Troubleshooting Information: Please note that this is time sensitive information for v7.1.1 valid only at this time to help you troubleshoot this issue. You may or may not experience this problem with a later version. Try the latest instructions on Git Bit Bucket SSH and TAC. See attached file. If still not working, try the following patch. https://talend-update.talend.com:443/nexus/service/local/repositories//Talend_Patches_For_Release_7.1.1/content/org/talend/tac/patch/full/Patch_20190830_TPS-3308_v3/7.1.1/Patch_20190830_TPS-3308_v3-7.1.1.zip You will be prompted for Talend Nexus user and password to download this patch. It is present in the license email for 7.1.1 issued to you. If you have a TIBCO/Jaspersoft support agreement, contact support if you need help in getting this patch [Reference # 1803502]. Patch details and installation instructions are here: https://help.talend.com/reader/xAG5ieGhYWbhI84Y~cCdpQ/U51sEUUUCfpxQuZma0zIxw You do not need an installer - you just have to follow steps 6 - 11 once you've extracted the patch

Problem Description:You are trying to delete organization folders that are no longer needed, but you are getting an error and unable to delete the folders even with superuser permissions. Workaround:There might be some unknown reasons for this issue. At least in one instance, it works if you delete the subfolders under the organization first.

Problem Description:You may be experiencing a variety of problems using IBM WAS 8.5.5.12 as application server. For example, failures in any of the repository screens or running reports. See example errors below. Solution:This is basically an IBM WAS issue for this specific version. Upgrade to a different release or apply the latest fix to WAS 8.5.5.12. https://www-01.ibm.com/support/docview.wss?uid=swg27009661 Error Log:[8/16/19 11:26:05:571 CDT] 000000dd ServletWrappe I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [jasperserver-pro_war] [/jasperserver-pro] [/WEB-INF/jsp/modules/system/500.jsp]: Initialization successful. [8/16/19 11:26:05:584 CDT] 000000e6 Helpers W NMSV0609W: A Reference object looked up from the context "java:" with the name "comp/BeanManager" was sent to the JNDI Naming Manager and was returned unprocessed. Reference data follows: Reference Factory Class Name: com.ibm.ws.webbeans.naming.BeanManagerObjectFactory Reference Factory Class Location URLs: <null> Reference Class Name: javax.enterprise.inject.spi.BeanManager [8/16/19 11:26:05:586 CDT] 000000e6 ServletWrappe E com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0271E: Uncaught init() exception created by servlet [JerseyREST] in application [jasperserver-pro_war]: java.lang.ClassCastException: javax.naming.Reference incompatible with javax.enterprise.inject.spi.BeanManager at com.sun.jersey.server.impl.cdi.CDIComponentProviderFactory.<init>(CDIComponentProviderFactory.java:89) at com.sun.jersey.server.impl.cdi.CDIComponentProviderFactoryInitializer.initialize(CDIComponentProviderFactoryInitializer.java:76) at com.sun.jersey.spi.container.servlet.WebComponent.configure(WebComponent.java:572) at com.sun.jersey.spi.container.servlet.ServletContainer$InternalWebComponent.configure(ServletContainer.java:332) at com.sun.jersey.spi.container.servlet.WebComponent.load(WebComponent.java:604) at com.sun.jersey.spi.container.servlet.WebComponent.init(WebComponent.java:207) at com.sun.jersey.spi.container.servlet.ServletContainer.init(ServletContainer.java:394) at com.sun.jersey.spi.container.servlet.ServletContainer.init(ServletContainer.java:577) at javax.servlet.GenericServlet.init(GenericServlet.java:161) at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:345) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:168) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:637) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1389) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:195) at com.jaspersoft.jasperserver.war.JavascriptForwardingServlet.doGet(JavascriptForwardingServlet.java:47) at javax.servlet.http.HttpServlet.service(HttpServlet.java:575) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97) at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88) at com.jaspersoft.jasperserver.api.security.csrf.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:72) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.api.security.csrf.CrossDomainCommunicationFilter.doFilter(CrossDomainCommunicationFilter.java:116) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticLoggingFilterPRO.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:157) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:99) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:194) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:103) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:86) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilterAndApplyHeadersIfNotSet(ResourceHTTPHeadersFilter.java:109) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:75) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3980) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1016) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892) 8/16/19 11:26:05:632 CDT] 000000dd ServletWrappe I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [jasperserver-pro_war] [/jasperserver-pro] [/WEB-INF/jsp/templates/nothingToDisplay.jsp]: Initialization successful. [8/16/19 11:26:05:669 CDT] 000000e6 SystemErrorCo E com.jaspersoft.jasperserver.war.control.SystemErrorController handle500 Internal server error javax.servlet.ServletException: SRVE0207E: Uncaught initialization exception created by servlet at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:407) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:168) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:637) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1389) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:195) at com.jaspersoft.jasperserver.war.JavascriptForwardingServlet.doGet(JavascriptForwardingServlet.java:47) at javax.servlet.http.HttpServlet.service(HttpServlet.java:575) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97) at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88) at com.jaspersoft.jasperserver.api.security.csrf.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:72) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.api.security.csrf.CrossDomainCommunicationFilter.doFilter(CrossDomainCommunicationFilter.java:116) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticLoggingFilterPRO.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:157) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:99) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:194) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:103) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:86) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilterAndApplyHeadersIfNotSet(ResourceHTTPHeadersFilter.java:109) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:75) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:191) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3980) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1016) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892) Caused by: java.lang.ClassCastException: javax.naming.Reference incompatible with javax.enterprise.inject.spi.BeanManager at com.sun.jersey.server.impl.cdi.CDIComponentProviderFactory.<init>(CDIComponentProviderFactory.java:89) at com.sun.jersey.server.impl.cdi.CDIComponentProviderFactoryInitializer.initialize(CDIComponentProviderFactoryInitializer.java:76) at com.sun.jersey.spi.container.servlet.WebComponent.configure(WebComponent.java:572) at com.sun.jersey.spi.container.servlet.ServletContainer$InternalWebComponent.configure(ServletContainer.java:332) at com.sun.jersey.spi.container.servlet.WebComponent.load(WebComponent.java:604) at com.sun.jersey.spi.container.servlet.WebComponent.init(WebComponent.java:207) at com.sun.jersey.spi.container.servlet.ServletContainer.init(ServletContainer.java:394) at com.sun.jersey.spi.container.servlet.ServletContainer.init(ServletContainer.java:577) at javax.servlet.GenericServlet.init(GenericServlet.java:161) at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:345) ... 137 more

Problem Description:Your Tomcat access log is showing password in clear text: e.g. apache-tomcat-7.0.67logslocalhost_access_log.2019-09-14.txt Solution:Filter the access log. Remove %s from the following section in server.xml under the Tomcat/conf directory. <Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true" startStopThreads="-1"> <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="localhost_access_log" suffix=".txt" pattern="%h %l %u %t &quot;%r&quot; %s %b"/> </Host>Here is a link to all the supported codes of the pattern. https://tomcat.apache.org/tomcat-7.0-doc/config/valve.html#Access_Logging

Problem DescriptionYou are using JTDS (e.g. v1.3.1) instead of the TIBCO drivers due to the need to support named DB instances and support for SSO (Using ntmlauth.ddl with no user/password supported by JTDS). You are getting the following exception: [toc]2017-10-05 12:29:20,632 ERROR LocalDataSourceJobStore,QuartzScheduler_quartzScheduler-ineal1507219259374_ClusterManager:3863 - ClusterManager: Error managing cluster: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [see nested exception: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157)at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3245)at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3857)at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3894)Caused by: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96)... 4 more2017-10-05 12:30:28,652 ERROR LocalDataSourceJobStore,QuartzScheduler_quartzScheduler-ineal1507219259374_ClusterManager:3863 - ClusterManager: Error managing cluster: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [see nested exception: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157)at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3245)at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3857)at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3894)Caused by: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96)... 4 more[/code]Solution:Add useCursors=true to the connection URL.

Problem Description:You want to display material icons in your report jrxml. https://material.io/resources/icons/?style=baseline [toc]Workaround: <componentElement> <reportElement x="0" y="-70" width="555" height="451" uuid="c557a700-606d-4893-af98-ca8df921bef9"/> <hc:html xmlns:hc="http://jasperreports.sourceforge.net/htmlcomponent" xsi:schemaLocation="http://jasperreports.sourceforge.net/htmlcomponent http://jasperreports.sourceforge.net/xsd/htmlcomponent.xsd" scaleType="RetainShape" horizontalAlign="Left" verticalAlign="Middle"> <hc:htmlContentExpression> <![CDATA"<link href='https://fonts.googleapis.com/icon?family=Material+Icons' rel='stylesheet'><i class='material-icons' style='color:#2196f3'>android</i>"]> </hc:htmlContentExpression> </hc:html> </componentElement>