You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by za...@intrasofttechnologies.com on 2021/04/27 20:26:36 UTC
Pentaho Reports Not Opening
Devs,
Kindly assist us fix this, we upgraded one of our servers to 18.03.01
(Fineract 1.4.0).
When I generate a Pentaho report, I get below errors from Catalina log:
23:09:24.861 [http-bio-443-exec-3] DEBUG o.a.f.i.d.s.GenericDataServiceImpl
- ::3 Was inside the fill ResultSetColumnHeader
23:09:24.892 [http-bio-443-exec-3] DEBUG o.a.f.i.d.s.GenericDataServiceImpl
- ::3 Was inside the fill ResultSetColumnHeader
23:09:24.991 [http-bio-443-exec-1] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - STARTING REPORT: ClientSummary
Type: report
23:09:24.997 [http-bio-443-exec-1] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - FINISHING Report/Request Name:
ClientSummary - report Elapsed Time: 6
23:09:27.121 [http-bio-443-exec-5] INFO
o.a.f.i.d.s.ReadWriteNonCoreDataServiceImpl - data scoped sql: select o.id
as officeId, null as groupId, c.id as clientId, null as savingsId, null as
loanId, null as entityId from m_client c join m_office o on o.id =
c.office_id and o.hierarchy like '.%' where c.id = 97
23:09:27.124 [http-bio-443-exec-5] DEBUG o.a.f.i.d.s.GenericDataServiceImpl
- ::3 Was inside the fill ResultSetColumnHeader
23:09:33.741 [http-bio-443-exec-5] INFO
o.a.f.i.d.s.ReadWriteNonCoreDataServiceImpl - data scoped sql: select o.id
as officeId, null as groupId, c.id as clientId, null as savingsId, null as
loanId, null as entityId from m_client c join m_office o on o.id =
c.office_id and o.hierarchy like '.%' where c.id = 97
23:09:33.744 [http-bio-443-exec-5] DEBUG o.a.f.i.d.s.GenericDataServiceImpl
- ::3 Was inside the fill ResultSetColumnHeader
23:09:49.096 [http-bio-443-exec-3] DEBUG o.a.f.i.d.s.GenericDataServiceImpl
- ::3 Was inside the fill ResultSetColumnHeader
23:09:49.117 [http-bio-443-exec-3] DEBUG o.a.f.i.d.s.GenericDataServiceImpl
- ::3 Was inside the fill ResultSetColumnHeader
23:09:49.489 [http-bio-443-exec-10] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - STARTING REPORT: ClientSummary
Type: report
23:09:49.494 [http-bio-443-exec-10] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - FINISHING Report/Request Name:
ClientSummary - report Elapsed Time: 5
23:10:00.121 [http-bio-443-exec-5] INFO
o.a.f.i.d.s.ReadWriteNonCoreDataServiceImpl - data scoped sql: select o.id
as officeId, null as groupId, c.id as clientId, null as savingsId, null as
loanId, null as entityId from m_client c join m_office o on o.id =
c.office_id and o.hierarchy like '.%' where c.id = 148
23:10:00.122 [http-bio-443-exec-5] DEBUG o.a.f.i.d.s.GenericDataServiceImpl
- ::3 Was inside the fill ResultSetColumnHeader
Apr 27, 2021 11:10:01 PM
org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport reportSlowQuery
WARNING: Slow Query Report SQL=SELECT MAX(t0.version) FROM job_run_history
t0 INNER JOIN job t1 ON t0.job_id = t1.id WHERE (t1.job_key = ?); time=1064
ms;
23:10:04.957 [http-bio-443-exec-5] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - STARTING REPORT: FullReportList
Type: parameter
23:10:04.986 [http-bio-443-exec-5] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - FINISHING Report/Request Name:
FullReportList - parameter Elapsed Time: 29
23:10:08.198 [http-bio-443-exec-5] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - STARTING REPORT: FullParameterList
Type: parameter
23:10:08.202 [http-bio-443-exec-5] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - FINISHING Report/Request Name:
FullParameterList - parameter Elapsed Time: 4
23:10:14.037 [http-bio-443-exec-5] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl - Report path:
/root/.mifosx/pentahoReports/Active Loan Summary per Branch.prpt
23:10:14.614 [http-bio-443-exec-5] INFO o.p.r.l.base.util.ObjectUtilities -
Specified class
org.pentaho.reporting.engine.classic.extensions.modules.sbarcodes.xml.Simple
BarcodesElementReadHandler failed to instantiate correctly.
23:10:14.670 [http-bio-443-exec-5] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl - db
URL:jdbc:mysql:thin://localhost:3306/tenant userhierarchy:.
23:10:14.670 [http-bio-443-exec-5] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl - db
URL:jdbc:mysql:thin://localhost:3306/tenant userid:1
23:10:15.008 [http-bio-443-exec-5] INFO o.p.r.l.base.util.ObjectUtilities -
Specified class
org.pentaho.reporting.engine.classic.core.cache.EhCacheDataCache failed to
instantiate correctly.
23:10:15.008 [http-bio-443-exec-5] INFO o.p.r.e.c.c.cache.DataCacheFactory
- Unable to create valid cache, returning <null>
23:10:15.425 [http-bio-443-exec-5] ERROR
o.p.r.e.c.c.l.o.AbstractReportProcessor - 1423489391: Report processing
failed.
An interesting observation is all Accounting Reports can open but not other
Pentaho reports.
Kindly advise how we can fix this issue.
Java version:
openjdk version "1.8.0_282"
MySQL version: mysql Ver 14.14 Distrib 5.6.16
Thanks & Regards;
*******
Zayyad A. Said | Chairman & C.E.O
Cell No.: +254 716 615274 | Skype: zsaid2011
Email: <ma...@intrasofttechnologies.com>
zayyad@intrasofttechnologies.com
Schedule Meetings: <https://calendly.com/zayyadsaid>
https://calendly.com/zayyadsaid