[Mifos-users] Branch progress report and GL report problems
Gayl Kennedy
when I try to run the branch progress report I get an error message:
the Parameter "BranchReportDate" is required
I have entered in todays date and yesterdays date to no avail.
When I try the General Ledger report the drop down filters have no values (although they do in the branch progress report and collection sheet report.
I cannot access the known issues with v 1.6 to check if this is one of the known issues - gatway timeout issue. We have a clean install not an upgrade.
Any suggestions appreciated
--
Regards
Gayl
Ryan Whitney
Are the other standard reports working?
Ryan
--
Ryan Whitney
Mifos Technical Program Manager
rwhi...@grameenfoundation.org
Mifos - Technology that Empowers Microfinance (www.mifos.org)
Our mission is to enable the poor, especially the poorest, to create a world without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.
Jessica Cheng
I created a jira issue for this recently, it is Mifos-3598.
Regards,
Jessica
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
Gayl Kennedy
the portfolio at risk report appears to be working (at least can select expected items from drop down) but there is no data in it. Should the current loans be showing even if not overdue? I have a test branch for which loans have been disbursed but nothing is overdue so may be an issue.
The same applies to the Branch Cash Confirmation report.
Kelechi was looking yesterday to check requirements for the batch jobs but mifos.org was down so hopefully he will get that done today and it may address those issues.
thanks
G
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
--
Regards
Gayl
Ryan Whitney
Our standard default login/passwd for mysql is usually mifos/mifos. I’m going to guess your database login/password might be different. I’m wondering if the GL and Branch Progress Report are not pulling the connection details correctly and trying mifos/mifos. I’m hazarding that is what may be the bug.
Have you tried opening the reports in BIRT and setting the connections yourself?
Ryan
On 8/26/10 19:27, "Gayl Kennedy" <gaylk...@gmail.com> wrote:
Hi Ryan
the portfolio at risk report appears to be working (at least can select expected items from drop down) but there is no data in it. Should the current loans be showing even if not overdue? I have a test branch for which loans have been disbursed but nothing is overdue so may be an issue.
The same applies to the Branch Cash Confirmation report.
Kelechi was looking yesterday to check requirements for the batch jobs but mifos.org <http://mifos.org> was down so hopefully he will get that done today and it may address those issues.
thanks
G
On 26 August 2010 00:06, Ryan Whitney <rwhi...@grameenfoundation.org> wrote:
Gayl,
Are the other standard reports working?
Ryan
On 8/25/10 22:42, "Gayl Kennedy" <gaylk...@gmail.com <http://gaylk...@gmail.com> > wrote:
Hi
when I try to run the branch progress report I get an error message:
the Parameter "BranchReportDate" is required
I have entered in todays date and yesterdays date to no avail.
When I try the General Ledger report the drop down filters have no values (although they do in the branch progress report and collection sheet report.
I cannot access the known issues with v 1.6 to check if this is one of the known issues - gatway timeout issue. We have a clean install not an upgrade.
Any suggestions appreciated
Jeff Brewster
Gayle and Jessica,
Binny also had encountered the these issues on his laptop. I wasn’t able to repro on my machine, but spent time with Binny trying to troubleshoot the behavior. We tried setting his db account to the default database and account/password, editing the report in Mifos BIRT report designer, and using different databases. After trying all those things, he was still having no luck until today when he restarted his laptop. After restarting, the parameters started showing up properly with no errors. Could you confirm you’re still seeing parameters missing or the popup message after restarting your machine?
Also, since the GL report is giving you no values, I assume you’re using a non-default database, user and password? We don’t document this as clearly as we need to in our installation guide, but the standard reports we ship with Mifos assume a database of “mifos” and user/password of mifos/mifos. You need to change these reports to work on a different database and account.
Regards,
Jeff
Gayl Kennedy
I have not been able to find the issue number provided by Jessica in
http://mifosforge.jira.com. Am I looking in the wrong place?
I can confirm that we are working with the default dB log in details
so that is not the issue.
It is also not solved by restarting the computer as I have had the
same issue for several days now and restart my laptop each morning.
The server is also shut down every evening and restarted each morning.
Kelechi is downloading a patch to try to run the BIRT reports directly.
Edward Cable
Jeff Brewster
I've attached a modified GL report to the issue noted below. Will you
download that report and test it on your laptop? I've lower-cased all
of the column names as I noticed the "branch_name" aliased column
"display_name" was upper case. I'm basing this theory on the 24 June
2010 comment made to issue http://mifosforge.jira.com/browse/MIFOS-1513
about external reports.
I'm still not sure why I don't see the same behavior on my machine as
you and Gayl. Could you both also directly send me a copy of you my.ini
file and copy of the Mifos System Information page displayed when
running on your machine (this is the page that includes Operating
system, Java vendor, database vendor, etc.)
Thanks,
Jeff
>-----Original Message-----
>From: Edward Cable [mailto:eca...@grameenfoundation.org]
>Sent: Monday, August 30, 2010 8:32 AM
>To: A good place to start for users or folks new to Mifos.
>Subject: Re: [Mifos-users] Branch progress report and GL report
problems
>
>Gayl,
>
>Here's the direct link to the issue:
>
>http://mifosforge.jira.com/browse/MIFOS-3598
>
>Ed
>
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
binnyg...@indiatimes.com
If I use your modified GL report, it works !! :-)
I will send my my.ini and system information page to you soon
Thanks
Binny
Thanks,
Jeff
--
Click for exclusive coverage on the New Bajaj Pulsar 220 the fastest Indian bike
http://www.zigwheels.com/Features/Bajaj-Pulsar-220-DTSi-Special-Coverage/Pulsar_20090623-1-1
Jeff Brewster
>
>If I use your modified GL report, it works !! :-)
>
Good to know Binny. Are you having any issues with the other reports at
this point?
Jeff
Gayl Kennedy
thanks for the new version. The fix to the GL report is now allowing
us to select branch and date but no data is showing so need to check
batch jobs etc.
We still have the issue with the branch progress report originally
referenced on this thread.
Regards
Gayl
--
Regards
Gayl
Ryan Whitney
The GL report does not depend on the batch jobs. That shouldn't be the
issue. Double check that you have entered transactions for the branch in
question between your selected dates, and that you are entering the dates in
correctly.
Also, you can try running the query directly against your database to double
check as well:
SELECT financial_trxn.posted_date,
gl_code.glcode_value,
SUM(IF(debit_credit_flag = 0, ABS(posted_amount), 0.000)) AS debit,
SUM(IF(debit_credit_flag = 1, ABS(posted_amount),0.000)) AS credit
FROM financial_trxn
INNER JOIN gl_code USING (glcode_id)
INNER JOIN account_trxn ON account_trxn.account_trxn_id =
financial_trxn.account_trxn_id
INNER JOIN account ON account.account_id = account_trxn.account_id
WHERE account.OFFICE_ID = ?
AND financial_trxn.posted_date >= ?
AND financial_trxn.posted_date <= ?
GROUP BY posted_date, glcode_value
ORDER BY posted_date, glcode_value
This appears to run fine on demo.mifos.org.
Ryan
--
Ryan Whitney
Mifos Technical Program Manager
rwhi...@grameenfoundation.org
Mifos - Technology that Empowers Microfinance (www.mifos.org)
Our mission is to enable the poor, especially the poorest, to create a world
without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.
Gayl Kennedy
does it matter what area of reports the new version of the GL report
was added to in mifos as we added it under performance and it was
originally under analysis. Would it be something simple like that? We
definitely have transactions in that date period in my test branch and
we entered the date format correctly.
I need Kelechi to run the report against the db so thanks for sending it on.
--
Regards
Gayl
kelechi Micheals
I ran the query against the database and it came up with results. however, with the report it gives blank.
Ryan Whitney
Kelechi, ok, that helps in narrowing down the issue. Next area I would look at is trying to run it in the BIRT Report Designer, and see if you can see any errors popping up. Might also try looking in the logs. You can download here: http://download.eclipse.org/birt/downloads/index2.5.2.php (you want the RCP Designer)**
Ryan
** Note: We are running 2.5.1 in mifos. I have seen that BIRT isn’t great with different versions, but I’m hoping 2.5.2 will be fine. I couldn’t find a download link for 2.5.1.
On 9/7/10 1:36, "kelechi Micheals" <kelechi...@fantsuam.org> wrote:
hi Ryan,
I ran the query against the database and it came up with results. however, with the report it gives blank.
Gayl Kennedy wrote:
Hi Ryan
does it matter what area of reports the new version of the GL report
was added to in mifos as we added it under performance and it was
originally under analysis. Would it be something simple like that? We
definitely have transactions in that date period in my test branch and
we entered the date format correctly.
I need Kelechi to run the report against the db so thanks for sending it on.
On 06/09/2010, Ryan Whitney <rwhi...@grameenfoundation.org> <mailto:rwhi...@grameenfoundation.org> wrote:
Gayl,
The GL report does not depend on the batch jobs. That shouldn't be the
issue. Double check that you have entered transactions for the branch in
question between your selected dates, and that you are entering the dates in
correctly.
Also, you can try running the query directly against your database to double
check as well:
SELECT financial_trxn.posted_date,
gl_code.glcode_value,
SUM(IF(debit_credit_flag = 0, ABS(posted_amount), 0.000)) AS debit,
SUM(IF(debit_credit_flag = 1, ABS(posted_amount),0.000)) AS credit
FROM financial_trxn
INNER JOIN gl_code USING (glcode_id)
INNER JOIN account_trxn ON account_trxn.account_trxn_id =
financial_trxn.account_trxn_id
INNER JOIN account ON account.account_id = account_trxn.account_id
WHERE account.OFFICE_ID = ?
AND financial_trxn.posted_date >= ?
AND financial_trxn.posted_date <= ?
GROUP BY posted_date, glcode_value
ORDER BY posted_date, glcode_value
This appears to run fine on demo.mifos.org.
Ryan
On 9/6/10 20:08, "Gayl Kennedy" <gaylk...@gmail.com> <mailto:gaylk...@gmail.com> wrote:
Mifos - Technology that Empowers Microfinance (www.mifos.org <http://www.mifos.org> )
Our mission is to enable the poor, especially the poorest, to create a world
without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
kelechi Micheals
I have Eclipse Galilio with Birt 2.5.1. (2009 ) version. This should do I guess, I will download 2.5.2 all the same and try it out.
Ryan Whitney
Yeah, that should work just fine and I would stick with that since its the right version. The RDP is just easier as its an all in one package.
Ryan
On 9/7/10 15:27, "kelechi Micheals" <kelechi...@fantsuam.org> wrote:
thanks Ryan,
I have Eclipse Galilio with Birt 2.5.1. (2009 ) version. This should do I guess, I will download 2.5.2 all the same and try it out.
Ryan Whitney wrote:
Re: [Mifos-users] Branch progress report and GL report problems Gayl, no – it doesn’t matter what area the GL report is uploaded under. Categories are just for sorting reports and setting permissions.
Mifos - Technology that Empowers Microfinance (www.mifos.org <http://www.mifos.org> <http://www.mifos.org> )
Jeff Brewster
Kelechi,
Also make sure your jdbc connection in the GL report is pointing to the same DB that your sql query is using. Is your database “mifos” on your system? If not, you need to modify the report.
Regards,
Jeff
From: kelechi Micheals
[mailto:kelechi...@fantsuam.org]
Sent: Tuesday, September 07, 2010 12:27 AM
To: A good place to start for users or folks new to Mifos.
binnyg...@indiatimes.com
For the branch progress report:
If the daily batch job did not run for a given date and if I selected the report for that date, then the report criteria screen is displayed again without any errors.
The values for branch dropdown and the date is retained here.
If I click submit on this page again without changing the date, I see the error message 'The parameter "branchReportDate" is required'. I see this behavior on my laptop where the daily batch job does not get initiated everyday.
Is this what you are seeing too?
You could verify by entering a date for which you are sure the batch job ran successfully.
Thanks
Binny
----- Original Message -----
From: Gayl Kennedy <gaylk...@gmail.com>
To: A good place to start for users or folks new to Mifos. <mifos...@lists.sourceforge.net>
Sent: Mon, 6 Sep 2010 17:38:34 +0530 (IST)
Subject: Re: [Mifos-users] Branch progress report and GL report problems
Hi Jeff
thanks for the new version. The fix to the GL report is now allowing
us to select branch and date but no data is showing so need to check
batch jobs etc.
We still have the issue with the branch progress report originally
referenced on this thread.
Regards
Gayl
On 06/09/2010, Jeff Brewster <jbre...@grameenfoundation.org> wrote:
>>Hi Jeff,
>>
>>If I use your modified GL report, it works !! :-)
>>
>
> Good to know Binny. Are you having any issues with the other reports at
> this point?
>
> Jeff
>
>
--
Regards
Gayl
--
Click for exclusive coverage on the New Bajaj Pulsar 220 the fastest Indian bike
http://www.zigwheels.com/Features/Bajaj-Pulsar-220-DTSi-Special-Coverage/Pulsar_20090623-1-1
------------------------------------------------------------------------------
Ryan Whitney
To clarify, the Batch Jobs for the Batch Progress Report create records for
the day of. IE, often you expect Batch jobs to run information for the
previous day (IE, I can't see yesterdays information until today), but for
the Branch Progress Report, it runs for the day.
For example, if the batch jobs ran last night, I would see the results by
entering in todays date (This makes sense, since its calculating arrears for
today).
Ryan
On 9/8/10 19:35, "binnyg...@indiatimes.com"
<binnyg...@indiatimes.com> wrote:
--
Ryan Whitney
Mifos Technical Program Manager
rwhi...@grameenfoundation.org
Mifos - Technology that Empowers Microfinance (www.mifos.org)
Our mission is to enable the poor, especially the poorest, to create a world
without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.
------------------------------------------------------------------------------
Automate Storage Tiering Simply
Optimize IT performance and efficiency through flexible, powerful,
automated storage tiering capabilities. View this brief to learn how
you can reduce costs and improve performance.
http://p.sf.net/sfu/dell-sfdev2dev
Jeff Brewster
>If I click submit on this page again without changing the date, I see
>the error message 'The parameter "branchReportDate" is required'. I see
>this behavior on my laptop where the daily batch job does not get
>initiated everyday.
Binny,
So are you saying you don't have an issue with Branch Progress Report on
your machine if the batch jobs are executed first?
If that is NOT the case, and you still encounter problems with the
Progress Report, can you try dropping the attached file into your
mifos\report\BirtReportResource directory and see if you get the same
behavior? I modified the column name case for the columnName
properties.
Thanks,
Jeff
Gayl Kennedy
I can see that the Branch batch job ran on the 10th of Sept so when I
use that date I can see some information in the report, mainly # of
clients but no loan information. See attached example.
I can also see that the batch job which refers to customer meeting
dates (# 1 and 2 assuming the list is a standard order) have not run
since Aug 30th so maybe that is the cause as the loans may have been
created after that date. not sure why it has not run since then, I
assume all batch jobs should run every night. Kelechi needs to review
further.
is it worth running the report you sent yesterday anyway?
Thanks Gayl
--
Regards
Gayl
Jeff Brewster
As a first step, please execute the batch jobs. See this page for how
to trigger them manually:
http://mifosforge.jira.com/wiki/display/MIFOS/How+To+Run+Batch+Jobs+Manu
ally
Binny, Gayl - can you both send me a query result of your
scheduled_tasks table? (SELECT * FROM scheduled_tasks s;)
Regards,
Jeff
>-----Original Message-----
>From: Gayl Kennedy [mailto:gaylk...@gmail.com]
>Sent: Wednesday, September 15, 2010 8:32 AM
>To: A good place to start for users or folks new to Mifos.
>Subject: Re: [Mifos-users] Branch progress report and GL report
problems
>
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
kelechi Micheals
find attached query results..
--
Kelechi B.G. Micheals
Programme Operations Manager
Fantsuam Foundation
Kafanchan
+234-8020918229
+234-7039642794
kelechi...@fantsuam.org
skype: kelech_fantsuam
Udai Gupta
I think we know one issue with BIRT reports here, i.e column binding
(name) is case sensitive in BIRT.
http://dev.eclipse.org/newslists/news.eclipse.birt/msg15093.html
http://www.informit.com/articles/article.aspx?p=686166&seqNum=3
search "BIRT ROM Data Spec" (google) see column section in that doc
In MySQL the column name comparison is case insensitive.
"Column, index, stored routine, and event names are not case sensitive
on any platform, nor are column aliases. " --
http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html
So here we have to understand that Mysql store columns in case
sensitive way. A JDBC resultset will have that column name in the case
specified during creation(DDL).
If you give a column name to MySQL(by query) it will compare it in
case insensitive way, BIRT does that comparison by asking(result set)
column name from database.
As per fix of http://mifosforge.jira.com/browse/MIFOS-1513, There are
users having column names in upper case when they upgrade to 1.6, so
the reports are working for them. Column names will be all lower case
for new users when they create mifos database so they may experience
problem with parameters (column binding).
This issue is just for Column binding(parameters) not for queries in
the reports as the queries goes to the mysql and mysql handles column
in case insensitive way.
The workaround for this issue is that we should have two versions of
BIRT reports.
1) pre 1.5 users (upper case column names in mifos database)
2) post 1.5 users (lower case column names in mifos database)
We can not have one report which will work for both user just by
changing the case in reports.
Udai
Jeff Brewster
>BIRT reports.
>1) pre 1.5 users (upper case column names in mifos database)
>2) post 1.5 users (lower case column names in mifos database)
>
>We can not have one report which will work for both user just by
>changing the case in reports.
>
modified post 1.5 reports as part of issue MIFOS-3598?
Jeff
Jeff Brewster
In talking with Udai further, the Progress Report should not require
edits, instead we think it is an issue of not having completed batch
jobs for that report to run correctly. Can you please confirm your
batch jobs have completed for that BranchReportTask?
Kelechi, when you last sent me your batch job results, the task had this
error: " You may be missing an entry for
the currency with this id in
applicationConfiguration.custom.properties." Were you able to review
your properties file and confirm whether there was something added
there?
The updated GL report to test is attached to issue
http://mifosforge.jira.com/browse/MIFOS-3598.
kelechi Micheals
Branch ReportTask ran ok, however, I also noticed the following task
returned error, so I commented them out in the task.xml file.
ApplyCustomerFeeTask
RegenerateScheduleTask
CollectionSheetReportParameterCachingTask
so far the properties file seems ok.
On 09/20/2010 10:13 PM, Jeff Brewster wrote:
> Binny and Kelechi,
> In talking with Udai further, the Progress Report should not require
> edits, instead we think it is an issue of not having completed batch
> jobs for that report to run correctly. Can you please confirm your
> batch jobs have completed for that BranchReportTask?
>
> Kelechi, when you last sent me your batch job results, the task had this
> error: " You may be missing an entry for
> the currency with this id in
> applicationConfiguration.custom.properties." Were you able to review
> your properties file and confirm whether there was something added
> there?
>
> The updated GL report to test is attached to issue
> http://mifosforge.jira.com/browse/MIFOS-3598.
>
> Jeff
>
>
--
Kelechi B.G. Micheals
Programme Operations Manager
Fantsuam Foundation
Kafanchan
+234-8020918229
+234-7039642794
kelechi...@fantsuam.org
skype: kelech_fantsuam
Jeff Brewster
>Branch ReportTask ran ok, however, I also noticed the following task
>returned error, so I commented them out in the task.xml file.
>
>ApplyCustomerFeeTask
>RegenerateScheduleTask
>CollectionSheetReportParameterCachingTask
>
Hi Kelechi,
This is expected as these tasks were removed in version 1.6 as noted in
http://www.mifos.org/knowledge/support/deploying-mifos/upgradeto16.
Regards,
Jeff
Jeff Brewster
>I have verified that the Branch Progress
report works on all days when the batch successfully completed.
Ok, thanks I’ll update the jira issue with your findings.
>And on the days when the batch did not
complete successfully, I see the report comes back to the Report parameter
screen and if you click submit >again it
gives alert "the Parameter 'branchReportDate' is required".
Not ideal behavior for sure, I’ll log this as different issue that we should improve the feedback to the user for this scenario.
Jeff
Gayl Kennedy
I just want to ensure we are the same page here but we still have no
loan information showing in the Branch progress report. we have data
in the panel to the left - # of clients, loans, savers, staff etc but
no data yet in the loans disbursed section or aging section.
Please advise
Thanks Gayl
------------------------------------------------------------------------------
Jeff Brewster
>I just want to ensure we are the same page here but we still have no
>loan information showing in the Branch progress report. we have data
>in the panel to the left - # of clients, loans, savers, staff etc but
>no data yet in the loans disbursed section or aging section.
>Please advise
>Thanks Gayl
Hi Gayl,
That wasn't clear to me before - that you are not seeing portions of the
report displayed.
Do you see these results for any date provided as a parameter? This
could be a result of the currency id error you are seeing in the batch
job. Will you or Kelechi send me your custom properties?
Jeff Brewster
I have reviewed your custom properties file and understand now why your
BranchReport task producing this error:
" Unable to find currency with id: 2. You may be missing an entry for
the currency with this id in
applicationConfiguration.custom.properties. "
Since you have the AccountingRules.CurrencyCode=NGN in your custom
properties file, the batch job is not able to locate its default
property setting of 2 (INR). This report shouldn't have its own
currency property, and I've filed a new issue
http://mifosforge.jira.com/browse/MIFOS-3758 to that regard.
In the meantime, if you edit the file
"webapps\mifos\WEB-INF\classes\org\mifos\reports\resources\ProgressRepor
t.properties" and replace currency.id with a value of 108 instead of 2
you task should now match up with the custom properties file the next
time the batch job executes. This file is inside your exploded mifos
folder below the tomcat's webapps directory. Currency code for NGN is
108 according to the currency table in Mifos.
Will you modify that properties file and test if that resolves the batch
job error? Once the batch job executes cleanly, do you see a populated
branch progress report?
One note, I tried this on my machine and for some reason the
intermediate value I entered for currency.id (one I made up) kept coming
being used by the batch job even after I modified the properties file
again. I'm unsure why that was the case. Others on the list may be
able to comment on that. If you set it to 108 right away, you should be
set.
Jeff
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
Gayl Kennedy
the "test branch" data and all appears to be in order. On the live
branch data it is showing a centre in arrears but I think it is just
that I changed their meeting date but that won't take effect till
after the next meeting date.. one of the clunky ways date changes
works in mifos, but I will keep an eye on it after I put in their
collection sheet data later this week.
I think there may be a data issue related to the outstanding
principle, possibly related to the group loan calc bug Iogged last
week but I will send a separate email on that one after I complete my
investigation.
On the GL report issue, we still have issues but for clarity I will
start a new discussion on it and close this one off.
Thanks
Gayl
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
Kevin Kimani
Thanks a lot for the references supplied in the attached email.
I have been experiencing similar problems mentioned on this thread
(Branch progress report and GL report problems), particularly with the
progress report and the GL report for mifos 2.1.
I am doing a follow up on the same to know if there is any
documentations/Work-around on how to resolve the Column Binding issue
for post 1.5 reports. Also, from the thread I managed download the
Modified GL report but it still did not bring the GL computation, only
the report header and footer.
please advice.
On Sep 16 2010, 4:51 pm, Udai Gupta <mailt...@gmail.com> wrote:
> Hi,
>
> I think we know one issue with BIRT reports here, i.ecolumnbinding
> (name) is case sensitive in BIRT.
>
> http://dev.eclipse.org/newslists/news.eclipse.birt/msg15093.htmlhttp://www.informit.com/articles/article.aspx?p=686166&seqNum=3
> search "BIRT ROM Data Spec" (google) seecolumnsection in that doc
>
> In MySQL thecolumnname comparison is case insensitive.
> "Column, index, stored routine, and event names are not case sensitive
> on any platform, nor arecolumnaliases. " --http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html
>
> So here we have to understand that Mysql store columns in case
> sensitive way. A JDBC resultset will have thatcolumnname in the case
> specified during creation(DDL).
>
> If you give acolumnname to MySQL(by query) it will compare it in
> case insensitive way, BIRT does that comparison by asking(result set)columnname from database.
>
> As per fix ofhttp://mifosforge.jira.com/browse/MIFOS-1513, There are
> users havingcolumnnames in upper case when they upgrade to 1.6, so
> the reports are working for them.Columnnames will be all lower case
> for new users when they create mifos database so they may experience
> problem with parameters (columnbinding).
>
> This issue is just forColumnbinding(parameters) not for queries in
> the reports as the queries goes to the mysql and mysql handlescolumn
> in case insensitive way.
>
> The workaround for this issue is that we should have two versions of
> BIRT reports.
> 1) pre 1.5 users (upper casecolumnnames in mifos database)
> 2) post 1.5 users (lower casecolumnnames in mifos database)
>
> We can not have one report which will work for both user just by
> changing the case in reports.
>
> Udai
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> Mifos-users mailing list
> Mifos-us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
Udai Gupta
If you are using modified Branch progress and GL reports of 1.5 with
2.1 then you should first see what is the difference in reports and
try to update it for 2.1. If you are using 2.1 default reports then
check if you have the correct reports which gets bundled with 2.1.
You should enable the BIRT logs to see errors.
BIRT view in Mifos is forced to PDF format but you can hack in by
opening the BIRT viewer frame of Mifos in different browser tab ("show
Only this frame" option of firefox). You can then change the URL of
frame to have html instead of pdf which will show error in the reports
with HTML output (if there is any error).
If you are seeing errors where you doubt that query is causing some
problem then you should try lower_case_table_names=1 or lower the case
of all queries in that report.
To understand the issue with case sensitivity of MySQL identifiers see
http://mifosforge.jira.com/browse/MIFOS-1513
Udai
Kevin Kimani
I managed to open the modified GL report (http://mifosforge.jira.com/browse/MIFOS-3598 ), the branch drop down on the report parameter is populated with the relevant details; in Birt the following are the errors shown.
data.engine.ColumnBindingReferToInexistColumn ( 1 time(s) ) detail : org.eclipse.birt.report.engine.api.EngineException: Column binding "mfi_name" has referred to a data set column "mfi_name" which does not exist. at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1163) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1127) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96) at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:137) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:137) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26) at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:137) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:882) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973) at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112) at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:318) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:880) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:213) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520) Caused by: org.eclipse.birt.data.engine.core.DataException: Column binding "mfi_name" has referred to a data set column "mfi_name" which does not exist. at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:336) at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:141) at org.eclipse.birt.data.engine.impl.ResultIterator2.<init>(ResultIterator2.java:50) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:188) at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:155) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:254) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1818) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) ... 70 more
As for the progress report.
data.engine.ColumnBindingReferToInexistColumn ( 1 time(s) ) detail : org.eclipse.birt.report.engine.api.EngineException: Column binding "GLCODE_VALUE" has referred to a data set column "GLCODE_VALUE" which does not exist. at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1163) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1127) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:882) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973) at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112) at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:318) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:880) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:748) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:213) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520) Caused by: org.eclipse.birt.data.engine.core.DataException: Column binding "GLCODE_VALUE" has referred to a data set column "GLCODE_VALUE" which does not exist. at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:336) at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:141) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:181) at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:155) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:254) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1818) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) ... 59 more
The report parameter for Branches is populated with -2 instead of the branch details. The following are the errors shown in BIRT;
