Jim W

Problem Description: Your jasperserver may be running on a complex network, or you may have customizations, it often takes a lot of effort and time to eliminate the network or customization. When a problem occurs suddenly especially on a production system, you might be reluctant to try something new during the heat of battle. Solution: One simple way to find the right "ball park" is to run a bundled install on the same system or a separate system. For example, if a bundled install works, then it is highly likely that the problem is with the customization. Most commercial installations are WAR installs. Therefore, you might not have the experience of running a bundled install. You can try it on a test PC to find out how easy it is to install it. Furthermore, you can install multiple instances on the same system and even run them simultaneously as long as the instances are using different ports. You can do some troubleshooting on your own before submitting a ticket. If you can duplicate the problem on a standalone bundled install, most likely the problem is with the jasperserver. Of course, it could be a network issue. However, it would be a lot easier to troubleshoot if you can duplicate the problem with a bundled install.

Problem Description: You might be deploying JasperServer in OpenShift using Docker files. When running reports from the instance using visualize.js you are consistently getting a CORS error on OPTIONS settings.html request with 403 Forbidden response. Specific error is, No 'Access-Control-Allow-Origin' header is present on the requested resource. Your version of jasperserver is v7.9.0. Domain whitelist set to * The log file seems to indicate that the request did not go through the CORS filter and none of the documented known CORS related settings seem to matter. Possible Solution: Check and see if you have deleted anonymous user from root. If so, add it back and see if it works. If it works, the problem is related to JS-62587 in progress. Check with your support engineer to see what the latest update is for this issue.

Problem Description: There is a scenario that you might run into when you restart Tomcat on a system that has been running for months. In this case, the restart was for the purpose of installing a Windows update. Tomcat restart/jasperserver would not complete. You would get an "HTTP Status 404 - Not Found" error if you try to log into jasperserver as http://localhost:8080/jasperserver-pro, for example. You would find dozens of these warnings in the log. Another clue is that if you deleted Tomcat/work directory, it would not recreate it. 00029: 23-Aug-2021 09:57:42.450 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [E:ApacheTomcatwebappsdocs] 00030: 23-Aug-2021 09:57:42.622 WARNING [main] org.apache.tomcat.util.scan.StandardJarScanner.processURLs Failed to scan [file:/E:/Apache/Tomcat/lib/aws-java-sdk-redshift-1.11.118.jar] from classloader hierarchy 00031: java.io.FileNotFoundException: E:ApacheTomcatlibaws-java-sdk-redshift-1.11.118.jar (The system cannot find the file specified) 00088: at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473) 00089: 23-Aug-2021 09:57:42.622 WARNING [main] org.apache.tomcat.util.scan.StandardJarScanner.processURLs Failed to scan [file:/E:/Apache/Tomcat/lib/aws-java-sdk-sts-1.11.118.jar] from classloader hierarchy 00090: java.io.FileNotFoundException: E:ApacheTomcatlibaws-java-sdk-sts-1.11.118.jar (The system cannot find the file specified) 00147: at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473) 00148: 23-Aug-2021 09:57:42.622 WARNING [main] org.apache.tomcat.util.scan.StandardJarScanner.processURLs Failed to scan [file:/E:/Apache/Tomcat/lib/aws-java-sdk-core-1.11.118.jar] from classloader hierarchy 00149: java.io.FileNotFoundException: E:ApacheTomcatlibaws-java-sdk-core-1.11.118.jar (The system cannot find the file specified) Possible Solution: In this specific case, three files were deleted by accident. After restoring them from a back up, Tomcat starts again. [Windows installation] /users/abc/.jrsks, jrsksp, jslic Looking in hindsight, if you search the log again, you will find another error embedded in the avalanche of WARNINGs. ================== Caused by: java.lang.RuntimeException: Keystore initialization failed. Keystore properties couldn't be loaded using file:/E:/Apache/Tomcat/webapps/jasperserver-pro/WEB-INF/lib/js-crypto-3.1.0.jar!/keystore-configuration.xml at com.jaspersoft.jasperserver.crypto.KeystoreManager.<init>(KeystoreManager.java:178) at com.jaspersoft.jasperserver.crypto.KeystoreManager.<init>(KeystoreManager.java:85) at com.jaspersoft.jasperserver.crypto.KeystoreManager$InstanceHolder.<clinit>(KeystoreManager.java:142) ... 52 more Caused by: org.apache.commons.configuration2.ex.ConfigurationException: Could not locate: org.apache.commons.configuration2.io.FileLocator@76cc4a53[fileName=.jrsksp,basePath=C:Userssrvamr-jaspprd,sourceURL=,encoding=ISO-8859-1,fileSystem=com.jaspersoft.jasperserver.crypto.utils.Base64SynchronizingFileSystem@cc149a3,locationStrategy=com.jaspersoft.jasperserver.crypto.utils.JrsBasePathLocationStrategy@4516635c] at org.apache.commons.configuration2.io.FileLocatorUtils.locateOrThrow(FileLocatorUtils.java:345) at org.apache.commons.configuration2.io.FileHandler.load(FileHandler.java:971) at org.apache.commons.configuration2.io.FileHandler.load(FileHandler.java:701) at org.apache.commons.configuration2.builder.FileBasedConfigurationBuilder.initFileHandler(FileBasedConfigurationBuilder.java:311) at org.apache.commons.configuration2.builder.ReloadingFileBasedConfigurationBuilder.initFileHandler(ReloadingFileBasedConfigurationBuilder.java:184) at org.apache.commons.configuration2.builder.FileBasedConfigurationBuilder.initResultInstance(FileBasedConfigurationBuilder.java:290) at org.apache.commons.configuration2.builder.FileBasedConfigurationBuilder.initResultInstance(FileBasedConfigurationBuilder.java:59) at org.apache.commons.configuration2.builder.BasicConfigurationBuilder.createResult(BasicConfigurationBuilder.java:420) at org.apache.commons.configuration2.builder.BasicConfigurationBuilder.getConfiguration(BasicConfigurationBuilder.java:284) at org.apache.commons.configuration2.builder.combined.CombinedConfigurationBuilder$ConfigurationSourceData.addChildConfiguration(CombinedConfigurationBuilder.java:1600) at org.apache.commons.configuration2.builder.combined.CombinedConfigurationBuilder$ConfigurationSourceData.createAndAddConfigurations(CombinedConfigurationBuilder.java:1474) at org.apache.commons.configuration2.builder.combined.CombinedConfigurationBuilder.initResultInstance(CombinedConfigurationBuilder.java:797) at org.apache.commons.configuration2.builder.combined.ReloadingCombinedConfigurationBuilder.initResultInstance(ReloadingCombinedConfigurationBuilder.java:161) at org.apache.commons.configuration2.builder.combined.ReloadingCombinedConfigurationBuilder.initResultInstance(ReloadingCombinedConfigurationBuilder.java:58) at org.apache.commons.configuration2.builder.BasicConfigurationBuilder.createResult(BasicConfigurationBuilder.java:420) at org.apache.commons.configuration2.builder.BasicConfigurationBuilder.getConfiguration(BasicConfigurationBuilder.java:284) at org.apache.commons.configuration2.builder.combined.ReloadingCombinedConfigurationBuilder.getConfiguration(ReloadingCombinedConfigurationBuilder.java:134) at com.jaspersoft.jasperserver.crypto.KeystoreManager.a(KeystoreManager.java:204) at com.jaspersoft.jasperserver.crypto.KeystoreManager.<init>(KeystoreManager.java:172) ... 54 more

Problem: You have the following variable defined in your report, <variable name="testVariable" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[iF($F{FirstName} == "John",1, 0)]]></variableExpression> </variable> where $F{FirstName} is a string field. This expression returns 0 always, even if John is a valid value in the field. Solution: The trouble is using == in this case. Try a ternary operator as follows: <variable name="testVariable" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[$F{FirstName}.equals("John")?1:0]]></variableExpression> </variable> Or, <variable name="testVariable" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[iF($F{FirstName}.equals("John"),1,0]]></variableExpression> </variable>

Problem Description:For HTML5 charts, you can normally define a palette of colors as follows: [toc]<hc:chartProperty name="colors"> <hc:propertyExpression> <![CDATA[java.util.Arrays.asList("#18438B","#417CB9","#7EC2D0","#717678","#1aadce", "#492970","#f28f43","#77a1e5","#c42525","#a6c96a")]]> </hc:propertyExpression></hc:chartProperty>[/code]In Jaspersoft® Studio, it has an option Use Expression to define the colors. However, it is strictly for defining a color array. It does not allow conditionals. Solution:Try using bucketProperty. <dataAxis axis="Columns"> <axisLevel name="Hour_Range"> <labelExpression><![CDATA[]]></labelExpression> <axisLevelBucket class="java.lang.Comparable"> <bucketExpression><![CDATA[$F{HOUR_RANGE_SORT}]]></bucketExpression> <labelExpression><![CDATA[$F{HOUR_RANGE}]]></labelExpression> <bucketProperty name="color">IF( $F{HOUR_RANGE_SORT} == 0, "RGB(255,0,0)", //redIF( $F{HOUR_RANGE_SORT} == 1, "RGB(255,165,0)", //orangeIF( $F{HOUR_RANGE_SORT} == 2, "RGB(255,255,0)", //yellowIF( $F{HOUR_RANGE_SORT} == 3, "RGB(165,42,42)", //brownIF( $F{HOUR_RANGE_SORT} == 4, "RGB(0,0,255)", //blueIF( $F{HOUR_RANGE_SORT} == 5, "RGB(0,233,0)", "white" //green)))))) </bucketProperty></axisLevelBucket></axisLevel></dataAxis>[/code]

Problem Description: How to make a column in specific color based on value of column for HTML5 chart? Solution: You would define zones as follow in jrxml chart properties. See highcharts link for principles on how it works in highcharts. <hc:chartProperty name="plotOptions.column.zones[0].value"> <hc:propertyExpression><![CDATA[10]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.column.zones[0].color"> <hc:propertyExpression><![CDATA["#ffea00"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.column.zones[1].value"> <hc:propertyExpression><![CDATA[22]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.column.zones[1].color"> <hc:propertyExpression><![CDATA["#ff0014"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.column.zones[2].color"> <hc:propertyExpression><![CDATA["#00BBC1"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.column.zones[2].value"> <hc:propertyExpression><![CDATA[23]]></hc:propertyExpression> </hc:chartProperty> https://api.highcharts.com/highcharts/plotOptions.series.zones.color https://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/highcharts/css/color-zones/

Problem Description:Normally, you would use an expression such as the following to run a subreport from the main repoort: <subreportExpression> <![CDATA[subreport.jasper"]]></subreportExpression>[/code]How to dynamically create the subreport name on the fly? Solution:You can use IF, or a ternary operator, here are some simple code examples: <subreportExpression> <![CDATA[$P{TemplateName}.equals("Company9") ? "T9.jasper" : "TSomethingElse.jasper"]]></subreportExpression>[/code]If TemplateName is exact, you can do something like, <subreportExpression> <![CDATA[$P{TemplateName}+".jasper"]]></subreportExpression>[/code]Here is a more complex IF example, <subreportExpression> <![CDATA[iF($V{Z}>2,$P{X}.concat("X.jasper"),$P{Y}.concat(".jasper"))]]></subreportExpression>[/code]More complex ternary expression: <subreportExpression> <![CDATA[$P{TemplateName}.equals("Company9") ? "T9.jasper" : $P{TemplateName}.equals("Company8")? "T8.jasper":$P{TemplateName}.equals("Company7")? "T7.jasper":"default.jasper"]]></subreportExpression>[/code]In simplified form: x > y ? "greater" : x < y ? "less than" : x == y ? "equal" : "else"[/code]

Problem Description: You are getting the following exception when exporting a dashboard on v7.8.0 or v7.9.0: 2021-02-04T02:36:41,667 ERROR BrowserService,pool-53-thread-1:211 - Page error: Failed to load resource: the server responded with a status of 400 () 2021-02-04T02:39:11,672 ERROR BaseDashboardRenderer,pool-19-thread-8:76 - Error rendering dashboard net.sf.jasperreports.engine.JRRuntimeException: java.util.concurrent.TimeoutException at net.sf.jasperreports.chrome.BrowserService.lambda$evaluateInPage$1(BrowserService.java:149) at net.sf.jasperreports.chrome.IsolatedPageCreator.lambda$runInPage$0(IsolatedPageCreator.java:96) at net.sf.jasperreports.chrome.ChromeInstance.runWithChromeInstance(ChromeInstance.java:92) at net.sf.jasperreports.chrome.IsolatedPageCreator.runInPage(IsolatedPageCreator.java:69) at net.sf.jasperreports.chrome.BrowserService.evaluateInPage(BrowserService.java:98) at com.jaspersoft.ji.remote.dashboard.ChromeDashboardRenderer.renderDashboard(ChromeDashboardRenderer.java:40) at com.jaspersoft.ji.remote.dashboard.BaseDashboardRenderer.call(BaseDashboardRenderer.java:73) at com.jaspersoft.ji.remote.dashboard.BaseDashboardRenderer.call(BaseDashboardRenderer.java:25) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.util.concurrent.TimeoutException at java.util.concurrent.CompletableFuture.timedGet(CompletableFuture.java:1784) at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1928) at net.sf.jasperreports.chrome.BrowserService.lambda$evaluateInPage$1(BrowserService.java:144) ... 11 more Solution: In WEB-INF/js.config.properties: For example, you have to put in your own URL deploy.base.local.url=https://localhost:8443/jasperserver-pro In WEB-INF/classes/jasperreports.properties add the following: net.sf.jasperreports.chrome.argument.ignore-certificate-errors=true Now restart JRS and try to export again.

Problem Description:You are getting the following error when exporting to PDF on Wildfly on TIBCO JasperReports® Server v7.2.0: [toc]2021-02-09 12:17:56,761 INFO [stdout] (default task-18) [JPivot] 09 Feb 2021 12:17:56,760 ERROR [Session ] com.jaspersoft.jasperserver.api.common.error.handling.SecureExceptionHandlerImpl#handleException: Handler dispatch failed; nested exception is java.lang.NoClassDefFoundError: org/apache/batik/anim/dom/SVGDOMImplementation (Error UID: ed69bb92-dd32-43b2-b164-849eea2b55e3) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) [JPivot] 09 Feb 2021 12:17:56,761 ERROR [Session ] com.jaspersoft.jasperserver.war.action.ErrorPageHandlerAction#prepareErrorPage: Error UID ed69bb92-dd32-43b2-b164-849eea2b55e3 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.NoClassDefFoundError: org/apache/batik/anim/dom/SVGDOMImplementation 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:982) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at javax.servlet.http.HttpServlet.service(HttpServlet.java:706) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:157) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.security.csrf.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:72) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.security.csrf.CrossDomainCommunicationFilter.doFilter(CrossDomainCommunicationFilter.java:116) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticLoggingFilterPRO.java:42) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,762 INFO [stdout] (default task-18) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.infogix.component.reportframework.customize.J2EEAuthenticationIntegrationFilter.doFilter(J2EEAuthenticationIntegrationFilter.java:89) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:100) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:227) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:96) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:85) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:227) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:163) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) 2021-02-09 12:17:56,763 INFO [stdout] (default task-18) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.SessionXssNonceSetterFilter.doFilter(SessionXssNonceSetterFilter.java:67) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:53) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:59) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502) 2021-02-09 12:17:56,764 INFO [stdout] (default task-18) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1982) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at java.lang.Thread.run(Thread.java:748) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) Caused by: java.lang.NoClassDefFoundError: org/apache/batik/anim/dom/SVGDOMImplementation 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.apache.batik.anim.dom.SAXSVGDocumentFactory.<init>(SAXSVGDocumentFactory.java:120) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.renderers.util.SvgDataSniffer.<init>(SvgDataSniffer.java:59) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.renderers.util.SvgDataSniffer.getInstance(SvgDataSniffer.java:68) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.renderers.util.RendererUtil.getSvgDataSniffer(RendererUtil.java:164) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.renderers.util.RendererUtil.getSvgInfo(RendererUtil.java:133) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.renderers.util.RendererUtil.isSvgData(RendererUtil.java:114) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.renderers.util.RendererUtil.isSvgData(RendererUtil.java:153) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter$InternalImageProcessor.process(JRPdfExporter.java:1587) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter$InternalImageProcessor.access$300(JRPdfExporter.java:1542) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter.exportImage(JRPdfExporter.java:1482) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at com.jaspersoft.jasperreports.fusion.BasePdfHandler.exportElement(BasePdfHandler.java:32) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter.exportGenericElement(JRPdfExporter.java:3210) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:1112) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:1063) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:927) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:547) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.exportToPdf(EngineServiceImpl.java:616) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at java.lang.reflect.Method.invoke(Method.java:498) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at com.sun.proxy.$Proxy472.exportToPdf(Unknown Source) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.action.ReportPdfExporter.export(ReportPdfExporter.java:66) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.action.AbstractReportExporter.exportBuffered(AbstractReportExporter.java:188) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.action.AbstractReportExporter.export(AbstractReportExporter.java:96) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at com.jaspersoft.jasperserver.war.action.ReportExporterAction.export(ReportExporterAction.java:160) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at java.lang.reflect.Method.invoke(Method.java:498) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:99) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.engine.ActionList.execute(ActionList.java:154) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.engine.State.enter(State.java:193) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.engine.Transition.execute(Transition.java:228) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:395) 2021-02-09 12:17:56,765 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:116) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:547) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:390) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.State.enter(State.java:194) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.Transition.execute(Transition.java:228) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:395) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:552) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:390) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:231) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:195) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.Flow.resume(Flow.java:537) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at sun.reflect.GeneratedMethodAccessor1347.invoke(Unknown Source) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at java.lang.reflect.Method.invoke(Method.java:498) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at com.sun.proxy.$Proxy530.resumeExecution(Unknown Source) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:253) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) 2021-02-09 12:17:56,766 INFO [stdout] (default task-18) ... 162 moreWorkaround:This problem should have been fixed on JasperReports Server v7.2.0. If you are still getting this error on v7.2.0, you might have deployed an embedded WAR without using buildomatic scripts. JasperReports Server on JBOSS requires libraries to be used from our application instead of the default libraries packaged into JBoss. To workaround this situation, on another machine, you can go through the buildomatic deployment, then copy the modules to your embedded installation. The specific file involved is, module_org_apache_batik.xml -<dependencies> <!--2013-04-19 javax.api does not includeorg.w3c.dom.svgfor that we pull in xml-apis-ext-1.3.04.jar --> <module name="javax.api"/> -<system export="true"> -<paths> <path name="org/w3c/dom/css"/> <path name="org/w3c/dom/xpath"/> <path name="org/w3c/dom/stylesheets"/> </paths> </system> </dependencies>

Problem Description: Suppose you have Jaspersoft ETL 7.1.1 license which is going to expire on 23-Apr-2021. You have created some projects to extract data from Oracle databases and generate CSV files from them, using the Jaspersoft ETL UI, and have exported these projects to JAR files. You run these JAR files daily using .bat files, triggered via some OS Task Scheduler. Once the ETL license expires, can you still run generated JAR files? Answer [as of Feb 2, 2021 Talend]: All code that you create with the software is usable in perpetuity without a continuing subscription per our EULA. Link to EULA (https://www.talend.com/legal-terms/us-eula/) 2(b) Use any Generated Code in perpetuity subject to the restrictions set forth below in Section 2.2; 1.4 “Generated Code” means an independently executable program or other similar binary code artifact that is generated by the Talend Software for which Customer has purchased a Software Subscription hereunder. 1.16 “Subscription Term” means the period of time set forth in the applicable Order Form for which a Software Subscription, Learning Subscription, Cloud Subscription or Monthly Cloud Subscription is valid. Notwithstanding the foregoing, the Subscription Term for any Generated Code is always perpetual.

Problem Description: If you created an in page multi-select input control for a report, you will see that it will display 10 items. If you have many input controls, you might want to reduce the size of the dropdown box. Solution: If you check the UI HTML code using F12 to get to the browser debug panel, you will see that the height of the drop down is set to 308px. This value is calculated in a file scriptsruntime_dependenciesjs-sdksrccomponentsmultiSelectviewMultiSelect.js. This script generats the JSP code responsible for displaying the input control drop down box. Look for the following value var DEFAULT_VISIBLE_ITEMS_COUNT = 10; If you reduce the count, the drop down box will be smaller. The change is simple here. However, you will need to go thru a complex process to re-optimize the code. See this link for more information: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v780/customizing-javascript-files After optimization, you will have to restart Tomcat to make the change active. Be sure to clear Tomcat /work cache before starting because the old JSP may still be in the cache. ======================================= Disclaimer: This change is provided as high level guidance. It is not meant to be an official fix provided by TIBCO/Jaspersoft. Customer is responsible for developing, testing, maintaining the fix as custom code and assume all risks that might exist. This suggestion is based on v7.5.1. Developer level skill is required.

Problem Description: You are unable to connect from Jaspersoft Studio to Jasperserver after you updated the expired certificate to a new one. You are getting the following error java.util.concurrent.ExecutionException: javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateException: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at jersey.repackaged.com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:306) at jersey.repackaged.com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:293) at jersey.repackaged.com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116) at com.jaspersoft.studio.server.protocol.restv2.JSSApacheConnectorFactory.doWait(JSSApacheConnectorFactory.java:40) at com.jaspersoft.studio.server.protocol.restv2.JSSApacheConnectorFactory.post(JSSApacheConnectorFactory.java:63) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.doConnectLogin(RestV2ConnectionJersey.java:328) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.doConnect(RestV2ConnectionJersey.java:247) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.connect(RestV2ConnectionJersey.java:227) 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:122) Caused by: javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateException: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Solution: Tbere are many reasons for getting this error including bad certificate and incorrect path. The error message can be misleading. This is a special case when you know your certificate is valid because you had just upgraded the same certificate that had expired from the same certificate source. One possibility is that you might have forgotten to update the intermediate certificate. If so, you will get the above error message.

Problem Description: You can get a lot of useful information from the diagnostic report provided in the repository folder /public/diagnostic. What do these attributes mean? For example, RunningSyncReportsCountCuml? Solution: If you hover your cursor over the attribute, you will see a brief description in the tooltip. In the example above, you will see the following description: Cumulative total of all synchronous report executions since last application startup. You can also find the complete list in this file: WEB-INFbundlesjasperserver_messages.properties For example: #Diagnostic params diagnosticCustomDataSource.name=Internal Diagnostic diagnosticAttribute.desc.LoggedInUsersCount=Number of users currently logged in diagnosticAttribute.desc.LoggedInUsersList=List of users currently logged in with count by session diagnosticAttribute.desc.TotalUsersCount=Total number of users (enabled and disabled) in repository diagnosticAttribute.desc.TotalEnabledUsersCount=Total number of enabled users in repository diagnosticAttribute.desc.TotalRolesCount=Total number of roles in repository diagnosticAttribute.desc.TotalOrganizationsCount=Total number of organizations in repository diagnosticAttribute.desc.ScheduledJobsCount=Total number of scheduled jobs in repository diagnosticAttribute.desc.RunningJobsCount=Number of jobs currently running diagnosticAttribute.desc.RunningJobsList=List of jobs currently running and # seconds running diagnosticAttribute.desc.TotalReportsCount=Total number of reports in repository diagnosticAttribute.desc.TotalFoldersCount=Total number of folders in repository diagnosticAttribute.desc.TotalDashboardsCount=Total number of dashboards in repository diagnosticAttribute.desc.TotalAdhocViewsCount=Total number of adhoc views in repository diagnosticAttribute.desc.TotalReportsOutputCount=Total number of report outputs in repository diagnosticAttribute.desc.TotalOlapViewsCount=Total number of olap views in repository diagnosticAttribute.desc.TotalDomainsCount=Total number of domains in repository diagnosticAttribute.desc.TotalDataSourcesCount=Total number of data sources in repository

Problem Description:You have successfully added to a report a text field that is as tall as 2 fields stacked together right next to it in TIBCO Jaspersoft® Studio. The fields are displayed exactly when running the report on TIBCO JasperReports® Server. However, when exporting to Excel, the first field is split into 2 Excel rows just like the 2 fields right next to it. Solution:Add the following to the jrxml file where all the properties are in the beginning of the jrxml file, <property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/>[/code]This setting is for the report only. If you add the following to WEB-INF/classes/jasperreports.properties file, restart jasperserver, it should work for all reports when export to Excel. net.sf.jasperreports.export.xls.collapse.row.span=false[/code]This setting is in the default properties [Window->Preferences->Jaspersoft Studio->Properties->Jasper Reports Properties] in Jaspersoft Studio. That is why it works when exporting from Jaspersoft Studio and not on jasperserver.

Problem Description:You have successfully added barcodes to your report in TIBCO Jaspersoft® Studio, and the barcodes are displayed properly when running the report on jasperserver. However, when exporting to Excel, no barcode is shown in the Excel spreadsheet. Solution:The default setting is "ignore graphics in the report" for the report. So, it will work if you add the following to the jrxml file where all the properties are in the beginning of the jrxml file, <property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"/>[/code]This setting is for the report only. If you add the following to WEB-INF/classes/jasperreports.properties file, restart jasperserver, it should work for all reports when export to Excel. net.sf.jasperreports.export.xls.ignore.graphics=false[/code]This setting is in the default properties [Window->Preferences->Jaspersoft Studio->Properties->Jasper Reports Properties] in Jaspersoft Studio. That is why it works when exporting from Jaspersoft Studio and not on JasperReports Server.

Problem Description:In the file applicationContext-audit.xml, this line of code is commented out. <!--<entry key="accessResource" value="exception"/>--> Explanation:If you enable this feature by uncommenting this line, jasperserver generates a large amount of audit data. It logs all resource types such as reports, input controlss, content resources etc. Currently, there is no way to specify logging in finer granularity. There is an enhancement request logged however, for a feature to allow finer granuarity for logging. If you need information about this request, please inquire about bug report JS-15409.

Problem Description: You have created a crosstab report in the Ad Hoc Designer. You are using a number of calcualted measures in the crosstab. When you drag a measure into the COLUMNS field, you get the following error: Crosstab Report Error: Already Closed Solution: There might be a variety of causes. One of the causes is, identifier too long for the database query created for the crosstab, e.g. for MSSQL. The identifier created may look something like this. The identifier that starts with 'CountAll_IF_equals_EAB_NonCancelled_CHGNUM_NONCNCL_EAB_NotPreappOrRoutine_CHGNUM_NOTPREAPP_EAB_NotPreappOrRoutine_CHGNUM_NOTPREA' is too long. Maximum length is 128. There is no known workaround for this issue at this time. Best is to shorten the field and measure names so that the concatenated name is less than 128 characters.

Problem Description:When clicking export to xlsx, the application fails with opening a new tab showing the log in page instead of downloading the spreadsheet. No error in the jasperserver.log or Tomcat logs. Resolution:There might be many reasons for this problem. If everything else looks good and you still don't know why it is failing. Check the maxParameterCount value in the Tomcat file server.xml. Also, compare that the number of values returning to an input control. If the number of rows exceeds the value set in maxParameterCount, you will get this failure with no error in the log. You will get a token missing error, if the token key is truncated in the POST call generated by jasperserver. You can increase the value of maxParameterCount or simply set it to -1 to have no limit. A harder solution would be to redesign the report to reduce the number of values you are getting. Perhaps using cascading input controls.

Problem Description:You are trying to add a JNDI datasource in TIBCO JasperReports® Server. You have updated your context.xml configuration file correctly and the driver jars are in WEB-INF/lib. You get the following error: [toc]2020-09-11T15:36:20,324 ERROR JSDataSourceConnectionFailedExceptionMapper,http-nio-9090-exec-11:32 - The data source connection failed com.jaspersoft.jasperserver.api.metadata.common.service.JSDataSourceConnectionFailedException: Name [abcdDS] is not bound in this Context. Unable to find [abcdDS]. Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JndiJdbcReportDataSourceServiceFactory.createService(JndiJdbcReportDataSourceServiceFactory.java:94) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:96) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributesResolverAspect.resolveDataSourceAttributes(ProfileAttributesResolverAspect.java:50) 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 org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy156.createService(Unknown Source) at com.jaspersoft.jasperserver.remote.connection.jdbc.JdbcConnector.getDataSourceService(JdbcConnector.java:119) at com.jaspersoft.jasperserver.remote.connection.jdbc.JdbcConnector.testConnection(JdbcConnector.java:90) at com.jaspersoft.jasperserver.remote.connection.jdbc.ClientJdbcConnector.testConnection(ClientJdbcConnector.java:52) at com.jaspersoft.jasperserver.remote.connection.jdbc.JdbcContextStrategy.createContext(JdbcContextStrategy.java:54) at com.jaspersoft.jasperserver.remote.connection.jdbc.JdbcContextStrategy.createContext(JdbcContextStrategy.java:43) at com.jaspersoft.jasperserver.remote.connection.ContextsManager.createContext(ContextsManager.java:115) at com.jaspersoft.jasperserver.jaxrs.connection.ContextsJaxrsService.createContext(ContextsJaxrsService.java:111) at com.jaspersoft.jasperserver.jaxrs.connection.ContextsJaxrsService$$FastClassBySpringCGLIB$$348349e7.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671) at com.jaspersoft.jasperserver.jaxrs.connection.ContextsJaxrsService$$EnhancerBySpringCGLIB$$60c600a8.createContext(<generated>) 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 org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) at org.glassfish.jersey.internal.Errors.process(Errors.java:315) at org.glassfish.jersey.internal.Errors.process(Errors.java:297) at org.glassfish.jersey.internal.Errors.process(Errors.java:267) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88) at com.jaspersoft.jasperserver.api.security.csrf.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:73) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.jasperserver.api.security.csrf.CrossDomainCommunicationFilter.doFilter(CrossDomainCommunicationFilter.java:116) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticLoggingFilterPRO.java:42) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:98) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:100) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:75) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:75) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:227) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:75) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:75) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:227) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:163) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at com.jaspersoft.jasperserver.api.security.externalAuth.JSDelegatingFilterProxy.doFilter(JSDelegatingFilterProxy.java:75) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:155) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:85) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.jasperserver.war.SessionXssNonceSetterFilter.doFilter(SessionXssNonceSetterFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.ForwardedHeaderFilter.doFilterInternal(ForwardedHeaderFilter.java:153) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:643) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: javax.naming.NameNotFoundException: Name [abcdDS] is not bound in this Context. Unable to find [abcdDS]. at org.apache.naming.NamingContext.lookup(NamingContext.java:833) at org.apache.naming.NamingContext.lookup(NamingContext.java:160) at org.apache.naming.NamingContext.lookup(NamingContext.java:843) at org.apache.naming.NamingContext.lookup(NamingContext.java:160) at org.apache.naming.NamingContext.lookup(NamingContext.java:843) at org.apache.naming.NamingContext.lookup(NamingContext.java:160) at org.apache.naming.NamingContext.lookup(NamingContext.java:843) at org.apache.naming.NamingContext.lookup(NamingContext.java:174) at org.apache.naming.SelectorContext.lookup(SelectorContext.java:163) at java.naming/javax.naming.InitialContext.lookup(InitialContext.java:409) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JndiJdbcReportDataSourceServiceFactory.createService(JndiJdbcReportDataSourceServiceFactory.java:78) ... 197 moreSolution:Use a service name like jdbc/abcdDS instead of just abcdDS.

Problem Description:I opened a jrxml file in Jaspersoft® Studio and went to Preview mode. All I see is the following when I click on the Data Adapter icon in the upper left corner of the report: -- No Data Adapter -- Don't use a Data Adapter In the Data Adapters section of the Repository Explorer pane, I have a list of Data Adapters. mySampleDataSourceSample DBOne Empty RecordDomain JRSHow can I make these adapters visible when I open a report jrxml file? Solution:In the Data Adapters section of the Repository Explorer, right click on the data adapter you want to make visible. Select the option - Export to File. You will see a Save As dialog box. In the field "Enter or select the parent folder": Select the MyReports folder to make your data adapter visible to all reports Or, Select a specific folder from your Jasperserver directory for a particular report

Problem Description: Suppose you have a ColumnLine HTML5 chart. It allows you to use only 1 y-axis for the ColumnLine chart. But, you want to plot an average line for all the data in the measure, but only sum for a subset of the Column measure. <multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Sum"> <labelExpression><![CDATA["Customer Total"]]></labelExpression> <valueExpression><![CDATA[$F{FREIGHT}]></valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Measure2" class="java.lang.Number" calculation="Average"> <labelExpression><![CDATA["Region Avg"]]></labelExpression> <valueExpression><![CDATA[$F{FREIGHT}]]></valueExpression> </multiAxisMeasure> Solution: <multiAxisMeasure name="Measure1" class="java.lang.Number" calculation="Sum"> <labelExpression><![CDATA["Customer Total"]]></labelExpression> <valueExpression><![CDATA[EQUALS($F{CUSTOMERID},"AAA")?$F{FREIGHT}:0]]></valueExpression> </multiAxisMeasure> <multiAxisMeasure name="Measure2" class="java.lang.Number" calculation="Average"> <labelExpression><![CDATA["Region Avg"]]></labelExpression> <valueExpression><![CDATA[$F{FREIGHT}]]></valueExpression> </multiAxisMeasure>

Problem Description: You have discovered the domain joins have changed after upgrade to v7.5.0. Workaround: Try, Use all joins, to maintain compatibility. Look for "Use all joins" as described in this link. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v750/understanding-joins-and-join-trees

Problem Description:You are getting this error when running a new report: [toc]"Processor of type com.jaspersoft.jasperserver.inputcontrols.cascade.handlers.converters.DataConverter for class net.sourceforge.jtds.jdbc.ClobImpl not configured." Workaround:You might get this error even when clob datatype is not used. For example, you may be using a JTDS jdbc driver. The trouble may be with a column with datatype of nvarchar(max). This datatype is interpreted by jasperserver as clob and hence the failure. Try using something like this: nvarchar(400)

Problem:After modification to a domain derived table sql statement, the topic field disappeared from the measure panel in Ad Hoc Designer despite valid sql syntax. But, this field is visible in the Domain, in Ad Hoc "Select Fields". It is not a cache or optimization issue. It is happening only with this one field. Explanation and Workaround:The are many reasons why fields may not appear in Ad Hoc Designer. This is a situation when only one field is affected and it is visible everywhere else. In this case, the derived table sql statement contains the following clause originally, NULL as Fieldx Fieldx is displayed properly when the topic is opened in Ad Hoc Designer. A case statement was added to fill Fieldx instead of setting it to NULL. After the change, Fieldx is no longer visible. The reason is because the original NULL as Fieldx clause defaults to datatype java.lang.Integer. Fieldx needs java.math.Decimal for the values determined by the case statement. To solve this problem, search for the field in the Topic and change the datatype java.lang.Integer to java.math.Decimal. This is a specific change for this particular circumstance. Datatypes will most likely not the same for similar symptoms. You will need to figure that out by looking at the actual datatypes that are appropriate for your situation.

Problem Description:You are getting the following exception in Jaspersoft Studio when trying to preview a report and logged into Jasperserver with non-admin user credential. Logging into jasperserver as user with ROLE_ADMINISTRATOR works without error. [toc]Exception, if you want to see more information look into details. Reason: (401)AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (401) faultActor: faultNode: faultDetail: {}:return code: 401<!doctype html><html lang="en"><head><title>HTTP Status 401 – Unauthorized</title><style type="text/css">h1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} h2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} h3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} body {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} b {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} p {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;} a {color:black;} a.name {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 401 – Unauthorized</h1><hr class="line" /><p><b>Type</b> Status Report</p><p><b>Message</b> Full authentication is required to access this resource</p><p><b>Description</b> The request has not been applied because it lacks valid authentication credentials for the target resource.</p><hr class="line" /><h3>Apache Tomcat/8.5.30</h3></body></html> {http://xml.apache.org/axis/}HttpErrorCode:401(401) at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender$3.handleResponse(JSSCommonsHTTPSender.java:245) at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender$3.handleResponse(JSSCommonsHTTPSender.java:1) at org.apache.http.client.fluent.Response.handleResponse(Response.java:90) at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender.invoke(JSSCommonsHTTPSender.java:221) 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)[/code]Workaround:Add the following line to applicationContext-security-pro-web: [JRS versions v6.4 to v7.5.1 as of 6/3/2020] Find<security:filter-security-metadata-source id="filterInvocationInterceptorPROExtention" request-matcher="ant" use-expressions="false">[/code]Add<security:intercept-url pattern="/rest_v2/queryExecutor/**" access="ROLE_USER,ROLE_ADMINISTRATOR"/>[/code]