Duplicate records identified Under APL Vizag MMU2

XMLWordPrintable

    • Type: Bug
    • Resolution: Done
    • Priority: High
    • None
    • Affects Version/s: 3.4.1
    • MMU
    • Prod

      Dear Avinash,

      Please find the attachment of APL Vizag MMU2 dump data from 2nd June to 28th Oct. We have identified some duplicate records with different createdDate and sync dates, due to this we are getting more records. Actually records are 8177 but we have identified 11695 records due to different timings for the same beneficiary.

      Query: Just for 0ne record reference.

      select BenVisitID,BeneficiaryRegID,VisitCode,visitno,VisitCategory,CreatedDate,SyncedDate,vanid,Deleted,VanSerialNo
       from t_benvisitdetail where visitcode=30002900007476; 

       

      APL Vizag MMU2 2nd June to Oct 28th.csv

              Assignee:
              Avinash Sharma
              Reporter:
              Venkatesh Bojja
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: