|
楼主 |
发表于 2014-12-22 11:41:30
|
显示全部楼层
点击我的日程
详情:
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT OA_SD_Schedule.* FROM OA_SD_Schedule OA_SD_Schedule WHERE ((OA_SD_Schedule IN ( SELECT e.fSDMasterID FROM OA_SD_Executor e WHERE e.fExecutorID ='PSN01')) AND ((:toDate('2014-12-21')OA_SD_Schedule.fBeginTime OR :toDate('2014-12-28')=OA_SD_Schedule.fBeginTime))) ORDER BY fBeginTime DESC LIMIT 0, 20
编码: JUSTEP150039; 提示: 执行sql: SELECT OA_SD_Schedule.VERSION AS version, OA_SD_Schedule.fTitle AS fTitle, OA_SD_Schedule.fBeginDatePart AS fBeginDatePart, OA_SD_Schedule.fBeginTimePart AS fBeginTimePart, OA_SD_Schedule.fBeginTime AS fBeginTime, OA_SD_Schedule.fEndDatePart AS fEndDatePart, OA_SD_Schedule.fEndTimePart AS fEndTimePart, OA_SD_Schedule.fEndTime AS fEndTime, OA_SD_Schedule.fContent AS fContent, OA_SD_Schedule.fExecutors AS fExecutors, OA_SD_Schedule.fIsShared AS fIsShared, OA_SD_Schedule.fIsRemind AS fIsRemind, OA_SD_Schedule.fRemindDatePart AS fRemindDatePart, OA_SD_Schedule.fRemindTimePart AS fRemindTimePart, OA_SD_Schedule.fRemindTime AS fRemindTime, OA_SD_Schedule.fCreatePsnID AS fCreatePsnID, OA_SD_Schedule.fCreatePsnName AS fCreatePsnName, OA_SD_Schedule.fCreateTime AS fCreateTime, OA_SD_Schedule.fCreateURL AS fCreateURL, OA_SD_Schedule.fBizID AS fBizID, OA_SD_Schedule.fBizType AS fBizType, OA_SD_Schedule.FEXTENDSTR1 AS fExtendStr1, OA_SD_Schedule.FEXTENDSTR2 AS fExtendStr2, OA_SD_Schedule.FEXTENDSTR3 AS fExtendStr3, OA_SD_Schedule.FEXTENDSTR4 AS fExtendStr4, OA_SD_Schedule.FEXTENDSTR5 AS fExtendStr5, OA_SD_Schedule.FEXTENDSTR6 AS fExtendStr6, OA_SD_Schedule.FEXTENDSTR7 AS fExtendStr7, OA_SD_Schedule.FEXTENDSTR8 AS fExtendStr8, OA_SD_Schedule.FEXTENDSTR9 AS fExtendStr9, OA_SD_Schedule.FEXTENDDATE1 AS fExtendDate1, OA_SD_Schedule.FEXTENDDATE2 AS fExtendDate2, OA_SD_Schedule.FEXTENDDATE3 AS fExtendDate3, OA_SD_Schedule.FEXTENDDATE4 AS fExtendDate4, OA_SD_Schedule.FEXTENDDATE5 AS fExtendDate5, OA_SD_Schedule.FEXTENDNUM1 AS fExtendNum1, OA_SD_Schedule.FEXTENDNUM2 AS fExtendNum2, OA_SD_Schedule.FEXTENDNUM3 AS fExtendNum3, OA_SD_Schedule.FEXTENDNUM4 AS fExtendNum4, OA_SD_Schedule.FEXTENDNUM5 AS fExtendNum5, OA_SD_Schedule.FISOUTSIDE AS fIsOutSide, OA_SD_Schedule.fID AS OA_SD_Schedule FROM OA_SD_Schedule OA_SD_Schedule WHERE ( (OA_SD_Schedule.fID IN (SELECT e.fMasterID AS fSDMasterID FROM OA_SD_Executor e WHERE e.fExecutorID = ?)) AND ( ( (? < OA_SD_Schedule.fEndTime) OR (? = OA_SD_Schedule.fEndTime) ) AND ( (? > OA_SD_Schedule.fBeginTime) OR (? = OA_SD_Schedule.fBeginTime) ) ) ) AND (OA_SD_Schedule.fScope = '0') ORDER BY fBeginTime DESC, binds: [PSN01, 2014-12-21, 2014-12-21, 2014-12-28, 2014-12-28]出错
Table 'x5sys.oa_sd_schedule' doesn't exist
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT OA_SD_Schedule.* FROM OA_SD_Schedule OA_SD_Schedule WHERE ((OA_SD_Schedule IN ( SELECT e.fSDMasterID FROM OA_SD_Executor e WHERE e.fExecutorID ='PSN01')) AND ((:toDate('2014-12-21')OA_SD_Schedule.fBeginTime OR :toDate('2014-12-28')=OA_SD_Schedule.fBeginTime))) ORDER BY fBeginTime DESC LIMIT 0, 20
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT OA_SD_Schedule.VERSION AS version, OA_SD_Schedule.fTitle AS fTitle, OA_SD_Schedule.fBeginDatePart AS fBeginDatePart, OA_SD_Schedule.fBeginTimePart AS fBeginTimePart, OA_SD_Schedule.fBeginTime AS fBeginTime, OA_SD_Schedule.fEndDatePart AS fEndDatePart, OA_SD_Schedule.fEndTimePart AS fEndTimePart, OA_SD_Schedule.fEndTime AS fEndTime, OA_SD_Schedule.fContent AS fContent, OA_SD_Schedule.fExecutors AS fExecutors, OA_SD_Schedule.fIsShared AS fIsShared, OA_SD_Schedule.fIsRemind AS fIsRemind, OA_SD_Schedule.fRemindDatePart AS fRemindDatePart, OA_SD_Schedule.fRemindTimePart AS fRemindTimePart, OA_SD_Schedule.fRemindTime AS fRemindTime, OA_SD_Schedule.fCreatePsnID AS fCreatePsnID, OA_SD_Schedule.fCreatePsnName AS fCreatePsnName, OA_SD_Schedule.fCreateTime AS fCreateTime, OA_SD_Schedule.fCreateURL AS fCreateURL, OA_SD_Schedule.fBizID AS fBizID, OA_SD_Schedule.fBizType AS fBizType, OA_SD_Schedule.FEXTENDSTR1 AS fExtendStr1, OA_SD_Schedule.FEXTENDSTR2 AS fExtendStr2, OA_SD_Schedule.FEXTENDSTR3 AS fExtendStr3, OA_SD_Schedule.FEXTENDSTR4 AS fExtendStr4, OA_SD_Schedule.FEXTENDSTR5 AS fExtendStr5, OA_SD_Schedule.FEXTENDSTR6 AS fExtendStr6, OA_SD_Schedule.FEXTENDSTR7 AS fExtendStr7, OA_SD_Schedule.FEXTENDSTR8 AS fExtendStr8, OA_SD_Schedule.FEXTENDSTR9 AS fExtendStr9, OA_SD_Schedule.FEXTENDDATE1 AS fExtendDate1, OA_SD_Schedule.FEXTENDDATE2 AS fExtendDate2, OA_SD_Schedule.FEXTENDDATE3 AS fExtendDate3, OA_SD_Schedule.FEXTENDDATE4 AS fExtendDate4, OA_SD_Schedule.FEXTENDDATE5 AS fExtendDate5, OA_SD_Schedule.FEXTENDNUM1 AS fExtendNum1, OA_SD_Schedule.FEXTENDNUM2 AS fExtendNum2, OA_SD_Schedule.FEXTENDNUM3 AS fExtendNum3, OA_SD_Schedule.FEXTENDNUM4 AS fExtendNum4, OA_SD_Schedule.FEXTENDNUM5 AS fExtendNum5, OA_SD_Schedule.FISOUTSIDE AS fIsOutSide, OA_SD_Schedule.fID AS OA_SD_Schedule FROM OA_SD_Schedule OA_SD_Schedule WHERE ( (OA_SD_Schedule.fID IN (SELECT e.fMasterID AS fSDMasterID FROM OA_SD_Executor e WHERE e.fExecutorID = ?)) AND ( ( (? < OA_SD_Schedule.fEndTime) OR (? = OA_SD_Schedule.fEndTime) ) AND ( (? > OA_SD_Schedule.fBeginTime) OR (? = OA_SD_Schedule.fBeginTime) ) ) ) AND (OA_SD_Schedule.fScope = '0') ORDER BY fBeginTime DESC, binds: [PSN01, 2014-12-21, 2014-12-21, 2014-12-28, 2014-12-28]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 31 more
Caused by: java.sql.SQLException: Table 'x5sys.oa_sd_schedule' doesn't exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 32 more
url:/UI/system/service/common/bizAction.j
param:OA_SD_Schedule.fBeginTime OR :toDate('2014-12-28')=OA_SD_Schedule.fBeginTime))]]>020[tr]Error: {"message":"执行KSQL出错, KSQL: SELECT OA_SD_Schedule.* FROM OA_SD_Schedule OA_SD_Schedule WHERE ((OA_SD_Schedule IN ( SELECT e.fSDMasterID FROM OA_SD_Executor e WHERE e.fExecutorID ='PSN01')) AND ((:toDate('2014-12-21')OA_SD_Schedule.fBeginTime OR :toDate('2014-12-28')=OA_SD_Schedule.fBeginTime))) ORDER BY fBeginTime DESC LIMIT 0, 20,刷新数据失败! ","reason":null,"code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\n\tatorg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\n\tat java.lang.Thread.run(Thread.java:745)\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT OA_SD_Schedule.* FROM OA_SD_Schedule OA_SD_Schedule WHERE ((OA_SD_Schedule IN ( SELECT e.fSDMasterID FROM OA_SD_Executor e WHERE e.fExecutorID ='PSN01')) AND ((:toDate('2014-12-21')OA_SD_Schedule.fBeginTime OR :toDate('2014-12-28')=OA_SD_Schedule.fBeginTime))) ORDER BY fBeginTime DESC LIMIT 0, 20\n\tat com.justep.exception.BusinessException.create(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknow
|
|