Uploaded image for project: 'VPMS Web Application'
  1. OVPMS-1923

Limit the number of reminders that can be listed or exported

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects versions: 2.0
    • Fix versions: 2.0
    • Components: Reporting
    • Labels:
      None
    • Sprint:

      Description

      Patient List Reminders and Patient Export Reminders are each processed in a single batch by Reporting - Reminders - Send All. On successful completion of the list/export they are each batch updated in a single transaction. This ensures that if the update fails, the original list/export can be discarded and retried.

      At present, there is no limit on how many reminders can be processed in this way. In practice, large numbers may cause transaction timeouts.
      On one database, updating 20000 List reminders timed out and rolled back. .

      To avoid this, List and Export reminders should not attempt to process all available reminders, but should terminate after processing a fixed number (e.g. 1000). A message should be displayed to indicate this.

        Attachments

          Activity

              People

              • Assignee:
                Tim Anderson
                Reporter:
                Tim Anderson
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 6h
                  6h

                    Who's Looking?