|
版本: |
其它(帖子中说明) |
小版本号: |
3.2 |
|
|
数据库: |
MySQL |
服务器操作系统: |
Linux |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Firefox |
|
|
在Ubuntu下部署BeX5_3.2版本,登录时报错,错误信息如下:
执行sql: insert into SA_Log (sOperatingSystem, sDeviceType, sActivityName, sStatusName, sCreatorPersonName, version, SID, sProcess, sParameters, sActionName, sTypeName, sActivity, sCreateTime, sProcessName, sIP, sAction, $clientName ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue ), binds: [WINDOWS_7, Computer, 系统, 失败, system, 0, AAC1D93C930A4F6DB36C5D6E3580F4BC, /SA/OPM/system/systemProcess, ******, 登录, 操作日志, mainActivity, 2015-07-27 18:27:38.536, 系统调用, 114.247.235.162, loginAction]失败
java.sql.SQLException: Table 'x5sys.SA_Log' 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.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)
at com.justep.system.interceptor.LogBefore.execSqlUpdate(Unknown Source)
at com.justep.system.interceptor.LogBefore.b(Unknown Source)
at com.justep.system.interceptor.LogBefore.c(Unknown Source)
at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
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.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)
2015-07-27 18:27:38 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="loginAction" execute-context="" content-type="application/xml"><parameters><parameter name="pwd"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">:e0d34b5ab5e5f0831ac99a9be6072f8e</xbiz:simple></parameter><parameter name="name"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">system</xbiz:simple></parameter><parameter name="loginDate"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Date">2015-07-27</xbiz:simple></parameter><parameter name="lang"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">zh_CN</xbiz:simple></parameter><parameter name="options"><xbiz:map xmlns:xbiz="http://www.justep.com/xbiz#"><item key="DeviceType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">Computer</xbiz:simple></item><item key="OperatingSystem"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">WINDOWS_7</xbiz:simple></item></xbiz:map></parameter><parameter name="ip"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">114.247.235.162</xbiz:simple></parameter></parameters></action>
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.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.system.util.BizSystemException: 编码: JUSTEP180040; 提示: 查询用户出错
at com.justep.system.util.BizSystemException.create(Unknown Source)
at com.justep.system.opm.OrgUtils.select(Unknown Source)
at com.justep.system.opm.OrgUtils.getPersonByDB(Native Method)
at com.justep.system.opm.OrgUtils.getPerson(Unknown Source)
at com.justep.system.opm.OrgUtils.login(Native Method)
at com.justep.system.opm.OrgUtils.login1(Unknown Source)
at OPMProcedure.login(OPMProcedure.java:121)
at OPMProcedure.login(OPMProcedure.java:106)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select case when UPPER(p.sLoginName)=:name then 1 when UPPER(p.sCode)=:name then 2 else 3 end as odr , mo, mo.sFID, mo.sFName, mo.sFCode, p.* from SA_OPPerson p join SA_OPOrg mo ON p.sMainOrgID = mo where (UPPER(p.sLoginName)=:name or UPPER(p.sCode)=:name) and p.sValidState=1 order by odr
--> sql: SELECT CASE WHEN UPPER(p.SLOGINNAME) = ? THEN ? WHEN UPPER(p.SCODE) = ? THEN ? ELSE ? END AS odr, mo.sID, mo.sFID AS sFID, mo.sFName AS sFName, mo.SFCODE AS sFCode, p.sID AS p, p.SNAME AS sName, p.SCODE AS sCode, p.SIDCARD AS sIDCard, p.SNUMB AS sNumb, p.SLOGINNAME AS sLoginName, p.SPASSWORD AS sPassword, p.SPASSWORDTIMELIMIT AS sPasswordTimeLimit, p.SPASSWORDMODIFYTIME AS sPasswordModifyTime, p.SMAINORGID AS sMainOrgID, p.SSAFELEVELID AS sSafeLevelID, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.SDESCRIPTION AS sDescription, p.SPHOTO AS sPhoto, p.SPHOTOLASTMODIFIED AS sPhotoLastModified, p.SSEX AS sSex, p.SBIRTHDAY AS sBirthday, p.SJOINDATE AS sJoinDate, p.SHOMEPLACE AS sHomePlace, p.SCOUNTRY AS sCountry, p.SPROVINCE AS sProvince, p.SCITY AS sCity, p.SDEGREE AS sDegree, p.SGRADUATESCHOOL AS sGraduateSchool, p.SSPECIALITY AS sSpeciality, p.SSCHOOLLENGTH AS sSchoolLength, p.STITLE AS sTitle, p.SMARRIAGE AS sMarriage, p.SCARDNO AS sCardNO, p.SCARDKIND AS sCardKind, p.SFAMILYADDRESS AS sFamilyAddress, p.SZIP AS sZip, p.SMSN AS sMsn, p.SQQ AS sQQ, p.SMAIL AS sMail, p.SMOBILEPHONE AS sMobilePhone, p.SFAMILYPHONE AS sFamilyPhone, p.SOFFICEPHONE AS sOfficePhone, p.SENGLISHNAME AS sEnglishName, p.VERSION AS version FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.SMAINORGID = mo.sID WHERE ( (UPPER(p.SLOGINNAME) = ? ) OR (UPPER(p.SCODE) = ? ) ) AND (p.SVALIDSTATE = ?) ORDER BY odr ASC
--> binds: [SYSTEM, 1, SYSTEM, 2, 3, SYSTEM, SYSTEM, 1]
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)
... 33 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT CASE WHEN UPPER(p.SLOGINNAME) = ? THEN ? WHEN UPPER(p.SCODE) = ? THEN ? ELSE ? END AS odr, mo.sID, mo.sFID AS sFID, mo.sFName AS sFName, mo.SFCODE AS sFCode, p.sID AS p, p.SNAME AS sName, p.SCODE AS sCode, p.SIDCARD AS sIDCard, p.SNUMB AS sNumb, p.SLOGINNAME AS sLoginName, p.SPASSWORD AS sPassword, p.SPASSWORDTIMELIMIT AS sPasswordTimeLimit, p.SPASSWORDMODIFYTIME AS sPasswordModifyTime, p.SMAINORGID AS sMainOrgID, p.SSAFELEVELID AS sSafeLevelID, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.SDESCRIPTION AS sDescription, p.SPHOTO AS sPhoto, p.SPHOTOLASTMODIFIED AS sPhotoLastModified, p.SSEX AS sSex, p.SBIRTHDAY AS sBirthday, p.SJOINDATE AS sJoinDate, p.SHOMEPLACE AS sHomePlace, p.SCOUNTRY AS sCountry, p.SPROVINCE AS sProvince, p.SCITY AS sCity, p.SDEGREE AS sDegree, p.SGRADUATESCHOOL AS sGraduateSchool, p.SSPECIALITY AS sSpeciality, p.SSCHOOLLENGTH AS sSchoolLength, p.STITLE AS sTitle, p.SMARRIAGE AS sMarriage, p.SCARDNO AS sCardNO, p.SCARDKIND AS sCardKind, p.SFAMILYADDRESS AS sFamilyAddress, p.SZIP AS sZip, p.SMSN AS sMsn, p.SQQ AS sQQ, p.SMAIL AS sMail, p.SMOBILEPHONE AS sMobilePhone, p.SFAMILYPHONE AS sFamilyPhone, p.SOFFICEPHONE AS sOfficePhone, p.SENGLISHNAME AS sEnglishName, p.VERSION AS version FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.SMAINORGID = mo.sID WHERE ( (UPPER(p.SLOGINNAME) = ? ) OR (UPPER(p.SCODE) = ? ) ) AND (p.SVALIDSTATE = ?) ORDER BY odr ASC, binds: [SYSTEM, 1, SYSTEM, 2, 3, SYSTEM, SYSTEM, 1]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 37 more
Caused by: java.sql.SQLException: Table 'x5sys.SA_OPPerson' 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)
... 38 more
|
|