mHWC: APIs Failing After App Reinstall Until Cache is Cleared

XMLWordPrintable

    • Type: Bug
    • Resolution: Done
    • Priority: Highest
    • 1.0
    • Affects Version/s: None
    • None
    • HWC Sprint 10, HWC Sprint 11

      When the app is uninstalled and then reinstalled, certain APIs fail to respond or return errors. As a result, dependent sync APIs are also failing. However, if the user clears the cache manually and logs in again, the APIs start working as expected.

      500 https://uatamrit.piramalswasthya.org/hwc-api/sync/userActivityLogsToServer

      Request : -

      [\{"id":1,"userId":1949,"userName":"Dakhinhengra","loginType":"HWC","loginTimeStamp":"2025-07-15T16:33:17+0530","latitude":28.6240927,"longitude":77.3818696,"syncState":"UNSYNCED","isOutOfReach":false}] 

       

       500 https://uatamrit.piramalswasthya.org/hwc-api/sync/1949/prescriptionTemplatesDataToApp

      Reqest :- *{"data":{"doseType":[

      {"covidDoseTypeID":1,"doseType":"1st Dose","deleted":false,"processed":"N","createdBy":"Admin","createdDate":"May 13, 2022, 1:04:37 AM","lastModDate":"May 13, 2022, 1:04:37 AM"}

      ,{"covidDoseTypeID":2,"doseType":"2nd Dose","deleted":false,"processed":"N","createdBy":"Admin","createdDate":"May 13, 2022, 1:04:38 AM","lastModDate":"May 13, 2022, 1:04:38 AM"},{"covidDoseTypeID":3,"doseType":"Precautionary/Booster dose","deleted":false,"processed":"N","createdBy":"Admin","createdDate":"May 13, 2022, 1:04:38 AM","lastModDate":"May 13, 2022, 1:04:38 AM"}],"vaccineType":[\{"covidVaccineTypeID":1,"vaccineType":"Covaxin","deleted":false,"processed":"N","createdBy":"Admin","createdDate":"May 13, 2022, 1:04:38 AM","lastModDate":"May 13, 2022, 1:04:38 AM"},\{"covidVaccineTypeID":2,"vaccineType":"Covishield","deleted":false,"processed":"N","createdBy":"Admin","createdDate":"May 13, 2022, 1:04:38 AM","lastModDate":"May 13, 2022, 1:04:38 AM"},\{"covidVaccineTypeID":3,"vaccineType":"Sputnik","deleted":false,"processed":"N","createdBy":"Admin","createdDate":"May 13, 2022, 1:04:38 AM","lastModDate":"May 13, 2022, 1:04:38 AM"},\{"covidVaccineTypeID":4,"vaccineType":"Corbevax","deleted":false,"processed":"N","createdBy":"Admin","createdDate":"May 13, 2022, 1:04:38 AM","lastModDate":"May 13, 2022, 1:04:38 AM"}]},"statusCode":200,"errorMessage":"Success","status":"Success"}*
      *

      {"data":null,"statusCode":500,"errorMessage":"Unable to fetch Prescription Templates userID1949Exception - org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select pt1_0.id,pt1_0.CreatedDate,pt1_0.DrugID,pt1_0.DrugName,pt1_0.Duration,pt1_0.Frequency,pt1_0.Instructions,pt1_0.ModifiedDate,pt1_0.TemplateID,pt1_0.TemplateName,pt1_0.Unit,pt1_0.UserID from t_prescription_templates pt1_0 where pt1_0.UserID\u003d?] [Table \u0027db_iemr.t_prescription_templates\u0027 doesn\u0027t exist] [n/a]; SQL [n/a]","status":"Unable to fetch Prescription Templates userID1949Exception - org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select pt1_0.id,pt1_0.CreatedDate,pt1_0.DrugID,pt1_0.DrugName,pt1_0.Duration,pt1_0.Frequency,pt1_0.Instructions,pt1_0.ModifiedDate,pt1_0.TemplateID,pt1_0.TemplateName,pt1_0.Unit,pt1_0.UserID from t_prescription_templates pt1_0 where pt1_0.UserID\u003d?] [Table \u0027db_iemr.t_prescription_templates\u0027 doesn\u0027t exist] [n/a]; SQL [n/a]"}

      *

       

      401 https://uatamrit.piramalswasthya.org/flw-api/child-care/vaccine/getAll?category=CHILD

              Assignee:
              Deep Shikha
              Reporter:
              Sushant Yadav
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: