[Mifos-developer] Mifosx Pentaho reports dont run on windows

Denis Frimos

unread,

Sep 5, 2016, 4:57:03 AM9/5/16

to Mifos software development

We are facing an issue with standard pentaho on windows environment, while the same set up works on Linux environment,

Error returned

{developerMessage: "The request caused a data integrity issue to be fired by the database.",…}

defaultUserMessage:"The parameters provided for this report are not valid."
developerMessage:"The request caused a data integrity issue to be fired by the database."
errors:[{developerMessage: "The parameters provided for this report are not valid.",…}]
httpStatusCode:"403"
userMessageGlobalisationCode:"error.msg.reporting.error"

Denis Frimos

Director, Project Architect | ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2^nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

Shreyaank Byadagi

unread,

Sep 6, 2016, 1:32:42 AM9/6/16

to Mifos software development

Hi Denis,

How are you?

Can you tell me whether your facing this issue with only one report or multiple reports.

Regards

Shreyaank

------------------------------------------------------------------------------

Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

--

Thanks and Regards

Shreyaank

E-mail:shre...@confluxtechnologies.com

Nayan Ambali

unread,

Sep 6, 2016, 2:05:47 AM9/6/16

to Mifos software development

Hello Denis,

I assume this is a custom Pentaho report you have deployed on the platform, usually this type of issue will come if the report parameters defined in the Pentaho report using report designer are not matching with the report parameter defined in the platform.

-

Nayan Ambali

On Tue, 6 Sep 2016 at 11:03 Shreyaank Byadagi <shre...@confluxtechnologies.com> wrote:

Hi Denis,

How are you?
Can you tell me whether your facing this issue with only one report or multiple reports.

Regards
Shreyaank

On Mon, Sep 5, 2016 at 2:26 PM, Denis Frimos <romeo...@gmail.com> wrote:

We are facing an issue with standard pentaho on windows environment, while the same set up works on Linux environment,

Error returned

{developerMessage: "The request caused a data integrity issue to be fired by the database.",…}
defaultUserMessage:"The parameters provided for this report are not valid."
developerMessage:"The request caused a data integrity issue to be fired by the database."
errors:[{developerMessage: "The parameters provided for this report are not valid.",…}]
httpStatusCode:"403"
userMessageGlobalisationCode:"error.msg.reporting.error"

Denis Frimos

Director, Project Architect | ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2^nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

------------------------------------------------------------------------------

Mifos-developer mailing list

mifos-d...@lists.sourceforge.net

Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

--
Thanks and Regards
Shreyaank
E-mail:shre...@confluxtechnologies.com

------------------------------------------------------------------------------
Mifos-developer mailing list
mifos-d...@lists.sourceforge.net

Denis Frimos

unread,

Sep 6, 2016, 5:02:16 AM9/6/16

to Mifos software development

@Nayan

the reports are pentaho standard reports that are shipped with the platform

@Shreyaank

All pentaho reports dont work on windows, if we follow the same procedures on linux they start working

Denis Frimos

Director, Project Architect | ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2^nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

On Tue, Sep 6, 2016 at 9:05 AM, Nayan Ambali <nayan....@gmail.com> wrote:

Hello Denis,

I assume this is a custom Pentaho report you have deployed on the platform, usually this type of issue will come if the report parameters defined in the Pentaho report using report designer are not matching with the report parameter defined in the platform.

-
Nayan Ambali

On Tue, 6 Sep 2016 at 11:03 Shreyaank Byadagi <shreyaank@confluxtechnologies.com> wrote:

Hi Denis,

How are you?
Can you tell me whether your facing this issue with only one report or multiple reports.

Regards
Shreyaank

On Mon, Sep 5, 2016 at 2:26 PM, Denis Frimos <romeo...@gmail.com> wrote:

We are facing an issue with standard pentaho on windows environment, while the same set up works on Linux environment,

Error returned

{developerMessage: "The request caused a data integrity issue to be fired by the database.",…}
defaultUserMessage:"The parameters provided for this report are not valid."
developerMessage:"The request caused a data integrity issue to be fired by the database."
errors:[{developerMessage: "The parameters provided for this report are not valid.",…}]
httpStatusCode:"403"
userMessageGlobalisationCode:"error.msg.reporting.error"

Denis Frimos

Director, Project Architect | ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2^nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

------------------------------------------------------------------------------

Mifos-developer mailing list

mifos-developer@lists.sourceforge.net

Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

--
Thanks and Regards
Shreyaank
E-mail:shreyaank@confluxtechnologies.com

------------------------------------------------------------------------------
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net

Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

------------------------------------------------------------------------------

Mifos-developer mailing list
mifos-developer@lists.sourceforge.net

Shreyaank Byadagi

unread,

Sep 6, 2016, 5:07:15 AM9/6/16

to Mifos software development

Hi Denis,

Please share the complete error log, so that I can guide you!!

Regards

Shreyaank

mifos-d...@lists.sourceforge.net

Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

--
Thanks and Regards
Shreyaank
E-mail:shreyaank@confluxtechnologies.com

------------------------------------------------------------------------------
Mifos-developer mailing list

mifos-d...@lists.sourceforge.net

Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

------------------------------------------------------------------------------

Mifos-developer mailing list
mifos-d...@lists.sourceforge.net

Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

------------------------------------------------------------------------------

Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

--

Thanks and Regards

Shreyaank

E-mail:shre...@confluxtechnologies.com

Denis Frimos

unread,

Sep 6, 2016, 5:20:18 AM9/6/16

to Mifos software development

189911 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - Report path: C:\Users\romodenis\.mifosx\pentahoReports\Client Listing(Pentaho).prpt

190869 [http-bio-8443-exec-6] INFO o.p.r.l.base.util.ObjectUtilities - Specified class org.pentaho.reporting.engine.classic.extensions.modules.sbarcodes.xml.SimpleBarcodesElementReadHandler failed to instantiate correctly.

190935 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - paramName:selectOffice

190936 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - addParametersToReport(selectOffice : 1 : java.lang.Long)

190936 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - db URL:jdbc:mysql://localhost:3306/mifostenant-default userhierarchy:.

190937 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - db URL:jdbc:mysql://localhost:3306/mifostenant-default userid:1

191543 [http-bio-8443-exec-6] INFO o.p.r.l.base.util.ObjectUtilities - Specified class org.pentaho.reporting.engine.classic.core.cache.EhCacheDataCache failed to instantiate correctly.

191544 [http-bio-8443-exec-6] INFO o.p.r.e.c.c.cache.DataCacheFactory - Unable to create valid cache, returning <null>

192043 [http-bio-8443-exec-6] ERROR o.p.r.e.c.c.l.o.AbstractReportProcessor - 1988540487: Report processing failed.

192413 [http-bio-8443-exec-6] INFO o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter - {"startTime":1473153213235,"totalTime":2528,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/Client%20Listing(Pentaho)","parameters":{"output-type":["XLS"],"locale":["en"],"dateFormat":["dd MMMM yyyy"],"R_selectOffice":["1"],"tenantIdentifier":["default"]}}

Denis Frimos

Director, Project Architect | ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2^nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

Shreyaank Byadagi

unread,

Sep 6, 2016, 5:29:42 AM9/6/16

to Mifos software development

Hi Denis,

I cannot see any exceptions generated in your error log, So please send complete error message.

Regards

Shreyaank

On Tue, Sep 6, 2016 at 2:49 PM, Denis Frimos <romeo...@gmail.com> wrote:

189911 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - Report path: C:\Users\romodenis\.mifosx\pentahoReports\Client Listing(Pentaho).prpt
190869 [http-bio-8443-exec-6] INFO o.p.r.l.base.util.ObjectUtilities - Specified class org.pentaho.reporting.engine.classic.extensions.modules.sbarcodes.xml.SimpleBarcodesElementReadHandler failed to instantiate correctly.
190935 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - paramName:selectOffice
190936 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - addParametersToReport(selectOffice : 1 : java.lang.Long)
190936 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - db URL:jdbc:mysql://localhost:3306/mifostenant-default userhierarchy:.
190937 [http-bio-8443-exec-6] INFO o.m.i.r.s.PentahoReportingProcessServiceImpl - db URL:jdbc:mysql://localhost:3306/mifostenant-default userid:1
191543 [http-bio-8443-exec-6] INFO o.p.r.l.base.util.ObjectUtilities - Specified class org.pentaho.reporting.engine.classic.core.cache.EhCacheDataCache failed to instantiate correctly.
191544 [http-bio-8443-exec-6] INFO o.p.r.e.c.c.cache.DataCacheFactory - Unable to create valid cache, returning <null>
192043 [http-bio-8443-exec-6] ERROR o.p.r.e.c.c.l.o.AbstractReportProcessor - 1988540487: Report processing failed.
192413 [http-bio-8443-exec-6] INFO o.a.f.i.s.f.TenantAwareBasicAuthenticationFilter - {"startTime":1473153213235,"totalTime":2528,"method":"GET","url":"https://localhost:8443/fineract-provider/api/v1/runreports/Client%20Listing(Pentaho)","parameters":{"output-type":["XLS"],"locale":["en"],"dateFormat":["dd MMMM yyyy"],"R_selectOffice":["1"],"tenantIdentifier":["default"]}}

Denis Frimos

Director, Project Architect | ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2^nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

--

Thanks and Regards

Shreyaank

E-mail:shre...@confluxtechnologies.com

Denis Frimos

unread,

Sep 6, 2016, 6:33:00 AM9/6/16

to Mifos software development

The platform runs okay with no errors,

The logs i have shared is what is logged when i run pentaho report!!!

When i run pentaho report nothing happens but i can see the errors on web console!!

that says :

The parameters provided for this report are not valid,

The request caused a data integrity issue to be fired by the database.

httpStatusCode:"403"

kindly see the attachments from the server logs,

Denis Frimos

Director, Project Architect | ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2^nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

fineract-platform.log

catalina.2016-09-06.log

localhost.2016-09-06.log

Reply all

Reply to author

Forward