[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mifos-developer
Subject:    Re: [Mifos-developer] Adding data to a blank Mifos Database
From:       "Aliya Walji" <awalji () grameenfoundation ! org>
Date:       2007-09-28 18:24:37
Message-ID: 9DD845C1ED0D5D40B4B56DF5A4B1EB0E01F4030D () gfmail ! gfusa ! org
[Download RAW message or body]

Hi Mark,

 

Just to add on a bit to Amy's email, the data in the test-data directory
of SVN is VERY old and most of it is from prior to when we had DB
versions and upgrade scripts for the data to make it work with the
current version of the code (see
http://mifos.org/developers/technical-orientation/mifos-database-develop
ment for more details about the history of DV versioning/upgrades and
the process for upgrading older databases).  

 

Furthermore, since this data comes from our test server (at least if I'm
not mistaken, based on the naming of the files), it probably does not
have data in the order of a typical mid-size MFI (120,000 clients with 4
accounts each).  I believe it is probably closer to a few thousand
clients at most (but I can't confirm without looking at the data in svn
to be sure).  It is probably very similar in size to the DB dump that I
pointed Massimo to yesterday which is a recent dump from the same test
server
(https://mifos.dev.java.net/servlets/ProjectDocumentView?documentID=6654
3&showInfo=true).  

 

I think the last time we generated test data of this size was prior to
our first release when performance testing was done for Mifos.  If I'm
not mistaken, you and Max have already found the DBs in SVN that
correspond to the datasets used for performance testing back then and
have found that you ran into the issue of upgrading the DB dump given
that it was generated prior to having a version number.  Honestly, since
I wasn't on the Mifos team back then and because the data was generated
by another organization named Aditi, I don't have a good sense for how a
data set of this size was generated back then and if you could follow
the same process for your needs now.

 

The recommendations I would take for next steps would be one of the
following:

 

1.	See if someone else on this mailing list can provide some
suggestions for generating large data sets of sample/test data

 

2.	See if you can take the data located in the "perfomance-tests"
directory in the Mifos SVN
(120000CUstomers-200000Loans-220000Savings1.zip) that was created by
Aditi and you have already discovered and follow the steps on the 'Mifos
database development' page linked above under the 'Databases older than
December 2006' to see if you can upgrade it to a version of the DB that
is more recent and will work with the latest version of the code.  I do
want to state quite strongly that I think this process will not be easy
and be quite messy, if it works at all ;)  It's not something we have
gone through on the Mifos team yet and I think we all know that database
upgrades for data that old will not be a simple task.  You're welcome to
give it a shot though, depending on how much time you have.

 

3.	See if you can build an automated way to generate large numbers
of clients/accounts/transactions.  This is not something we have yet,
but something that would be hugely valuable for us in our ongoing
development/testing process.

 

As Amy mentions, we have not well documented what the various dumps of
data in SVN are and also, have not been able to post and point people to
a good dump of test data or information about how to generate test data
easily yet.  It's something we are working on and will hopefully improve
over time to help support our developer community.  Any work you do in
the area of determining how to automatically generate test data for
performance testing or otherwise will be useful for the entire Mifos
community so please feel free to share with us how you end up moving
forward with this.

 

Thanks,

 

Aliya

 

 

________________________________

From: mifos-developer-bounces@lists.sourceforge.net
[mailto:mifos-developer-bounces@lists.sourceforge.net] On Behalf Of Mark
Kavanagh
Sent: Friday, September 28, 2007 6:52 AM
To: Developer
Subject: Re: [Mifos-developer] Adding data to a blank Mifos Database

 

Thanks for reply Amy ..

I'm working with Massimo and I think we've got a stable starting point
now !




On 9/28/07, Amy Bensinger (Contractor)
<abensinger@grameenfoundation.org> wrote:

Hi, Mark.   The attached thread will help you get some data, I think.
There are database backups available, and then you must
upgrade/downgrade the database as is appropriate with your build.  

You could try in
https://mifos.dev.java.net/svn/mifos/documents/test-data.

 

We'll be expanding this area a bit on mifo.org in the next few months,
but  for now, it's a bit bumpy.

 

________________________________

From: mifos-developer-bounces@lists.sourceforge.net
[mailto:mifos-developer-bounces@lists.sourceforge.net] On Behalf Of Mark
Kavanagh
Sent: Friday, September 28, 2007 2:45 PM
To: mifos-developer@lists.sourceforge.net
Subject: [Mifos-developer] Adding data to a blank Mifos Database

 

Hi 

I've set up Mifos environment ( mySQL 4.1.22, JBoss 4.0.5 ) with blank
database and would like to populate
it with data to do some performance tests..
How have people been populating their blank databases so far to execute
tests or whats the best way to approach 
this so i have meaningful data to simulate ? 
Would like to have data to simulate a typical mid size MFI , i.e 120,000
clients with 4 accounts each..

any direction appreciated , Thanks ! 



---------- Forwarded message ----------
From: "Mohammed Nyamatullah" <nyamat.signup@gmail.com>
To: "Developer" < mifos-developer@lists.sourceforge.net
<mailto:mifos-developer@lists.sourceforge.net> >
Date: Mon, 24 Sep 2007 12:47:37 -0400
Subject: Re: [Mifos-developer] FW: Milestone 1 and test database

On 9/24/07, Massimiliano Parlione <parlione@hotmail.com> wrote: 
> 
> Hi all, 
> my team is trying to setup an enviroment for Mifos Milestone 1. 
> 
> We have checked out MIFOS (revision 11704), build it and installed it.
Since 
> we didn't have any test data we decided to upload the data located in
the 
> perfomance-tests directory in the Mifos SVN: 
> 120000CUstomers-200000Loans-220000Savings1.zip 
> 
> Unfortunately we got this error: 
> 
> Mifos Database Upgrade Error 
> The system was not able to automatically upgrade the database. Correct
the 
> error and restart the application. 
> I have noticed that there is a page describing how to handle the case
where 
> the database version and the application version don't match 
>
(http://mifos.org/developers/technical-orientation/coding-standards#data
basestandards ) 
> but in our case we have an empty column. 

Hi Parlione , 
The testdata you have taken is prettyy old. Just check the following 
if you want to upgrade the same database. 

http://mifos.org/developers/technical-orientation/mifos-database-develop
ment 
Please refer to section Older databases (December 2006 or older) 

Mohammed Nyamatullah 

------------------------------------------------------------------------
- 
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2005. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ 


------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

 


[Attachment #3 (text/html)]

<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" \
xmlns:st1="urn:schemas-microsoft-com:office:smarttags" \
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
 namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
p
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle20
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
 /* List Definitions */
 @list l0
	{mso-list-id:1329749713;
	mso-list-type:hybrid;
	mso-list-template-ids:-1863260994 67698703 67698713 67698715 67698703 67698713 \
67698715 67698703 67698713 67698715;} @list l0:level1
	{mso-level-tab-stop:.5in;
	mso-level-number-position:left;
	text-indent:-.25in;}
ol
	{margin-bottom:0in;}
ul
	{margin-bottom:0in;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Mark,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Just to add on a bit to Amy&#8217;s email,
the data in the test-data directory of SVN is VERY old and most of it is from
prior to when we had DB versions and upgrade scripts for the data to make it
work with the current version of the code (see <a
href="http://mifos.org/developers/technical-orientation/mifos-database-development">http://mifos.org/developers/technical-orientation/mifos-database-development</a>
 for more details about the history of DV versioning/upgrades and the process
for upgrading older databases).&nbsp; <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Furthermore,
since this data comes from our test server (at least if I&#8217;m not mistaken,
based on the naming of the files), it probably does not have data in the order
of a typical mid-size MFI (120,000 clients with 4 accounts each).&nbsp; I believe it
is probably closer to a few thousand clients at most (but I can&#8217;t confirm
without looking at the data in svn to be sure).&nbsp; It is probably very similar in
size to the DB dump that I pointed Massimo to yesterday which is a recent dump
from the same test server (</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><a
href="https://mifos.dev.java.net/servlets/ProjectDocumentView?documentID=66543&amp;sho \
wInfo=true">https://mifos.dev.java.net/servlets/ProjectDocumentView?documentID=66543&amp;showInfo=true</a>).&nbsp;
 <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I think the last time we generated test
data of this size was prior to our first release when performance testing was
done for Mifos.&nbsp; If I&#8217;m not mistaken, you and Max have already found the
DBs in SVN that correspond to the datasets used for performance testing back
then and have found that you ran into the issue of upgrading the DB dump given
that it was generated prior to having a version number.&nbsp; Honestly, since I \
wasn&#8217;t on the Mifos team back then and because the data was generated by \
another organization named Aditi, I don&#8217;t have a good sense for how a data set \
of this size was generated back then and if you could follow the same process for
your needs now.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The recommendations I would take for next
steps would be one of the following:<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<ol style='margin-top:0in' start=1 type=1>
 <li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
     color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'>See
     if someone else on this mailing list can provide some suggestions for
     generating large data sets of sample/test data<o:p></o:p></span></font></li>
</ol>

<p class=MsoNormal style='margin-left:.25in'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>


<ol style='margin-top:0in' start=2 type=1>
 <li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
     color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'>See
     if you can take the data located in the &quot;perfomance-tests&quot;
     directory in the Mifos SVN (120000CUstomers-200000Loans-220000Savings1.zip)
     that was created by Aditi and you have already discovered and follow the
     steps on the &#8216;Mifos database development&#8217; page linked above
     under the &#8216;Databases older than December 2006&#8217; to see if you
     can upgrade it to a version of the DB that is more recent and will work
     with the latest version of the code.&nbsp; I do want to state quite strongly
     that I think this process will not be easy and be quite messy, if it works
     at all ;)&nbsp; It&#8217;s not something we have gone through on the Mifos team
     yet and I think we all know that database upgrades for data that old will
     not be a simple task.&nbsp; You&#8217;re welcome to give it a shot though,
     depending on how much time you have.<o:p></o:p></span></font></li>
</ol>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<ol style='margin-top:0in' start=3 type=1>
 <li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
     color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'>See
     if you can build an automated way to generate large numbers of
     clients/accounts/transactions.&nbsp; This is not something we have yet, but
     something that would be hugely valuable for us in our ongoing
     development/testing process.<o:p></o:p></span></font></li>
</ol>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>As Amy mentions, we have not well
documented what the various dumps of data in SVN are and also, have not been
able to post and point people to a good dump of test data or information about
how to generate test data easily yet.&nbsp; It&#8217;s something we are working on
and will hopefully improve over time to help support our developer community.&nbsp;
Any work you do in the area of determining how to automatically generate test
data for performance testing or otherwise will be useful for the entire Mifos
community so please feel free to share with us how you end up moving forward
with this.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Aliya<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> \
mifos-developer-bounces@lists.sourceforge.net \
[mailto:mifos-developer-bounces@lists.sourceforge.net] <b><span \
style='font-weight:bold'>On Behalf Of </span></b>Mark Kavanagh<br> <b><span \
style='font-weight:bold'>Sent:</span></b> Friday, September 28, 2007 6:52 AM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName \
w:st="on">Developer</st1:PersonName><br> <b><span \
style='font-weight:bold'>Subject:</span></b> Re: [Mifos-developer] Adding data to a \
blank Mifos Database</span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Thanks for reply Amy ..<br>
<br>
I'm working with Massimo and I think we've got a stable starting point now !<br>
<br>
<br>
<o:p></o:p></span></font></p>

<div>

<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 9/28/07, <b><span style='font-weight:bold'>Amy
Bensinger (Contractor) </span></b>&lt;<a
href="mailto:abensinger@grameenfoundation.org">abensinger@grameenfoundation.org</a>&gt;
 wrote:</span></font></span><o:p></o:p></p>

<div link=blue vlink=purple>

<div>

<p><font size=2 color=blue face=Calibri><span style='font-size:11.0pt;
font-family:Calibri;color:blue'>Hi, Mark.&nbsp; &nbsp;The attached thread will
help you get some data, I think.&nbsp; There are database backups available,
and then you must upgrade/downgrade the database as is appropriate with your
build.&nbsp; </span></font><o:p></o:p></p>

<p><font size=2 color=blue face=Calibri><span style='font-size:11.0pt;
font-family:Calibri;color:blue'>You could try in <a
href="https://mifos.dev.java.net/svn/mifos/documents/test-data" \
target="_blank">https://mifos.dev.java.net/svn/mifos/documents/test-data</a>.</span></font><o:p></o:p></p>


<p><font size=2 color=blue face=Calibri><span style='font-size:11.0pt;
font-family:Calibri;color:blue'>&nbsp;</span></font><o:p></o:p></p>

<p><font size=2 color=blue face=Calibri><span style='font-size:11.0pt;
font-family:Calibri;color:blue'>We'll be expanding this area a bit on <a
href="http://mifo.org" target="_blank">mifo.org</a> in the next few months, but
&nbsp;for now, it's a bit bumpy.</span></font><o:p></o:p></p>

<p><font size=2 color=blue face=Calibri><span style='font-size:11.0pt;
font-family:Calibri;color:blue'>&nbsp;</span></font><o:p></o:p></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center>

</span></font></div>

<p><b><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
font-weight:bold'>From:</span></font></b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'> <a
href="mailto:mifos-developer-bounces@lists.sourceforge.net" \
target="_blank">mifos-developer-bounces@lists.sourceforge.net</a> [mailto:<a \
href="mailto:mifos-developer-bounces@lists.sourceforge.net" \
target="_blank">mifos-developer-bounces@lists.sourceforge.net</a>] <b><span \
style='font-weight:bold'>On Behalf Of </span></b>Mark Kavanagh<br> <b><span \
style='font-weight:bold'>Sent:</span></b> Friday, September 28, 2007 2:45 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <a
href="mailto:mifos-developer@lists.sourceforge.net" \
target="_blank">mifos-developer@lists.sourceforge.net</a><br> <b><span \
style='font-weight:bold'>Subject:</span></b> [Mifos-developer] Adding data to a blank \
Mifos Database</span></font><o:p></o:p></p>

</div>

<div><span id="q_1154b982538be515_1">

<p><font size=3 face="Times New Roman"><span \
style='font-size:12.0pt'>&nbsp;<o:p></o:p></span></font></p>

<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Hi <br>
<br>
I've set up Mifos environment ( mySQL 4.1.22, JBoss 4.0.5 ) with blank database
and would like to populate<br>
it with data to do some performance tests..<br>
How have people been populating their blank databases so far to execute tests
or whats the best way to approach <br>
this so i have meaningful data to simulate ? <br>
Would like to have data to simulate a typical mid size MFI , i.e 120,000
clients with 4 accounts each..<br>
<br>
any direction appreciated , Thanks ! <o:p></o:p></span></font></p>

</div>

</div>

</div>

</span>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br>
---------- Forwarded message ----------<br>
From:&nbsp;&quot;Mohammed Nyamatullah&quot; &lt;<a
href="mailto:nyamat.signup@gmail.com">nyamat.signup@gmail.com</a>&gt;<br>
To:&nbsp;&quot;<st1:PersonName w:st="on">Developer</st1:PersonName>&quot; &lt;<a
href="mailto:mifos-developer@lists.sourceforge.net">
mifos-developer@lists.sourceforge.net</a>&gt;<br>
Date:&nbsp;Mon, 24 Sep 2007 12:47:37 -0400<br>
Subject:&nbsp;Re: [Mifos-developer] FW: Milestone 1 and test \
database<o:p></o:p></span></font></p>

<div>

<p><font size=2 face="Times New Roman"><span style='font-size:10.0pt'>On
9/24/07, Massimiliano Parlione &lt;<a href="mailto:parlione@hotmail.com"
target="_blank">parlione@hotmail.com</a>&gt; wrote:</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt;</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; Hi all,</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; my team is trying to setup an
enviroment for Mifos Milestone 1.</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt;</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; We have checked out MIFOS
(revision 11704), build it and installed it. Since</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; we didn't have any test data
we decided to upload the data located in the</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; perfomance-tests directory in
the Mifos SVN:</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt;
120000CUstomers-200000Loans-220000Savings1.zip</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt;</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; Unfortunately we got this
error:</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt;</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; Mifos Database Upgrade \
Error</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; The system was not able to
automatically upgrade the database. Correct the</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; error and restart the
application.</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; I have noticed that there is a
page describing how to handle the case where</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; the database version and the
application version don't match</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; (<a
href="http://mifos.org/developers/technical-orientation/coding-standards#databasestandards"
 target="_blank">http://mifos.org/developers/technical-orientation/coding-standards#databasestandards
 </a>)</span></font> <br>
<font size=2><span style='font-size:10.0pt'>&gt; but in our case we have an
empty column.</span></font> <o:p></o:p></p>

<p><font size=2 face="Times New Roman"><span style='font-size:10.0pt'>Hi
Parlione ,</span></font> <br>
<font size=2><span style='font-size:10.0pt'>The testdata you have taken is
prettyy old. Just check the following</span></font> <br>
<font size=2><span style='font-size:10.0pt'>if you want to upgrade the same
database.</span></font> <o:p></o:p></p>

<p><font size=2 face="Times New Roman"><span style='font-size:10.0pt'><a
href="http://mifos.org/developers/technical-orientation/mifos-database-development"
target="_blank">http://mifos.org/developers/technical-orientation/mifos-database-development
 </a></span></font><br>
<font size=2><span style='font-size:10.0pt'>Please refer to section Older
databases (December 2006 or older)</span></font> <o:p></o:p></p>

<p><font size=2 face="Times New Roman"><span style='font-size:10.0pt'>Mohammed
Nyamatullah</span></font> <o:p></o:p></p>

<p><font size=2 face="Times New Roman"><span \
style='font-size:10.0pt'>-------------------------------------------------------------------------</span></font>
 <br>
<font size=2><span style='font-size:10.0pt'>This SF.net email is sponsored by:
Microsoft</span></font> <br>
<font size=2><span style='font-size:10.0pt'>Defy all challenges. Microsoft(R)
Visual Studio 2005.</span></font> <br>
<font size=2><span style='font-size:10.0pt'><a
href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" \
target="_blank">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a></span></font>
 <o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
-------------------------------------------------------------------------<br>
This SF.net email is sponsored by: Microsoft<br>
Defy all challenges. Microsoft(R) Visual Studio 2005.<br>
<a href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/"
target="_blank">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a><o:p></o:p></span></font></p>


</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</div>

</body>

</html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic