You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Fafa Akligo <jn...@gmail.com> on 2022/03/21 14:50:26 UTC

Date and Repayment issues

Hi everyone! I am a developer using Mifos in my organization and need some
support
1. When we create a Loan Application from the API it sets the Dates a day
earlier. For instance when the Creation date is March 15, 2022 it sets it
to March 14 2022 so we can only disburse from that date. And the repayment
schedule starts from March 14 too instead of March 15.

2. When we try using the following API it does not work and comes with the
attached error message.
POST
https://DomainName/api/v1/loans/1/schedule?command=calculateLoanSchedule
<https://domainname/api/v1/loans/1/schedule?command=calculateLoanSchedule>
The response shows the repayment schedule change but the new schedule does
not show on the UI

3. Sometimes when we try to Approve a loan from the API we get the message
below which is not descriptive enough. But I suspect it is due to the date
issue.{"timestamp":1647317430052,"status":500,"error":"Internal Server
Error","message":"","path":"/fineract-provider/api/v1/loans/{loanId}"

Re: Date and Repayment issues

Posted by Kigred Developer <ki...@gmail.com>.
Thank You.

On Thu, Mar 24, 2022 at 10:21 AM Bharath Gowda <bg...@mifos.org> wrote:

> Hi Wilfred,
>
> I am glad you were able to solve this issue.
> I have commented on the ticket as well to help others in the future.
>
>
>
> Regards,
> Bharath
> Lead Implementation Analyst | Mifos Initiative
> Skype: live:cbharath4| Mobile: +91.7019635592
> http://mifos.org  <http://facebook.com/mifos>
> <http://www.twitter.com/mifos>
>
>
> On Wed, Mar 23, 2022 at 6:40 PM Kigred Developer <
> kigred.developer@gmail.com> wrote:
>
>> Hi Gowda,
>>
>> This helped sort out the issue. Item number 2, section 1 of your response
>> however is not mentioned on the link below.
>> *2. Check if server and DB hosted instances are of the same time zone as
>> the user time zone*
>>
>> https://issues.apache.org/jira/browse/FINERACT-1309.
>>
>> I believe it will be helpful if it is mentioned here. It will give a more
>> complete solution for anyone that runs into the same issue.
>>
>> Regards.
>> Wilfred
>>
>> On Tue, Mar 22, 2022 at 9:24 AM Bharath Gowda <bg...@mifos.org> wrote:
>>
>>> Hi Fafa,
>>>
>>> My 2 cents,
>>>
>>> Date issues usually happen when the timezones are not set properly
>>>
>>> 1. Check timezone is set right at the table 'tenants' under
>>> 'fineract_tenants' DB
>>> 2. Check if server and DB hosted instances are of the same time zone as
>>> the user time zone
>>>
>>>
>>> Few other things to check from your end
>>>
>>> 1. Check the version of Front end and Fineract are correct (if you had
>>> downloaded mifos 21.07.01 files from sourceforge, then ignore this step)
>>> 2. On the Organization settings, check if you have configured the
>>> working days and holidays, usually system will reschedule as per the
>>> working days and holidays specification
>>> Document on that is here:
>>> https://mifosforge.jira.com/wiki/spaces/docs/pages/90243212/Working+Days
>>>
>>> https://mifosforge.jira.com/wiki/spaces/docs/pages/67141730/Manage+Holidays
>>>
>>> If you are still facing the issue, please share the exact product
>>> configuration and steps for helping you out further, screenshots would
>>> be helpful as well.
>>>
>>> Regards,
>>> Bharath
>>> Lead Implementation Analyst | Mifos Initiative
>>> Skype: live:cbharath4| Mobile: +91.7019635592
>>> http://mifos.org  <http://facebook.com/mifos>
>>> <http://www.twitter.com/mifos>
>>>
>>>
>>> On Mon, Mar 21, 2022 at 8:39 PM James Dailey <ja...@gmail.com>
>>> wrote:
>>>
>>>> Fafa
>>>>
>>>> Welcome to the community.
>>>>
>>>> You may find your answer in the documentation at Fineract.Apache.org
>>>> or in this listserv archives.
>>>> Also, see the jira tickets at Apache Fineract and at Mifos forge. If
>>>> you find your same issue, give it a bump or propose a fix.
>>>>
>>>> Please:
>>>> 1) check all existing info sources
>>>> 2) when discussing an issue, provide info on version of Mifos/Fineract
>>>> (issues may already be resolved in later version and you may be on an old
>>>> one)
>>>> 3) any particulars w reproducing the error
>>>>
>>>> Note that bugs in the Mifos UI should be solved at Mifos and bugs in
>>>> the backend at Fineract project.
>>>>
>>>> This is mostly general info.  Hope it helps.
>>>>
>>>>
>>>>
>>>> On Mon, Mar 21, 2022 at 7:57 AM Fafa Akligo <jn...@gmail.com> wrote:
>>>>
>>>>> Hi everyone! I am a developer using Mifos in my organization and need
>>>>> some support
>>>>> 1. When we create a Loan Application from the API it sets the Dates a
>>>>> day earlier. For instance when the Creation date is March 15, 2022 it sets
>>>>> it to March 14 2022 so we can only disburse from that date. And the
>>>>> repayment schedule starts from March 14 too instead of March 15.
>>>>>
>>>>> 2. When we try using the following API it does not work and comes with
>>>>> the attached error message.
>>>>> POST
>>>>> https://DomainName/api/v1/loans/1/schedule?command=calculateLoanSchedule
>>>>> <https://domainname/api/v1/loans/1/schedule?command=calculateLoanSchedule>
>>>>> The response shows the repayment schedule change but the new schedule
>>>>> does not show on the UI
>>>>>
>>>>> 3. Sometimes when we try to Approve a loan from the API we get the
>>>>> message below which is not descriptive enough. But I suspect it is due to
>>>>> the date issue.{"timestamp":1647317430052,"status":500,"error":"Internal
>>>>> Server Error","message":"","path":"/fineract-provider/api/v1/loans/{loanId}"
>>>>>
>>>> --
>>>> Sent from Gmail Mobile
>>>>
>>>

Re: Date and Repayment issues

Posted by Bharath Gowda <bg...@mifos.org>.
Hi Wilfred,

I am glad you were able to solve this issue.
I have commented on the ticket as well to help others in the future.



Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019635592
http://mifos.org  <http://facebook.com/mifos>
<http://www.twitter.com/mifos>


On Wed, Mar 23, 2022 at 6:40 PM Kigred Developer <ki...@gmail.com>
wrote:

> Hi Gowda,
>
> This helped sort out the issue. Item number 2, section 1 of your response
> however is not mentioned on the link below.
> *2. Check if server and DB hosted instances are of the same time zone as
> the user time zone*
>
> https://issues.apache.org/jira/browse/FINERACT-1309.
>
> I believe it will be helpful if it is mentioned here. It will give a more
> complete solution for anyone that runs into the same issue.
>
> Regards.
> Wilfred
>
> On Tue, Mar 22, 2022 at 9:24 AM Bharath Gowda <bg...@mifos.org> wrote:
>
>> Hi Fafa,
>>
>> My 2 cents,
>>
>> Date issues usually happen when the timezones are not set properly
>>
>> 1. Check timezone is set right at the table 'tenants' under
>> 'fineract_tenants' DB
>> 2. Check if server and DB hosted instances are of the same time zone as
>> the user time zone
>>
>>
>> Few other things to check from your end
>>
>> 1. Check the version of Front end and Fineract are correct (if you had
>> downloaded mifos 21.07.01 files from sourceforge, then ignore this step)
>> 2. On the Organization settings, check if you have configured the working
>> days and holidays, usually system will reschedule as per the working days
>> and holidays specification
>> Document on that is here:
>> https://mifosforge.jira.com/wiki/spaces/docs/pages/90243212/Working+Days
>>
>> https://mifosforge.jira.com/wiki/spaces/docs/pages/67141730/Manage+Holidays
>>
>> If you are still facing the issue, please share the exact product
>> configuration and steps for helping you out further, screenshots would
>> be helpful as well.
>>
>> Regards,
>> Bharath
>> Lead Implementation Analyst | Mifos Initiative
>> Skype: live:cbharath4| Mobile: +91.7019635592
>> http://mifos.org  <http://facebook.com/mifos>
>> <http://www.twitter.com/mifos>
>>
>>
>> On Mon, Mar 21, 2022 at 8:39 PM James Dailey <ja...@gmail.com>
>> wrote:
>>
>>> Fafa
>>>
>>> Welcome to the community.
>>>
>>> You may find your answer in the documentation at Fineract.Apache.org or
>>> in this listserv archives.
>>> Also, see the jira tickets at Apache Fineract and at Mifos forge. If you
>>> find your same issue, give it a bump or propose a fix.
>>>
>>> Please:
>>> 1) check all existing info sources
>>> 2) when discussing an issue, provide info on version of Mifos/Fineract
>>> (issues may already be resolved in later version and you may be on an old
>>> one)
>>> 3) any particulars w reproducing the error
>>>
>>> Note that bugs in the Mifos UI should be solved at Mifos and bugs in the
>>> backend at Fineract project.
>>>
>>> This is mostly general info.  Hope it helps.
>>>
>>>
>>>
>>> On Mon, Mar 21, 2022 at 7:57 AM Fafa Akligo <jn...@gmail.com> wrote:
>>>
>>>> Hi everyone! I am a developer using Mifos in my organization and need
>>>> some support
>>>> 1. When we create a Loan Application from the API it sets the Dates a
>>>> day earlier. For instance when the Creation date is March 15, 2022 it sets
>>>> it to March 14 2022 so we can only disburse from that date. And the
>>>> repayment schedule starts from March 14 too instead of March 15.
>>>>
>>>> 2. When we try using the following API it does not work and comes with
>>>> the attached error message.
>>>> POST
>>>> https://DomainName/api/v1/loans/1/schedule?command=calculateLoanSchedule
>>>> <https://domainname/api/v1/loans/1/schedule?command=calculateLoanSchedule>
>>>> The response shows the repayment schedule change but the new schedule
>>>> does not show on the UI
>>>>
>>>> 3. Sometimes when we try to Approve a loan from the API we get the
>>>> message below which is not descriptive enough. But I suspect it is due to
>>>> the date issue.{"timestamp":1647317430052,"status":500,"error":"Internal
>>>> Server Error","message":"","path":"/fineract-provider/api/v1/loans/{loanId}"
>>>>
>>> --
>>> Sent from Gmail Mobile
>>>
>>

Re: Date and Repayment issues

Posted by Kigred Developer <ki...@gmail.com>.
Hi Gowda,

This helped sort out the issue. Item number 2, section 1 of your response
however is not mentioned on the link below.
*2. Check if server and DB hosted instances are of the same time zone as
the user time zone*

https://issues.apache.org/jira/browse/FINERACT-1309.

I believe it will be helpful if it is mentioned here. It will give a more
complete solution for anyone that runs into the same issue.

Regards.
Wilfred

On Tue, Mar 22, 2022 at 9:24 AM Bharath Gowda <bg...@mifos.org> wrote:

> Hi Fafa,
>
> My 2 cents,
>
> Date issues usually happen when the timezones are not set properly
>
> 1. Check timezone is set right at the table 'tenants' under
> 'fineract_tenants' DB
> 2. Check if server and DB hosted instances are of the same time zone as
> the user time zone
>
>
> Few other things to check from your end
>
> 1. Check the version of Front end and Fineract are correct (if you had
> downloaded mifos 21.07.01 files from sourceforge, then ignore this step)
> 2. On the Organization settings, check if you have configured the working
> days and holidays, usually system will reschedule as per the working days
> and holidays specification
> Document on that is here:
> https://mifosforge.jira.com/wiki/spaces/docs/pages/90243212/Working+Days
> https://mifosforge.jira.com/wiki/spaces/docs/pages/67141730/Manage+Holidays
>
> If you are still facing the issue, please share the exact product
> configuration and steps for helping you out further, screenshots would
> be helpful as well.
>
> Regards,
> Bharath
> Lead Implementation Analyst | Mifos Initiative
> Skype: live:cbharath4| Mobile: +91.7019635592
> http://mifos.org  <http://facebook.com/mifos>
> <http://www.twitter.com/mifos>
>
>
> On Mon, Mar 21, 2022 at 8:39 PM James Dailey <ja...@gmail.com>
> wrote:
>
>> Fafa
>>
>> Welcome to the community.
>>
>> You may find your answer in the documentation at Fineract.Apache.org or
>> in this listserv archives.
>> Also, see the jira tickets at Apache Fineract and at Mifos forge. If you
>> find your same issue, give it a bump or propose a fix.
>>
>> Please:
>> 1) check all existing info sources
>> 2) when discussing an issue, provide info on version of Mifos/Fineract
>> (issues may already be resolved in later version and you may be on an old
>> one)
>> 3) any particulars w reproducing the error
>>
>> Note that bugs in the Mifos UI should be solved at Mifos and bugs in the
>> backend at Fineract project.
>>
>> This is mostly general info.  Hope it helps.
>>
>>
>>
>> On Mon, Mar 21, 2022 at 7:57 AM Fafa Akligo <jn...@gmail.com> wrote:
>>
>>> Hi everyone! I am a developer using Mifos in my organization and need
>>> some support
>>> 1. When we create a Loan Application from the API it sets the Dates a
>>> day earlier. For instance when the Creation date is March 15, 2022 it sets
>>> it to March 14 2022 so we can only disburse from that date. And the
>>> repayment schedule starts from March 14 too instead of March 15.
>>>
>>> 2. When we try using the following API it does not work and comes with
>>> the attached error message.
>>> POST
>>> https://DomainName/api/v1/loans/1/schedule?command=calculateLoanSchedule
>>> <https://domainname/api/v1/loans/1/schedule?command=calculateLoanSchedule>
>>> The response shows the repayment schedule change but the new schedule
>>> does not show on the UI
>>>
>>> 3. Sometimes when we try to Approve a loan from the API we get the
>>> message below which is not descriptive enough. But I suspect it is due to
>>> the date issue.{"timestamp":1647317430052,"status":500,"error":"Internal
>>> Server Error","message":"","path":"/fineract-provider/api/v1/loans/{loanId}"
>>>
>> --
>> Sent from Gmail Mobile
>>
>

Re: [Mifos-users] Date and Repayment issues

Posted by Francis Guchie <fr...@gmail.com>.
Hi Fafa

Please read the following issue
https://issues.apache.org/jira/browse/FINERACT-1309
also read the comments on these pages below
https://mifosforge.jira.com/wiki/spaces/docs/pages/2809626625/Mifos+21.07.01+Installation+on+Tomcat-Windows?focusedCommentId=3035463690#comment-3035463690

&
https://mifosforge.jira.com/wiki/spaces/docs/pages/2824142857/Mifos+21.07.01+Installation+on+Tomcat-Ubuntu+18.04?focusedCommentId=3035561986#comment-3035561986





My Kind Regards

Francis Guchie Kirago
*Skype:* francisguchie
*Telegram: *232 79 19 44 07
*Whatsapp: *232 79 19 44 07
*LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/
twitter: @FrancisGuchie









On Tue, Mar 22, 2022 at 8:28 AM Bharath Gowda <bg...@mifos.org> wrote:

> Hi Fafa,
>
> My 2 cents,
>
> Date issues usually happen when the timezones are not set properly
>
> 1. Check timezone is set right at the table 'tenants' under
> 'fineract_tenants' DB
> 2. Check if server and DB hosted instances are of the same time zone as
> the user time zone
>
>
> Few other things to check from your end
>
> 1. Check the version of Front end and Fineract are correct (if you had
> downloaded mifos 21.07.01 files from sourceforge, then ignore this step)
> 2. On the Organization settings, check if you have configured the working
> days and holidays, usually system will reschedule as per the working days
> and holidays specification
> Document on that is here:
> https://mifosforge.jira.com/wiki/spaces/docs/pages/90243212/Working+Days
> https://mifosforge.jira.com/wiki/spaces/docs/pages/67141730/Manage+Holidays
>
> If you are still facing the issue, please share the exact product
> configuration and steps for helping you out further, screenshots would
> be helpful as well.
>
> Regards,
> Bharath
> Lead Implementation Analyst | Mifos Initiative
> Skype: live:cbharath4| Mobile: +91.7019635592
> http://mifos.org  <http://facebook.com/mifos>
> <http://www.twitter.com/mifos>
>
>
> On Mon, Mar 21, 2022 at 8:39 PM James Dailey <ja...@gmail.com>
> wrote:
>
>> Fafa
>>
>> Welcome to the community.
>>
>> You may find your answer in the documentation at Fineract.Apache.org or
>> in this listserv archives.
>> Also, see the jira tickets at Apache Fineract and at Mifos forge. If you
>> find your same issue, give it a bump or propose a fix.
>>
>> Please:
>> 1) check all existing info sources
>> 2) when discussing an issue, provide info on version of Mifos/Fineract
>> (issues may already be resolved in later version and you may be on an old
>> one)
>> 3) any particulars w reproducing the error
>>
>> Note that bugs in the Mifos UI should be solved at Mifos and bugs in the
>> backend at Fineract project.
>>
>> This is mostly general info.  Hope it helps.
>>
>>
>>
>> On Mon, Mar 21, 2022 at 7:57 AM Fafa Akligo <jn...@gmail.com> wrote:
>>
>>> Hi everyone! I am a developer using Mifos in my organization and need
>>> some support
>>> 1. When we create a Loan Application from the API it sets the Dates a
>>> day earlier. For instance when the Creation date is March 15, 2022 it sets
>>> it to March 14 2022 so we can only disburse from that date. And the
>>> repayment schedule starts from March 14 too instead of March 15.
>>>
>>> 2. When we try using the following API it does not work and comes with
>>> the attached error message.
>>> POST
>>> https://DomainName/api/v1/loans/1/schedule?command=calculateLoanSchedule
>>> <https://domainname/api/v1/loans/1/schedule?command=calculateLoanSchedule>
>>> The response shows the repayment schedule change but the new schedule
>>> does not show on the UI
>>>
>>> 3. Sometimes when we try to Approve a loan from the API we get the
>>> message below which is not descriptive enough. But I suspect it is due to
>>> the date issue.{"timestamp":1647317430052,"status":500,"error":"Internal
>>> Server Error","message":"","path":"/fineract-provider/api/v1/loans/{loanId}"
>>>
>> --
>> Sent from Gmail Mobile
>>
> _______________________________________________
> Mifos-users mailing list
> Mifos-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>

Re: Date and Repayment issues

Posted by Bharath Gowda <bg...@mifos.org>.
Hi Fafa,

My 2 cents,

Date issues usually happen when the timezones are not set properly

1. Check timezone is set right at the table 'tenants' under
'fineract_tenants' DB
2. Check if server and DB hosted instances are of the same time zone as the
user time zone


Few other things to check from your end

1. Check the version of Front end and Fineract are correct (if you had
downloaded mifos 21.07.01 files from sourceforge, then ignore this step)
2. On the Organization settings, check if you have configured the working
days and holidays, usually system will reschedule as per the working days
and holidays specification
Document on that is here:
https://mifosforge.jira.com/wiki/spaces/docs/pages/90243212/Working+Days
https://mifosforge.jira.com/wiki/spaces/docs/pages/67141730/Manage+Holidays

If you are still facing the issue, please share the exact product
configuration and steps for helping you out further, screenshots would
be helpful as well.

Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019635592
http://mifos.org  <http://facebook.com/mifos>
<http://www.twitter.com/mifos>


On Mon, Mar 21, 2022 at 8:39 PM James Dailey <ja...@gmail.com> wrote:

> Fafa
>
> Welcome to the community.
>
> You may find your answer in the documentation at Fineract.Apache.org or
> in this listserv archives.
> Also, see the jira tickets at Apache Fineract and at Mifos forge. If you
> find your same issue, give it a bump or propose a fix.
>
> Please:
> 1) check all existing info sources
> 2) when discussing an issue, provide info on version of Mifos/Fineract
> (issues may already be resolved in later version and you may be on an old
> one)
> 3) any particulars w reproducing the error
>
> Note that bugs in the Mifos UI should be solved at Mifos and bugs in the
> backend at Fineract project.
>
> This is mostly general info.  Hope it helps.
>
>
>
> On Mon, Mar 21, 2022 at 7:57 AM Fafa Akligo <jn...@gmail.com> wrote:
>
>> Hi everyone! I am a developer using Mifos in my organization and need
>> some support
>> 1. When we create a Loan Application from the API it sets the Dates a day
>> earlier. For instance when the Creation date is March 15, 2022 it sets it
>> to March 14 2022 so we can only disburse from that date. And the repayment
>> schedule starts from March 14 too instead of March 15.
>>
>> 2. When we try using the following API it does not work and comes with
>> the attached error message.
>> POST
>> https://DomainName/api/v1/loans/1/schedule?command=calculateLoanSchedule
>> <https://domainname/api/v1/loans/1/schedule?command=calculateLoanSchedule>
>> The response shows the repayment schedule change but the new schedule
>> does not show on the UI
>>
>> 3. Sometimes when we try to Approve a loan from the API we get the
>> message below which is not descriptive enough. But I suspect it is due to
>> the date issue.{"timestamp":1647317430052,"status":500,"error":"Internal
>> Server Error","message":"","path":"/fineract-provider/api/v1/loans/{loanId}"
>>
> --
> Sent from Gmail Mobile
>

Re: Date and Repayment issues

Posted by James Dailey <ja...@gmail.com>.
Fafa

Welcome to the community.

You may find your answer in the documentation at Fineract.Apache.org or in
this listserv archives.
Also, see the jira tickets at Apache Fineract and at Mifos forge. If you
find your same issue, give it a bump or propose a fix.

Please:
1) check all existing info sources
2) when discussing an issue, provide info on version of Mifos/Fineract
(issues may already be resolved in later version and you may be on an old
one)
3) any particulars w reproducing the error

Note that bugs in the Mifos UI should be solved at Mifos and bugs in the
backend at Fineract project.

This is mostly general info.  Hope it helps.



On Mon, Mar 21, 2022 at 7:57 AM Fafa Akligo <jn...@gmail.com> wrote:

> Hi everyone! I am a developer using Mifos in my organization and need some
> support
> 1. When we create a Loan Application from the API it sets the Dates a day
> earlier. For instance when the Creation date is March 15, 2022 it sets it
> to March 14 2022 so we can only disburse from that date. And the repayment
> schedule starts from March 14 too instead of March 15.
>
> 2. When we try using the following API it does not work and comes with the
> attached error message.
> POST
> https://DomainName/api/v1/loans/1/schedule?command=calculateLoanSchedule
> <https://domainname/api/v1/loans/1/schedule?command=calculateLoanSchedule>
> The response shows the repayment schedule change but the new schedule does
> not show on the UI
>
> 3. Sometimes when we try to Approve a loan from the API we get the message
> below which is not descriptive enough. But I suspect it is due to the date
> issue.{"timestamp":1647317430052,"status":500,"error":"Internal Server
> Error","message":"","path":"/fineract-provider/api/v1/loans/{loanId}"
>
-- 
Sent from Gmail Mobile