|
|
请问这是什么错误，应该怎么解决
OA_Schedule.fRepeat,OA_Schedule.fStartTime,OA_Schedule.fEndTime,OA_Schedule.fRepeatFrequency,OA_Schedule.fWeekRepeat,OA_Schedule.fUpToDate,OA_Schedule.fCreatorID,OA_Schedule.fName,OA_Schedule from OA_Schedule OA_Schedule where OA_Schedule.fCreatorID = :sPersonID and stringToDate(:scheMonthFirstDay) >= stringToDate(concat(getYear(OA_Schedule.fStartTime), '-', getMonth(OA_Schedule.fStartTime), '-01')) and (OA_Schedule.fUpToDate is null or stringToDate(:scheMonthFirstDay) <= fUpToDate) union select OA_Schedule.fRepeat,OA_Schedule.fStartTime,OA_Schedule.fEndTime,OA_Schedule.fRepeatFrequency,OA_Schedule.fWeekRepeat,OA_Schedule.fUpToDate,SA_Social.sPersonID,OA_Schedule.fName,OA_Schedule from OA_Schedule OA_Schedule join SA_Social SA_Social on OA_Schedule = SA_Social.sData1 and SA_Social.sValidState = '1' and SA_Social.sTypeID = 'RelativeOrg' and (SA_Social.sESField01 ='o') and SA_Social.sPersonID = :sPersonID where stringToDate(:scheMonthFirstDay) >= stringToDate(concat(getYear(OA_Schedule.fStartTime), '-', getMonth(OA_Schedule.fStartTime), '-01')) and (OA_Schedule.fUpToDate is null or stringToDate(:scheMonthFirstDay) <= fUpToDate)
--> sql: SELECT OA_Schedule.FREPEAT AS fRepeat, OA_Schedule.FSTARTTIME AS fStartTime, OA_Schedule.FENDTIME AS fEndTime, OA_Schedule.FREPEATFREQUENCY AS fRepeatFrequency, OA_Schedule.FWEEKREPEAT AS fWeekRepeat, OA_Schedule.FUPTODATE AS fUpToDate, OA_Schedule.FCREATORID AS fCreatorID, OA_Schedule.FNAME AS fName, OA_Schedule.fID FROM OA_SCHEDULE OA_Schedule WHERE (OA_Schedule.FCREATORID = ? ) AND (CONVERT(datetime , ? + ' 00:00:00', 120) >= CONVERT(datetime ,DATEPART(yyyy, OA_Schedule.FSTARTTIME) + ? + DATEPART(mm, OA_Schedule.FSTARTTIME) + ?+ ' 00:00:00', 120)) AND ( (OA_Schedule.FUPTODATE IS NULL) OR (CONVERT(datetime , ? + ' 00:00:00', 120) <= fUpToDate) ) UNION SELECT OA_Schedule.FREPEAT AS OA_Schedule_fRepeat, OA_Schedule.FSTARTTIME AS OA_Schedule_fStartTime, OA_Schedule.FENDTIME AS OA_Schedule_fEndTime, OA_Schedule.FREPEATFREQUENCY AS OA_Schedule_fRepeatFrequency, OA_Schedule.FWEEKREPEAT AS OA_Schedule_fWeekRepeat, OA_Schedule.FUPTODATE AS OA_Schedule_fUpToDate, SA_Social.SPERSONID AS sPersonID, OA_Schedule.FNAME AS OA_Schedule_fName, OA_Schedule.fID FROM OA_SCHEDULE OA_Schedule JOIN SA_Social SA_Social ON (OA_Schedule.fID = SA_Social.SDATA1) AND (SA_Social.SVALIDSTATE = ?) AND (SA_Social.STYPEID = ?) AND (SA_Social.SESFIELD01 = ?) AND (SA_Social.SPERSONID = ? ) WHERE (CONVERT(datetime , ? + ' 00:00:00', 120) >= CONVERT(datetime ,DATEPART(yyyy, OA_Schedule.FSTARTTIME) + ? + DATEPART(mm, OA_Schedule.FSTARTTIME) + ?+ ' 00:00:00', 120)) AND ( (OA_Schedule.FUPTODATE IS NULL) OR (CONVERT(datetime , ? + ' 00:00:00', 120) <= fUpToDate) )
--> binds: [PSN01, 2016-09-01, -, -01, 2016-09-01, 1, RelativeOrg, o, PSN01, 2016-09-01, -, -01, 2016-09-01]
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.KSQL.select(Unknown Source)
at Schedule.queryOA_ScheduleMonth(Schedule.java:52)
... 47 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT OA_Schedule.FREPEAT AS fRepeat, OA_Schedule.FSTARTTIME AS fStartTime, OA_Schedule.FENDTIME AS fEndTime, OA_Schedule.FREPEATFREQUENCY AS fRepeatFrequency, OA_Schedule.FWEEKREPEAT AS fWeekRepeat, OA_Schedule.FUPTODATE AS fUpToDate, OA_Schedule.FCREATORID AS fCreatorID, OA_Schedule.FNAME AS fName, OA_Schedule.fID FROM OA_SCHEDULE OA_Schedule WHERE (OA_Schedule.FCREATORID = ? ) AND (CONVERT(datetime , ? + ' 00:00:00', 120) >= CONVERT(datetime ,DATEPART(yyyy, OA_Schedule.FSTARTTIME) + ? + DATEPART(mm, OA_Schedule.FSTARTTIME) + ?+ ' 00:00:00', 120)) AND ( (OA_Schedule.FUPTODATE IS NULL) OR (CONVERT(datetime , ? + ' 00:00:00', 120) <= fUpToDate) ) UNION SELECT OA_Schedule.FREPEAT AS OA_Schedule_fRepeat, OA_Schedule.FSTARTTIME AS OA_Schedule_fStartTime, OA_Schedule.FENDTIME AS OA_Schedule_fEndTime, OA_Schedule.FREPEATFREQUENCY AS OA_Schedule_fRepeatFrequency, OA_Schedule.FWEEKREPEAT AS OA_Schedule_fWeekRepeat, OA_Schedule.FUPTODATE AS OA_Schedule_fUpToDate, SA_Social.SPERSONID AS sPersonID, OA_Schedule.FNAME AS OA_Schedule_fName, OA_Schedule.fID FROM OA_SCHEDULE OA_Schedule JOIN SA_Social SA_Social ON (OA_Schedule.fID = SA_Social.SDATA1) AND (SA_Social.SVALIDSTATE = ?) AND (SA_Social.STYPEID = ?) AND (SA_Social.SESFIELD01 = ?) AND (SA_Social.SPERSONID = ? ) WHERE (CONVERT(datetime , ? + ' 00:00:00', 120) >= CONVERT(datetime ,DATEPART(yyyy, OA_Schedule.FSTARTTIME) + ? + DATEPART(mm, OA_Schedule.FSTARTTIME) + ?+ ' 00:00:00', 120)) AND ( (OA_Schedule.FUPTODATE IS NULL) OR (CONVERT(datetime , ? + ' 00:00:00', 120) <= fUpToDate) ) , binds: [PSN01, 2016-09-01, -, -01, 2016-09-01, 1, RelativeOrg, o, PSN01, 2016-09-01, -, -01, 2016-09-01]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 52 more
Caused by: java.sql.SQLException: 在将 varchar 值 ' 00:00:00' 转换成数据类型 int 时失败。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:792)
at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 53 more
2016-09-01 17:01:35 [Action Time]action执行时间：15ms,/OA/personalOffice/process/schedule/scheduleProcess,mainActivity,queryOA_ScheduleMonthAction
2016-09-01 17:01:35 [Action Time]action执行时间：5ms,/SA/OPM/system/systemProcess,mainActivity,getClientAppsAction
//*[@process='/OA/personalOffice/process/tasksAssigned/tasksAssignedProcess' and @activity='mainActivity' and @url='null']
|
|
IP卡
狗仔卡
发表于 2016-9-1 17:08:44
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2016-9-1 17:43:38
楼主