Details

    • Type: Bug Fix
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.0.2.1
    • Fix Version/s: Backlog
    • Component/s: Development
    • Labels:
    • Rice Module:
      KEW
    • Application Requirement:
      Rice
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      We had users getting daily email reminders when they had nothing in their worklist. We are sending daily emails based on a view with this query:

      select distinct kait.prncpl_id as PRINCIPAL_ID from krew_actn_itm_t kait
      where kait.asnd_dt < sysdate - 1

      There were entries in that table for CANCELLED and FINAL documents... to remedy this, we manually deleted rows from that table. Not sure how they got there, dont know how to reproduce, but if this is indeed a problem, maybe there should be a daemon that cleans up this table if inconsistencies can occur...

      Thanks.

        Attachments

          Activity

          Hide
          jcoltrin Jessica Coltrin (Inactive) added a comment -

          This shouldn't too long, but if it takes more than 2 days, reevaluate. Root cause may some time once it's discovered.

          Show
          jcoltrin Jessica Coltrin (Inactive) added a comment - This shouldn't too long, but if it takes more than 2 days, reevaluate. Root cause may some time once it's discovered.
          Hide
          jcoltrin Jessica Coltrin (Inactive) added a comment -

          deferring to 1.0.4? since it's low priority and we're heading to code freeze.

          Show
          jcoltrin Jessica Coltrin (Inactive) added a comment - deferring to 1.0.4? since it's low priority and we're heading to code freeze.

            People

            • Assignee:
              Unassigned
              Reporter:
              mchyzer Chris Hyzer (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: