One of our facilities is experiencing a challenge viewing the patient dashboard, instead, an error displays on screen when trying to view a patient after searching. Image is attached.
OpenMRS version: 1.8.3 >>> See the error log here:
org.openmrs.api.APIException: Unable to evaluate SQL Flag ARTStartDateTooOld, Error while running sql: select obs_art_com.person_id from obs_art_com
inner join patient on(patient.patient_id=obs_art_com.person_id and patient.voided=0)
where obs_art_com.ART_INIT_DT<'2004-01-01' and patient.patient_id = 38107 . Message: Error writing file '/tmp/MYAuDxmJ' (Errcode: 28)
I think there might be two problems based on your error trace,
You databases might be outdated for this request or misplaced tables (some errors may occur during the OpenMRS installation).
Access denied for your tmp directory.
could please check your writing access to that directory?
@suthagar23 thank you for the suggestion, is not a new installation site it has been stable for nearly four (4) years now. But I will check and revert back soon.
This is resolved, it appears that there was two reason that causes this error:
(1) The server was running out of space and due to that low disk space, it affected the app from operating at its full capacity. I cleared and free up disk space, it resumes well.
(2) Patient Flag Module, the module fails to run due to the fact that either the multiple queries inserted which I think causes the search controller to slow down transactions or outdated version of the module.
I will retract to check and provide a full detail investigation report. I will be posting the new server logs at Pastebin.