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