@Override
public List<EntDbLoadPaxSummary> findByTimeRange() {
List<EntDbLoadPaxSummary> res = new ArrayList<>();
HpUfisCalendar startDate = new HpUfisCalendar();
HpUfisCalendar endDate = new HpUfisCalendar();
startDate.setTimeZone(HpEKConstants.utcTz);
endDate.setTimeZone(HpEKConstants.utcTz);
startDate.DateAdd(HpPaxAlertTimeRangeConfig.getPaxAlertFromOffset(), EnumTimeInterval.Hours);
endDate.DateAdd(HpPaxAlertTimeRangeConfig.getPaxAlertToOffset(), EnumTimeInterval.Hours);
LOG.debug("Timer FromOffset : <{}> ToOffset : <{}>", startDate.getCedaString(), endDate.getCedaString());
try{
Query query = _em.createNamedQuery("EntDbLoadPaxSummary.findByTimeRange");
query.setParameter("starDate", startDate.getTime());
query.setParameter("endDate", endDate.getTime());
query.setParameter("infoType", HpEKConstants.INFO_ID_PAX_ALERT);
res = query.getResultList();
LOG.debug("Total pax connected flights within current UTC : <{}>", res.size());
} catch (Exception ex) {