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
