[
http://mifosforge.jira.com/browse/MIFOS-4301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62864#action_62864
]
Tolu Talabi commented on MIFOS-4301:
------------------------------------
We were able to find a backup from November 26th that had the missing
records from the account payment table.
I extracted the records from the backup and inserted them into our live
MIFOS instance.
I ran this query as a check:
select count(*) from account_trxn att
where not exists (select 'f' from account_payment ap where ap.payment_id
= att.payment_id)
and got no records returned.
I'll start compiling all these queries as part of a database integrity
check.
Thanks a lot, Gayl and Keith.
All hail Tipperary?
> 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
------------------------------------------------------------------------------
Oracle to DB2 Conversion Guide: Learn learn about native support for PL/SQL,
new data types, scalar functions, improved concurrency, built-in packages,
OCI, SQL*Plus, data movement tools, best practices and more.
http://p.sf.net/sfu/oracle-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
