Re: [Gnumed-devel] single box SOAP functional at last !

[Ian Haywood]

On Tue, 24 Jun 2003 15:09:36 +0200
Karsten Hilbert <address@hidden> wrote:

> Dear GnuMedders,
> 
> believe it or not but you can now store free-text clinical
> notes in GnuMed (but not view/modify them yet :-)))
Excellent!

> Please test and comment.

[WARN]  (/home/ian/gnumed/gnumed/client/python-common/gmPG.py::run_query:546): 
query >>>insert into clin_health_issue (id_patient, description) values (%s, 
%s);<<< (args: (3, '__default__')) failed
[WARN]  (/home/ian/gnumed/gnumed/client/python-common/gmPG.py::run_query:546): 
exception type : libpq.OperationalError
[WARN]  (/home/ian/gnumed/gnumed/client/python-common/gmPG.py::run_query:546): 
exception value: ERROR:  Cannot insert a duplicate key into unique index 
clin_health_issu_id_patient_key
 
[ERROR] 
(/home/ian/gnumed/gnumed/client/business/gmClinicalRecord.py::_create_health_issue:336):
 cannot insert health issue [__default__] for patient [3]
[ERROR] 
(/home/ian/gnumed/gnumed/client/business/gmClinicalRecord.py::__load_default_health_issue:313):
 cannot load default health issue for patient [3]

And the data isn't appearing:

gnumed=# select * from clin_root_item;
 pk_item | id_encounter | id_episode | narrative
---------+--------------+------------+-----------
(0 rows)
 
(am I looking in the right table of course?)

The health issue is there:

gnumed=# select * from clin_health_issue;
 pk_audit | row_version |          modify_when          | modify_by | id | 
id_patient | description                                                        
                                           
----------+-------------+-------------------------------+-----------+----+------------+-------------
     9209 |           0 | 2003-06-25 17:55:12.606418+10 | _test-doc |  1 |      
    3 | __default__(1 row)
 
I've looked at the code, you are checking to see if the health issue exists, 
but it isn't working (the query returns no rows)
I can't look into it any further as I can't seen to get a debugger running on 
gnumed (BYW, which one's are people using?)


Ian



Had a quick look at the table: indeed it does have a unique constraint, seems 
reasonable




.