Hi,
I compiled the right cloned fineract and some reports work fine while still
there are issues with other reports.
The reports are behaving so weird. I tried an instance with Fineract and
the same report with Mifos X. The one with Fineract failed while the one
with Mifos X ran. Please revive the logs captured for both as below:
*WITH FINERACT*
*22:34:28.396 [http-bio-8443-exec-2] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984068310,"totalTime":86,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/reportCategoryList","parameters":{"parameterType":["true"],"genericResultSet":["false"],"R_reportCategory":["Loan"]}}22:34:42.255
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: FullParameterList Type: parameter22:34:42.285
[http-bio-8443-exec-4] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984082238,"totalTime":46,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/reports/141","parameters":{"fields":["reportParameters"]}}22:34:42.348
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: FullParameterList - parameter Elapsed
Time: 9322:34:42.349 [http-bio-8443-exec-2] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984082238,"totalTime":111,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/FullParameterList","parameters":{"R_reportListing":["\u0027Portfolio
at Risk by Branch(Pentaho)\u0027"],"parameterType":["true"]}}22:34:42.386
[http-bio-8443-exec-10] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: loanPurposeIdSelectAll Type: parameter22:34:42.386
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: currencyIdSelectAll Type: parameter22:34:42.388
[http-bio-8443-exec-4] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: fundIdSelectAll Type: parameter22:34:42.412
[http-bio-8443-exec-7] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: parTypeSelect Type: parameter22:34:42.414
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: currencyIdSelectAll - parameter Elapsed
Time: 2822:34:42.425 [http-bio-8443-exec-2] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984082363,"totalTime":62,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/currencyIdSelectAll","parameters":{"parameterType":["true"]}}22:34:42.435
[http-bio-8443-exec-7] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: parTypeSelect - parameter Elapsed Time:
2322:34:42.435 [http-bio-8443-exec-4] INFO
o.a.f.i.d.s.ReadReportingServiceImpl - FINISHING Report/Request Name:
fundIdSelectAll - parameter Elapsed Time: 4722:34:42.437
[http-bio-8443-exec-7] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984082387,"totalTime":50,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/parTypeSelect","parameters":{"parameterType":["true"]}}22:34:42.437
[http-bio-8443-exec-10] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: loanPurposeIdSelectAll - parameter
Elapsed Time: 5122:34:42.441 [http-bio-8443-exec-4] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984082364,"totalTime":77,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/fundIdSelectAll","parameters":{"parameterType":["true"]}}22:34:42.449
[http-bio-8443-exec-10] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984082364,"totalTime":85,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/loanPurposeIdSelectAll","parameters":{"parameterType":["true"]}}22:34:42.454
[http-bio-8443-exec-9] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: OfficeIdSelectOne Type: parameter22:34:42.468
[http-bio-8443-exec-9] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: OfficeIdSelectOne - parameter Elapsed
Time: 1422:34:42.471 [http-bio-8443-exec-9] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984082428,"totalTime":43,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/OfficeIdSelectOne","parameters":{"parameterType":["true"]}}22:34:45.393
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: loanProductIdSelectAll Type: parameter22:34:45.404
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: loanProductIdSelectAll - parameter
Elapsed Time: 1122:34:45.406 [http-bio-8443-exec-2] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984085381,"totalTime":25,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/loanProductIdSelectAll","parameters":{"R_currencyId":["UGX"],"parameterType":["true"]}}22:35:01.360
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
STARTING REPORT: loanOfficerIdSelectAll Type: parameter22:35:01.450
[http-bio-8443-exec-2] INFO o.a.f.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: loanOfficerIdSelectAll - parameter
Elapsed Time: 9022:35:01.451 [http-bio-8443-exec-2] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984101344,"totalTime":107,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/loanOfficerIdSelectAll","parameters":{"R_officeId":["1"],"parameterType":["true"]}}22:35:14.261
[http-bio-8443-exec-2] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl -
Report path: C:\Users\Eng. Ippez Roberts\.mifosx\pentahoReports\Portfolio
at Risk by Branch(Pentaho).prpt22:35:28.372 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl - paramName:Branch22:35:28.373
[http-bio-8443-exec-2] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl -
addParametersToReport(Branch : 1 : java.lang.Long)22:35:28.373
[http-bio-8443-exec-2] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl -
paramName:parType22:35:28.374 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl -
addParametersToReport(parType : 4 : java.lang.Long)22:35:28.374
[http-bio-8443-exec-2] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl -
paramName:Loan Officer22:35:28.374 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl - addParametersToReport(Loan
Officer : -1 : java.lang.Long)22:35:28.375 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl -
paramName:CurrencyId22:35:28.375 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl -
addParametersToReport(CurrencyId : UGX : java.lang.String)22:35:28.376
[http-bio-8443-exec-2] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl -
paramName:fundId22:35:28.376 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl - addParametersToReport(fundId
: 1 : java.lang.Long)22:35:28.377 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl -
paramName:loanPurposeId22:35:28.377 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl -
addParametersToReport(loanPurposeId : -1 : java.lang.Long)22:35:28.377
[http-bio-8443-exec-2] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl -
paramName:loanProductId22:35:28.378 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl -
addParametersToReport(loanProductId : -1 : java.lang.Long)22:35:28.378
[http-bio-8443-exec-2] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl -
db URL:jdbc:mysql:thin://localhost:3306/mifostenant-default
userhierarchy:.22:35:28.379 [http-bio-8443-exec-2] INFO
o.m.i.r.s.PentahoReportingProcessServiceImpl - db
URL:jdbc:mysql:thin://localhost:3306/mifostenant-default
userid:122:35:28.437 [http-bio-8443-exec-2] ERROR
o.p.r.e.c.c.l.o.AbstractReportProcessor - 89823050: Report processing
failed.*
*WITH MIFOS X *
*22:35:28.441 [http-bio-8443-exec-2] INFO
o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984114243,"totalTime":14197,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/Portfolio%20at%20Risk%20by%20Branch(Pentaho)","parameters":{"R_loanPurposeId":["-1"],"dateFormat":["dd
MMMM yyyy"],"R_loanProductId":["-1"],"R_parType":["4"],"R_Loan
Officer":["-1"],"output-type":["HTML"],"R_Branch":["1"],"locale":["en"],"R_CurrencyId":["UGX"],"tenantIdentifier":["default"],"R_fundId":["1"]}}22:36:28.974
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: reportCategoryList Type: parameter22:36:28.999
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - FINISHING
Report/Request Name: reportCategoryList - parameter Elapsed Time:
2522:36:29.007 [http-bio-8443-exec-8] INFO
o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984188956,"totalTime":51,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/reportCategoryList","parameters":{"parameterType":["true"],"genericResultSet":["false"],"R_reportCategory":["Loan"]}}22:36:33.335
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: FullParameterList Type: parameter22:36:33.348
[http-bio-8443-exec-5] INFO o.m.i.s.f.TenantAwareBasicAuthenticationFilter
-
{"startTime":1457984193319,"totalTime":29,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/reports/141","parameters":{"fields":["reportParameters"]}}22:36:33.348
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - FINISHING
Report/Request Name: FullParameterList - parameter Elapsed Time:
1322:36:33.350 [http-bio-8443-exec-8] INFO
o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984193314,"totalTime":36,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/FullParameterList","parameters":{"R_reportListing":["\u0027Portfolio
at Risk by Branch(Pentaho)\u0027"],"parameterType":["true"]}}22:36:33.421
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: currencyIdSelectAll Type: parameter22:36:33.421
[http-bio-8443-exec-5] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: fundIdSelectAll Type: parameter22:36:33.429
[http-bio-8443-exec-7] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: loanPurposeIdSelectAll Type: parameter22:36:33.435
[http-bio-8443-exec-4] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: parTypeSelect Type: parameter22:36:33.443 [http-bio-8443-exec-8]
INFO o.m.i.d.s.ReadReportingServiceImpl - FINISHING Report/Request Name:
currencyIdSelectAll - parameter Elapsed Time: 2222:36:33.443
[http-bio-8443-exec-5] INFO o.m.i.d.s.ReadReportingServiceImpl - FINISHING
Report/Request Name: fundIdSelectAll - parameter Elapsed Time:
2222:36:33.444 [http-bio-8443-exec-7] INFO
o.m.i.d.s.ReadReportingServiceImpl - FINISHING Report/Request Name:
loanPurposeIdSelectAll - parameter Elapsed Time: 1522:36:33.445
[http-bio-8443-exec-8] INFO o.m.i.s.f.TenantAwareBasicAuthenticationFilter
-
{"startTime":1457984193401,"totalTime":44,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/currencyIdSelectAll","parameters":{"parameterType":["true"]}}22:36:33.446
[http-bio-8443-exec-5] INFO o.m.i.s.f.TenantAwareBasicAuthenticationFilter
-
{"startTime":1457984193402,"totalTime":44,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/fundIdSelectAll","parameters":{"parameterType":["true"]}}22:36:33.449
[http-bio-8443-exec-7] INFO o.m.i.s.f.TenantAwareBasicAuthenticationFilter
-
{"startTime":1457984193411,"totalTime":38,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/loanPurposeIdSelectAll","parameters":{"parameterType":["true"]}}22:36:33.456
[http-bio-8443-exec-4] INFO o.m.i.d.s.ReadReportingServiceImpl - FINISHING
Report/Request Name: parTypeSelect - parameter Elapsed Time:
2122:36:33.458 [http-bio-8443-exec-10] INFO
o.m.i.d.s.ReadReportingServiceImpl - STARTING REPORT: OfficeIdSelectOne
Type: parameter22:36:33.461 [http-bio-8443-exec-4] INFO
o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984193412,"totalTime":48,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/parTypeSelect","parameters":{"parameterType":["true"]}}22:36:33.470
[http-bio-8443-exec-10] INFO o.m.i.d.s.ReadReportingServiceImpl -
FINISHING Report/Request Name: OfficeIdSelectOne - parameter Elapsed
Time: 1222:36:33.471 [http-bio-8443-exec-10] INFO
o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984193438,"totalTime":33,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/OfficeIdSelectOne","parameters":{"parameterType":["true"]}}22:36:35.427
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: loanProductIdSelectAll Type: parameter22:36:35.493
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - FINISHING
Report/Request Name: loanProductIdSelectAll - parameter Elapsed Time:
6622:36:35.494 [http-bio-8443-exec-8] INFO
o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984195414,"totalTime":80,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/loanProductIdSelectAll","parameters":{"R_currencyId":["UGX"],"parameterType":["true"]}}22:36:46.522
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - STARTING
REPORT: loanOfficerIdSelectAll Type: parameter22:36:46.555
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - FINISHING
Report/Request Name: loanOfficerIdSelectAll - parameter Elapsed Time:
3322:36:46.555 [http-bio-8443-exec-8] INFO
o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984206507,"totalTime":48,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/loanOfficerIdSelectAll","parameters":{"R_officeId":["1"],"parameterType":["true"]}}22:36:56.772
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - Report
path: C:\Users\Eng. Ippez Roberts\.mifosx\pentahoReports\Portfolio at Risk
by Branch(Pentaho).prpt22:37:09.463 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - paramName:Branch22:37:09.463
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl -
addParametersToReport(Branch : 1 : java.lang.Long)22:37:09.464
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl -
paramName:parType22:37:09.464 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - addParametersToReport(parType : 4 :
java.lang.Long)22:37:09.465 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - paramName:Loan Officer22:37:09.465
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl -
addParametersToReport(Loan Officer : -1 : java.lang.Long)22:37:09.466
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl -
paramName:CurrencyId22:37:09.466 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - addParametersToReport(CurrencyId : UGX
: java.lang.String)22:37:09.467 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - paramName:fundId22:37:09.467
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl -
addParametersToReport(fundId : 1 : java.lang.Long)22:37:09.467
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl -
paramName:loanPurposeId22:37:09.468 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - addParametersToReport(loanPurposeId :
-1 : java.lang.Long)22:37:09.468 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - paramName:loanProductId22:37:09.468
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl -
addParametersToReport(loanProductId : -1 : java.lang.Long)22:37:09.470
[http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl - db
URL:jdbc:mysql://localhost:3306/mifostenant-default
userhierarchy:.22:37:09.470 [http-bio-8443-exec-8] INFO
o.m.i.d.s.ReadReportingServiceImpl - db
URL:jdbc:mysql://localhost:3306/mifostenant-default
userid:122:37:09.890 [http-bio-8443-exec-8] INFO
o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
{"startTime":1457984216751,"totalTime":13139,"method":"GET","url":"https://localhost:8443/mifosng-provider/api/v1/runreports/Portfolio%20at%20Risk%20by%20Branch(Pentaho)","parameters":{"R_loanPurposeId":["-1"],"dateFormat":["dd
MMMM yyyy"],"R_loanProductId":["-1"],"R_parType":["4"],"R_Loan
Officer":["-1"],"output-type":["HTML"],"R_Branch":["1"],"locale":["en"],"R_CurrencyId":["UGX"],"tenantIdentifier":["default"],"R_fundId":["1"]}}*
Why are these two behaving so different with reports?
*ThanksRegardsIppez Robert*
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
