Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 12-Jun-2018 23:39:39.727 INFO [main] org.apache.catalina.core.StandardServer.await A valid shutdown command was received via the shutdown port. Stopping the Server instance.
- 12-Jun-2018 23:39:39.728 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8080"]
- OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512m; support was removed in 8.0
- 12-Jun-2018 23:39:39.779 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["ajp-nio-8009"]
- 12-Jun-2018 23:39:39.830 INFO [main] org.apache.catalina.core.StandardService.stopInternal Stopping service [Catalina]
- WARN - Module.expandExtensionNames(546) |2018-06-12 23:39:40,020| owa: Unable to find class definition for extension: org.openmrs.admin.list
- java.lang.NoClassDefFoundError: org/openmrs/module/web/extension/AdministrationSectionExt
- at java.lang.ClassLoader.defineClass1(Native Method)
- at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
- at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
- at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
- at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:637)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:556)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at org.openmrs.module.Module.expandExtensionNames(Module.java:538)
- at org.openmrs.module.Module.getExtensions(Module.java:490)
- at org.openmrs.module.ModuleFactory.stopModule(ModuleFactory.java:1167)
- at org.openmrs.module.ModuleUtil.shutdown(ModuleUtil.java:161)
- at org.openmrs.api.context.Context.shutdown(Context.java:900)
- at org.openmrs.web.Listener.contextDestroyed(Listener.java:558)
- at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4792)
- at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5429)
- at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1435)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1424)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: java.lang.ClassNotFoundException: org.openmrs.module.web.extension.AdministrationSectionExt
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:563)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- ... 27 more
- WARN - Module.expandExtensionNames(546) |2018-06-12 23:39:40,033| owa: Unable to find class definition for extension: org.openmrs.admin.list
- java.lang.NoClassDefFoundError: org/openmrs/module/web/extension/AdministrationSectionExt
- at java.lang.ClassLoader.defineClass1(Native Method)
- at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
- at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
- at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
- at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:637)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:556)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at org.openmrs.module.Module.expandExtensionNames(Module.java:538)
- at org.openmrs.module.Module.getExtensions(Module.java:490)
- at org.openmrs.module.ModuleFactory.stopModule(ModuleFactory.java:1215)
- at org.openmrs.module.ModuleUtil.shutdown(ModuleUtil.java:161)
- at org.openmrs.api.context.Context.shutdown(Context.java:900)
- at org.openmrs.web.Listener.contextDestroyed(Listener.java:558)
- at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4792)
- at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5429)
- at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1435)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1424)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: java.lang.ClassNotFoundException: org.openmrs.module.web.extension.AdministrationSectionExt
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:563)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- ... 27 more
- WARN - Module.expandExtensionNames(546) |2018-06-12 23:39:40,105| webservices.rest: Unable to find class definition for extension: org.openmrs.admin.list
- java.lang.NoClassDefFoundError: org/openmrs/module/web/extension/AdministrationSectionExt
- at java.lang.ClassLoader.defineClass1(Native Method)
- at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
- at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
- at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
- at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:637)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:556)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at org.openmrs.module.Module.expandExtensionNames(Module.java:538)
- at org.openmrs.module.Module.getExtensions(Module.java:490)
- at org.openmrs.module.ModuleFactory.stopModule(ModuleFactory.java:1167)
- at org.openmrs.module.ModuleUtil.shutdown(ModuleUtil.java:161)
- at org.openmrs.api.context.Context.shutdown(Context.java:900)
- at org.openmrs.web.Listener.contextDestroyed(Listener.java:558)
- at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4792)
- at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5429)
- at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1435)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1424)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: java.lang.ClassNotFoundException: org.openmrs.module.web.extension.AdministrationSectionExt
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:563)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- ... 27 more
- WARN - Module.expandExtensionNames(546) |2018-06-12 23:39:40,110| webservices.rest: Unable to find class definition for extension: org.openmrs.admin.list
- java.lang.NoClassDefFoundError: org/openmrs/module/web/extension/AdministrationSectionExt
- at java.lang.ClassLoader.defineClass1(Native Method)
- at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
- at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
- at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
- at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:637)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:556)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at org.openmrs.module.Module.expandExtensionNames(Module.java:538)
- at org.openmrs.module.Module.getExtensions(Module.java:490)
- at org.openmrs.module.ModuleFactory.stopModule(ModuleFactory.java:1215)
- at org.openmrs.module.ModuleUtil.shutdown(ModuleUtil.java:161)
- at org.openmrs.api.context.Context.shutdown(Context.java:900)
- at org.openmrs.web.Listener.contextDestroyed(Listener.java:558)
- at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4792)
- at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5429)
- at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:226)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1435)
- at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1424)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:748)
- Caused by: java.lang.ClassNotFoundException: org.openmrs.module.web.extension.AdministrationSectionExt
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:563)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- ... 27 more
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,117| QUERY: from CHITSConfig
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,118| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,118| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,118| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,119| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,119| Average time : 3
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,120| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,120| QUERY: [CRITERIA] select this_.patient_program_id as patient_1_103_0_, this_.uuid as uuid2_103_0_, this_.date_enrolled as date_enr3_103_0_, this_.date_completed as date_com4_103_0_, this_.date_created as date_cre5_103_0_, this_.voided as voided6_103_0_, this_.date_voided as date_voi7_103_0_, this_.void_reason as void_rea8_103_0_, this_.voided_by as voided_b9_103_0_, this_.date_changed as date_ch10_103_0_, this_.outcome_concept_id as outcome11_103_0_, this_.program_id as program12_103_0_, this_.patient_id as patient13_103_0_, this_.creator as creator14_103_0_, this_.changed_by as changed15_103_0_, this_.location_id as locatio16_103_0_ from patient_program this_ where this_.patient_id=? and this_.voided=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,120| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,121| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,121| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,122| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,123| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,124| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,125| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 5 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,126| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,126| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,126| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,127| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,128| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,128| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,128| QUERY: SELECT DISTINCT f FROM FamilyFolder f JOIN f.patients p WHERE p.patientId = :patientId AND f.voided = false
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,129| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,129| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,129| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,130| Execution Count : 6
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,130| Average time : 115
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,130| Row Count : 6
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,131| QUERY: from User u order by u.userId
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,131| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,131| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,132| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,133| Execution Count : 3
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,133| Average time : 13
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,133| Row Count : 6
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,134| QUERY: from InternalExamination WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,134| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,134| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,134| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,135| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,135| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,135| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,135| QUERY: from HealthCenter
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,136| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,136| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,136| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,136| Execution Count : 3
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,137| Average time : 7
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,137| Row Count : 519
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,137| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 13 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,137| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,138| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,138| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,138| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,138| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,139| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,139| QUERY: [CRITERIA] select this_.patient_id as person_i1_105_1_, this_1_.uuid as uuid2_105_1_, this_1_.gender as gender3_105_1_, this_1_.birthdate as birthdat4_105_1_, this_1_.birthdate_estimated as birthdat5_105_1_, this_1_.birthtime as birthtim6_105_1_, this_1_.dead as dead7_105_1_, this_1_.death_date as death_da8_105_1_, this_1_.deathdate_estimated as deathdat9_105_1_, this_1_.cause_of_death as cause_o10_105_1_, this_1_.creator as creator11_105_1_, this_1_.date_created as date_cr12_105_1_, this_1_.changed_by as changed13_105_1_, this_1_.date_changed as date_ch14_105_1_, this_1_.voided as voided15_105_1_, this_1_.voided_by as voided_16_105_1_, this_1_.date_voided as date_vo17_105_1_, this_1_.void_reason as void_re18_105_1_, this_.patient_id as patient_1_100_1_, this_.creator as creator2_100_1_, this_.date_created as date_cre3_100_1_, this_.changed_by as changed_4_100_1_, this_.date_changed as date_cha5_100_1_, this_.voided as voided6_100_1_, this_.voided_by as voided_b7_100_1_, this_.date_voided as date_voi8_100_1_, this_.void_reason as void_rea9_100_1_, this_.allergy_status as allergy10_100_1_, case when exists (select * from patient p where p.patient_id = this_1_.person_id) then 1 else 0 end as formula1_1_, name1_.person_name_id as person_n1_110_0_, name1_.uuid as uuid2_110_0_, name1_.preferred as preferre3_110_0_, name1_.person_id as person_i4_110_0_, name1_.prefix as prefix5_110_0_, name1_.given_name as given_na6_110_0_, name1_.middle_name as middle_n7_110_0_, name1_.family_name_prefix as family_n8_110_0_, name1_.family_name as family_n9_110_0_, name1_.family_name2 as family_10_110_0_, name1_.family_name_suffix as family_11_110_0_, name1_.degree as degree12_110_0_, name1_.creator as creator13_110_0_, name1_.date_created as date_cr14_110_0_, name1_.changed_by as changed15_110_0_, name1_.date_changed as date_ch16_110_0_, name1_.voided_by as voided_17_110_0_, name1_.date_voided as date_vo18_110_0_, name1_.void_reason as void_re19_110_0_, name1_.voided as voided20_110_0_ from patient this_ inner join person this_1_ on this_.patient_id=this_1_.person_id inner join person_name name1_ on this_.patient_id=name1_.person_id where ((name1_.voided=? and (((name1_.given_name is not null and name1_.given_name like ?) or (name1_.middle_name is not null and name1_.middle_name like ?) or (name1_.family_name is not null and name1_.family_name like ?) or (name1_.family_name2 is not null and name1_.family_name2 like ?)) and (name1_.given_name is null or name1_.given_name<>?) and (name1_.middle_name is null or name1_.middle_name<>?) and (name1_.family_name is null or name1_.family_name<>?) and (name1_.family_name2 is null or name1_.family_name2<>?)))) and this_.voided=? order by name1_.given_name asc, name1_.middle_name asc, name1_.family_name asc
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,139| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,140| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,140| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,140| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,140| Average time : 12
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,141| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,141| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 12 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,141| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,141| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,142| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,142| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,142| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,142| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,142| QUERY: [CRITERIA] select count(*) as y0_ from patient this_ inner join person this_1_ on this_.patient_id=this_1_.person_id inner join person_name name1_ on this_.patient_id=name1_.person_id left outer join person_attribute attribute2_ on this_.patient_id=attribute2_.person_id left outer join person_attribute_type attributet3_ on attribute2_.person_attribute_type_id=attributet3_.person_attribute_type_id left outer join patient_identifier ids4_ on this_.patient_id=ids4_.patient_id where (((name1_.voided=? and ((name1_.given_name is not null and lower(name1_.given_name)=?) or (name1_.middle_name is not null and lower(name1_.middle_name)=?) or (name1_.family_name is not null and lower(name1_.family_name)=?) or (name1_.family_name2 is not null and lower(name1_.family_name2)=?)))) or ((attributet3_.searchable=? and attribute2_.voided=? and lower(attribute2_.value) like ?)) or (ids4_.voided=? and lower(ids4_.identifier) like ?)) and this_.voided=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,143| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,143| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,143| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,144| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,144| Average time : 7
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,144| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,144| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 10 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,145| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,145| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,145| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,145| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,146| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,146| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,146| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 9 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,147| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,147| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,147| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,147| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,148| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,148| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,148| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 1 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,149| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,149| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,149| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,149| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,150| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,150| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,150| QUERY: [CRITERIA] select count(*) as y0_ from patient this_ inner join person this_1_ on this_.patient_id=this_1_.person_id inner join person_name name1_ on this_.patient_id=name1_.person_id where (((name1_.voided=? and (name1_.given_name like ? or name1_.middle_name like ? or name1_.family_name like ? or name1_.family_name2 like ?))) and not (((name1_.voided=? and ((name1_.given_name is not null and lower(name1_.given_name)=?) or (name1_.middle_name is not null and lower(name1_.middle_name)=?) or (name1_.family_name is not null and lower(name1_.family_name)=?) or (name1_.family_name2 is not null and lower(name1_.family_name2)=?))))) and not (((name1_.voided=? and (((name1_.given_name is not null and name1_.given_name like ?) or (name1_.middle_name is not null and name1_.middle_name like ?) or (name1_.family_name is not null and name1_.family_name like ?) or (name1_.family_name2 is not null and name1_.family_name2 like ?)) and (name1_.given_name is null or name1_.given_name<>?) and (name1_.middle_name is null or name1_.middle_name<>?) and (name1_.family_name is null or name1_.family_name<>?) and (name1_.family_name2 is null or name1_.family_name2<>?)))))) and this_.voided=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,150| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,150| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,151| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,151| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,151| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,151| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,151| QUERY: [CRITERIA] select this_.patient_queue_id as patient_1_33_0_, this_.notes_number as notes_nu2_33_0_, this_.entered_queue as entered_3_33_0_, this_.consult_start as consult_4_33_0_, this_.consult_end as consult_5_33_0_, this_.exited_queue as exited_q6_33_0_, this_.emergent as emergent7_33_0_, this_.patient_id as patient_8_33_0_, this_.encounter_id as encounte9_33_0_, this_.program_id as program10_33_0_ from chits_patient_queue this_ where this_.exited_queue is null and this_.patient_id=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,152| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,152| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,152| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,152| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,152| Average time : 3
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,153| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,153| QUERY: [CRITERIA] select this_.patient_queue_id as patient_1_33_0_, this_.notes_number as notes_nu2_33_0_, this_.entered_queue as entered_3_33_0_, this_.consult_start as consult_4_33_0_, this_.consult_end as consult_5_33_0_, this_.exited_queue as exited_q6_33_0_, this_.emergent as emergent7_33_0_, this_.patient_id as patient_8_33_0_, this_.encounter_id as encounte9_33_0_, this_.program_id as program10_33_0_ from chits_patient_queue this_ where this_.patient_id=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,153| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,153| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,153| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,154| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,154| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,154| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,154| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 11 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,154| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,154| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,155| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,155| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,155| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,155| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,155| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 16 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,156| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,156| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,156| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,156| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,157| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,157| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,157| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 3 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,158| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,158| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,158| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,158| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,159| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,159| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,159| QUERY: from TetanusVaccination WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,159| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,160| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,160| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,160| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,160| Average time : 3
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,160| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,161| QUERY: SELECT unique_identifier_code from chits_sh_individual_client_record WHERE patient_id like '3'
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,161| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,161| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,161| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,161| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,162| Average time : 4
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,162| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,162| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 9 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,162| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,162| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,162| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,163| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,163| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,163| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,163| QUERY: [CRITERIA] select this_.relationship_id as relation1_122_0_, this_.uuid as uuid2_122_0_, this_.start_date as start_da3_122_0_, this_.end_date as end_date4_122_0_, this_.voided as voided5_122_0_, this_.date_voided as date_voi6_122_0_, this_.void_reason as void_rea7_122_0_, this_.date_created as date_cre8_122_0_, this_.person_a as person_a9_122_0_, this_.person_b as person_10_122_0_, this_.relationship as relatio11_122_0_, this_.creator as creator12_122_0_, this_.voided_by as voided_13_122_0_, this_.changed_by as changed14_122_0_, this_.date_changed as date_ch15_122_0_ from relationship this_ where this_.person_b=? and this_.relationship=? and this_.voided=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,164| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,164| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,164| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,165| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,165| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,166| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,166| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 4 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,166| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,166| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,166| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,167| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,167| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,167| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,167| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 2 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,167| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,168| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,168| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,168| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,168| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,168| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,168| QUERY: [CRITERIA] select this_.task_config_id as task_con1_127_0_, this_.uuid as uuid2_127_0_, this_.name as name3_127_0_, this_.description as descript4_127_0_, this_.schedulable_class as schedula5_127_0_, this_.repeat_interval as repeat_i6_127_0_, this_.start_time as start_ti7_127_0_, this_.start_time_pattern as start_ti8_127_0_, this_.last_execution_time as last_exe9_127_0_, this_.start_on_startup as start_o10_127_0_, this_.started as started11_127_0_, this_.created_by as created12_127_0_, this_.changed_by as changed13_127_0_, this_.date_created as date_cr14_127_0_, this_.date_changed as date_ch15_127_0_ from scheduler_task_config this_
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,169| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,169| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,169| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,169| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,169| Average time : 9
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,170| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,170| QUERY: from ObstetricHistoryDetails WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,170| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,170| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,174| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,175| Execution Count : 3
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,175| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,175| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,176| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 1 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,176| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,177| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,183| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,183| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,184| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,184| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,184| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 12 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,184| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,184| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,185| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,185| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,185| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,185| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,185| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 6 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,186| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,186| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,186| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,186| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,186| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,187| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,187| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 6 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,187| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,187| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,188| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,188| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,194| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,195| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,195| QUERY: from PostPartumInternalExamination WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,195| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,195| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,196| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,196| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,196| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,196| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,196| QUERY: [CRITERIA] select this_.encounter_id as encounte1_69_0_, this_.uuid as uuid2_69_0_, this_.encounter_datetime as encounte3_69_0_, this_.date_created as date_cre4_69_0_, this_.voided as voided5_69_0_, this_.date_voided as date_voi6_69_0_, this_.void_reason as void_rea7_69_0_, this_.date_changed as date_cha8_69_0_, this_.changed_by as changed_9_69_0_, this_.patient_id as patient10_69_0_, this_.location_id as locatio11_69_0_, this_.form_id as form_id12_69_0_, this_.encounter_type as encount13_69_0_, this_.creator as creator14_69_0_, this_.voided_by as voided_15_69_0_, this_.visit_id as visit_i16_69_0_ from encounter this_ where this_.patient_id=? and this_.voided=? order by this_.encounter_datetime asc
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,197| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,197| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,197| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,197| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,197| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,198| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,198| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 10 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,198| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,198| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,198| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,199| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,199| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,219| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,220| QUERY: [CRITERIA] select this_.patient_identifier_type_id as patient_1_102_0_, this_.uuid as uuid2_102_0_, this_.name as name3_102_0_, this_.description as descript4_102_0_, this_.format as format5_102_0_, this_.format_description as format_d6_102_0_, this_.required as required7_102_0_, this_.validator as validato8_102_0_, this_.date_created as date_cre9_102_0_, this_.location_behavior as locatio10_102_0_, this_.uniqueness_behavior as uniquen11_102_0_, this_.creator as creator12_102_0_, this_.retired_by as retired13_102_0_, this_.date_retired as date_re14_102_0_, this_.retire_reason as retire_15_102_0_, this_.retired as retired16_102_0_ from patient_identifier_type this_ where this_.name=? and this_.retired=? order by this_.required desc, this_.name asc, this_.patient_identifier_type_id asc
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,220| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,220| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,220| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,221| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,221| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,221| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,221| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 7 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,221| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,222| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,222| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,222| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,222| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,222| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,223| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 5 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,223| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,223| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,223| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,223| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,224| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,224| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,224| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 11 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,224| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,225| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,225| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,225| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,225| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,225| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,226| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 7 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,226| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,226| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,226| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,226| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,227| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,227| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,233| QUERY: from IronSupplementation WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,234| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,234| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,234| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,235| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,236| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,237| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,237| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 8 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,238| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,238| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,238| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,239| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,239| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,239| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,239| QUERY: from PostPartumRecord WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,240| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,240| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,240| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,240| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,240| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,241| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,241| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 12 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,241| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,241| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,242| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,242| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,242| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,242| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,242| QUERY: [CRITERIA] select this_.relationship_type_id as relation1_123_0_, this_.uuid as uuid2_123_0_, this_.a_is_to_b as a_is_to_3_123_0_, this_.b_is_to_a as b_is_to_4_123_0_, this_.description as descript5_123_0_, this_.preferred as preferre6_123_0_, this_.weight as weight7_123_0_, this_.date_created as date_cre8_123_0_, this_.creator as creator9_123_0_, this_.retired_by as retired10_123_0_, this_.date_retired as date_re11_123_0_, this_.retire_reason as retire_12_123_0_, this_.retired as retired13_123_0_ from relationship_type this_ where CONCAT(a_Is_To_B, CONCAT('/', b_Is_To_A)) like (?)
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,243| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,243| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,243| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,243| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,243| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,244| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,244| QUERY: from PatientStateRemarks WHERE patientProgram=null
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,244| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,244| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,244| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,245| Execution Count : 1
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,245| Average time : 2
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,245| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,245| QUERY: from TetanusVaccination WHERE patient=3
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,245| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,246| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,246| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,246| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,246| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,246| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,247| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 3 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,247| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,247| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,247| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,247| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,248| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,248| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,248| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 4 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,248| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,248| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,249| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,249| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,249| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,249| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,249| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 11 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,250| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,251| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,251| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,251| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,252| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,252| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,252| QUERY: [CRITERIA] select this_.patient_queue_id as patient_1_33_0_, this_.notes_number as notes_nu2_33_0_, this_.entered_queue as entered_3_33_0_, this_.consult_start as consult_4_33_0_, this_.consult_end as consult_5_33_0_, this_.exited_queue as exited_q6_33_0_, this_.emergent as emergent7_33_0_, this_.patient_id as patient_8_33_0_, this_.encounter_id as encounte9_33_0_, this_.program_id as program10_33_0_ from chits_patient_queue this_ where this_.exited_queue is null and this_.patient_id=? and this_.program_id=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,252| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,252| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,252| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,253| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,255| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,255| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,255| QUERY: from DewormingService WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,255| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,255| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,255| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,256| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,256| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,256| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,256| QUERY: from MenstrualHistory WHERE patient=3
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,260| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,260| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,260| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,260| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,260| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,260| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,261| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 8 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,261| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,261| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,261| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,261| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,261| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,261| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,262| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 6 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,262| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,262| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,262| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,262| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,262| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,262| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,262| QUERY: select count(*) from PhilhealthMemberRegistrationForm f where f.patient.id = :patient_id
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,263| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,263| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,263| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,263| Execution Count : 1
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,263| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,263| Row Count : 1
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,263| QUERY: from ObstetricData WHERE patient=3
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,264| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,264| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,266| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,266| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,266| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,266| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,266| QUERY: [CRITERIA] select this_.encounter_type_id as encounte1_72_0_, this_.name as name2_72_0_, this_.description as descript3_72_0_, this_.date_created as date_cre4_72_0_, this_.creator as creator5_72_0_, this_.edit_privilege as edit_pri6_72_0_, this_.view_privilege as view_pri7_72_0_, this_.uuid as uuid8_72_0_, this_.retired_by as retired_9_72_0_, this_.date_retired as date_re10_72_0_, this_.retire_reason as retire_11_72_0_, this_.retired as retired12_72_0_, this_.changed_by as changed13_72_0_, this_.date_changed as date_ch14_72_0_ from encounter_type this_ where this_.retired=? and this_.name=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,267| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,267| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,267| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,267| Execution Count : 3
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,267| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,267| Row Count : 3
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,267| QUERY: [CRITERIA] select this_.concept_name_id as concept_1_53_1_, this_.concept_id as concept_2_53_1_, this_.name as name3_53_1_, this_.locale as locale4_53_1_, this_.date_created as date_cre5_53_1_, this_.creator as creator6_53_1_, this_.voided as voided7_53_1_, this_.date_voided as date_voi8_53_1_, this_.void_reason as void_rea9_53_1_, this_.voided_by as voided_10_53_1_, this_.concept_name_type as concept11_53_1_, this_.locale_preferred as locale_12_53_1_, this_.uuid as uuid13_53_1_, concept1_.concept_id as concept_1_44_0_, concept1_.uuid as uuid2_44_0_, concept1_.retired as retired3_44_0_, concept1_.date_created as date_cre4_44_0_, concept1_.version as version5_44_0_, concept1_.date_changed as date_cha6_44_0_, concept1_.is_set as is_set7_44_0_, concept1_.retire_reason as retire_r8_44_0_, concept1_.date_retired as date_ret9_44_0_, concept1_.retired_by as retired10_44_0_, concept1_.datatype_id as datatyp11_44_0_, concept1_.class_id as class_i12_44_0_, concept1_.changed_by as changed13_44_0_, concept1_.creator as creator14_44_0_, concept1_1_.hi_absolute as hi_absol2_56_0_, concept1_1_.hi_critical as hi_criti3_56_0_, concept1_1_.hi_normal as hi_norma4_56_0_, concept1_1_.low_absolute as low_abso5_56_0_, concept1_1_.low_critical as low_crit6_56_0_, concept1_1_.low_normal as low_norm7_56_0_, concept1_1_.units as units8_56_0_, concept1_1_.precise as precise9_56_0_, concept1_1_.display_precision as display10_56_0_, concept1_2_.handler as handler2_49_0_, case when concept1_1_.concept_id is not null then 1 when concept1_2_.concept_id is not null then 2 when concept1_.concept_id is not null then 0 end as clazz_0_ from concept_name this_ inner join concept concept1_ on this_.concept_id=concept1_.concept_id left outer join concept_numeric concept1_1_ on concept1_.concept_id=concept1_1_.concept_id left outer join concept_complex concept1_2_ on concept1_.concept_id=concept1_2_.concept_id where (this_.locale=? or this_.locale like ?) and lower(this_.name) like ? and this_.voided=? and concept1_.retired=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,268| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,268| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,268| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,268| Execution Count : 8
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,268| Average time : 43
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,278| Row Count : 11
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,278| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 16 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,278| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,278| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,279| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,279| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,279| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,279| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,279| QUERY: [CRITERIA] select count(*) as y0_ from patient this_ inner join person this_1_ on this_.patient_id=this_1_.person_id inner join person_name name1_ on this_.patient_id=name1_.person_id where ((name1_.voided=? and (((name1_.given_name is not null and name1_.given_name like ?) or (name1_.middle_name is not null and name1_.middle_name like ?) or (name1_.family_name is not null and name1_.family_name like ?) or (name1_.family_name2 is not null and name1_.family_name2 like ?)) and (name1_.given_name is null or name1_.given_name<>?) and (name1_.middle_name is null or name1_.middle_name<>?) and (name1_.family_name is null or name1_.family_name<>?) and (name1_.family_name2 is null or name1_.family_name2<>?)))) and this_.voided=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,279| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,279| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,279| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,280| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,280| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,280| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,280| QUERY: from DeliveryPregnancyOutcome WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,280| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,280| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,280| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,281| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,281| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,281| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,281| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 1 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,281| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,281| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,282| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,282| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,282| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,283| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,283| QUERY: [CRITERIA] select this_.patient_program_id as patient_1_103_0_, this_.uuid as uuid2_103_0_, this_.date_enrolled as date_enr3_103_0_, this_.date_completed as date_com4_103_0_, this_.date_created as date_cre5_103_0_, this_.voided as voided6_103_0_, this_.date_voided as date_voi7_103_0_, this_.void_reason as void_rea8_103_0_, this_.voided_by as voided_b9_103_0_, this_.date_changed as date_ch10_103_0_, this_.outcome_concept_id as outcome11_103_0_, this_.program_id as program12_103_0_, this_.patient_id as patient13_103_0_, this_.creator as creator14_103_0_, this_.changed_by as changed15_103_0_, this_.location_id as locatio16_103_0_ from patient_program this_ where this_.patient_id=? and this_.program_id=? and this_.voided=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,283| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,283| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,283| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,283| Execution Count : 44
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,283| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,284| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,284| QUERY: from PrenatalRecord WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,284| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,284| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,284| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,284| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,284| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,284| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,284| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 14 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,285| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,285| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,285| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,285| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,285| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,285| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,285| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 14 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,285| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,286| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,286| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,286| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,286| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,286| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,286| QUERY: from VitaminASupplementation WHERE patient=3 AND dateVoided IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,286| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,286| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,287| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,287| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,287| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,287| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,287| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 14 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,288| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,290| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,290| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,290| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,291| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,291| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,291| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 15 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,291| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,291| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,291| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,292| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,292| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,292| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,292| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 2 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,292| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,292| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,292| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,292| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,293| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,293| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,293| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 9 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,293| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,293| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,293| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,293| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,293| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,293| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,294| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 13 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,294| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,294| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,294| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,294| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,294| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,294| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,294| QUERY: [CRITERIA] select this_.patient_program_id as patient_1_103_0_, this_.uuid as uuid2_103_0_, this_.date_enrolled as date_enr3_103_0_, this_.date_completed as date_com4_103_0_, this_.date_created as date_cre5_103_0_, this_.voided as voided6_103_0_, this_.date_voided as date_voi7_103_0_, this_.void_reason as void_rea8_103_0_, this_.voided_by as voided_b9_103_0_, this_.date_changed as date_ch10_103_0_, this_.outcome_concept_id as outcome11_103_0_, this_.program_id as program12_103_0_, this_.patient_id as patient13_103_0_, this_.creator as creator14_103_0_, this_.changed_by as changed15_103_0_, this_.location_id as locatio16_103_0_ from patient_program this_ where this_.patient_id=? and this_.program_id=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,294| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,295| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,295| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,295| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,295| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,295| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,295| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 10 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,295| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,295| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,295| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,296| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,296| Average time : 2
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,296| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,296| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 8 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,296| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,296| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,296| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,296| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,297| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,297| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,297| QUERY: [CRITERIA] select this_.location_id as location1_84_0_, this_.uuid as uuid2_84_0_, this_.name as name3_84_0_, this_.description as descript4_84_0_, this_.address1 as address5_84_0_, this_.address2 as address6_84_0_, this_.city_village as city_vil7_84_0_, this_.state_province as state_pr8_84_0_, this_.country as country9_84_0_, this_.postal_code as postal_10_84_0_, this_.latitude as latitud11_84_0_, this_.longitude as longitu12_84_0_, this_.county_district as county_13_84_0_, this_.address3 as address14_84_0_, this_.address4 as address15_84_0_, this_.address6 as address16_84_0_, this_.address5 as address17_84_0_, this_.address7 as address18_84_0_, this_.address8 as address19_84_0_, this_.address9 as address20_84_0_, this_.address10 as address21_84_0_, this_.address11 as address22_84_0_, this_.address12 as address23_84_0_, this_.address13 as address24_84_0_, this_.address14 as address25_84_0_, this_.address15 as address26_84_0_, this_.date_created as date_cr27_84_0_, this_.date_changed as date_ch28_84_0_, this_.parent_location as parent_29_84_0_, this_.changed_by as changed30_84_0_, this_.creator as creator31_84_0_, this_.retired_by as retired32_84_0_, this_.date_retired as date_re33_84_0_, this_.retire_reason as retire_34_84_0_, this_.retired as retired35_84_0_ from location this_ where this_.name=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,297| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,297| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,297| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,297| Execution Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,297| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,297| Row Count : 4
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,298| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 2 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,298| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,298| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,298| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,298| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,298| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,298| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,299| QUERY: [CRITERIA] select this_.person_attribute_type_id as person_a1_108_0_, this_.uuid as uuid2_108_0_, this_.name as name3_108_0_, this_.description as descript4_108_0_, this_.format as format5_108_0_, this_.foreign_key as foreign_6_108_0_, this_.sort_weight as sort_wei7_108_0_, this_.searchable as searchab8_108_0_, this_.creator as creator9_108_0_, this_.date_created as date_cr10_108_0_, this_.changed_by as changed11_108_0_, this_.date_changed as date_ch12_108_0_, this_.retired_by as retired13_108_0_, this_.date_retired as date_re14_108_0_, this_.retire_reason as retire_15_108_0_, this_.retired as retired16_108_0_, this_.edit_privilege as edit_pr17_108_0_ from person_attribute_type this_ where this_.name=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,299| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,299| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,299| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,299| Execution Count : 56
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,299| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,299| Row Count : 52
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,299| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 13 AND patient_id = 3 AND consult_end IS NOT NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,300| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,300| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,300| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,300| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,300| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,300| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,300| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 7 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,300| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,300| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,301| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,301| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,301| Average time : 1
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,301| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,301| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 15 AND patient_id = 3 AND entered_queue IS NOT NULL AND consult_start IS NULL AND consult_end IS NULL && exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,301| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,301| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,301| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,301| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,302| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,302| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,302| QUERY: [CRITERIA] select this_.property as property1_79_0_, this_.property_value as property2_79_0_, this_.description as descript3_79_0_, this_.datatype as datatype4_79_0_, this_.datatype_config as datatype5_79_0_, this_.preferred_handler as preferre6_79_0_, this_.handler_config as handler_7_79_0_, this_.uuid as uuid8_79_0_ from global_property this_ where lower(this_.property)=?
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,302| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,302| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,302| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,302| Execution Count : 194
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,302| Average time : 2
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,302| Row Count : 194
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,303| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 3 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,303| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,303| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,303| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,303| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,303| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,303| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,303| QUERY: from MedicalHistory WHERE patient=3
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,303| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,304| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,304| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,304| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,304| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,304| Row Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,304| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 4 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,304| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,304| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,305| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,305| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,305| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,305| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,305| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 15 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,305| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,305| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,305| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,305| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,306| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,306| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,306| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 16 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,306| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,306| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,306| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,306| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,306| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,306| Row Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(372) |2018-06-12 23:39:40,307| QUERY: SELECT COUNT(DISTINCT patient_id) AS in_program FROM chits_patient_queue WHERE program_id = 5 AND patient_id = 3 AND consult_start IS NOT NULL AND consult_end IS NULL AND exited_queue IS NULL
- INFO - HibernateContextDAO.showUsageStatistics(374) |2018-06-12 23:39:40,307| Cache Hit Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(375) |2018-06-12 23:39:40,307| Cache Miss Count: 0
- INFO - HibernateContextDAO.showUsageStatistics(376) |2018-06-12 23:39:40,307| Cache Put Count : 0
- INFO - HibernateContextDAO.showUsageStatistics(377) |2018-06-12 23:39:40,307| Execution Count : 2
- INFO - HibernateContextDAO.showUsageStatistics(378) |2018-06-12 23:39:40,307| Average time : 0
- INFO - HibernateContextDAO.showUsageStatistics(379) |2018-06-12 23:39:40,307| Row Count : 2
- 12-Jun-2018 23:39:40.351 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [openmrs] appears to have started a thread named [Thread-5] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
- java.lang.Thread.sleep(Native Method)
- org.apache.log4j.helpers.FileWatchdog.run(FileWatchdog.java:104)
- 12-Jun-2018 23:39:40.351 SEVERE [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [openmrs] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@6db25028]) and a value of type [org.openmrs.Patient] (value [Patient#3]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
- 12-Jun-2018 23:39:40.383 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-8080"]
- 12-Jun-2018 23:39:40.387 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["ajp-nio-8009"]
- 12-Jun-2018 23:39:40.388 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-8080"]
- 12-Jun-2018 23:39:40.390 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["ajp-nio-8009"]
- 12-Jun-2018 23:39:40.830 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.16
- 12-Jun-2018 23:39:40.833 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jun 21 2017 17:01:09 UTC
- 12-Jun-2018 23:39:40.833 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.16.0
- 12-Jun-2018 23:39:40.833 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
- 12-Jun-2018 23:39:40.833 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 4.13.0-43-generic
- 12-Jun-2018 23:39:40.833 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
- 12-Jun-2018 23:39:40.833 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-8-openjdk-amd64/jre
- 12-Jun-2018 23:39:40.833 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_171-8u171-b11-0ubuntu0.16.04.1-b11
- 12-Jun-2018 23:39:40.834 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
- 12-Jun-2018 23:39:40.834 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/tomcat
- 12-Jun-2018 23:39:40.834 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/tomcat
- 12-Jun-2018 23:39:40.834 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/tomcat/conf/logging.properties
- 12-Jun-2018 23:39:40.834 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
- 12-Jun-2018 23:39:40.834 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
- 12-Jun-2018 23:39:40.835 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
- 12-Jun-2018 23:39:40.835 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms1024m
- 12-Jun-2018 23:39:40.835 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx8192m
- 12-Jun-2018 23:39:40.835 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=512m
- 12-Jun-2018 23:39:40.835 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/tomcat
- 12-Jun-2018 23:39:40.835 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/tomcat
- 12-Jun-2018 23:39:40.836 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/tomcat/temp
- 12-Jun-2018 23:39:40.836 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib]
- 12-Jun-2018 23:39:40.943 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
- 12-Jun-2018 23:39:40.962 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
- 12-Jun-2018 23:39:40.966 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
- 12-Jun-2018 23:39:40.968 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
- 12-Jun-2018 23:39:40.969 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 854 ms
- 12-Jun-2018 23:39:41.006 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
- 12-Jun-2018 23:39:41.006 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.16
- 12-Jun-2018 23:39:41.082 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/opt/tomcat/webapps/openmrs.war]
- 12-Jun-2018 23:39:41.129 WARNING [localhost-startStop-1] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'antiJARLocking' to 'true' did not find a matching property.
- 12-Jun-2018 23:39:48.022 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
- WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2018-06-12 23:39:48,873| Unable to find a runtime properties file at /home/nthc/workspace/chitscore/openmrs-runtime.properties
- WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2018-06-12 23:39:48,895| Unable to find a runtime properties file at /home/nthc/workspace/chitscore/openmrs-runtime.properties
- INFO - Listener.contextInitialized(174) |2018-06-12 23:39:48,896| Using runtime properties file: /root/.OpenMRS/openmrs-runtime.properties
- INFO 6/12/18 11:39 PM:liquibase: Reading from `liquibasechangelog`
- WARNING 6/12/18 11:39 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case
- WARNING 6/12/18 11:39 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case
- WARNING 6/12/18 11:39 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case
- WARN - SimpleUrlHandlerMapping.registerHandlers(115) |2018-06-12 23:40:05,207| Neither 'urlMap' nor 'mappings' set on SimpleUrlHandlerMapping
- WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2018-06-12 23:40:05,354| Unable to find a runtime properties file at /home/nthc/workspace/chitscore/openmrs-runtime.properties
- INFO 6/12/18 11:40 PM:liquibase: Reading from `liquibasechangelog`
- WARNING 6/12/18 11:40 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case
- WARNING 6/12/18 11:40 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case
- WARNING 6/12/18 11:40 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql. Use <sql> and re-specify all configuration if this is the case
- INFO - LoggingAdvice.invoke(115) |2018-06-12 23:40:09,224| In method AdministrationService.saveGlobalProperty. Arguments: GlobalProperty=property: chitscore.started value: true,
- INFO - LoggingAdvice.invoke(155) |2018-06-12 23:40:09,265| Exiting method saveGlobalProperty
- INFO - LoggingAdvice.invoke(115) |2018-06-12 23:40:09,277| In method AdministrationService.saveGlobalProperty. Arguments: GlobalProperty=property: chitscore.mandatory value: false,
- INFO - LoggingAdvice.invoke(155) |2018-06-12 23:40:09,283| Exiting method saveGlobalProperty
- Exception in thread "Thread-13" java.lang.LinkageError: loader constraint violation: when resolving method "org.slf4j.impl.StaticLoggerBinder.getLoggerFactory()Lorg/slf4j/ILoggerFactory;" the class loader (instance of org/openmrs/module/ModuleClassLoader) of the current class, org/slf4j/LoggerFactory, and the class loader (instance of org/apache/catalina/loader/ParallelWebappClassLoader) for the method's defining class, org/slf4j/impl/StaticLoggerBinder, have different Class objects for the type org/slf4j/ILoggerFactory used in the signature
- at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:273)
- at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:241)
- at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:156)
- at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:132)
- at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:272)
- at org.openmrs.module.chitscore.ChitscoreActivator.<init>(ChitscoreActivator.java:23)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at java.lang.Class.newInstance(Class.java:442)
- at org.openmrs.module.Module.getModuleActivator(Module.java:156)
- at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:770)
- at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
- WARN - Module.expandExtensionNames(546) |2018-06-12 23:40:09,852| webservices.rest: Unable to find class definition for extension: org.openmrs.admin.list
- java.lang.NoClassDefFoundError: org/openmrs/module/web/extension/AdministrationSectionExt
- at java.lang.ClassLoader.defineClass1(Native Method)
- at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
- at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
- at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
- at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:637)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:556)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at org.openmrs.module.Module.expandExtensionNames(Module.java:538)
- at org.openmrs.module.Module.getExtensions(Module.java:490)
- at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:664)
- at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
- Caused by: java.lang.ClassNotFoundException: org.openmrs.module.web.extension.AdministrationSectionExt
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:563)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- ... 16 more
- INFO - LoggingAdvice.invoke(115) |2018-06-12 23:40:09,865| In method AdministrationService.saveGlobalProperty. Arguments: GlobalProperty=property: webservices.rest.started value: true,
- INFO - LoggingAdvice.invoke(155) |2018-06-12 23:40:09,870| Exiting method saveGlobalProperty
- INFO - LoggingAdvice.invoke(115) |2018-06-12 23:40:09,874| In method AdministrationService.saveGlobalProperty. Arguments: GlobalProperty=property: webservices.rest.mandatory value: false,
- INFO - LoggingAdvice.invoke(155) |2018-06-12 23:40:09,880| Exiting method saveGlobalProperty
- WARN - Module.expandExtensionNames(546) |2018-06-12 23:40:10,301| owa: Unable to find class definition for extension: org.openmrs.admin.list
- java.lang.NoClassDefFoundError: org/openmrs/module/web/extension/AdministrationSectionExt
- at java.lang.ClassLoader.defineClass1(Native Method)
- at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
- at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
- at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
- at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
- at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:637)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:556)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at org.openmrs.module.Module.expandExtensionNames(Module.java:538)
- at org.openmrs.module.Module.getExtensions(Module.java:490)
- at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:664)
- at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
- Caused by: java.lang.ClassNotFoundException: org.openmrs.module.web.extension.AdministrationSectionExt
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
- at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
- at org.openmrs.module.ModuleClassLoader.loadClass(ModuleClassLoader.java:563)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- ... 16 more
- INFO - LoggingAdvice.invoke(115) |2018-06-12 23:40:10,347| In method AdministrationService.saveGlobalProperty. Arguments: GlobalProperty=property: owa.started value: true,
- INFO - LoggingAdvice.invoke(155) |2018-06-12 23:40:10,383| Exiting method saveGlobalProperty
- INFO - LoggingAdvice.invoke(115) |2018-06-12 23:40:10,404| In method AdministrationService.saveGlobalProperty. Arguments: GlobalProperty=property: owa.mandatory value: false,
- INFO - LoggingAdvice.invoke(155) |2018-06-12 23:40:10,424| Exiting method saveGlobalProperty
- Exception in thread "Thread-12" java.lang.LinkageError: loader constraint violation: when resolving method "org.slf4j.impl.StaticLoggerBinder.getLoggerFactory()Lorg/slf4j/ILoggerFactory;" the class loader (instance of org/openmrs/module/ModuleClassLoader) of the current class, org/slf4j/LoggerFactory, and the class loader (instance of org/apache/catalina/loader/ParallelWebappClassLoader) for the method's defining class, org/slf4j/impl/StaticLoggerBinder, have different Class objects for the type org/slf4j/ILoggerFactory used in the signature
- at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:273)
- at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:241)
- at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:156)
- at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:132)
- at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:272)
- at org.openmrs.module.chitscore.ChitscoreActivator.<init>(ChitscoreActivator.java:23)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at java.lang.Class.newInstance(Class.java:442)
- at org.openmrs.module.Module.getModuleActivator(Module.java:156)
- at org.openmrs.module.ModuleUtil.refreshApplicationContext(ModuleUtil.java:814)
- at org.openmrs.module.web.WebModuleUtil.refreshWAC(WebModuleUtil.java:866)
- at org.openmrs.web.Listener.performWebStartOfModules(Listener.java:658)
- at org.openmrs.web.Listener.performWebStartOfModules(Listener.java:637)
- at org.openmrs.web.Listener.startOpenmrs(Listener.java:268)
- at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42)
- WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2018-06-12 23:40:11,568| Unable to find a runtime properties file at /home/nthc/workspace/chitscore/openmrs-runtime.properties
- 12-Jun-2018 23:40:11.676 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/webapps/openmrs.war] has finished in [30,593] ms
- 12-Jun-2018 23:40:11.678 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/docs]
- 12-Jun-2018 23:40:11.694 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/docs] has finished in [16] ms
- 12-Jun-2018 23:40:11.694 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/examples]
- 12-Jun-2018 23:40:11.885 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/examples] has finished in [191] ms
- 12-Jun-2018 23:40:11.886 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/host-manager]
- 12-Jun-2018 23:40:11.923 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/host-manager] has finished in [37] ms
- 12-Jun-2018 23:40:11.923 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/ROOT]
- 12-Jun-2018 23:40:11.942 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/ROOT] has finished in [18] ms
- 12-Jun-2018 23:40:11.942 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/manager]
- 12-Jun-2018 23:40:11.968 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/manager] has finished in [26] ms
- 12-Jun-2018 23:40:11.974 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
- 12-Jun-2018 23:40:11.996 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
- 12-Jun-2018 23:40:12.034 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 31065 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement