Hello!
That error could be different reasons, for instance the connection to the
database without SSL,
Maybe you need to review the tenant connection parameters to not use the SSL
Thanks and best regardsçAlberto
On Mon, Feb 28, 2022 at 4:25 PM Kevin Kihara <kihashkevo2...@gmail.com>
wrote:
> Hello I'm new to mifos . I've been trying to integrate pentaho reports
> plugin to mifos but I haven't been successful. This is the error I get when
> I generate any Pentaho based Report.
> Kindly Assist.
> {"developerMessage":"The request caused a data integrity issue to be fired
> by the database.","httpStatusCode":"403","defaultUserMessage":"Pentaho
> failed: Failed to process the
> report","userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":"Pentaho
> failed: Failed to process the report","defaultUserMessage":"Pentaho failed:
> Failed to process the
> report","userMessageGlobalisationCode":"error.msg.reporting.error","parameterName":null,"value":null,"args":[]}]}
>
>
>
>
> "developerMessage":"The request caused a data integrity issue to be fired
> by the database.","httpStatusCode":"403","defaultUserMessage":"Pentaho
> failed: Failed at query: \n\n\n\n\n\nselect debits.glcode as 'glcode',
> debits.name as 'name',
> (ifnull(debits.debitamount,0)-ifnull(credits.creditamount,0)) as
> 'balance'\nfrom\n(select acc_gl_account.gl_code as
> 'glcode',name,sum(amount) as 'debitamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=2\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) debits\nLEFT OUTER JOIN\n(select
> acc_gl_account.gl_code as 'glcode',name,sum(amount) as 'creditamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=1\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) credits\non debits.glcode=credits.glcode\n\n
> \n\nunion\n\n \n\nselect credits.glcode as 'glcode', credits.name as
> 'name', (ifnull(debits.debitamount,0)-ifnull(credits.creditamount,0)) as
> 'balance'\nfrom\n(select acc_gl_account.gl_code as
> 'glcode',name,sum(amount) as 'debitamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=2\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) debits\nRIGHT OUTER JOIN\n(select
> acc_gl_account.gl_code as 'glcode',name,sum(amount) as 'creditamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=1\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> name\norder by glcode) credits\non debits.glcode=credits.glcode;
> ","userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":"Pentaho
> failed: Failed at query: \n\n\n\n\n\nselect debits.glcode as 'glcode',
> debits.name as 'name',
> (ifnull(debits.debitamount,0)-ifnull(credits.creditamount,0)) as
> 'balance'\nfrom\n(select acc_gl_account.gl_code as
> 'glcode',name,sum(amount) as 'debitamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=2\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) debits\nLEFT OUTER JOIN\n(select
> acc_gl_account.gl_code as 'glcode',name,sum(amount) as 'creditamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=1\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) credits\non debits.glcode=credits.glcode\n\n
> \n\nunion\n\n \n\nselect credits.glcode as 'glcode', credits.name as
> 'name', (ifnull(debits.debitamount,0)-ifnull(credits.creditamount,0)) as
> 'balance'\nfrom\n(select acc_gl_account.gl_code as
> 'glcode',name,sum(amount) as 'debitamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=2\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) debits\nRIGHT OUTER JOIN\n(select
> acc_gl_account.gl_code as 'glcode',name,sum(amount) as 'creditamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=1\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> name\norder by glcode) credits\non debits.glcode=credits.glcode;
> ","defaultUserMessage":"Pentaho failed: Failed at query: \n\n\n\n\n\nselect
> debits.glcode as 'glcode', debits.name as 'name',
> (ifnull(debits.debitamount,0)-ifnull(credits.creditamount,0)) as
> 'balance'\nfrom\n(select acc_gl_account.gl_code as
> 'glcode',name,sum(amount) as 'debitamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=2\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) debits\nLEFT OUTER JOIN\n(select
> acc_gl_account.gl_code as 'glcode',name,sum(amount) as 'creditamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=1\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) credits\non debits.glcode=credits.glcode\n\n
> \n\nunion\n\n \n\nselect credits.glcode as 'glcode', credits.name as
> 'name', (ifnull(debits.debitamount,0)-ifnull(credits.creditamount,0)) as
> 'balance'\nfrom\n(select acc_gl_account.gl_code as
> 'glcode',name,sum(amount) as 'debitamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=2\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> glcode\norder by glcode) debits\nRIGHT OUTER JOIN\n(select
> acc_gl_account.gl_code as 'glcode',name,sum(amount) as 'creditamount'\nfrom
> acc_gl_journal_entry,acc_gl_account\nwhere acc_gl_account.id =
> acc_gl_journal_entry.account_id\nand acc_gl_journal_entry.type_enum=1\nand
> acc_gl_account.classification_enum in (1)\nand
> acc_gl_journal_entry.entry_date <= ${date}\nand
> (acc_gl_journal_entry.office_id=${branch} or ${branch}=1)\ngroup by
> name\norder by glcode) credits\non debits.glcode=credits.glcode;
> ","userMessageGlobalisationCode":"error.msg.reporting.error","parameterName":null,"value":null,"args":[]}]}
>
> _______________________________________________
> Mifos-users mailing list
> Mifos-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
