Santosh,
I created a fresh database and ran
$ ..\gradlew clean tomcatrunwar
The database got populated.
I see, for example, the following entry in m_working_days
id recurrence
repayment_rescheduling_enum
extend_term_daily_repayments extend_term_holiday_repayment
1 FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR,SA,SU 2
false
false
But "Repayment Scheduleing Type*" still not populated
Thanks
Stephen
On Wed, Nov 8, 2017 at 11:57 PM, Santosh Math <
[email protected]> wrote:
> Hi Stephen,
>
> You need not run the command,
>
> \gradlew migrateTenantListDB -PdbName=mifosplatform-tenants
>
> 1. Just create a new fresh database 'mifostenant-default'.
>
> 2. And run ./gradlew clean tomcatrunwar
>
> Migration should happen automatically.
>
> Regards
> Santosh
>
> On Wed, Nov 8, 2017 at 9:19 PM, Stephen Agyepong <
> [email protected]>
> wrote:
>
> > 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
> > > > >
> > > >
> > >
> >
>
