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: