JX00672958

Hi Team, Recently , we have upgraded to Jaspersoft 8. After upgradation, we have observed that one report which uses Abstract template is not working. We have used Abstract template for getting TOC(Table Of Contents) Information. Report is working fine within the jaspersoft server and not running when scheculed Could you please help on this. Obtained the below error msg: wijava.lang.NullPointerException at java.base/java.lang.reflect.Proxy.getInvocationHandler(Proxy.java:1102) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:65) at com.sun.proxy.$Proxy242.equals(Unknown Source) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getTimezoneAdjustFromParent(JRTimezoneJdbcQueryExecuter.java:133) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter. <init>(JRTimezoneJdbcQueryExecuter.java:105) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter. <init>(JSControlledJdbcQueryExecuter.java:67) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuterFactory.createQueryExecuter(JSControlledJdbcQueryExecuterFactory.java:25) at net.sf.jasperreports.engine.query.QueryExecuterFactory.createQueryExecuter(QueryExecuterFactory.java:109) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1254) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:584) at net.sf.jasperreports.parts.subreport.SubreportFillPart.fill(SubreportFillPart.java:237) at net.sf.jasperreports.engine.part.FillPart.fill(FillPart.java:77) at net.sf.jasperreports.engine.fill.PartReportFiller.fillPart(PartReportFiller.java:417) at net.sf.jasperreports.engine.fill.PartReportFiller.fillParts(PartReportFiller.java:402) at net.sf.jasperreports.engine.fill.PartReportFiller.fillFirstGroupHeaders(PartReportFiller.java:361) at net.sf.jasperreports.engine.fill.PartReportFiller.fillReport(PartReportFiller.java:289) at net.sf.jasperreports.engine.fill.PartReportFiller.fill(PartReportFiller.java:225) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:959) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:910) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1857) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1162) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1103) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:981) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Regards, Sathyaseelane

Hello Team, We have requirement to create adhoc view in CA PPM for allocation cost,FTE,Default allocation %, Hard allocated hours and soft allocated hours in monthly basis. In measures, we can see only weekly measures like weekly allocation hours, team weekly hard allocation hours etc but there is no measures to calculate in monthly basis but can able to see 'month' in domain fields. Could you please help to find which measures will measures will help in get allocation cost, FTE in monthly basis. Regards, Sathyaseelane