|
|
2015-09-07 12:09:0
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT OA_WM_LeaveApply.*,SA_Task,SA_Task.sEURL as sEURL,SA_Task.sProcess as sProcess,SA_Task.sActivity as sActivity FROM OA_WM_LeaveApply OA_WM_LeaveApply join SA_Task SA_Task on SA_Task.sData1 = OA_WM_LeaveApply LIMIT 0, -1
--> sql: SELECT OA_WM_LeaveApply.fID AS OA_WM_LeaveApply, SA_Task.sID, OA_WM_LeaveApply.FAPPLYDATE AS fApplyDate, OA_WM_LeaveApply.FAPPLYDEPTID AS fApplyDeptID, OA_WM_LeaveApply.FAPPLYDEPTNAME AS fApplyDeptName, OA_WM_LeaveApply.FAPPLYPERSONID AS fApplyPersonID, OA_WM_LeaveApply.FAPPLYPERSONNAME AS fApplyPersonName, OA_WM_LeaveApply.FBIZSTATE AS fBizState, OA_WM_LeaveApply.FBIZSTATENAME AS fBizStateName, OA_WM_LeaveApply.FCANCEDAYS AS fCanceDays, OA_WM_LeaveApply.FCANCEENDTIME AS fCanceEndTime, OA_WM_LeaveApply.FCANCEHOURS AS fCanceHours, OA_WM_LeaveApply.FCANCESTARTTIME AS fCanceStartTime, OA_WM_LeaveApply.FCANCELHOLSDATE AS fCancelHolsDate, OA_WM_LeaveApply.FCANCELHOLSDEPTNAME AS fCancelHolsDeptName, OA_WM_LeaveApply.FCANCELHOLSPERSONNAME AS fCancelHolsPersonName, OA_WM_LeaveApply.FCANCELTIME AS fCancelTime, OA_WM_LeaveApply.FCLIENTERID AS fClienterID, OA_WM_LeaveApply.FCLIENTERNAME AS fClienterName, OA_WM_LeaveApply.FCREATEDEPTID AS fCreateDeptID, OA_WM_LeaveApply.FCREATEDEPTNAME AS fCreateDeptName, OA_WM_LeaveApply.FCREATEPERID AS fCreatePerID, OA_WM_LeaveApply.FCREATEPERNAME AS fCreatePerName, OA_WM_LeaveApply.FCREATETIME AS fCreateTime, OA_WM_LeaveApply.FCURRENTACTIVITIES AS fCurrentActivities, OA_WM_LeaveApply.FCURRENTEXECUTORS AS fCurrentExecutors, OA_WM_LeaveApply.FDEPTPATH AS fDeptPath, OA_WM_LeaveApply.FENDTIME AS fEndTime, OA_WM_LeaveApply.FFACTDAYS AS fFactDays, OA_WM_LeaveApply.FFACTENDTIME AS fFactEndTime, OA_WM_LeaveApply.FFACTHOURS AS fFactHours, OA_WM_LeaveApply.FFACTSTARTTIME AS fFactStartTime, OA_WM_LeaveApply.FFACTTIME AS fFactTime, OA_WM_LeaveApply.FISREDUCHOLIDAY AS fIsReducHoliday, OA_WM_LeaveApply.FISSALARY AS fIsSalary, OA_WM_LeaveApply.FLEAVEDAYS AS fLeaveDays, OA_WM_LeaveApply.FLEAVEHOURS AS fLeaveHours, OA_WM_LeaveApply.FLEAVEREASON AS fLeaveReason, OA_WM_LeaveApply.FLEAVETIME AS fLeaveTime, OA_WM_LeaveApply.FLEAVETYPEID AS fLeaveTypeID, OA_WM_LeaveApply.FLEAVETYPENAME AS fLeaveTypeName, OA_WM_LeaveApply.FNO AS fNO, OA_WM_LeaveApply.FPLACE AS fPLACE, OA_WM_LeaveApply.FPLANID AS fPlanID, OA_WM_LeaveApply.FPLANNAME AS fPlanName, OA_WM_LeaveApply.FPROJECTID AS fProjectID, OA_WM_LeaveApply.FPROJECTNAME AS fProjectName, OA_WM_LeaveApply.FRELATIONTEL AS fRelationTel, OA_WM_LeaveApply.FREMARK AS fRemark, OA_WM_LeaveApply.FSTARTTIME AS fStartTime, OA_WM_LeaveApply.FTRANSPORT AS fTransport, OA_WM_LeaveApply.FURL AS fURL, OA_WM_LeaveApply.FUPDATEDEPTID AS fUpdateDeptID, OA_WM_LeaveApply.FUPDATEDEPTNAME AS fUpdateDeptName, OA_WM_LeaveApply.FUPDATEPERID AS fUpdatePerID, OA_WM_LeaveApply.FUPDATEPERNAME AS fUpdatePerName, OA_WM_LeaveApply.FUPDATETIME AS fUpdateTime, OA_WM_LeaveApply.FWORKCONNECTPERSONID AS fWorkConnectPersonID, OA_WM_LeaveApply.FWORKCONNECTPERSONNAME AS fWorkConnectPersonName, OA_WM_LeaveApply.FWORKEXPLAIN AS fWorkExplain, SA_Task.SACTIVITY AS sActivity, SA_Task.SEURL AS sEURL, SA_Task.SPROCESS AS sProcess, OA_WM_LeaveApply.VERSION AS version FROM OA_WM_LeaveApply OA_WM_LeaveApply JOIN SA_Task SA_Task ON SA_Task.SDATA1 = OA_WM_LeaveApply.fID
--> binds: []
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_WM_LeaveApply.fID AS OA_WM_LeaveApply, SA_Task.sID, OA_WM_LeaveApply.FAPPLYDATE AS fApplyDate, OA_WM_LeaveApply.FAPPLYDEPTID AS fApplyDeptID, OA_WM_LeaveApply.FAPPLYDEPTNAME AS fApplyDeptName, OA_WM_LeaveApply.FAPPLYPERSONID AS fApplyPersonID, OA_WM_LeaveApply.FAPPLYPERSONNAME AS fApplyPersonName, OA_WM_LeaveApply.FBIZSTATE AS fBizState, OA_WM_LeaveApply.FBIZSTATENAME AS fBizStateName, OA_WM_LeaveApply.FCANCEDAYS AS fCanceDays, OA_WM_LeaveApply.FCANCEENDTIME AS fCanceEndTime, OA_WM_LeaveApply.FCANCEHOURS AS fCanceHours, OA_WM_LeaveApply.FCANCESTARTTIME AS fCanceStartTime, OA_WM_LeaveApply.FCANCELHOLSDATE AS fCancelHolsDate, OA_WM_LeaveApply.FCANCELHOLSDEPTNAME AS fCancelHolsDeptName, OA_WM_LeaveApply.FCANCELHOLSPERSONNAME AS fCancelHolsPersonName, OA_WM_LeaveApply.FCANCELTIME AS fCancelTime, OA_WM_LeaveApply.FCLIENTERID AS fClienterID, OA_WM_LeaveApply.FCLIENTERNAME AS fClienterName, OA_WM_LeaveApply.FCREATEDEPTID AS fCreateDeptID, OA_WM_LeaveApply.FCREATEDEPTNAME AS fCreateDeptName, OA_WM_LeaveApply.FCREATEPERID AS fCreatePerID, OA_WM_LeaveApply.FCREATEPERNAME AS fCreatePerName, OA_WM_LeaveApply.FCREATETIME AS fCreateTime, OA_WM_LeaveApply.FCURRENTACTIVITIES AS fCurrentActivities, OA_WM_LeaveApply.FCURRENTEXECUTORS AS fCurrentExecutors, OA_WM_LeaveApply.FDEPTPATH AS fDeptPath, OA_WM_LeaveApply.FENDTIME AS fEndTime, OA_WM_LeaveApply.FFACTDAYS AS fFactDays, OA_WM_LeaveApply.FFACTENDTIME AS fFactEndTime, OA_WM_LeaveApply.FFACTHOURS AS fFactHours, OA_WM_LeaveApply.FFACTSTARTTIME AS fFactStartTime, OA_WM_LeaveApply.FFACTTIME AS fFactTime, OA_WM_LeaveApply.FISREDUCHOLIDAY AS fIsReducHoliday, OA_WM_LeaveApply.FISSALARY AS fIsSalary, OA_WM_LeaveApply.FLEAVEDAYS AS fLeaveDays, OA_WM_LeaveApply.FLEAVEHOURS AS fLeaveHours, OA_WM_LeaveApply.FLEAVEREASON AS fLeaveReason, OA_WM_LeaveApply.FLEAVETIME AS fLeaveTime, OA_WM_LeaveApply.FLEAVETYPEID AS fLeaveTypeID, OA_WM_LeaveApply.FLEAVETYPENAME AS fLeaveTypeName, OA_WM_LeaveApply.FNO AS fNO, OA_WM_LeaveApply.FPLACE AS fPLACE, OA_WM_LeaveApply.FPLANID AS fPlanID, OA_WM_LeaveApply.FPLANNAME AS fPlanName, OA_WM_LeaveApply.FPROJECTID AS fProjectID, OA_WM_LeaveApply.FPROJECTNAME AS fProjectName, OA_WM_LeaveApply.FRELATIONTEL AS fRelationTel, OA_WM_LeaveApply.FREMARK AS fRemark, OA_WM_LeaveApply.FSTARTTIME AS fStartTime, OA_WM_LeaveApply.FTRANSPORT AS fTransport, OA_WM_LeaveApply.FURL AS fURL, OA_WM_LeaveApply.FUPDATEDEPTID AS fUpdateDeptID, OA_WM_LeaveApply.FUPDATEDEPTNAME AS fUpdateDeptName, OA_WM_LeaveApply.FUPDATEPERID AS fUpdatePerID, OA_WM_LeaveApply.FUPDATEPERNAME AS fUpdatePerName, OA_WM_LeaveApply.FUPDATETIME AS fUpdateTime, OA_WM_LeaveApply.FWORKCONNECTPERSONID AS fWorkConnectPersonID, OA_WM_LeaveApply.FWORKCONNECTPERSONNAME AS fWorkConnectPersonName, OA_WM_LeaveApply.FWORKEXPLAIN AS fWorkExplain, SA_Task.SACTIVITY AS sActivity, SA_Task.SEURL AS sEURL, SA_Task.SPROCESS AS sProcess, OA_WM_LeaveApply.VERSION AS version FROM OA_WM_LeaveApply OA_WM_LeaveApply JOIN SA_Task SA_Task ON SA_Task.SDATA1 = OA_WM_LeaveApply.fID, binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 31 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 32 more
OA_WM_LeaveApply表是存在的 在ccsoa中
SA_TASK是在ccssys中
|
|
IP卡
狗仔卡
发表于 2015-9-7 13:15:53
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2015-9-7 16:26:06
楼主