Uploaded image for project: 'Archive mifos 2.x'
  1. MIFOS2X-2011

Duplicate transactions logged in bulk entry path

    Details

    • Sprint:

      Description

      REPRO (Rev 12212 and GK production DB)
      =================
      Prose repro rather than specific steps, since the issue doesn't have concrete
      repro steps yet. GK has been seeing regular (i.e. daily) instances of cases
      where bulk entry for a center is submitted but rather than just one transaction
      (e.g. one payment) being logged for the center for a particular loan account,
      multiple duplicate transactions are logged (one or two duplicate transactions)
      against the same account. These duplicate transactions look just like
      prepayments for the next installment on the loan, however are not valid because
      the user did not enter a pre-payment for the next installment.

      Additionally, duplicate disbursals also occur, however the symptoms of this
      issue display themselves differently in the DB because the DB enforces the
      business rule that there cannot be more than one disbursal transaction on a loan
      account in some tables. In other tables this is not enforced so there will be
      orphaned records that indicate a duplicate disbursal.

      Attached is a CSV file (and excel file) which show the duplicate transaction
      issue on once center in one branch at Grameen Koota which occurred on June 7th,
      2008. In this case, there are one or two duplicate payments for almost all of
      the accounts in the center. There are no examples of the duplicate disbursal
      issue because there were no due disbursals for this particular center at GK.

      The file shows the output for just the bulk entry transactions for the center in
      the account_txn table. Exact queries to identify this issue and the disbursal
      issue will be provided by GK later.

      Additional information:

      • There doesn't seem to be any pattern in the branches/centers for which this
        occurs. It seems to be evenly spread across branches (and evenly spread across
        those with slow and fast connections).
      • There is no other noticeable pattern that GK has identified in reproducing
        this issue. It varies in frequency but currently it is occurring in one or two
        branches daily.

        Attachments

        1. Coll_Sheet_AutomatedTest_failures.zip
          11 kB
        2. Collection_Sheet_Entry_Test.docx
          200 kB
        3. doublesubmit.xls
          21 kB
        4. doublesubmit.zip
          92 kB
        5. doublesubmit-excel2000.xls
          47 kB
        6. seedDataManyClients.py
          19 kB
        7. seedDataManyClients.py
          15 kB
        8. start-selenium-server.sh
          0.2 kB
        9. Test_Loans_March_26_2009.zip
          1.45 MB

          Activity

            People

            • Assignee:
              mifosdeveloperqueue mifosdeveloperqueue
              Reporter:
              aliyaw aliyaw (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: