Production_MMU_Wrong state information for Saurya Urja Project

XMLWordPrintable

    • AMRIT Sprint 25, AMRIT Sprint 26, AMRIT Sprint 27, AMRIT Sprint 28
    • Huge

      • Steps to Reproduce:
        1. This is data related point so need to run below mentioned query to reproduce the same.
        2. select ad.PermState,count(distinct t.BeneficiaryRegID) from db_iemr.t_benvisitdetail t 
          inner join db_identity.i_beneficiarymapping m on m.benregid=t.BeneficiaryRegID
          inner join db_identity.i_beneficiaryaddress ad on (ad.VanSerialNo=m.BenAddressId and ad.vanid=m.vanid)
          where t.ProviderServiceMapID=20 
          group by 1;
      • Expected Result:
        User should be logged in and redirected to the dashboard. It should display correct beneficiary and locations details to the user.
      • Actual Result:
        When user trying to search with Ben ID or Advance Search, displaying different beneficiary details.
      • Observed  Environment:  Saurya Urja MMU Van1 Production

       Environment

      • URL: ++ NA(offline)
      • Browser: Google Chrome

      Issue raised from BIDA- We have identified jharkhand as a state for Saurya Urja project under demographic information, Actually Saurya Urja project running under Rajasthan State. Please check and correct the state information accordingly.

      For your reference please find the attached query:

       

            Assignee:
            Mokirala Anil Kumar
            Reporter:
            Venkatesh Bojja
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - 2 days
                2d
                Remaining:
                Time Spent - 30 minutes Remaining Estimate - 1 day, 7 hours, 30 minutes
                1d 7h 30m
                Logged:
                Time Spent - 30 minutes Remaining Estimate - 1 day, 7 hours, 30 minutes
                30m