OA协同中考勤管理>外出申请出错

iamama

OA协同中考勤管理>外出申请出错
采用的是MYSQL，按流程上走的，3.2，3.3版本都试了，我的电脑是XP系统

执行KSQL出错, KSQL: INSERT INTO OA_WM_outApply OA_WM_outApply(OA_WM_outApply, OA_WM_outApply.version, OA_WM_outApply.fAPPLYDATE, OA_WM_outApply.fAPPLYDEPTID, OA_WM_outApply.fAPPLYDEPTNAME, OA_WM_outApply.fAPPLYPERSONID, OA_WM_outApply.fAPPLYPERSONNAME, OA_WM_outApply.fBizState, OA_WM_outApply.fBizStateName, OA_WM_outApply.fCANCELHOLSDATE, OA_WM_outApply.fCANCELHOLSDEPTID, OA_WM_outApply.fCANCELHOLSDEPTNAME, OA_WM_outApply.fCANCELHOLSPERSONID, OA_WM_outApply.fCANCELHOLSPERSONNAME, OA_WM_outApply.fCLIENTERID, OA_WM_outApply.fCLIENTERNAME, OA_WM_outApply.fCREATEDEPTID, OA_WM_outApply.fCREATEDEPTNAME, OA_WM_outApply.fCreatePerID, OA_WM_outApply.fCreatePerName, OA_WM_outApply.fCreateTime, OA_WM_outApply.fCurrentActivities, OA_WM_outApply.fCurrentExecutors, OA_WM_outApply.fDAYS, OA_WM_outApply.fENDTIME, OA_WM_outApply.fExplain, OA_WM_outApply.fFACTDAYS, OA_WM_outApply.fFACTENDTIME, OA_WM_outApply.fFACTHOURS, OA_WM_outApply.fFACTSTARTTIME, OA_WM_outApply.fFactTime, OA_WM_outApply.fHOURS, OA_WM_outApply.fISSURE, OA_WM_outApply.fNO, OA_WM_outApply.fNUMBER, OA_WM_outApply.fPERSONNEL, OA_WM_outApply.fPLANID, OA_WM_outApply.fPLANNAME, OA_WM_outApply.fPROJECTID, OA_WM_outApply.fPROJECTNAME, OA_WM_outApply.fREASON, OA_WM_outApply.fRemark, OA_WM_outApply.fSTARTTIME, OA_WM_outApply.fTIME, OA_WM_outApply.fUPDATEDEPTID, OA_WM_outApply.fUPDATEDEPTNAME, OA_WM_outApply.fUPDATEPERID, OA_WM_outApply.fUPDATEPERNAME, OA_WM_outApply.fUPDATETIME, OA_WM_outApply.fURL) VALUES (:OA_WM_outApply, :version, :fAPPLYDATE, :fAPPLYDEPTID, :fAPPLYDEPTNAME, :fAPPLYPERSONID, :fAPPLYPERSONNAME, :fBizState, :fBizStateName, :fCANCELHOLSDATE, :fCANCELHOLSDEPTID, :fCANCELHOLSDEPTNAME, :fCANCELHOLSPERSONID, :fCANCELHOLSPERSONNAME, :fCLIENTERID, :fCLIENTERNAME, :fCREATEDEPTID, :fCREATEDEPTNAME, :fCreatePerID, :fCreatePerName, :fCreateTime, :fCurrentActivities, :fCurrentExecutors, :fDAYS, :fENDTIME, :fExplain, :fFACTDAYS, :fFACTENDTIME, :fFACTHOURS, :fFACTSTARTTIME, :fFactTime, :fHOURS, :fISSURE, :fNO, :fNUMBER, :fPERSONNEL, :fPLANID, :fPLANNAME, :fPROJECTID, :fPROJECTNAME, :fREASON, :fRemark, :fSTARTTIME, :fTIME, :fUPDATEDEPTID, :fUPDATEDEPTNAME, :fUPDATEPERID, :fUPDATEPERNAME, :fUPDATETIME, :fURL)
编码：JUSTEP150210

jishuang

发tomcat控制台完整的错误信息

iamama

控制台错误文档见附件！

iamama

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
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:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO OA_WM_outApply OA_WM_outApply(OA_WM_outApply, OA_WM_outApply.version, OA_WM_outApply.fAPPLYDATE, OA_WM_outApply.fAPPLYDEPTID, OA_WM_outApply.fAPPLYDEPTNAME, OA_WM_outApply.fAPPLYPERSONID, OA_WM_outApply.fAPPLYPERSONNAME, OA_WM_outApply.fBizState, OA_WM_outApply.fBizStateName, OA_WM_outApply.fCANCELHOLSDATE, OA_WM_outApply.fCANCELHOLSDEPTID, OA_WM_outApply.fCANCELHOLSDEPTNAME, OA_WM_outApply.fCANCELHOLSPERSONID, OA_WM_outApply.fCANCELHOLSPERSONNAME, OA_WM_outApply.fCLIENTERID, OA_WM_outApply.fCLIENTERNAME, OA_WM_outApply.fCREATEDEPTID, OA_WM_outApply.fCREATEDEPTNAME, OA_WM_outApply.fCreatePerID, OA_WM_outApply.fCreatePerName, OA_WM_outApply.fCreateTime, OA_WM_outApply.fCurrentActivities, OA_WM_outApply.fCurrentExecutors, OA_WM_outApply.fDAYS, OA_WM_outApply.fENDTIME, OA_WM_outApply.fExplain, OA_WM_outApply.fFACTDAYS, OA_WM_outApply.fFACTENDTIME, OA_WM_outApply.fFACTHOURS, OA_WM_outApply.fFACTSTARTTIME, OA_WM_outApply.fFactTime, OA_WM_outApply.fHOURS, OA_WM_outApply.fISSURE, OA_WM_outApply.fNO, OA_WM_outApply.fNUMBER, OA_WM_outApply.fPERSONNEL, OA_WM_outApply.fPLANID, OA_WM_outApply.fPLANNAME, OA_WM_outApply.fPROJECTID, OA_WM_outApply.fPROJECTNAME, OA_WM_outApply.fREASON, OA_WM_outApply.fRemark, OA_WM_outApply.fSTARTTIME, OA_WM_outApply.fTIME, OA_WM_outApply.fUPDATEDEPTID, OA_WM_outApply.fUPDATEDEPTNAME, OA_WM_outApply.fUPDATEPERID, OA_WM_outApply.fUPDATEPERNAME, OA_WM_outApply.fUPDATETIME, OA_WM_outApply.fURL) VALUES (:OA_WM_outApply, :version, :fAPPLYDATE, :fAPPLYDEPTID, :fAPPLYDEPTNAME, :fAPPLYPERSONID, :fAPPLYPERSONNAME, :fBizState, :fBizStateName, :fCANCELHOLSDATE, :fCANCELHOLSDEPTID, :fCANCELHOLSDEPTNAME, :fCANCELHOLSPERSONID, :fCANCELHOLSPERSONNAME, :fCLIENTERID, :fCLIENTERNAME, :fCREATEDEPTID, :fCREATEDEPTNAME, :fCreatePerID, :fCreatePerName, :fCreateTime, :fCurrentActivities, :fCurrentExecutors, :fDAYS, :fENDTIME, :fExplain, :fFACTDAYS, :fFACTENDTIME, :fFACTHOURS, :fFACTSTARTTIME, :fFactTime, :fHOURS, :fISSURE, :fNO, :fNUMBER, :fPERSONNEL, :fPLANID, :fPLANNAME, :fPROJECTID, :fPROJECTNAME, :fREASON, :fRemark, :fSTARTTIME, :fTIME, :fUPDATEDEPTID, :fUPDATEDEPTNAME, :fUPDATEPERID, :fUPDATEPERNAME, :fUPDATETIME, :fURL)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.BizData.save(Unknown Source)
at BizProcedure.save(BizProcedure.java:143)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO OA_WM_OutApply (OA_WM_OutApply.fID, OA_WM_OutApply.VERSION, OA_WM_OutApply.FAPPLYDATE, OA_WM_OutApply.FAPPLYDEPTID, OA_WM_OutApply.FAPPLYDEPTNAME, OA_WM_OutApply.FAPPLYPERSONID, OA_WM_OutApply.FAPPLYPERSONNAME, OA_WM_OutApply.FBIZSTATE, OA_WM_OutApply.FBIZSTATENAME, OA_WM_OutApply.FCANCELHOLSDATE, OA_WM_OutApply.FCANCELHOLSDEPTID, OA_WM_OutApply.FCANCELHOLSDEPTNAME, OA_WM_OutApply.FCANCELHOLSPERSONID, OA_WM_OutApply.FCANCELHOLSPERSONNAME, OA_WM_OutApply.FCLIENTERID, OA_WM_OutApply.FCLIENTERNAME, OA_WM_OutApply.FCREATEDEPTID, OA_WM_OutApply.FCREATEDEPTNAME, OA_WM_OutApply.FCREATEPERID, OA_WM_OutApply.FCREATEPERNAME, OA_WM_OutApply.FCREATETIME, OA_WM_OutApply.FCURRENTACTIVITIES, OA_WM_OutApply.FCURRENTEXECUTORS, OA_WM_OutApply.FDAYS, OA_WM_OutApply.FENDTIME, OA_WM_OutApply.FEXPLAIN, OA_WM_OutApply.FFACTDAYS, OA_WM_OutApply.FFACTENDTIME, OA_WM_OutApply.FFACTHOURS, OA_WM_OutApply.FFACTSTARTTIME, OA_WM_OutApply.FFACTTIME, OA_WM_OutApply.FHOURS, OA_WM_OutApply.FISSURE, OA_WM_OutApply.FNO, OA_WM_OutApply.FNUMBER, OA_WM_OutApply.FPERSONNEL, OA_WM_OutApply.FPLANID, OA_WM_OutApply.FPLANNAME, OA_WM_OutApply.FPROJECTID, OA_WM_OutApply.FPROJECTNAME, OA_WM_OutApply.FREASON, OA_WM_OutApply.FREMARK, OA_WM_OutApply.FSTARTTIME, OA_WM_OutApply.FTIME, OA_WM_OutApply.FUPDATEDEPTID, OA_WM_OutApply.FUPDATEDEPTNAME, OA_WM_OutApply.FUPDATEPERID, OA_WM_OutApply.FUPDATEPERNAME, OA_WM_OutApply.FUPDATETIME, OA_WM_OutApply.FURL, OA_WM_OutApply.fType) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?), binds: [482DB3E9FCAF403EAABCE6AA2AAE1304, 0, 2016-08-24, F9F279D0C1924E3AB753B72C76C1CF08, 办公室, 87930426E1EE42C29F592484CA028A9C, 起步OA, bsEditing, 编辑中, null, null, null, null, null, null, null, F9F279D0C1924E3AB753B72C76C1CF08, 办公室, 87930426E1EE42C29F592484CA028A9C, 起步OA, 2016-08-24 08:44:21.0, null, null, 1, 2016-08-26 08:44:27.935, null, null, null, 0.0, null, null, 7.0, 0, CCSQ-20160824001, 1, 张三, null, null, null, null, 买东西！, 没有, 2016-08-24 10:44:21.861, 0, F9F279D0C1924E3AB753B72C76C1CF08, 办公室, 87930426E1EE42C29F592484CA028A9C, 起步OA, 2016-08-24 08:44:21.031, /ORG01.ogn/F9F279D0C1924E3AB753B72C76C1CF08.dpt/87930426E1EE42C29F592484CA028A9C@F9F279D0C1924E3AB753B72C76C1CF08.psm, 外出申请]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 36 more
Caused by: java.sql.SQLException: Unknown column 'OA_WM_OutApply.FNUMBER' in 'field list'
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.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 37 more

jishuang

http://docs.wex5.com/bex5-server-question-list-10013/