FSM3.1-INFO: select PageHeight,PageWidth from p_desktopself where AgentID='yqzg' and MenuID='5005' (dbsqlinfo) [2014-04-14 09:29:26,275]
FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc (dbsqlinfo) [2014-04-14 09:29:27,445]
FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' ) t)where rowno>='1' and rowno<='20' (dbsqlinfo) [2014-04-14 09:29:32,653]
FSM3.1-INFO: select count(*) from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' (dbsqlinfo) [2014-04-14 09:29:32,758]
FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc (dbsqlinfo) [2014-04-14 09:29:37,163]
FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' ) t)where rowno>='1' and rowno<='20' (dbsqlinfo) [2014-04-14 09:29:41,107]
FSM3.1-INFO: select count(*) from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' (dbsqlinfo) [2014-04-14 09:29:41,221]
FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc (dbsqlinfo) [2014-04-14 09:29:48,400]
FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' ) t)where rowno>='1' and rowno<='20' (dbsqlinfo) [2014-04-14 09:29:49,703]
FSM3.1-INFO: select count(*) from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' (dbsqlinfo) [2014-04-14 09:29:49,825]
FSM3.1-INFO: [MyTaskGroup.网站访问量统计.20120919164235890485742] 作业在 “2014-04-14 09:30:00” 启动， 时间间隔表达式为: 0 */30 * * * ? (com.fsm.task.JspJob) [2014-04-14 09:30:00,070]
FSM3.1-INFO: [MyTaskGroup.信息发布量统计.20120918164235890485742] 作业在 “2014-04-14 09:30:00” 启动， 时间间隔表达式为: 0 */30 * * * ? (com.fsm.task.JspJob) [2014-04-14 09:30:00,070]
FSM3.1-INFO: [MyTaskGroup.网站点击量统计.20120920164235890485742] 作业在 “2014-04-14 09:30:00” 启动， 时间间隔表达式为: 0 */30 * * * ? (com.fsm.task.JspJob) [2014-04-14 09:30:00,070]
FSM3.1-INFO: select count(1) from p_tasklog where TaskID='20120920164235890485742' and RecordTime='2014-04-14 09:30:00' (dbsqlinfo) [2014-04-14 09:30:00,197]
FSM3.1-INFO: select count(1) from p_tasklog where TaskID='20120919164235890485742' and RecordTime='2014-04-14 09:30:00' (dbsqlinfo) [2014-04-14 09:30:00,198]
FSM3.1-INFO: select count(1) from p_tasklog where TaskID='20120918164235890485742' and RecordTime='2014-04-14 09:30:00' (dbsqlinfo) [2014-04-14 09:30:00,199]
FSM3.1-INFO: insert into p_tasklog (TID,TaskID,TaskName,LogType,DoState,LogInfo,RecordTime) values ('2014041409300007020120919164235890485742','20120919164235890485742','网站访问量统计','执行','执行中','“MyTaskGroup.网站访问量统计”作业在“2014-04-14 09:30:00”被“192.168.191.1”执行！','2014-04-14 09:30:00') (dbsqlinfo) [2014-04-14 09:30:00,357]
FSM3.1-INFO: insert into p_tasklog (TID,TaskID,TaskName,LogType,DoState,LogInfo,RecordTime) values ('2014041409300007020120920164235890485742','20120920164235890485742','网站点击量统计','执行','执行中','“MyTaskGroup.网站点击量统计”作业在“2014-04-14 09:30:00”被“192.168.191.1”执行！','2014-04-14 09:30:00') (dbsqlinfo) [2014-04-14 09:30:00,358]
FSM3.1-INFO: insert into p_tasklog (TID,TaskID,TaskName,LogType,DoState,LogInfo,RecordTime) values ('2014041409300007020120918164235890485742','20120918164235890485742','信息发布量统计','执行','执行中','“MyTaskGroup.信息发布量统计”作业在“2014-04-14 09:30:00”被“192.168.191.1”执行！','2014-04-14 09:30:00') (dbsqlinfo) [2014-04-14 09:30:00,360]
FSM3.1-INFO: select min(TID) from p_tasklog where TaskID='20120919164235890485742' and RecordTime='2014-04-14 09:30:00' (dbsqlinfo) [2014-04-14 09:30:00,407]
FSM3.1-INFO: select min(TID) from p_tasklog where TaskID='20120918164235890485742' and RecordTime='2014-04-14 09:30:00' (dbsqlinfo) [2014-04-14 09:30:00,491]
FSM3.1-INFO: select min(TID) from p_tasklog where TaskID='20120920164235890485742' and RecordTime='2014-04-14 09:30:00' (dbsqlinfo) [2014-04-14 09:30:00,653]
FSM3.1-INFO: delete from p_visitrep where VisitDate='2014-04-14' (dbsqlinfo) [2014-04-14 09:30:01,088]
FSM3.1-INFO: delete from p_webreleaserep where RecordDate='2014-04-14' (dbsqlinfo) [2014-04-14 09:30:01,092]
FSM3.1-INFO: delete from p_infodotrep where DotDate='2014-04-14' (dbsqlinfo) [2014-04-14 09:30:01,248]
FSM3.1-INFO: select sum(VisitNum) as VisitNum from p_counter where VisitTime >= '2014-04-14 00:00:00' and VisitTime <= '2014-04-14 23:59:59' (dbsqlinfo) [2014-04-14 09:30:01,253]
FSM3.1-INFO: select * from p_site order by SortID asc (dbsqlinfo) [2014-04-14 09:30:01,446]
FSM3.1-INFO: select SiteID,ColumnID,count(*) as DotNum from p_infodot where DotTime >= '2014-04-14 00:00:00' and DotTime <= '2014-04-14 23:59:59' group by SiteID,ColumnID (dbsqlinfo) [2014-04-14 09:30:01,462]
FSM3.1-INFO: insert into p_visitrep(VisitDate,VisitNum) values('2014-04-14',0) (dbsqlinfo) [2014-04-14 09:30:01,493]
FSM3.1-INFO: select DeptID,AgentID,SiteID,ColumnID,count(*) as RelNum from p_web where TState='finished' and ReleaseTime >= '2014-04-14 00:00:00' and ReleaseTime <= '2014-04-14 23:59:59' group by DeptID,AgentID,SiteID,ColumnID (dbsqlinfo) [2014-04-14 09:30:01,497]
FSM3.1-INFO: update p_tasklog set DoState='成功',LogInfo='“MyTaskGroup.网站点击量统计”作业在“2014-04-14 09:30:00”被“192.168.191.1”执行！ 执行结束时间：2014-04-14 09:30:01'where TID='2014041409300007020120920164235890485742' (dbsqlinfo) [2014-04-14 09:30:01,804]
FSM3.1-INFO: update p_tasklog set DoState='成功',LogInfo='“MyTaskGroup.网站访问量统计”作业在“2014-04-14 09:30:00”被“192.168.191.1”执行！ 执行结束时间：2014-04-14 09:30:01'where TID='2014041409300007020120919164235890485742' (dbsqlinfo) [2014-04-14 09:30:01,805]
FSM3.1-INFO: select * from p_column where ColumnType='pic' order by SortID asc (dbsqlinfo) [2014-04-14 09:30:01,924]
FSM3.1-INFO: update p_tasklog set DoState='成功',LogInfo='“MyTaskGroup.信息发布量统计”作业在“2014-04-14 09:30:00”被“192.168.191.1”执行！ 执行结束时间：2014-04-14 09:30:01'where TID='2014041409300007020120918164235890485742' (dbsqlinfo) [2014-04-14 09:30:02,009]
java.io.FileNotFoundException: D:workspacegbrmWebRoot空缺职位列表20140414093026.xls (系统找不到指定的路径。)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
at jxl.Workbook.createWorkbook(Workbook.java:272)
at jxl.Workbook.createWorkbook(Workbook.java:259)
at org.apache.jsp.gbrm.app.sjcx_005fkqzw_005fexp_jsp._jspService(sjcx_005fkqzw_005fexp_jsp.java:148)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' ) t)where rowno>='1' and rowno<='20' (dbsqlinfo) [2014-04-14 09:30:40,053]
FSM3.1-INFO: select count(*) from j_kqzw where 1=1 and DEADLINE >='2013-04-14' and DEADLINE <='2014-04-14' (dbsqlinfo) [2014-04-14 09:30:40,150]