Jim W

Description:Getting null pointer exception when trying to import users and roles from a previous version to a new version of TIBCO JasperReports® Server. Resolution:For this particular situation, <role/> is causing the null pointer exception. This is probably a result of an irregular creation from your LDAP where the user is not mapped to a role. You have to find these users and delete them. You can also delete all the external users anyway because they will be regenerated on your new system. You can search for the files *.xml in the exported zip package or directory for this tag <role/>. You will get a list of users that you need to delete <?xml version="1.0" encoding="UTF-8"?><user> <username>auserA</username> <fullName>auserA</fullName> <externallyDefined>true</externallyDefined> <enabled>true</enabled> <role/></user>[/code]

Description:You are getting the following Hibernate Optimistic Locking error when running many jobs at the same time [toc]org.quartz.JobExecutionException: The job was not completed. A system error occurred while running it. [see nested exception: org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException: Object of class [com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobAlert] with identifier [2241]: optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobAlert#2241]]at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.throwJobExecutionException(ReportExecutionJob.java:416)at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.checkExceptions(ReportExecutionJob.java:408)at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:644)at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:279)at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:47)at org.quartz.core.JobRunShell.run(JobRunShell.java:213)at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)Caused by: org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException: Object of class [com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobAlert] with identifier [2241]: optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobAlert#2241]at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:683)[/code]Resolution:Try adding these properties to WEB-INF/js.quartz.base.properties and set them to "true" org.quartz.jobStore.txIsolationLevelSerializableorg.quartz.jobStore.acquireTriggersWithinLock[/code]

Description:Trouble installing TIBCO Jaspersoft® Studio v6.5.0 final via a remote shell with the following error. [toc][root@localhost TIB_js-studiocomm_6.5.0.final]# less /root/JasperSoft/TIB_js-studiocomm_6.5.0.final/configuration/1515504630074.log!SESSION 2018-01-09 10:30:28.709 -----------------------------------------------eclipse.buildId=unknownjava.version=1.8.0_144java.vendor=Oracle CorporationBootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_USCommand-line arguments: -os linux -ws gtk -arch x86_64 -data @noDefault!ENTRY org.eclipse.osgi 4 0 2018-01-09 10:30:38.216!MESSAGE Application error!STACK 1org.eclipse.swt.SWTError: No more handles [gtk_init_check() failed]at org.eclipse.swt.SWT.error(SWT.java:4559)at org.eclipse.swt.widgets.Display.createDisplay(Display.java:958)at org.eclipse.swt.widgets.Display.create(Display.java:942)at org.eclipse.swt.graphics.Device.<init>(Device.java:174)at org.eclipse.swt.widgets.Display.<init>(Display.java:562)at org.eclipse.swt.widgets.Display.<init>(Display.java:553)at org.eclipse.ui.internal.Workbench.createDisplay(Workbench.java:795)at org.eclipse.ui.PlatformUI.createDisplay(PlatformUI.java:160)at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:41)at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673)at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610)at org.eclipse.equinox.launcher.Main.run(Main.java:1519)at org.eclipse.equinox.launcher.Main.main(Main.java:1492)[/code]Resolution:add "X11Forward yes" inside the /etc/ssh/ssh_config on the remote server enable X11 forwarding in your SSH client install and run an X11 server on your Windows client laptop (e.g. Xming)

Description: You may see the chart legend garbled when exporting a view from Ad Hoc to PDF. Resolution: You may have multiple properties defined that are interferring, e.g. <hc:chartProperty name="legend.itemStyle.textOverflow" value="null"></hc:chartProperty> <hc:chartProperty name="legend.itemStyle.width" value="600"></hc:chartProperty> <hc:chartProperty name="legend.itemStyle.fontSize" value="8px"></hc:chartProperty>[/code]Try removing two and leaving just one property, that may be all that is needed: </hc:chartProperty> <hc:chartProperty name="legend.itemStyle.fontSize" value="8px"></hc:chartProperty>[/code]

Description:The issue is, postgreSQL Schema creates pg_toast schema and does not purge when reports are purged. So, you ended up using a lot of database space in the repository. This would create a db space issue if you are running thousands upon thousands of reports on a busy system. You can use the following query to check usage of each schema: SELECT schema_name, pg_size_pretty( sum(table_size) ::bigint), (sum(table_size) / pg_database_size(current_database())) * 100 FROM ( SELECT pg_catalog.pg_namespace.nspname as schema_name, pg_relation_size(pg_catalog.pg_class.oid) as table_size FROM pg_catalog.pg_class JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid) tGROUP BY schema_nameORDER BY schema_name[/code]You can see that pg_toast schema size is increasing. Delete scheduled reports from jasperserver and check the usage again. You can see that pg_toast schema size does not decease after scheduled reports are deleted. For example, "information_schema";"96 kB";0.01640122369038771500"pg_catalog";"5920 kB";1.01140879424057576000"pg_toast";"550 MB";96.23007969742732097600"public";"14 MB";2.43011464345911310900[/code]AFTER deleting 15,000 output files. "information_schema";"96 kB";0.01578401730292068700"pg_catalog";"5928 kB";0.97466306845535240600"pg_toast";"572 MB";96.30486623899532674700"public";"14 MB";2.37417926931431996400[/code]Resolution:This is "by design" in Postgres DB. JasperReports® Server does not have control over it. The solution is to perform postgresql maintenance from time to time. See here for some internet user discussion : https://stackoverflow.com/questions/28032850/how-to-shrink-pg-toast-table Autovaccum could be the solution : https://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM

Description: How to calculate age based on today's date in Ad Hoc view designer? Solution: Add a calculated field as follows: ElapsedYears( Today(0),BirthDate)

Description:You may have a simple or complex cluster set up. The basic problem is that an organization is created on one node, but the change is not visible on another node in the cluster. You have followed all the instructions in the TIBCO JasperReports® Server documentation and it is still failing. Solution:The current documentation as of v7.1.0 has some ambiguity for setting up a cluster for partial session replication. The following is a temporary clarification for you. Documentation will be updated in the next available release. When designing a cluster of JasperReports® Servers, you can enable partial session replication by configuring the server and its app server on each node. Partial session replication is not required, but it is usually beneficial because it makes failover less visible to users in most cases, and some cases of single-sign-on authentication will not work on the cluster without it. The current version of the TIBCO JasperReports® Server Ultimate Guide suggests that server configuration is not necessary, only app server configuration. However, in order to enable partial session replication, you must make configuration changes to JasperReports Server on every node. The current version of the Ultimate Guide does provide all the correct configuration steps in the following section: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v710/app-server-configuration-failover Follow that procedure on every node in your cluster to enable partial session replication, including the server's internal ehcache. After re-deploying all nodes, you should see successful failover and single sign-on in your cluster.

Description:You are suddenly getting the following exception when running a dashboard which worked before many times. Dashboard works again after restarting the OS, then fails again after a little while. Error Trace:Exception occurred rendering view org.springframework.web.servlet.view.JstlView: name 'modules/system/errorPage'; URL [/WEB-INF/jsp/modules/system/errorPage.jsp] java.lang.IllegalStateException: Exception occurred rendering view org.springframework.web.servlet.view.JstlView: name 'modules/system/errorPage'; URL [/WEB-INF/jsp/modules/system/errorPage.jsp] at org.springframework.webflow.mvc.view.AbstractMvcView.render(AbstractMvcView.java:191)atorg.springframework.webflow.engine.ViewState.render(ViewState.java:296) at....[/code]Solution: You may be running out of disc space. Check disk space immediately and run disk cleanup as soon as possible to keep the system running normally at least temporarily until you have time to make major deletion of unused folders. This particular failure system has only 50G of disc space which is inadequate. Disc space is inexpensive these days, should be more generous. Leave a large margin for growth. Suggested minimum 256G. The diagnostic report in /public/diagnostic is a very useful tool for checking memory or disc space. Run it once in a while to make sure that JRS has ample system resources to operate normally.

Description:2018-08-23 18:19:25,213 ERROR BrokerService,localhost-startStop-1:624 - Failed to start Apache ActiveMQ ([ip-10-4-1-135.ec2.internal, null], java.lang.RuntimeException: java.io.IOException: Failed to create directory activemq-data/ip-10-4-1-135.ec2.internal/KahaDB) 2018-08-23 18:19:25,223 ERROR KahaDBPersistenceAdapter,localhost-startStop-1:96 - Could not stop service: KahaDBPersistenceAdapter[/usr/share/tomcat8/activemq-data/ip-10-4-1-135.ec2.internal/KahaDB]. Reason: org.apache.activemq.broker.BrokerStoppedException org.apache.activemq.broker.BrokerStoppedException at org.apache.activemq.broker.BrokerService.checkStartException(BrokerService.java:1331) at org.apache.activemq.broker.BrokerService.getManagementContext(BrokerService.java:1323) at org.apache.activemq.broker.BrokerService.createBrokerObjectName(BrokerService.java:2470) at org.apache.activemq.broker.BrokerService.getBrokerObjectName(BrokerService.java:1309) at org.apache.activemq.store.kahadb.KahaDBPersistenceAdapter.doStop(KahaDBPersistenceAdapter.java:253) at org.apache.activemq.util.ServiceSupport.stop(ServiceSupport.java:71) at org.apache.activemq.util.ServiceStopper.stop(ServiceStopper.java:41) at org.apache.activemq.broker.BrokerService.stop(BrokerService.java:839) at org.apache.activemq.xbean.XBeanBrokerService.stop(XBeanBrokerService.java:122) at org.apache.activemq.broker.BrokerService.start(BrokerService.java:627) at org.apache.activemq.broker.BrokerService.autoStart(BrokerService.java:575) at org.apache.activemq.broker.BrokerService.postConstruct(BrokerService.java:562) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:344) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:295) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:396) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1507) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedMap(BeanDefinitionValueResolver.java:384) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:165) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:637) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:145) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1077) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:981) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:449) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:423) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:551) at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:169) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:304) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1148) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1131) at org.springframework.ui.context.support.UiApplicationContextUtils.initThemeSource(UiApplicationContextUtils.java:58) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.onRefresh(AbstractRefreshableWebApplicationContext.java:195) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:476) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 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: org.apache.activemq.broker.BrokerStoppedException: Stop invoked at org.apache.activemq.broker.BrokerService.stop(BrokerService.java:793) ... 128 more 2018-08-23 18:19:25,230 ERROR KahaDBPersistenceAdapter,localhost-startStop-1:96 - Could not stop service: KahaDBPersistenceAdapter[/usr/share/tomcat8/activemq-data/ip-10-4-1-135.ec2.internal/KahaDB]. Reason: org.apache.activemq.broker.BrokerStoppedException org.apache.activemq.broker.BrokerStoppedException Failure to create the folder activemq-data [ec2-user@ip-10-5-2-76 tomcat8]$ ls activemq-data bin conf lib logs temp webapps work Workaround: August 25, 2018 [JS Bug tracking JS-34159]It`s a known bug, this issue started happening one week ago as AWS start pushing "tomcat8-8.5.32-1.78.amzn1" update which is changing permissions for tomcat home folder /usr/share/tomcat8. By default, in Amazon Linux when an instance first launched, it executes upgrade of all installed packages (including tomcat) To disable that - here are the options: https://aws.amazon.com/amazon-linux-ami/faqs/#auto_update Our JAWS Releases always have tomcat home folder owned by user tomcat and group tomcat also by default. In previous tomcat packages it was having read-write-execute (rwx) permissions for owner and group. In the latest update of tomcat, owner is changed to user:root and group:tomcat. Also permissions are changed to read-write-execute only for owner-user, group will have only read and execute permissions (write is missing). As Tomcat is launched from user tomcat - it cannot create any folders in it's home folder (/usr/share/tomcat8), not only for ActiveMQ but also folder for cache, license activation, etc. You have the following options: option 1: Disable auto update. https://aws.amazon.com/amazon-linux-ami/faqs/#auto_update option 2: After update, before tomcat is started, change owner of tomcat home folder to user:tomcat group:tomcat option 3: After update, before tomcat is started, change permissions of /usr/share/tomcat8 to read-write-execute for group and user option 4: Re-package AMI and introduce some fix which will be resolving this issue when tomcat will be updated. As an example, you can add additional command in special file which will be executed after tomcat update, e.g. file "/etc/yum/post-actions/allowTomcatToBindPort80.action". Additional command example: "tomcat8:update: chown tomcat:tomcat /usr/share/tomcat8" Question about option 1: Update 8/27/2018 Does it mean we can specify whether or not to do this from the user-data section of our cloud formation templates? Or, is it referencing some other user-data information? For hourly single instance modes - yes, it`s possible to use user-data because we don`t use user-data For Cluster HA mode - no, because we use user-data to pass many Cluster related parameters. Adding extra parameters to disable auto-update are ignored.

I do not have access to the operating system TIBCO JasperReports® Server is running on. Is there a way to find general information about the operating system? Yes, log in as superuser, run the diagnostic report in /public/diagnostic and look for, ExternalInfo. Here are some examples of what you can find in the diagnostic report. OsArchitectureamd64OsCommittedVirtualMemorySize-1OsFreePhysicalMemorySize-1OsFreeSwapSpaceSize-1OsNameWindows 10OsProcessCpuTime-1OsSystemLoadAverage-1.0OsTotalPhysicalMemorySize-1OsTotalSwapSpaceSize-1OsVersion10.0Propertiessun.desktop = windows awt.toolkit = sun.awt.windows.WToolkit file.encoding.pkg = sun.io java.specification.version = 1.8 sun.cpu.isalist = amd64 sun.jnu.encoding = Cp1252 sun.awt.enableExtraMouseButtons = true java.class.path = C:\Jaspersoft\jasperreports-server-6.4.0Nov17\apache-tomcat\bin\bootstrap.jar;C:\Jaspersoft\jasperreports-server-6.4.0Nov17\apache-tomcat\bin\tomcat-juli.jar java.vm.vendor = Oracle Corporation sun.arch.data.model = 64 user.variant = catalina.useNaming = true java.vendor.url = http://java.oracle.com/ user.timezone = America/Los_Angeles os.name = Windows 10 java.vm.specification.version = 1.8 user.country = US sun.boot.library.path = C:\JASPER~1\JASPER~1.0NO\java\bin sun.cpu.endian = little user.home = C:\WINDOWS\system32\config\systemprofile user.language = en java.specification.vendor = Oracle Corporation java.naming.factory.url.pkgs = org.apache.naming java.home = C:\JASPER~1\JASPER~1.0NO\java file.separator = \ line.separator = rn java.vm.specification.vendor = Oracle Corporation java.specification.name = Java Platform API Specification java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment package.access = sun.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.tomcat. package.definition = sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.naming.,org.apache.tomcat. sun.boot.class.path = C:\JASPER~1\JASPER~1.0NO\java\lib\resources.jar;C:\JASPER~1\JASPER~1.0NO\java\lib\rt.jar;C:\JASPER~1\JASPER~1.0NO\java\lib\sunrsasign.jar;C:\JASPER~1\JASPER~1.0NO\java\lib\jsse.jar;C:\JASPER~1\JASPER~1.0NO\java\lib\jce.jar;C:\JASPER~1\JASPER~1.0NO\java\lib\charsets.jar;C:\JASPER~1\JASPER~1.0NO\java\lib\jfr.jar;C:\JASPER~1\JASPER~1.0NO\java\classes user.script = server.loader = java.util.logging.config.file = C:\Jaspersoft\jasperreports-server-6.4.0Nov17\apache-tomcat\conf\logging.properties sun.management.compiler = HotSpot 64-Bit Tiered Compilers java.runtime.version = 1.8.0_121-b13 java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory user.name = MAIN$ path.separator = ; ehcache.disk.store.dir = C:\JASPER~1\JASPER~1.0NO\APACHE~1\temp common.loader = "${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.home}/lib/*.jar" os.version = 10.0 java.endorsed.dirs = C:\JASPER~1\JASPER~1.0NO\APACHE~1\endorsed java.runtime.name = Java(TM) SE Runtime Environment file.encoding = Cp1252 java.vm.name = Java HotSpot(TM) 64-Bit Server VM js.license.directory = C:\JASPER~1\JASPER~1.0NO jasperserver-pro.root = C:\Jaspersoft\jasperreports-server-6.4.0Nov17\apache-tomcat\webapps\jasperserver-pro\ java.vendor.url.bug = http://bugreport.sun.com/bugreport/ java.io.tmpdir = C:\JASPER~1\JASPER~1.0NO\APACHE~1\temp tomcat.util.scan.StandardJarScanFilter.jarsToScan = log4j-web*.jar,log4j-taglib*.jar,log4javascript*.jar,slf4j-taglib*.jar catalina.home = C:\Jaspersoft\jasperreports-server-6.4.0Nov17\apache-tomcat java.version = 1.8.0_121 java.util.concurrent.ForkJoinPool.common.threadFactory = org.apache.catalina.startup.SafeForkJoinWorkerThreadFactory tomcat.util.scan.StandardJarScanFilter.jarsToSkip = bootstrap.jar,commons-daemon.jar,tomcat-juli.jar,annotations-api.jar,el-api.jar,jsp-api.jar,servlet-api.jar,websocket-api.jar,catalina.jar,catalina-ant.jar,catalina-ha.jar,catalina-storeconfig.jar,catalina-tribes.jar,jasper.jar,jasper-el.jar,ecj-*.jar,tomcat-api.jar,tomcat-util.jar,tomcat-util-scan.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-jni.jar,tomcat-websocket.jar,tomcat-i18n-en.jar,tomcat-i18n-es.jar,tomcat-i18n-fr.jar,tomcat-i18n-ja.jar,tomcat-juli-adapters.jar,catalina-jmx-remote.jar,catalina-ws.jar,tomcat-jdbc.jar,tools.jar,commons-beanutils*.jar,commons-codec*.jar,commons-collections*.jar,commons-dbcp*.jar,commons-digester*.jar,commons-fileupload*.jar,commons-httpclient*.jar,commons-io*.jar,commons-lang*.jar,commons-logging*.jar,commons-math*.jar,commons-pool*.jar,jstl.jar,taglibs-standard-spec-*.jar,geronimo-spec-jaxrpc*.jar,wsdl4j*.jar,ant.jar,ant-junit*.jar,aspectj*.jar,jmx.jar,h2*.jar,hibernate*.jar,httpclient*.jar,jmx-tools.jar,jta*.jar,log4j*.jar,mail*.jar,slf4j*.jar,xercesImpl.jar,xmlParserAPIs.jar,xml-apis.jar,junit.jar,junit-*.jar,ant-launcher.jar,cobertura-*.jar,asm-*.jar,dom4j-*.jar,icu4j-*.jar,jaxen-*.jar,jdom-*.jar,jetty-*.jar,oro-*.jar,servlet-api-*.jar,tagsoup-*.jar,xmlParserAPIs-*.jar,xom-*.jar user.dir = C:\Jaspersoft\jasperreports-server-6.4.0Nov17 os.arch = amd64 java.vm.specification.name = Java Virtual Machine Specification java.awt.printerjob = sun.awt.windows.WPrinterJob sun.os.patch.level = catalina.base = C:\Jaspersoft\jasperreports-server-6.4.0Nov17\apache-tomcat shared.loader = java.util.logging.manager = org.apache.juli.ClassLoaderLogManager net.sf.ehcache.disabled = false java.library.path = C:\Jaspersoft\jasperreports-server-6.4.0Nov17\apache-tomcat\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\TOOLS\phantomjs-2.1.1-windows\phantomjs-2.1.1-windows\bin\phantomjs.exe;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\windows\system32;c:\windows;C:\Program Files (x86)\Skype\Phone\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\WINDOWS\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps;. java.vendor = Oracle Corporation java.vm.info = mixed mode java.vm.version = 25.121-b13 sun.io.unicode.encoding = UnicodeLittle java.ext.dirs = C:\JASPER~1\JASPER~1.0NO\java\lib\ext;C:\WINDOWS\Sun\Java\lib\ext tomcat.util.buf.StringCache.byte.enabled = true java.class.version = 52.0RtBootClassPathC:JASPER~1JASPER~1.0NOjavalibresources.jar;C:JASPER~1JASPER~1.0NOjavalibrt.jar;C:JASPER~1JASPER~1.0NOjavalibsunrsasign.jar;C:JASPER~1JASPER~1.0NOjavalibjsse.jar;C:JASPER~1JASPER~1.0NOjavalibjce.jar;C:JASPER~1JASPER~1.0NOjavalibcharsets.jar;C:JASPER~1JASPER~1.0NOjavalibjfr.jar;C:JASPER~1JASPER~1.0NOjavaclassesRtClassPathC:Jaspersoftjasperreports-server-6.4.0Nov17apache-tomcatbinbootstrap.jar;C:Jaspersoftjasperreports-server-6.4.0Nov17apache-tomcatbintomcat-juli.jarRtInputArguments[-Dcatalina.home=C:JASPER~1JASPER~1.0NOAPACHE~1, -Dcatalina.base=C:JASPER~1JASPER~1.0NOAPACHE~1, -Djava.endorsed.dirs=C:JASPER~1JASPER~1.0NOAPACHE~1endorsed, -Djava.io.tmpdir=C:JASPER~1JASPER~1.0NOAPACHE~1temp, -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager, -Djava.util.logging.config.file=C:Jaspersoftjasperreports-server-6.4.0Nov17apache-tomcatconflogging.properties, -Djs.license.directory=C:JASPER~1JASPER~1.0NO, exit, -Xms1024m, -Xmx2048m, -Xss2k]RtLibraryPathC:Jaspersoftjasperreports-server-6.4.0Nov17apache-tomcatbin;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:TOOLSphantomjs-2.1.1-windowsphantomjs-2.1.1-windowsbinphantomjs.exe;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:WINDOWSSystem32WindowsPowerShellv1.0;c:windowssystem32;c:windows;C:Program Files (x86)SkypePhone;C:Program FilesIntelWiFibin;C:Program FilesCommon FilesIntelWirelessCommon;C:WINDOWSsystem32configsystemprofileAppDataLocalMicrosoftWindowsApps;.RtUpTime22924828RtVmNameJava HotSpot(TM) 64-Bit Server VMRtVmVendorOracle CorporationRtVmVersion25.121-b13TotalMemory1704460288

I do not have access to the operating system TIBCO JasperReports® Server is running on. Is there a way to find out what Java version JasperReports Server is running on? Yes, log in as superuser, run the diagnostic report in /public/diagnostic and look for, ExternalInfo->Environment. Along with many environment variables, for example, you can find JAVA_HOME showing the path if it is defined. LOCALAPPDATA = C:\\WINDOWS\\system32\\config\\systemprofile\\AppData\\Local PROCESSOR_LEVEL = 6 USERDOMAIN = WORKGROUP JAVA_HOME = C:\\Program Files\\Java\\jdk1.8.0_131 ALLUSERSPROFILE = C:\\ProgramData PROCESSOR_ARCHITECTURE = AMD64 PSModulePath = C:\\Program Files\\WindowsPowerShell\\Modules;C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\Modules SystemDrive = C: asl.log = Destination=file APPDATA = C:\\WINDOWS\\system32\\config\\systemprofile\\AppData\\Roaming USERNAME = USER$ ProgramFiles(x86) = C:\\Program Files (x86) CommonProgramFiles = C:\\Program Files\\Common Files Path = C:\\TOOLS\\phantomjs-2.1.1-windows\\phantomjs-2.1.1-windows\\bin\\phantomjs.exe;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\System32\\WindowsPowerShell\\v1.0\\;c:\\windows\\system32;c:\\windows;C:\\Program Files (x86)\\Skype\\Phone\\;C:\\Program Files\\Intel\\WiFi\\bin\\;C:\\Program Files\\Common Files\\Intel\\WirelessCommon\\;C:\\WINDOWS\\system32\\config\\systemprofile\\AppData\\Local\\Microsoft\\WindowsApps PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC OS = Windows_NT COMPUTERNAME = MAIN PROCESSOR_REVISION = 9e09 CommonProgramW6432 = C:\\Program Files\\Common Files ComSpec = C:\\WINDOWS\\system32\\cmd.exe ProgramData = C:\\ProgramData ProgramW6432 = C:\\Program Files SystemRoot = C:\\WINDOWS TEMP = C:\\WINDOWS\\TEMP PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 158 Stepping 9, GenuineIntel USERPROFILE = C:\\WINDOWS\\system32\\config\\systemprofile TMP = C:\\WINDOWS\\TEMP CommonProgramFiles(x86) = C:\\Program Files (x86)\\Common Files ProgramFiles = C:\\Program Files PUBLIC = C:\\Users\\Public NUMBER_OF_PROCESSORS = 4 windir = C:\\WINDOWS

QUESTION:TIBCO JasperReports® Server uses Hibernate and EhCache to access the repository. I do not have access to the server operating system. Is there a simple way to do a quick check on whether Hibernate and EhCache is running normally? ANSWER:Yes, log in as superuser, run the diagnostic report in /public/diagnostic and look for the following. As shown in the example, cache hit percentage is very high, so it is probably working normally. One specific thing that you might want to check is OptimisticFailureCount. If the number is positive, a number of StaleObjectStateExceptions has occurred. Try this solution:In WEB-INF/js.quartz.base.properties file, set the following to "true" org.quartz.jobStore.txIsolationLevelSerializable org.quartz.jobStore.acquireTriggersWithinLock HibernateStaticsCloseStatementCount113396 CollectionFetchCount16876 CollectionLoadCount16876 CollectionRecreateCount114 CollectionRemoveCount137 CollectionRoleNamescom.jaspersoft.commons.semantic.datasource.impl.hibernate.RepoSemanticLayerDataSource.bundles com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoCustomDataSource.resources com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.RepoReportUnit.inputControls com.jaspersoft.ji.adhoc.hibernate.RepoAdhocDataView.inputControls com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser.thumbnails com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJob.source.parametersMap com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.accessEvents com.jaspersoft.commons.semantic.datasource.impl.hibernate.RepoSemanticLayerDataSource.dataSources com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoListOfValues.values com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoTenant.subTenants com.jaspersoft.ji.report.options.metadata.hibernate.RepoReportOptions.inputValues com.jaspersoft.jasperserver.api.metadata.data.snapshot.hibernate.PersistentDataSnapshot.dataParameters com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole.users com.jaspersoft.ji.adhoc.hibernate.RepoDashboardModelResource.resources com.jaspersoft.ji.adhoc.hibernate.RepoAdhocDataView.reports com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobAlert.toAddresses com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobMailNotification.recipients com.jaspersoft.ji.adhoc.hibernate.RepoDashboardState.frameProperties com.jaspersoft.ji.logging.audit.domain.hibernate.RepoAuditEvent.auditEventProperties com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFolder.children com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.thumbnails com.jaspersoft.ji.adhoc.hibernate.RepoDashboardResource.resources com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.RepoReportUnit.resources com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem.referrers com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoVirtualDataSource.dataSourceUriMap com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJob.outputFormats com.jaspersoft.ji.adhoc.hibernate.RepoAdhocState.propertyMap com.jaspersoft.ji.logging.audit.domain.hibernate.RepoAuditEventArchive.auditEventProperties com.jaspersoft.ji.adhoc.hibernate.RepoAdhocDataView.resources com.jaspersoft.ji.ja.security.domain.RepoSecureMondrianConnection.accessGrants com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.queryVisibleColumns com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser.roles com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobRepositoryDestination.outputFTPInfo.propertiesMap com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoTenant.roles com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoTenant.users com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFolder.subFolders com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoCustomDataSource.propertyMap CollectionUpdateCount11 ConnectCount31481 EntityDeleteCount50 EntityFetchCount2414 EntityInsertCount7242 EntityLoadCount90726 EntityNamescom.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoProfileAttribute com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobTrigger com.jaspersoft.jasperserver.api.common.domain.impl.RepoLogEvent com.jaspersoft.ji.ja.security.domain.RepoSecureMondrianXMLADefinition com.jaspersoft.ji.adhoc.hibernate.RepoDashboardResource com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoTenant com.jaspersoft.ji.adhoc.hibernate.RepoDashboardState com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResourceItemBase com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobSimpleTrigger com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResourceFolderItem com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResourceLight com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobCalendarTrigger com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoBeanDataSource com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJob com.jaspersoft.jasperserver.api.metadata.data.snapshot.hibernate.PersistentDataSnapshot com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobRepositoryDestination com.jaspersoft.ji.logging.audit.domain.hibernate.RepoReportMonitoringFact com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoListOfValues com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource com.jaspersoft.jasperserver.api.metadata.data.snapshot.hibernate.PersistentDataSnapshotContents com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.util.BasicPersistentFileResource com.jaspersoft.jasperserver.api.metadata.olap.domain.impl.hibernate.RepoOlapClientConnection com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResourceItem com.jaspersoft.ji.ja.security.domain.RepoSecureMondrianConnection com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl com.jaspersoft.ji.adhoc.hibernate.RepoDashboardModelResource com.jaspersoft.ji.adhoc.hibernate.RepoAdhocReportUnit com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.RepoReportUnit com.jaspersoft.commons.semantic.datasource.impl.hibernate.RepoSemanticLayerDataSource com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoVirtualDataSource com.jaspersoft.ji.logging.audit.domain.hibernate.RepoAuditEvent com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoCustomDataSource com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobMailNotification com.jaspersoft.ji.logging.audit.domain.hibernate.RepoAuditEventArchive com.jaspersoft.jasperserver.api.metadata.olap.domain.impl.hibernate.RepoXMLAConnection com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoAwsDataSource com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser com.jaspersoft.ji.report.options.metadata.hibernate.RepoReportOptions com.jaspersoft.jasperserver.api.metadata.olap.domain.impl.hibernate.RepoOlapUnit com.jaspersoft.ji.adhoc.hibernate.RepoAdhocDataView com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobAlert com.jaspersoft.ji.adhoc.hibernate.RepoAdhocState com.jaspersoft.ji.logging.audit.domain.hibernate.RepoAuditEventPropertyArchive com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoQuery com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFolder com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJndiJdbcDataSource com.jaspersoft.commons.semantic.impl.hibernate.RepoDataDefinerUnit com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJdbcDataSource com.jaspersoft.ji.logging.audit.domain.hibernate.RepoAuditEventProperty com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoReportThumbnail com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoAzureSqlDataSource com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoObjectPermission EntityUpdateCount63 FlushCount27459 OptimisticFailureCount0 PrepareStatementCount113323 Queriesfrom com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoObjectPermission as objPermission where objPermission.URI = ? from RepoProfileAttribute as panwheren(pa.principal.class = :tenantClass and pa.principal.id inn(select tenants.id from RepoTenant as tenants where tenants.id in (:parentIds))nornpa.principal.class = :curClass and pa.principal.id = :curId)n where hidden = false from RepoProfileAttribute as panwheren(pa.principal.class = :curClass and pa.principal.id = :curId)n n selectn rr.id from RepoResource rrn wheren rr in (select ru from RepoReportUnit ru where ru.dataSource=:dependency and ru.parent.URI!=:dependencySubFolderURI)n orn rr in (select slds from RepoSemanticLayerDataSource slds where :dependency in elements(slds.dataSources))n orn rr in (select av from RepoAdhocDataView av where av.dataSource=:dependency)n orn rr in (select dm from RepoDashboardModelResource dm where :dependency in elements(dm.resources))ntttorn rr in (select av from RepoAdhocDataView av where av.dataSource in (select ddu from RepoDataDefinerUnit ddu where ddu.dataSource=:dependency))tttnn order byn rr.parent.URI ASC, rr.name ASCn from com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoObjectPermission as objPermission where objPermission.URI = ? and objPermission.permissionRecipient.id = ? and objPermission.permissionRecipient.class = ? QueryCacheHitCount17577 QueryCacheMissCount9185 QueryCachePutCount9165 QueryExecutionCount76112 QueryExecutionMaxTime631 QueryExecutionMaxTimeQueryString SecondLevelCacheHitCount40111 SecondLevelCacheMissCount510 SecondLevelCachePutCount15746 SecondLevelCacheRegionNamesdefaultRepoCache org.hibernate.cache.StandardQueryCache org.hibernate.cache.UpdateTimestampsCache SessionCloseCount32336 SessionOpenCount32336 StartTime1511402457095 StatisticsEnabledtrue SuccessfulTransactionCount30259 TransactionCount61738EhCacheCacheHitPercentage0.9803287028175967 CacheHits389265 CacheMissPercentage0.019671297182403367 CacheMisses7811 Conf.DiskExpiryThreadIntervalSeconds120 Conf.DiskSpoolBufferSizeMB30 Conf.LoggingEnabledfalse Conf.MaxBytesLocalDisk0 Conf.MaxBytesLocalHeap0 Conf.MaxBytesLocalOffHeap0 Conf.MaxElementsInMemory10000 Conf.MaxElementsOnDisk10000000 Conf.MaxEntriesLocalDisk10000000 Conf.MaxEntriesLocalHeap10000 Conf.MemoryStoreEvictionPolicyLRU Conf.Statisticsfalse Conf.TimeToIdleSeconds120 Conf.TimeToLiveSeconds120 DiskPersistentfalse DiskStoreObjectCount88 Eternalfalse InMemoryHitPercentage0.9844492101948843 InMemoryHits389265 InMemoryMisses6149 MemoryStoreObjectCount2467 ObjectCount2467 OffHeapHitPercentage0.0 OffHeapHits0 OffHeapMisses0 OffHeapStoreObjectCount0 OnDiskHitPercentage0.0 OnDiskHits0 OnDiskMisses6149 OverflowToDisktrue OverflowToOffHeapfalse StatisticsAccuracy1 StatisticsAccuracyDescriptionBest Effort WriteMaxQueueSize0 WriteQueueLength0

I do not have access to the server operating system. Is there a simple way to find out how much memory TIBCO JasperReports® Server is using? Yes, log in as superuser, run the diagnostic report in /public/diagnostic and look for the following in ExternalInfo, Xmx Setting: [search for Xmx] RtInputArguments[-Dcatalina.home=C:JASPER~1JASPER~1.0NOAPACHE~1, -Dcatalina.base=C:JASPER~1JASPER~1.0NOAPACHE~1, -Djava.endorsed.dirs=C:JASPER~1JASPER~1.0NOAPACHE~1endorsed, -Djava.io.tmpdir=C:JASPER~1JASPER~1.0NOAPACHE~1temp, -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager, -Djava.util.logging.config.file=C:Jaspersoftjasperreports-server-6.4.0Nov17apache-tomcatconflogging.properties, -Djs.license.directory=C:JASPER~1JASPER~1.0NO, exit, -Xms1024m, -Xmx2048m, -Xss2k]Memory Usage FreeMemory920955856JvmHeapMemoryinit = 1073741824(1048576K) used = 783504432(765141K) committed = 1704460288(1664512K) max = 1908932608(1864192K)JvmNonHeapMemoryinit = 2555904(2496K) used = 340395608(332417K) committed = 366030848(357452K) max = -1(-1K)MaxMemory1908932608

I do not have access to the server operating system. Is there a way to find out whether the system is running out of disc space? Yes, log in as superuser, run the diagnostic report in /public/diagnostic and look for, ExternalInfo, DisksFreeSpace = 310120865792

Log in as superuser, you can run the diagnostic report in /public/diagnostic and obtain the following. The information may be useful for performance troubleshooting. RepositoryTotalAdhocViewsCount841 TotalDashboardsCount51 TotalDataSourcesCount50 TotalDomainsCount271 TotalFoldersCount2998 TotalOlapViewsCount4 TotalOrganizationsCount69 TotalReportOutputsCount2940 TotalReportsCount523

Is there a simple way to find out what users are logged into the TIBCO JasperReports® Server currently? ANSWER:Yes, log in as superuser, you can run the diagnostic report in /public/diagnostic and obtain the following recorded information. LoggedInUsersList will show a list of users currently logged in the JasperReports Server. UsersLoggedInUsersCount1 LoggedInUsersListsuperuser = 1 TotalEnabledUsersCount855 TotalRolesCount143 TotalUsersCount855ReportsRunningAsyncReportsActiveTaskCount1 RunningAsyncReportsCountCuml30 RunningAsyncReportsPoolSize1 RunningReportsCount1 RunningReportsCountCuml592 RunningReportsErrorsCuml176 RunningReportsList/public/diagnostic/JSDiagnosticReport=0 RunningSyncReportsCountCuml562SchedulerRunningJobsCount0 RunningJobsList ScheduledJobsCount85

My version of TIBCO JasperReports® Server does not have the usual About JasperReports Server link on the lower left hand corner of any of it's pages. Is there a simple way to find out the license details? ANSWER:Yes, you can run the diagnostic report in the repository under the folder /public/diagnostic. Look for the About section. You will find the following items recorded in the diagnostic report. BuildIsLicenseValidLicenseAboutToExpireLicenseCoresCountLicenseCpusCountLicenseEnvironmentTypeLicenseExpirationDateLicenseTypeLicenseUserCountExceededLicenseUsersCountProductEditionNameProductTypeNameReportRunsAtLimitDaysCountReportRunsAvailableCountReportRunsAvailableDateReportRunsByDayListReportRunsLimitCountReportRunsTodayCountReportRunsTotalCountSourceEditionSupportedFeaturesVersion

Issue:TIBCO JasperReports® Server schedule job fails intermittently when set to copying the csv file of a report to FTP server every 4 hrs daily. It is failing intermittently with error : [toc]ERROR ReportExecutionJob,quartzScheduler_Worker-4:317 - report.scheduling.error.upload.to.ftp.server com.jaspersoft.jasperserver.api.JSException: Fail to upload file reportABC_schedule-201611101130.csv You can see the error in jasperserver.log. These errors occurred 10 times in 3 weeks. Jasperserver.log Trace:2016-11-10 11:29:32,375 ERROR HandlerExecutionChain,http-apr-8081-exec-12:170 - HandlerInterceptor.afterCompletion threw exception java.lang.IllegalStateException: Cannot call sendError() after the response has been committed at org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:450) at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:119) at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:119) at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:119) at org.springframework.security.web.context.SaveContextOnUpdateOrErrorResponseWrapper.sendError(SaveContextOnUpdateOrErrorResponseWrapper.java:97) at com.jaspersoft.jasperserver.war.control.interceptor.RenderViewExceptionInterceptor.afterCompletion(RenderViewExceptionInterceptor.java:59) at org.springframework.web.servlet.HandlerExecutionChain.triggerAfterCompletion(HandlerExecutionChain.java:167) at org.springframework.web.servlet.DispatcherServlet.triggerAfterCompletion(DispatcherServlet.java:1252) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:936) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:163) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:157) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:99) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:194) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:103) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:86) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:614) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2476) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2465) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) 2016-11-10 11:30:25,377 ERROR ReportExecutionJob,quartzScheduler_Worker-4:317 - report.scheduling.error.upload.to.ftp.server com.jaspersoft.jasperserver.api.JSException: Fail to upload file reportABC_schedule-201611101130.csv at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil.putFile(FTPUtil.java:209) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil.access$400(FTPUtil.java:36) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil$FTPSServiceClientImpl.putFile(FTPUtil.java:115) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.saveToFTPServer(ReportExecutionJobFileSavingImpl.java:207) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.save(ReportExecutionJobFileSavingImpl.java:91) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:528) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:224) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:49) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) 2016-11-10 12:35:51,777 ERROR errorPage_jsp,http-apr-8081-exec-18:294 - JSException: 2016-11-10 12:35:51,780 ERROR errorPage_jsp,http-apr-8081-exec-18:580 - stack trace of exception that redirected to errorPage.jsp com.jaspersoft.jasperserver.api.engine.jasperreports.common.JSReportExecutionRequestCancelledException: Report has been cancelled at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportCancelled(EngineServiceImpl.java:1250) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyCancel(BaseFillHandle.java:201) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:131) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:882) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:838) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1727) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1082) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1011) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:904) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
 Resolution:At least for this instance this is not a TIBCO JasperReports® Server issue. The proxy server is dropping connections intermittently. Check this possibility first by removing the proxy server to see if the problem still occurs. Ref. Case #1439186

Issue:TIBCO Japsersoft® Studio v6.3.0 Hangs in Linux. Resolution:Unfortunately the Linux environment is not playing nice with Eclipse in general and one of the main issues is also the huge number of Linux flavours available. Even from version to version (i.e Ubuntu) there could be a library version (i.e SWT_GTK) that could lead to having Jaspersoft Studio not working correctly. Problem like glitches or freezse are caused by the SWT_GTK library installed on the Linux version. I would suggest to give it a try to export the variable SWT_GTK3=0. See this link for an example: http://community.jaspersoft.com/jaspersoft-studio/issues/7626 (comment #6) You can directly modify the runubuntu script on the installation folder.

Issue:We are using TIBCO JasperReports® Library to generate PDF reports. Currently, we are using the curly apostrophe, ’, in the text to indicate possession. When a word that contains this character will not fit at the end of the line, JasperReports moves the "’s" to the next line. In essence, JR is treating the curly apostrophe as a space when it decides how to wrap lines. For example, If you have a line that says, aaaaaaaaaaaaaaa Mary's lamb. It is truncated/wrapped to aaaaaaaaaaaaaaa Mary's lamb. Resolution:This is a problem with the TIBCO Jaspersoft® Studio previewer only. It should work when you export to PDF. Ref. Case #1443007

Issue:Change the TIBCO Jaspersoft logo in log in page [upper left hand corner] but somehow, even though the image is resized multiple times, it still showing a cut off image. Resolution:Try resizing the image itself to 368 x 42. Ref. Case #1442379

Issue:You may encounter this message in TIBCO JasperReports® Server when using Ad Hoc. You do not have permission to write to the folder "/temp". Choose another folder or contact your system administrator. Resolution:Check permissions. If all correct, it is possible that you might have deleted the original Temp directory and recreated another one yourself. If you did, you must use Temp as name and the resource ID must be temp. All case sensitive. Perhaps you might have used the incorrect case. Ref. Case #1441310

Issue:Following upgrade to TIBCO JasperReports® Server v6.3, you may experience a new behavior with External Authentication. When you execute the REST login, you may get status code of 302 instead of 200. [toc]Fri Dec 02 15:51:51 EST 2016:DEBUG:Attempt 1 to execute request Fri Dec 02 15:51:51 EST 2016:DEBUG:Sending request: POST /jasperserver-pro/rest/login?j_username=abcuser&j_password=1234 HTTP/1.1 Fri Dec 02 15:51:51 EST 2016:DEBUG:Receiving response: HTTP/1.1 302 Fri Dec 02 15:51:51 EST 2016:DEBUG:Connection can be kept alive indefinitely Fri Dec 02 15:51:51 EST 2016:DEBUG:Stale connection check Fri Dec 02 15:51:51 EST 2016:DEBUG:Attempt 1 to execute request Fri Dec 02 15:51:51 EST 2016:DEBUG:Sending request: GET /jasperserver-pro/loginsuccess.html;jsessionid=1B485C48A0BFE2F6571E79B67BE92787 HTTP/1.1 Fri Dec 02 15:51:51 EST 2016:DEBUG:Receiving response: HTTP/1.1 302 Fri Dec 02 15:51:51 EST 2016:DEBUG:Connection can be kept alive indefinitely Fri Dec 02 15:51:51 EST 2016:DEBUG:Redirecting to 'http://rptint:8080/jasperserver-pro/flow.html?_flowId=searchFlow&mode=search&filterId=resourceTypeFilter&filterOption=resourceTypeFilter-reports&searchText=' via HttpRoute[{}->http://rptint:8080] Fri Dec 02 15:51:51 EST 2016:DEBUG:Attempt 2 to execute request Fri Dec 02 15:51:51 EST 2016:DEBUG:Sending request: GET /jasperserver-pro/flow.html?_flowId=searchFlow&mode=search&filterId=resourceTypeFilter&filterOption=resourceTypeFilter-reports&searchText= HTTP/1.1 Fri Dec 02 15:51:51 EST 2016:DEBUG:Receiving response: HTTP/1.1 200 Fri Dec 02 15:51:51 EST 2016:DEBUG:Connection can be kept alive indefinitely Fri Dec 02 15:51:51 EST 2016:INFO:Got response for [http://rpttest:8080.Login:Request 1] in 353ms (105152 bytes) RPTTEST (6.0) Fri Dec 02 15:49:42 EST 2016:DEBUG:Stale connection check Fri Dec 02 15:49:42 EST 2016:DEBUG:Attempt 1 to execute request Fri Dec 02 15:49:42 EST 2016:DEBUG:Sending request: POST /jasperserver-pro/rest/login?j_username=rez1restuser&j_password=r35ut53r1z3r HTTP/1.1 Fri Dec 02 15:49:42 EST 2016:DEBUG:Receiving response: HTTP/1.1 200 OK Fri Dec 02 15:49:42 EST 2016:DEBUG:Connection can be kept alive indefinitely Fri Dec 02 15:49:42 EST 2016:INFO:Got response for [http://rpttest:8080.Login:Request 1] in 26ms (0 bytes)Resolution:This is a result of Spring 3 upgrade. When you log in, you do not get a 200 back directly. You get a 302 redirect always as the first response. When you get the 302 back, you can check the Location request header to see where it will redirect to and if that url is an internal url (other than login.html?error=1) then you have successfully logged in. If the Location request header is to login.html?error=1 you have a failure. Spring 3 uses authsuccess and authfailurehandler beans, that is where these redirects are happening. Ref. Case #1438833