2026-03-25 19:28:53 446 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(security,char),convert(status,char),convert(roles,char) from dform_module where name = 'home'

2026-03-25 19:28:53 446 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - id=479

2026-03-25 19:28:53 457 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 457 [info] (com.smarteform.hibernate.LookUpDAO) - sql: Select categoryname from dform_rscategories where recordid=case '' when '' then '' else '' end union select 'View All' from dform_rscategories where '' = ''

2026-03-25 19:28:53 458 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 458 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype2@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 458 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),0) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),1) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),2) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),3) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),4) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),5) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),6) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),7) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),8) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),9) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),10) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),11) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),12) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),13) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),14) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),15) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),16) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),17) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),18) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),19) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),20) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),21) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),22) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),23) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),24) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),25) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),26) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),27) and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),28) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),29) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),30) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),31) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),32) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),33) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),34) and date_format(str_to_date('20240401','%Y%m%d'),'%m')=date_format(c1.dt,'%m') and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') union select c1.monthname as m ,c1.d, c2.monthname as m ,c2.d,c3.monthname as m ,c3.d,c4.monthname as m ,c4.d,c5.monthname as m ,c5.d,c6.monthname as m ,c6.d,c7.monthname as m ,c7.d , date_format(c1.dt,'%Y%m%d'),date_format(c2.dt,'%Y%m%d'),date_format(c3.dt,'%Y%m%d'),date_format(c4.dt,'%Y%m%d'),date_format(c5.dt,'%Y%m%d'),date_format(c6.dt,'%Y%m%d'),date_format(c7.dt,'%Y%m%d'), checkPrivateLessonAvailNewCalendar(-1,c1.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c2.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c3.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c4.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c5.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c6.dt, '',''), checkPrivateLessonAvailNewCalendar(-1,c7.dt, '','') from dform_rscalendar_table c1, dform_rscalendar_table c2, dform_rscalendar_table c3, dform_rscalendar_table c4, dform_rscalendar_table c5, dform_rscalendar_table c6, dform_rscalendar_table c7 where c1.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),35) and c2.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),36) and c3.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),37) and c4.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),38) and c5.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),39) and c6.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),40) and c7.dt=ADDDATE(SUBDATE(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1),dayofweek(ADDDATE(LAST_DAY(SUBDATE(str_to_date('20240401','%Y%m%d'), INTERVAL 1 MONTH)), 1))-1),41) and date_format(str_to_date('20240401','%Y%m%d'),'%m')=date_format(c1.dt,'%m') and date_format(date(c1.dt + interval (7 - dayofweek(c1.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c2.dt + interval (7 - dayofweek(c2.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c3.dt + interval (7 - dayofweek(c3.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c4.dt + interval (7 - dayofweek(c4.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c5.dt + interval (7 - dayofweek(c5.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c6.dt + interval (7 - dayofweek(c6.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d') and date_format(date(c7.dt + interval (7 - dayofweek(c7.dt)) day),'%Y%m%d') >= date_format(getjegytime(),'%Y%m%d')

2026-03-25 19:28:53 480 [info] (com.smarteform.hibernate.LookUpDAO) - sql: Select date_format(20240401,'%M, %Y')

2026-03-25 19:28:53 481 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select date_format((str_to_date('20240401','%Y%m%d') + interval 1 month),'%Y%m%d')

2026-03-25 19:28:53 481 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 481 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select ''

2026-03-25 19:28:53 481 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select date_format((str_to_date('20240401','%Y%m%d') - interval 1 month),'%Y%m%d')

2026-03-25 19:28:53 481 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 482 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype2@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 482 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select * from ( select '','View All',case when '' = '' and '' = '' then 'calbluebtnactivenew' else 'calbluebtnactive' end,'' as nnn,'' as weight, 0 as recordid,case when '' = '' and '' = '' then 'ccc' else '' end as color,'' as recordid2 union select recordid, categoryname, case when recordid='' then 'calbluebtnactivenew' else 'calbluebtnactive' end, '' as nnn,weight,recordid,Color,'' as recordid2 from dform_rscategories where status = 'Active' and RegisterOnline='Yes' union select '',name, case when recordid='' then 'calbluebtnactivenew' else 'calbluebtnactive' end, '' as nnn,weight,0 as recordid,color,recordid as recordid2 from dform_plprogram_categories where status = 'Active' and calendar='Yes' ) aaa order by aaa.weight,aaa.recordid

2026-03-25 19:28:53 482 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select '20240401'

2026-03-25 19:28:53 482 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 483 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select waiver from dform_rscategories where recordid = case '' when '' then (select min(recordid) from dform_rscategories where status='Active') else '' end

2026-03-25 19:28:53 483 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select date_format(str_to_date('20240401','%Y%m%d'),'%m')

2026-03-25 19:28:53 483 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select year(str_to_date('20240401','%Y%m%d'))

2026-03-25 19:28:53 483 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select '01','January',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '01' then 'selected' else '' end union select '02','February',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '02' then 'selected' else '' end union select '03','March',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '03' then 'selected' else '' end union select '04','April',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '04' then 'selected' else '' end union select '05','May',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '05' then 'selected' else '' end union select '06','June',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '06' then 'selected' else '' end union select '07','July',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '07' then 'selected' else '' end union select '08','August',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '08' then 'selected' else '' end union select '09','September',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '09' then 'selected' else '' end union select '10','October',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '10' then 'selected' else '' end union select '11','November',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '11' then 'selected' else '' end union select '12','December',case when date_format(str_to_date('20240401','%Y%m%d'),'%m') = '12' then 'selected' else '' end

2026-03-25 19:28:53 484 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select distinct y, case when date_format(str_to_date('20240401','%Y%m%d'),'%Y') = y then 'selected' else '' end from dform_rscalendar_table

2026-03-25 19:28:53 490 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT 1 FROM dform_privatelessonmapping m left join dform_user_transactions t on cast(m.usertransactionid as char(20)) = cast(t.transaction_id as char(20)) where m.recordowner=-1 and m.status='Registration Pending' union SELECT 1 FROM dform_plprogrammapping m,dform_plprograms p, dform_plprogram_categories c where m.camp=p.recordid and p.camptype=c.recordid and c.calendar='Yes' and m.recordowner=-1 and m.status='Registration Pending'

2026-03-25 19:28:53 491 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select concat((select count(*) from dform_programmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_productmapping where recordowner=-1 and status='Order Pending') + (select count(*) from dform_childrencampmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_childrenlessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_privatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_plprogrammapping where recordowner=-1 and status='Registration Pending'),' ',case when (select count(*) from dform_programmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_productmapping where recordowner=-1 and status='Order Pending') + (select count(*) from dform_childrencampmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_childrenlessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_privatelessonmapping where recordowner=-1 and status='Registration Pending') + (select count(*) from dform_plprogrammapping where recordowner=-1 and status='Registration Pending') > 1 then 'Items' else 'Item' end)

2026-03-25 19:28:53 492 [error] (com.smarteform.spring.bean.handler.ReportHandler) - Error getEventVariable @@Request.bookingtype2@@
java.lang.NullPointerException
at com.smarteform.spring.bean.handler.BaseHandler.getVariable(BaseHandler.java:990)
at com.smarteform.spring.bean.handler.BaseHandler.filterVariables(BaseHandler.java:1153)
at com.smarteform.spring.bean.handler.ReportHandler.readReportHtml(ReportHandler.java:184)
at com.smarteform.spring.mvc.controller.report.ReportViewController.handleRequest(ReportViewController.java:45)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:748)


2026-03-25 19:28:53 493 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select ''

2026-03-25 19:28:53 493 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-03-25 19:28:53 494 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-03-25 19:28:53 494 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-03-25 19:28:53 494 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-03-25 19:28:53 495 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-03-25 19:28:53 495 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-03-25 19:28:53 496 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-03-25 19:28:53 496 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-03-25 19:28:53 496 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(javascript,char),convert(javascript,char),convert(javascript,char) from dform_mobilelookandfeel where recordid=1

2026-03-25 19:28:53 497 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-03-25 19:28:53 497 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-03-25 19:28:53 497 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-03-25 19:28:53 498 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-03-25 19:28:53 498 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(header,char),convert(header,char),convert(header,char) from dform_mobilelookandfeel where recordid=1

2026-03-25 19:28:53 498 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-03-25 19:28:53 499 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-03-25 19:28:53 499 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-03-25 19:28:53 499 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-03-25 19:28:53 510 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select background from dform_color where recordid=1

2026-03-25 19:28:53 510 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-03-25 19:28:53 511 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-03-25 19:28:53 511 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-03-25 19:28:53 511 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-03-25 19:28:53 512 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(footer,char),convert(footer,char),convert(footer,char) from dform_mobilelookandfeel where recordid=1

2026-03-25 19:28:53 512 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-03-25 19:28:53 512 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-03-25 19:28:53 513 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-03-25 19:28:53 513 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1