Re: [Mifos-users] Database integrity audit queries

2010-12-07 Thread Gayl Kennedy
Hi, we are still investigating. It was quite a shock on Monday morning to discover all loans and savings were zero! There were some error messages on the log at startup of the server so Tolu has implemented a planned shut down every evening instead of just having someone in the IT dept. power dow

Re: [Mifos-users] Database integrity audit queries

2010-12-07 Thread Edward Cable
Ryan, As FYI, Keith Woodlock (prior to this happening) was planning to spend a little time looking at their database and configuration to troubleshoot other outstanding issues. He now has their database and their logs so perhaps he will find something there. Gayl, please do share any details y

Re: [Mifos-users] Database integrity audit queries

2010-12-07 Thread Ryan Whitney
Gayl, Sorry to hear about your data issue. This is also troubling as I've never heard of anything happening within Mifos before, neither can I fathom how this is possible. Can you shed some more light into what happened? Have you done an investigation into what happened? Do you believe this ca

Re: [Mifos-users] Interest Calculations for Loan Accounts -Declining Balance Interest (EMI of Principal and Interest)

2010-12-07 Thread Ryan Whitney
Miguel, I believe what this means is that its not applied for generation of meeting schedules. I can see how its confusing to read, but its meant to be clear about the interest. Best way to determine this would be to test these scenarios out. Ryan On 12/1/10 1:36 AM, "Miguel Jóia Santos" wro

Re: [Mifos-users] Holidays and LSIM

2010-12-07 Thread Gayl Kennedy
hi Ryan I am not seeing consistency in how this is being applied but here is one example where the repayment is pushed out a month: Disbursal date: 20/09/2010 which was BEFORE the holiday was created! Group Loan C1-6 from PFD fund # 00010002226- 2 18-Nov-2010 18-Nov-2010 1666.67

[Mifos-users] Database integrity audit queries

2010-12-07 Thread Gayl Kennedy
Hi all We have been populating our mifos database since Sept and had our first major database corruption yesterday when we discovered all loans and savings had reverted to 0! We had to revert to a backup from Friday. My concern is that there could be minor corruption which we would not notice as e