ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(173) |2013-04-14 16:16:59,385| P: query in Program =INSERT INTO patient_program (patient_id, program_id, date_enrolled, creator, date_created, changed_by, date_changed,uuid) SELECT DISTINCT encounter.patient_id, 1, encounter.encounter_datetime, 1, '2013-04-14', 1, '2013-04-14','17398bdf-138d-4bcf-b756-f30738a0d271' FROM encounter WHERE encounter.encounter_type in  (select form2program_map.encounter_type from form2program_map where form2program_map.program = 1) AND encounter.patient_id not in (select patient_id from patient_program where patient_program.program_id = 1 and patient_program.date_completed is null ) AND encounter.encounter_datetime = (select min(e.encounter_datetime) from encounter e where e.patient_id = encounter.patient_id and e.encounter_type in ( select form2program_map.encounter_type from form2program_map where form2program_map.program = 1 ) ) GROUP BY encounter.patient_id ORDER BY encounter.encounter_datetime ASC
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(181) |2013-04-14 16:16:59,478| P:exist in encounter true
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(182) |2013-04-14 16:16:59,478| P:exist in form2program_map true
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(189) |2013-04-14 16:16:59,962| Duplicate entry '17398bdf-138d-4bcf-b756-f30738a0d271' for key 'patient_program_uuid_index'
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(191) |2013-04-14 16:16:59,962| P:rows after try block=0
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(173) |2013-04-14 16:24:52,924| P: query in Program =INSERT INTO patient_program (patient_id, program_id, date_enrolled, creator, date_created, changed_by, date_changed,uuid) SELECT DISTINCT encounter.patient_id, 1, encounter.encounter_datetime, 1, '2013-04-14', 1, '2013-04-14','b4db7e4f-6320-4446-ae6e-7e9e01756e12' FROM encounter WHERE encounter.encounter_type in  (select form2program_map.encounter_type from form2program_map where form2program_map.program = 1) AND encounter.patient_id not in (select patient_id from patient_program where patient_program.program_id = 1 and patient_program.date_completed is null ) AND encounter.encounter_datetime = (select min(e.encounter_datetime) from encounter e where e.patient_id = encounter.patient_id and e.encounter_type in ( select form2program_map.encounter_type from form2program_map where form2program_map.program = 1 ) ) GROUP BY encounter.patient_id ORDER BY encounter.encounter_datetime ASC
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(181) |2013-04-14 16:24:53,017| P:exist in encounter true
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(182) |2013-04-14 16:24:53,017| P:exist in form2program_map true
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(189) |2013-04-14 16:24:53,532| Duplicate entry 'b4db7e4f-6320-4446-ae6e-7e9e01756e12' for key 'patient_program_uuid_index'
ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(191) |2013-04-14 16:24:53,532| P:rows after try block=0