Hi Stephen, If you are using Google chrome, right click and then click on inspect element. Then go to 'Network' mode and try to click on drop-down menu for 'repayment schedule type'.
Just take the screenshot and share with us. OR While clicking on drop-down menu , please share screenshot of tomcat log where you are running it. Regards Santosh On Thu, Nov 9, 2017 at 9:34 PM, Stephen Agyepong <stephenagyep...@gmail.com> wrote: > 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 < > sant...@confluxtechnologies.com> 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 < > > stephenagyep...@gmail.com> > > 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 < > > > sant...@confluxtechnologies.com> 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 < > > > > stephenagyep...@gmail.com> > > > > 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 < > > > > > sant...@confluxtechnologies.com> 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 < > > > > > > stephenagyep...@gmail.com> 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 <edca...@mifos.org> > > > 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 < > > > > > >> > sant...@confluxtechnologies.com> 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 < > edca...@mifos.org> > > > > > wrote: > > > > > >> > > > > > > > >> > >> Santosh, > > > > > >> > >> > > > > > >> > >> Could we document that as a solution in AnswerHub? > > > > > >> > >> > > > > > >> > >> Ed > > > > > >> > >> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math < > > > > > >> > >> sant...@confluxtechnologies.com> 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 < > > edca...@mifos.org> > > > > > >> 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 > > > > > >> > >>>> edca...@mifos.org | 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 > > > > > >> > >> edca...@mifos.org | 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 > > > > > >> > edca...@mifos.org | 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 > > > > > > mifos-develo...@lists.sourceforge.net > > > > > > Unsubscribe or change settings at: > > > > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > > > > > > > > > > > > > > > > > > > >
