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