[Gnumed-bugs] Unhandled exception where encounter duration was not 'sane'

[Busser, Jim]

Here is a snippet from the log file, the entirety of which I will send by 
private email.

Here is the context:

- today, I had only one patient scheduled, at 1130h who I saw for one hour
- ahead of time (yesterday evening), I searched the patient to review their 
record
        … this would have instantiated the encounter as beginning 2014-10-14 in 
the evening
- this was on my laptop, on which GNUmed runs non-networked
- the instance went unchanged overnight
- today, I saw the patient but did not interact with GNUmed until 1530h
- I attempted to change the start and end times to
        1130
        1230

but was met with the unhandled exception below. Maybe the preference, which may 
declare some maximum duration for the encounter and therefore view an end time 
as "not sane" is failing to take into account that the comparitor should be the 
start time which has been entered into the dialog, and not the start time of 
reference when the encounter had been initiated?

-- Jim


2014-10-15 15:20:09  ERROR     gm.db 
(/Users/djb/Downloads/gnumed-client.1.4.9/Gnumed/pycommon/gmPG2.py::run_rw_queries()
 #1365): RW query failed: [UPDATE clin.encounter SET
                                started = cast('2014-10-15T11:30:00-07:00' as 
timestamp with time zone),
                                last_affirmed = 
cast('2014-10-14T12:30:00-07:00' as timestamp with time zone),
                                fk_location = 11586,
                                fk_type = 1,
                                reason_for_encounter = 
gm.nullify_empty_string('Consult prior to mesenchymal stem cell harvest and 
injection R hip, Oct 21st'),
                                assessment_of_encounter = 
gm.nullify_empty_string(NULL)
                        WHERE
                                pk = 1557 AND
                                xmin = '17623'
                        ]
2014-10-15 15:20:09  ERROR     gm.db 
(/Users/djb/Downloads/gnumed-client.1.4.9/Gnumed/pycommon/gmPG2.py::run_rw_queries()
 #1369): PG error code: 23514
2014-10-15 15:20:09  ERROR     gm.db 
(/Users/djb/Downloads/gnumed-client.1.4.9/Gnumed/pycommon/gmPG2.py::run_rw_queries()
 #1371): PG error message: ERROR:  new row for relation "encounter" violates 
check constraint "clin_enc_sane_duration"
DETAIL:  Failing row contains (1665038, 2, 2014-10-15 15:20:09.76991-07, lmcc, 
1557, 306, 1, 11586, -07:00:00, Consult prior to mesenchymal stem cell harvest 
and injection R h..., null, 2014-10-15 11:30:00-07, 2014-10-14 12:30:00-07).
2014-10-15 15:20:09  DEBUG     gm.gui 
(/Users/djb/Downloads/gnumed-client.1.4.9/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
 #196): unhandled exception caught:

-- end