FYI for anybody who may have enabled strict mode on MySQL
Got an update from Madhukar that the issue Joel was facing was due to
strict mode being enabled on MySQL. We shall be updating the pentaho
reports to work with strict mode in the next release,
Regards,
Vishwas
On 22 May 2014 12:43, Joel Welti <[email protected]> wrote:
> Please, anybody? What does it mean when report exexution crahes with
> this error:
>
> {"developerMessage":"The request caused a data integrity issue to be fired
> by the
> database.","httpStatusCode":"403","defaultUserMessage":null,"userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":null,"defaultUserMessage":null,"userMessageGlobalisationCode":"error.msg.reporting.error","parameterName":null,"value":null,"args":[]}]}
>
>
> and in the logs I read:
>
> 86529251 [http-bio-8443-exec-8] ERROR o.m.i.d.s.ReadReportingServiceImpl
> - error.msg.reporting.error:null ....( <- It crashed because of an
> inexistent error)
>
> I am totaly stuck with this for days, there is nobody else with an IT
> background here to help me on my team and people are beginnig to think
> that we should abort our move to MIFOS.
>
>
> How do I tackle this?
> Joel
>
> > I figured that on one machine (Windows 7) I do experience this problem,
> > but on the other (Windows XP) I do. This is the correspondig part of the
> > log:
> >
> > 86503135 [http-bio-8443-exec-8] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597107610,"totalTime":13,"method":"POST","url":"
> https://localhost:8443/mifosng-provider/api/v1/authentication
> ","parameters":{"username":["mifos"]}}
> > 86510477 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: reportCategoryList Type: parameter
> > 86510498 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: reportCategoryList - parameter
> > Elapsed Time: 21
> > 86510506 [http-bio-8443-exec-8] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597114949,"totalTime":45,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/reportCategoryList
> ","parameters":{"parameterType":["true"],"genericResultSet":["false"],"R_reportCategory":["Loan"]}}
> > 86513264 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: FullParameterList Type: parameter
> > 86513278 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: FullParameterList - parameter
> > Elapsed Time: 14
> > 86513280 [http-bio-8443-exec-8] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597117730,"totalTime":38,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/FullParameterList
> ","parameters":{"R_reportListing":["\u0027Active
> > Loans - Details(Pentaho)\u0027"],"parameterType":["true"]}}
> > 86513501 [http-bio-8443-exec-3] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597117958,"totalTime":31,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/reports/120
> ","parameters":{"fields":["reportParameters"]}}
> > 86513741 [http-bio-8443-exec-3] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: currencyIdSelectAll Type: parameter
> > 86513747 [http-bio-8443-exec-3] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: currencyIdSelectAll - parameter
> > Elapsed Time: 6
> > 86513748 [http-bio-8443-exec-3] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597118222,"totalTime":13,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/currencyIdSelectAll
> ","parameters":{"parameterType":["true"]}}
> > 86513802 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: OfficeIdSelectOne Type: parameter
> > 86513807 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: OfficeIdSelectOne - parameter
> > Elapsed Time: 5
> > 86513808 [http-bio-8443-exec-8] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597118272,"totalTime":24,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/OfficeIdSelectOne
> ","parameters":{"parameterType":["true"]}}
> > 86513851 [http-bio-8443-exec-3] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: fundIdSelectAll Type: parameter
> > 86513856 [http-bio-8443-exec-3] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: fundIdSelectAll - parameter Elapsed
> > Time: 5
> > 86513857 [http-bio-8443-exec-3] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597118274,"totalTime":71,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/fundIdSelectAll
> ","parameters":{"parameterType":["true"]}}
> > 86513922 [http-bio-8443-exec-9] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: loanPurposeIdSelectAll Type: parameter
> > 86513927 [http-bio-8443-exec-9] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: loanPurposeIdSelectAll - parameter
> > Elapsed Time: 5
> > 86513928 [http-bio-8443-exec-9] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597118402,"totalTime":14,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/loanPurposeIdSelectAll
> ","parameters":{"parameterType":["true"]}}
> > 86515454 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: loanProductIdSelectAll Type: parameter
> > 86515465 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: loanProductIdSelectAll - parameter
> > Elapsed Time: 11
> > 86515467 [http-bio-8443-exec-8] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597119924,"totalTime":31,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/loanProductIdSelectAll
> ","parameters":{"R_currencyId":["-1"],"parameterType":["true"]}}
> > 86516725 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - STARTING REPORT: loanOfficerIdSelectAll Type: parameter
> > 86516735 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - FINISHING Report/Request Name: loanOfficerIdSelectAll - parameter
> > Elapsed Time: 10
> > 86516738 [http-bio-8443-exec-8] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597121195,"totalTime":30,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/loanOfficerIdSelectAll
> ","parameters":{"R_officeId":["1"],"parameterType":["true"]}}
> > 86529217 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - Report path: C:\\.mifosx\pentahoReports\Active Loans -
> > Details(Pentaho).prpt
> > 86529251 [http-bio-8443-exec-8] INFO o.m.i.d.s.ReadReportingServiceImpl
> > - paramName:tenantdb
> > 86529251 [http-bio-8443-exec-8] ERROR o.m.i.d.s.ReadReportingServiceImpl
> > - error.msg.reporting.error:null
> > 86529254 [http-bio-8443-exec-8] INFO
> > o.m.i.s.f.TenantAwareBasicAuthenticationFilter -
> > {"startTime":1400597133679,"totalTime":63,"method":"GET","url":"
> https://localhost:8443/mifosng-provider/api/v1/runreports/Active%20Loans%20-%20Details(Pentaho)
> ","parameters":{"R_fundId":["-1"],"R_currencyId":["-1"],"tenantIdentifier":["default"],"output-type":["HTML"],"locale":["en"],"R_loanProductId":["-1"],"dateFormat":["dd
> > MMMM
> > yyyy"],"R_loanPurposeId":["-1"],"R_branch":["1"],"R_loanOfficer":["-1"]}}
> >
> >
> >
> > Am 20.05.2014 11:13, schrieb Joel Welti:
> >> Hello MIFOS helpers
> >>
> >> I'm trying to get to run pentaho reports, after several problems solved
> >> I ran into this:
> >>
> >> {"developerMessage":"The request caused a data integrity issue to be
> >> fired by the
> >>
> database.","httpStatusCode":"403","defaultUserMessage":null,"userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":null,"defaultUserMessage":null,"userMessageGlobalisationCode":"error.msg.reporting.error","parameterName":null,"value":null,"args":[]}]}
> >>
> >> ....No more information given, the messages for the errors I had before
> >> gave much more information.
> >>
> >> first I had the one with reports not in the right folder
> >> then with the defaut password
> >> then I had editet the report with the wrong version of the designer
> >> ...but this one I can just not solve
> >>
> >> Any help would be very much appreciated, thank you
> >> Joel
> >>
> >>
> ------------------------------------------------------------------------------
> >> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> >> Instantly run your Selenium tests across 300+ browser/OS combos.
> >> Get unparalleled scalability from the best Selenium testing platform
> available
> >> Simple to use. Nothing to install. Get started now for free."
> >> http://p.sf.net/sfu/SauceLabs
> >> _______________________________________________
> >> Mifos-users mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/mifos-users
> >
> >
> ------------------------------------------------------------------------------
> > "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> > Instantly run your Selenium tests across 300+ browser/OS combos.
> > Get unparalleled scalability from the best Selenium testing platform
> available
> > Simple to use. Nothing to install. Get started now for free."
> > http://p.sf.net/sfu/SauceLabs
> > _______________________________________________
> > Mifos-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.
> Get unparalleled scalability from the best Selenium testing platform
> available
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
------------------------------------------------------------------------------
The best possible search technologies are now affordable for all companies.
Download your FREE open source Enterprise Search Engine today!
Our experts will assist you in its installation for $59/mo, no commitment.
Test it for FREE on our Cloud platform anytime!
http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users