最近从家里访问部署在公司的x5服务器经常出错，求助。

zzqqstc

最近从家里访问部署在公司的x5 3.8服务器经常出错，求助。
但是在公司使用，啥问题也没有。

请看看这是怎么回事，是什么参数需要调整么？

2018-05-29 12:45:15 Not registed session:A1A6E83866FA13AF1722AA20A5089375, jsess
ionid:JSESSIONID=455AE10FD0764C1196EF19CD49DEBD66, action: <?xml version="1.0" e
ncoding="UTF-8"?>
<actions><action process="/SA/OPM/system/systemProcess" activity="mainActivity"
name="getSysParamsAction" execute-context="" content-type="application/xml"><par
ameters/></action></actions>
2018-05-29 12:45:26 加载模块：/UI2/portal/mobile/main ...
2018-05-29 12:45:26 加载模块：/UI2/portal/mobile/main
2018-05-29 12:45:26 加载模块：/OA/personalOffice/process/tasksAssigned ...
2018-05-29 12:45:26 加载模块：/OA/common/logic/code ...
2018-05-29 12:45:26 加载模块：/OA/common/logic ...
2018-05-29 12:45:26 null
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Sour
ce)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Sour
ce)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at Portal.queryMessage(Portal.java:41)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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 Sour
ce)
        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(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Sour
ce)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Sour
ce)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at PortalInfo.tasksAssignedPortal(PortalInfo.java:123)
        ... 40 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执
行KSQL出错, KSQL: SELECT OA_TasksAssigned.*,SA_Social.sGroupID as sGroupID,SA_So
cial.sMessageNumber as sMessageNumber,SA_Social_att.sActive as sActive  FROM OA_
TasksAssigned OA_TasksAssigned  join (select  SA_Social.sData1, MIN(SA_Social.sG
roupID) as sGroupID from SA_Social SA_Social  where  SA_Social.sPersonID = :curr
entPersonID() AND SA_Social.sTypeID = 'RelativeOrg' AND SA_Social.sValidState =
1   group by SA_Social.sData1) SA_SocialOne on OA_TasksAssigned = SA_SocialOne.s
Data1 join SA_Social SA_Social on  OA_TasksAssigned = SA_Social.sData1 AND SA_So
cial.sPersonID = :currentPersonID() AND SA_Social.sTypeID = 'RelativeOrg' AND SA
_Social.sValidState = 1 AND SA_Social.sGroupID = SA_SocialOne.sGroupID  optional
  join SA_Social SA_Social_att on  OA_TasksAssigned = SA_Social_att.sData1 AND S
A_Social_att.sPersonID = :currentPersonID() AND SA_Social_att.sTypeID = 'Focus'
AND SA_Social_att.sValidState = 1 ORDER BY OA_TasksAssigned.fLastModifyTime desc
LIMIT 0, 1
--> sql: SELECT  OA_TasksAssigned.fID AS OA_TasksAssigned, OA_TasksAssigned.VER
SION AS version, OA_TasksAssigned.FNAME AS fName, OA_TasksAssigned.FCONTENT AS f
Content, OA_TasksAssigned.FCREATORID AS fCreatorID, OA_TasksAssigned.FCREATOR AS
fCreator, OA_TasksAssigned.FCREATORTIME AS fCreatorTime, OA_TasksAssigned.FEXEC
UTOR AS fExecutor, OA_TasksAssigned.FEXECUTORID AS fExecutorID, OA_TasksAssigned
.FCLOSER AS fCloser, OA_TasksAssigned.FCLOSERID AS fCloserID, OA_TasksAssigned.F
CLOSERMEMO AS fCloserMemo, OA_TasksAssigned.FSTATUS AS fStatus, OA_TasksAssigned
.FLASTMODIFYTIME AS fLastModifyTime, OA_TasksAssigned.FATTACHMENT AS fAttachment
, SA_Social.SGROUPID AS sGroupID, SA_Social.SMESSAGENUMBER AS sMessageNumber, SA
_Social_att.SACTIVE AS sActive FROM OA_TASKSASSIGNED OA_TasksAssigned JOIN (SELE
CT  SA_Social.SDATA1 AS sData1, MIN(SA_Social.SGROUPID) AS sGroupID FROM SA_Soci
al SA_Social  WHERE  (SA_Social.SPERSONID =  ? ) AND (SA_Social.STYPEID = ?) AND
(SA_Social.SVALIDSTATE = ?)    GROUP BY SA_Social.SDATA1) SA_SocialOne ON OA_Ta
sksAssigned.fID = SA_SocialOne.sData1 JOIN SA_Social SA_Social ON  (OA_TasksAssi
gned.fID = SA_Social.SDATA1) AND (SA_Social.SPERSONID =  ? ) AND (SA_Social.STYP
EID = ?) AND (SA_Social.SVALIDSTATE = ?) AND (SA_Social.SGROUPID = SA_SocialOne.
sGroupID)  LEFT JOIN SA_Social SA_Social_att ON  (OA_TasksAssigned.fID = SA_Soci
al_att.SDATA1) AND (SA_Social_att.SPERSONID =  ? ) AND (SA_Social_att.STYPEID =
?) AND (SA_Social_att.SVALIDSTATE = ?)   ORDER BY OA_TasksAssigned.FLASTMODIFYTI
ME DESC
--> binds: [DEtiSXCEbr5KC36jmW7, RelativeOrg, 1, DEtiSXCEbr5KC36jmW7, RelativeO
rg, 1, DEtiSXCEbr5KC36jmW7, Focus, 1]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 49 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执
行sql: SELECT  OA_TasksAssigned.fID AS OA_TasksAssigned, OA_TasksAssigned.VERSIO
N AS version, OA_TasksAssigned.FNAME AS fName, OA_TasksAssigned.FCONTENT AS fCon
tent, OA_TasksAssigned.FCREATORID AS fCreatorID, OA_TasksAssigned.FCREATOR AS fC
reator, OA_TasksAssigned.FCREATORTIME AS fCreatorTime, OA_TasksAssigned.FEXECUTO
R AS fExecutor, OA_TasksAssigned.FEXECUTORID AS fExecutorID, OA_TasksAssigned.FC
LOSER AS fCloser, OA_TasksAssigned.FCLOSERID AS fCloserID, OA_TasksAssigned.FCLO
SERMEMO AS fCloserMemo, OA_TasksAssigned.FSTATUS AS fStatus, OA_TasksAssigned.FL
ASTMODIFYTIME AS fLastModifyTime, OA_TasksAssigned.FATTACHMENT AS fAttachment, S
A_Social.SGROUPID AS sGroupID, SA_Social.SMESSAGENUMBER AS sMessageNumber, SA_So
cial_att.SACTIVE AS sActive FROM OA_TASKSASSIGNED OA_TasksAssigned JOIN (SELECT
SA_Social.SDATA1 AS sData1, MIN(SA_Social.SGROUPID) AS sGroupID FROM SA_Social
SA_Social  WHERE  (SA_Social.SPERSONID =  ? ) AND (SA_Social.STYPEID = ?) AND (S
A_Social.SVALIDSTATE = ?)    GROUP BY SA_Social.SDATA1) SA_SocialOne ON OA_Tasks
Assigned.fID = SA_SocialOne.sData1 JOIN SA_Social SA_Social ON  (OA_TasksAssigne
d.fID = SA_Social.SDATA1) AND (SA_Social.SPERSONID =  ? ) AND (SA_Social.STYPEID
= ?) AND (SA_Social.SVALIDSTATE = ?) AND (SA_Social.SGROUPID = SA_SocialOne.sGr
oupID)  LEFT JOIN SA_Social SA_Social_att ON  (OA_TasksAssigned.fID = SA_Social_
att.SDATA1) AND (SA_Social_att.SPERSONID =  ? ) AND (SA_Social_att.STYPEID = ?)
AND (SA_Social_att.SVALIDSTATE = ?)   ORDER BY OA_TasksAssigned.FLASTMODIFYTIME
DESC, binds: [DEtiSXCEbr5KC36jmW7, RelativeOrg, 1, DEtiSXCEbr5KC36jmW7, Relative
Org, 1, DEtiSXCEbr5KC36jmW7, Focus, 1]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 54 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'x5s
ys.oa_tasksassigned' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1901)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2002)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:96)
        ... 55 more

jishuang

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'x5s
ys.oa_tasksassigned' doesn't exist

数据库中表不存在，跟在什么地方访问无关

zzqqstc

jishuang 发表于 2018-5-29 13:23
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'x5s
ys.oa_tasksassigned' doesn't e ...

明白了，已解决，请结帖。