ERROR: Please did anyone ever come across this Error? HOW WAS IT RESOLVED

ggomez · February 16, 2018, 11:43am

Hello,

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:

See the error log here:

Thanks in advance. GG

dkayiwa · February 16, 2018, 11:56am

Does a restart help?

ggomez · February 16, 2018, 3:42pm

Thanks, @dkayiwa for the swift response.

Unfortunately, yes, we restarted several times yet the error still pops up.

dkayiwa · February 17, 2018, 6:16pm

Can you paste the logs at pastebin.com?

suthagar23 · February 18, 2018, 6:29am

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?

dkayiwa · February 18, 2018, 7:03am

@ggomez oh sorry i had not seen the error log in your original post. This looks like you are running out of disk space on the server.

ggomez · February 19, 2018, 7:04pm

@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.

ggomez · February 19, 2018, 7:06pm

@dkayiwa you minght be right this could be another reason why the error appears too. I will get back to you on this. thank you Dan.

ggomez · February 21, 2018, 6:42pm

Thank you @suthagar23 and @dkayiwa

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.

Thanks @ggomez

ucheemelife · February 27, 2018, 11:26am

good job. how do i join this community?