Santosh, Please find below the screenshots. I have also attached them just in case. I see that both of these tables are empty: m_holiday m_holiday_office But m_working_days has an entry
Do they have anything to do with the problem? And how/what should be the settings? Thanks Stephen > > On > > > [image: Inline image 2] > > > [image: Inline image 1] > > On Fri, Nov 10, 2017 at 12:07 AM, Santosh Math < > [email protected]> wrote: > >> 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 < >> [email protected]> >> 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 < >> > [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.c >> om/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 >> > > > > > > >> > > > > > >> > > > > >> > > > >> > > >> > >> > >
