[
http://mifosforge.jira.com/browse/MIFOS-4301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62810#action_62810
]
keithwoodlock commented on MIFOS-4301:
--------------------------------------
Gayl,
yes savings is suffering from the same problems as seen in loans.
I have checked making payments manually via the 'apply payment' and
'depoit/withdrawal' and also via the collection sheet process and they both
worked successfully creating the right transactions.
But somehow lots of your data does not have 'account_payments' associated with
it which is very strange. So i quickly checked the 'account_payment' table and
its 'primary_ids' which are auto generated goes from 1 up to 1186, nothing
unusual there, then theres a big gap in the id increment, the next value is
9084.
Drafted in the help of John Woodlock on this cause its very weird and it looks
like your database is missing LOTS of account_payment information.
Running the following query show me the number account_trxns missing their
parent account_payment:
{panel}
select count(*) from account_trxn att
where not exists (select 'f' from account_payment ap where ap.payment_id =
att.payment_id)
{panel}
It comes out as 8553 on my local snapshot of your backed up data.
So how could this happen?
It is not possible to do this via the application (i.e. through web interface
etc) and this will be the cause of a lot of other problems you may be seeing
e.g. closing savings account etc
{panel}
org.hibernate.ObjectNotFoundException: No row with the given
identifier exists:
[org.mifos.accounts.business.AccountPaymentEntity#6114]
{panel}
Somehow the database contraints between account_payment and account_trxns were
removed and all account_payment data between 2010-09-17 and 2010-11-26 is
basically gone buts its account_trxns and related financial trxns still remain.
John seemed to think that it was possible that it might have been a
restore/backup gone wrong etc.
Can we recover?
At the moment it looks like its possible to derive the account_payment
information from the 'account_trxn' but some information that is
'account_payment' specific would not be possible such as 'receipt_id'.
I will raise this with Ed/Kay and others today
> Transaction history does not provide all details for some accounts even
> though see transactions on summary screen
> -----------------------------------------------------------------------------------------------------------------
>
> Key: MIFOS-4301
> URL: http://mifosforge.jira.com/browse/MIFOS-4301
> Project: mifos
> Issue Type: Bug
> Affects Versions: Release 1.6.0, Release 1.6.1
> Reporter: Gayl Kennedy
> Assignee: keithwoodlock
> Attachments: transaction history issue.ppt
>
>
> Not for all centres but for at least one (e.g. Yan Masa II) you can see in
> the Transaction history screen only the initial deposit for their savings and
> the initial disbursement for their loan but in the recent Activity summary or
> in the View All Account Activity screen you can see additional payments,
> interest postings etc. See screen shot provided in ppt.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
This SF Dev2Dev email is sponsored by:
WikiLeaks The End of the Free Internet
http://p.sf.net/sfu/therealnews-com
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
