Adding +Yubaraj and +Gbenga who are facing same type of issues in different
scenarios.
Hi Stephen,
Sorry for delayed reply.
Nazeer, considering Stephen's explaination, Could it be the same reason
for Gbenga and Yubaraj as well for drop-down currency not appearing?
.
Santosh
On Tue, Nov 14, 2017 at 10:59 AM, Stephen Agyepong <
stephenagyep...@gmail.com> wrote:
> 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 <
> stephenagyep...@gmail.com> 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 <
>>> sant...@confluxtechnologies.com> 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 <
>>>> 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/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 <
>>>> 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.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 <
>>>> > 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
>>>> > > > > > >
>>>> > > > > >
>>>> > > > >
>>>> > > >
>>>> > >
>>>> >
>>>>
>>>
>>>
>>
>
