Santosh,
I dropped the databases. But got the following error when I try to
re-create:
$ mysql -u root -pmysql
mysql> DROP DATABASE IF EXISTS `mifostenant-default`;
mysql> DROP DATABASE IF EXISTS `mifosplatform-tenants`;
mysql> CREATE DATABASE `mifosplatform-tenants`;
mysql> CREATE DATABASE `mifostenant-default`;
..\gradlew migrateTenantListDB -PdbName=mifosplatform-tenants
Listening for transport dt_socket at address: 8005
:migrateTenantListDB
Could not execute query
org.drizzle.jdbc.internal.common.query.DrizzleQuery@57466fb7: Table
'`mifosplatform-tenants`.`schema_version`' already exists
:migrateTenantListDB FAILED
FAILURE: Build failed with an exception.
* Where:
Build file 'C:\workspace\fineract\fineract\fineract-provider\build.gradle'
line: 461
* What went wrong:
Execution failed for task ':flywayMigrate'.
> Error occurred while executing flywayMigrate
Error executing statement at line 17: CREATE TABLE
`mifosplatform-tenants`.`schema_version` (
`version_rank` INT NOT NULL,
`installed_rank` INT NOT NULL,
`version` VARCHAR(50) NOT NULL,
`description` VARCHAR(200) NOT NULL,
`type` VARCHAR(20) NOT NULL,
`script` VARCHAR(1000) NOT NULL,
`checksum` INT,
`installed_by` VARCHAR(100) NOT NULL,
`installed_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`execution_time` INT NOT NULL,
`success` BOOL NOT NULL
) ENGINE=InnoDB
Table '`mifosplatform-tenants`.`schema_version`' already exists
Table '`mifosplatform-tenants`.`schema_version`' already exists
* Try:
Run with --stacktrace option to get the stack trace. Run with --info or
--debug option to get more log output.
BUILD FAILED
Total time: 3 mins 5.609 secs
On Wed, Nov 8, 2017 at 8:13 AM, Santosh Math <
[email protected]> wrote:
> Hi Stephen,
>
> Could you create new database and try the same with it?
>
>
> .Santosh
>
> On Wed, Nov 8, 2017 at 6:39 PM, Stephen Agyepong <
> [email protected]>
> wrote:
>
> > Santosh,
> >
> > I am running it locally on my laptop (Windows 10).
> > I guessed it was database related because when I point to the demo the
> list
> > is populated:
> > http://localhost:9002/?baseApiUrl=https://demo.openmf.org#/
> >
> > But when I point locally it is not populated:
> > https://localhost:8443/community-app/app/index.html#/
> > http://localhost:9002/?baseApiUrl=https://localhost:
> > 8443&tenantIdentifier=default
> > http://localhost:9002/?baseApiUrl=https://localhost:
> > 8443&tenantIdentifier=default#/createholiday
> >
> > Question is how do I fix this? I followed these links
> >
> > https://github.com/openMF/community-app/tree/develop
> > https://github.com/apache/fineract
> >
> > Run the following commands:
> >
> > 1. ./gradlew migrateTenantListDB -PdbName=mifosplatform-tenants
> > 2. ./gradlew migrateTenantDB -PdbName=mifostenant-default
> >
> >
> > Is it possible to get a copy of the demo DB on my local machine?
> >
> > Thanks
> >
> > Stephen
> >
> >
> > On Tue, Nov 7, 2017 at 11:20 PM, Santosh Math <
> > [email protected]> wrote:
> >
> > > Adding +Nazeer.
> > >
> > >
> > > Hi Stephen,
> > >
> > > It's more likely database migration issue at your side. Are you running
> > it
> > > locally in your machine or hosted somewhere?
> > >
> > >
> > > Regards
> > > Santosh
> > >
> > > On Tue, Nov 7, 2017 at 7:56 PM, Stephen Agyepong <
> > > [email protected]> wrote:
> > >
> > >> Hi,
> > >>
> > >> I am trying to setup a New Head Office on my local machine (Windows
> 10)
> > >> but
> > >> have issues.
> > >> For example, the "Repayment Scheduleing Type" of the "Create Holiday"
> > >> feature's dropdown list is empty.
> > >> How does it get populated?
> > >> I am following this link:
> > >> https://mifosforge.jira.com/wiki/spaces/docs/pages/67895348/
> > >> Initial+System+Set+Up?preview
> > >>
> > >> What am I missing?
> > >>
> > >> Thanks
> > >>
> > >> Stephen
> > >>
> > >> On Tue, Oct 31, 2017 at 12:25 PM, Ed Cable <[email protected]> wrote:
> > >>
> > >> > Thanks Santosh. I added bullet loan to the title for people that
> > search
> > >> > that.
> > >> >
> > >> > Ed
> > >> >
> > >> > On Tue, Oct 31, 2017 at 9:21 AM, Santosh Math <
> > >> > [email protected]> wrote:
> > >> >
> > >> > > Hi Ed,
> > >> > >
> > >> > > I documented it here with little more and concise description:
> > >> > >
> > >> > > http://mifos.cloud.answerhub.com/questions/2393/how-to-pay-
> > >> > > whole-principal-or-whole-principalinter.html?
> > >> > childToView=2394#answer-2394
> > >> > >
> > >> > > Related to variable instalment, I will reproduce the scenario and
> > let
> > >> me
> > >> > > come back on that.
> > >> > >
> > >> > > Thanks
> > >> > > Santosh
> > >> > >
> > >> > > On Tue, Oct 31, 2017 at 9:29 PM, Ed Cable <[email protected]>
> > wrote:
> > >> > >
> > >> > >> Santosh,
> > >> > >>
> > >> > >> Could we document that as a solution in AnswerHub?
> > >> > >>
> > >> > >> Ed
> > >> > >>
> > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > >> > >> [email protected]> wrote:
> > >> > >>
> > >> > >>> Hi Ed,
> > >> > >>>
> > >> > >>> I created one scenario here- all principal only paid at last
> > >> > instalment-
> > >> > >>> using moratorium on Principal payment.
> > >> > >>>
> > >> > >>> https://demo.openmf.org/#/viewloanaccount/1722
> > >> > >>>
> > >> > >>> If number of instalments are 'n' and then set moratorium on
> > >> principal
> > >> > >>> payment as 'n-1'
> > >> > >>>
> > >> > >>> in above link n=4.
> > >> > >>>
> > >> > >>>
> > >> > >>> Thanks
> > >> > >>> Santosh
> > >> > >>>
> > >> > >>> On Tue, Oct 31, 2017 at 7:59 PM, Ed Cable <[email protected]>
> > >> wrote:
> > >> > >>>
> > >> > >>>> Santosh or others,
> > >> > >>>>
> > >> > >>>> I was trying to test out configuration of a bullet loan (all
> > >> principal
> > >> > >>>> or principal/interest) to be repaid in the final installment of
> > the
> > >> > loan.
> > >> > >>>>
> > >> > >>>> I was going to try two approaches and ended up doing mix of the
> > >> two to
> > >> > >>>> achieve my purpose but I think it could be made easier.
> > >> > >>>>
> > >> > >>>> *Approach 1: *
> > >> > >>>> - Set loan term to # of months for total maturity of loan (i.e.
> > 24
> > >> > >>>> months)
> > >> > >>>> - Set # of repayments to 1.
> > >> > >>>>
> > >> > >>>> Expected: Repayment schedule has the 1 one repayment as the
> final
> > >> date
> > >> > >>>> in the maturity of the loan
> > >> > >>>>
> > >> > >>>> Actual: Repayment date is first due after disbursal (i.e. first
> > >> > month).
> > >> > >>>>
> > >> > >>>> Approach 2:
> > >> > >>>>
> > >> > >>>> - Create a full schedule
> > >> > >>>> - Modify repayment schedule and delete all the payments except
> > the
> > >> > last
> > >> > >>>> one and modify installments amount to be total.
> > >> > >>>>
> > >> > >>>> Expected: successful loan creation
> > >> > >>>>
> > >> > >>>> Actual: got several different errors even though I had set max
> > gap
> > >> in
> > >> > >>>> installment to be greater than the gap I was testing.
> > >> > >>>>
> > >> > >>>> validation.msg.loan.variable.schedule.date.must.be.in.min.ma
> > >> x.range
> > >> > >>>>
> > >> > >>>>
> > >> > >>>> Blended Approach:
> > >> > >>>>
> > >> > >>>> - At last I just did what I did in approach 1 and then i
> modified
> > >> > >>>> repayment schedule to adjust the installment date till the
> > maturity
> > >> > date.
> > >> > >>>> Originally I thought i had to do find this maturity date on my
> > own
> > >> > but then
> > >> > >>>> I realize it was displayed so this isn't too bad.
> > >> > >>>>
> > >> > >>>> Alternatively one could specify first repayment date as this
> > >> maturity
> > >> > >>>> date too.
> > >> > >>>>
> > >> > >>>> Is this the approach one should take?
> > >> > >>>>
> > >> > >>>> --
> > >> > >>>> *Ed Cable*
> > >> > >>>> President/CEO, Mifos Initiative
> > >> > >>>> [email protected] | Skype: edcable | Mobile: +1.484.477.8649
> > >> <(484)%20477-8649>
> > >> > >>>> <(484)%20477-8649>
> > >> > >>>>
> > >> > >>>> *Collectively Creating a World of 3 Billion Maries | *
> > >> > http://mifos.org
> > >> > >>>> <http://facebook.com/mifos> <http://www.twitter.com/mifos>
> > >> > >>>>
> > >> > >>>>
> > >> > >>>
> > >> > >>
> > >> > >>
> > >> > >> --
> > >> > >> *Ed Cable*
> > >> > >> President/CEO, Mifos Initiative
> > >> > >> [email protected] | Skype: edcable | Mobile: +1.484.477.8649
> > >> <(484)%20477-8649>
> > >> > >> <(484)%20477-8649>
> > >> > >>
> > >> > >> *Collectively Creating a World of 3 Billion Maries | *
> > >> http://mifos.org
> > >> > >> <http://facebook.com/mifos> <http://www.twitter.com/mifos>
> > >> > >>
> > >> > >>
> > >> > >
> > >> >
> > >> >
> > >> > --
> > >> > *Ed Cable*
> > >> > President/CEO, Mifos Initiative
> > >> > [email protected] | Skype: edcable | Mobile: +1.484.477.8649
> > >> <(484)%20477-8649>
> > >> >
> > >> > *Collectively Creating a World of 3 Billion Maries | *
> > http://mifos.org
> > >> > <http://facebook.com/mifos> <http://www.twitter.com/mifos>
> > >> >
> > >>
> > >
> > >
> > > ------------------------------------------------------------
> > > ------------------
> > > Check out the vibrant tech community on one of the world's most
> > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > > Mifos-developer mailing list
> > > [email protected]
> > > Unsubscribe or change settings at:
> > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > >
> >
>
