Hi All,
I did some digging with my problem ("Repayment Scheduleing Type" of the
"Create Holiday" feature's dropdown list is empty) and found the following
issue.
The https://localhost:8443/fineract-provider/api/v1/holidays/template
endpoint:
is missing in the Fineract 1.0.0 branch but exists in the develop branch
package org.apache.fineract.organisation.holiday.api;
@Path("/holidays")
@Component
@Scope("singleton")
public class HolidaysApiResource {
@GET
@Path("/template")
@Consumes({MediaType.APPLICATION_JSON})
@Produces({MediaType.APPLICATION_JSON})
public String retrieveRepaymentScheduleUpdationTyeOptions(@Context
final UriInfo uriInfo){
this.context.authenticatedUser().validateHasReadPermission(HOLIDAY_RESOURCE_NAME);
return
this.toApiJsonSerializer.serialize(this.holidayReadPlatformService.retrieveRepaymentScheduleUpdationTyeOptions());
}
Also the following tables are empty:
m_holiday
m_holiday_office
Do we fix the tables or code to resolve the issue?
Thanks
Stephen
On Mon, Nov 13, 2017 at 9:01 AM, Stephen Agyepong <[email protected]
> wrote:
> 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/wi
>>> ki/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
>>> > > > > > >
>>> > > > > >
>>> > > > >
>>> > > >
>>> > >
>>> >
>>>
>>
>>
>
