15:53:00,014 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-3) Completed job org.quartz.impl.JobExecutionContextImpl 15:54:00,001 INFO [com.iemr.common.config.quartz.ScheduleJobForNHMAgentRealTimeData] (scheduling-1) Calling Scheduler for NHM_Agent_Real_Time_Data 15:57:00,002 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-7) Started job org.quartz.impl.JobExecutionContextImpl 15:56:00,001 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-6) Started job org.quartz.impl.JobExecutionContextImpl 15:55:00,002 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-5) Started job org.quartz.impl.JobExecutionContextImpl 15:54:00,002 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-4) Started job org.quartz.impl.JobExecutionContextImpl 15:57:04,804 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-7) SQL Error: 1054, SQLState: 42S22 15:57:04,808 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-7) Unknown column 'sad1_0.QuantityinhandPercent' in 'field list' 15:57:04,810 ERROR [com.iemr.common.service.email.EmailServiceImpl] (jelies-quartz-scheduler_Worker-7) publishEmail failed with error JDBC exception executing SQL [select sad1_0.uuid,sad1_0.Totalquantity,sad1_0.CreatedBy,sad1_0.DistrictName,sad1_0.Emailid,sad1_0.FacilityId,sad1_0.FacilityName,sad1_0.ItemID,sad1_0.ItemName,sad1_0.Quantityinhand,sad1_0.QuantityinhandPercent from v_emailstockalert sad1_0] [Unknown column 'sad1_0.QuantityinhandPercent' in 'field list'] [n/a]; SQL [n/a] 15:57:04,811 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-7) Completed job org.quartz.impl.JobExecutionContextImpl 15:57:04,808 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-4) SQL Error: 1054, SQLState: 42S22 15:57:04,813 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-4) Unknown column 'sad1_0.QuantityinhandPercent' in 'field list' 15:57:04,813 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-6) SQL Error: 1054, SQLState: 42S22 15:57:04,814 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-6) Unknown column 'sad1_0.QuantityinhandPercent' in 'field list' 15:57:04,813 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-5) SQL Error: 1054, SQLState: 42S22 15:57:04,815 ERROR [com.iemr.common.service.email.EmailServiceImpl] (jelies-quartz-scheduler_Worker-6) publishEmail failed with error JDBC exception executing SQL [select sad1_0.uuid,sad1_0.Totalquantity,sad1_0.CreatedBy,sad1_0.DistrictName,sad1_0.Emailid,sad1_0.FacilityId,sad1_0.FacilityName,sad1_0.ItemID,sad1_0.ItemName,sad1_0.Quantityinhand,sad1_0.QuantityinhandPercent from v_emailstockalert sad1_0] [Unknown column 'sad1_0.QuantityinhandPercent' in 'field list'] [n/a]; SQL [n/a] 15:57:04,817 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-6) Completed job org.quartz.impl.JobExecutionContextImpl 15:57:04,814 ERROR [com.iemr.common.service.email.EmailServiceImpl] (jelies-quartz-scheduler_Worker-4) publishEmail failed with error JDBC exception executing SQL [select sad1_0.uuid,sad1_0.Totalquantity,sad1_0.CreatedBy,sad1_0.DistrictName,sad1_0.Emailid,sad1_0.FacilityId,sad1_0.FacilityName,sad1_0.ItemID,sad1_0.ItemName,sad1_0.Quantityinhand,sad1_0.QuantityinhandPercent from v_emailstockalert sad1_0] [Unknown column 'sad1_0.QuantityinhandPercent' in 'field list'] [n/a]; SQL [n/a] 15:57:04,816 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-5) Unknown column 'sad1_0.QuantityinhandPercent' in 'field list' 15:57:04,823 ERROR [com.iemr.common.service.email.EmailServiceImpl] (jelies-quartz-scheduler_Worker-5) publishEmail failed with error JDBC exception executing SQL [select sad1_0.uuid,sad1_0.Totalquantity,sad1_0.CreatedBy,sad1_0.DistrictName,sad1_0.Emailid,sad1_0.FacilityId,sad1_0.FacilityName,sad1_0.ItemID,sad1_0.ItemName,sad1_0.Quantityinhand,sad1_0.QuantityinhandPercent from v_emailstockalert sad1_0] [Unknown column 'sad1_0.QuantityinhandPercent' in 'field list'] [n/a]; SQL [n/a] 15:57:04,822 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-4) Completed job org.quartz.impl.JobExecutionContextImpl 15:57:04,823 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-5) Completed job org.quartz.impl.JobExecutionContextImpl 15:57:25,801 ERROR [com.iemr.common.service.nhm_dashboard.NHM_AgentRealTimeDatacServiceImpl] (scheduling-1) Error While callin CZ Url : http://175.101.1.83/apps/utility/alive_api.php Error Message I/O error on POST request for "http://175.101.1.83/apps/utility/alive_api.php": Connection timed out: connect 15:58:00,001 INFO [com.iemr.common.config.quartz.ScheduleJobForNHMAgentRealTimeData] (scheduling-1) Calling Scheduler for NHM_Agent_Real_Time_Data 15:58:00,002 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-8) Started job org.quartz.impl.JobExecutionContextImpl 15:58:00,017 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-8) SQL Error: 1054, SQLState: 42S22 15:58:00,017 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (jelies-quartz-scheduler_Worker-8) Unknown column 'sad1_0.QuantityinhandPercent' in 'field list' 15:58:00,019 ERROR [com.iemr.common.service.email.EmailServiceImpl] (jelies-quartz-scheduler_Worker-8) publishEmail failed with error JDBC exception executing SQL [select sad1_0.uuid,sad1_0.Totalquantity,sad1_0.CreatedBy,sad1_0.DistrictName,sad1_0.Emailid,sad1_0.FacilityId,sad1_0.FacilityName,sad1_0.ItemID,sad1_0.ItemName,sad1_0.Quantityinhand,sad1_0.QuantityinhandPercent from v_emailstockalert sad1_0] [Unknown column 'sad1_0.QuantityinhandPercent' in 'field list'] [n/a]; SQL [n/a] 15:58:00,020 INFO [com.iemr.common.config.quartz.ScheduleJobServiceForEmail] (jelies-quartz-scheduler_Worker-8) Completed job org.quartz.impl.JobExecutionContextImpl has context menu