|
|
| 版本: |
BeX5V3.3 |
小版本号: |
3.3 |
|
|
| 数据库: |
MySQL |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
| 客户端操作系统: |
Windows 7 |
浏览器: |
Chrome |
|
|
通过手机浏览器访问起步提供的协同OA办公系统,点击左栏的“工作交办”手机弹出如下的错误：
控制面版上出现以下提示：
2016-09-08 10:41:24 开始-WINDOW生成中间文件: /UI2/OA/personalOffice/process/tasksAssigned/mainActivity.m.w
2016-09-08 10:41:26 加载模块：/UI2/system/components/justep/windowDialog/server ...
2016-09-08 10:41:26 加载模块：/UI2/system/components/justep/windowDialog/server
2016-09-08 10:41:26 结束-WINDOW生成中间文件: /UI2/OA/personalOffice/process/tasksAssigned/mainActivity.m.w
2016-09-08 10:41:26 开始-中间文件生成缓存文件: /UI2/OA/personalOffice/process/tasksAssigned/mainActivity.m.w
2016-09-08 10:41:27 结束-中间文件生成缓存文件: /UI2/OA/personalOffice/process/tasksAssigned/mainActivity.m.w
2016-09-08 10:41:29 加载模块：/OA/personalOffice/process/tasksAssigned ...
2016-09-08 10:41:29 excute stream action, params:{"accept":"application/json","action":"queryOA_TasksAssignedOpAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"OA_TasksAssigned,fAttachment,fCloser,fCloserID,fCloserMemo,fContent,fCreator,fCreatorID,fCreatorTime,fExecutor,fExecutorID,fLastModifyTime,fName,fStatus,sActive,sGroupID,sMessageNumber,version","limit":-1,"offset":0,"orderBy":"fLastModifyTime DESC","variables":{}},"process":"/OA/personalOffice/process/tasksAssigned/tasksAssignedProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"OA_TasksAssigned","sequence":"OA_TasksAssigned,fAttachment,fCloser,fCloserID,fCloserMemo,fContent,fCreator,fCreatorID,fCreatorTime,fExecutor,fExecutorID,fLastModifyTime,fName,fShowTime,fStatus,sActive,sGroupID,sMessageNumber,version"},"transformIdcolumn":true,"useNamespace":true}}
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: SELECT OA_TasksAssigned.*,SA_Social.sGroupID as sGroupID,SA_Social.sMessageNumber as sMessageNumber,SA_Social_att.sActive as sActive FROM OA_TasksAssigned OA_TasksAssigned join (select SA_Social.sData1, MIN(SA_Social.sGroupID) as sGroupID from SA_Social SA_Social where SA_Social.sPersonID = :currentPersonID() AND SA_Social.sTypeID = 'RelativeOrg' AND SA_Social.sValidState = 1 group by SA_Social.sData1) SA_SocialOne on OA_TasksAssigned = SA_SocialOne.sData1 join SA_Social SA_Social on OA_TasksAssigned = SA_Social.sData1 AND SA_Social.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 SA_Social_att.sPersonID = :currentPersonID() AND SA_Social_att.sTypeID = 'Focus' AND SA_Social_att.sValidState = 1 WHERE (OA_TasksAssigned.fStatus = '未关闭') ORDER BY fLastModifyTime DESC LIMIT 0, -1
--> sql: SELECT OA_TasksAssigned.fID AS OA_TasksAssigned, OA_TasksAssigned.FATTACHMENT AS fAttachment, OA_TasksAssigned.FCLOSER AS fCloser, OA_TasksAssigned.FCLOSERID AS fCloserID, OA_TasksAssigned.FCLOSERMEMO AS fCloserMemo, OA_TasksAssigned.FCONTENT AS fContent, OA_TasksAssigned.FCREATOR AS fCreator, OA_TasksAssigned.FCREATORID AS fCreatorID, OA_TasksAssigned.FCREATORTIME AS fCreatorTime, OA_TasksAssigned.FEXECUTOR AS fExecutor, OA_TasksAssigned.FEXECUTORID AS fExecutorID, OA_TasksAssigned.FLASTMODIFYTIME AS fLastModifyTime, OA_TasksAssigned.FNAME AS fName, OA_TasksAssigned.FSTATUS AS fStatus, SA_Social_att.SACTIVE AS sActive, SA_Social.SGROUPID AS sGroupID, SA_Social.SMESSAGENUMBER AS sMessageNumber, OA_TasksAssigned.VERSION AS version 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 (SA_Social.SVALIDSTATE = ?) GROUP BY SA_Social.SDATA1) SA_SocialOne ON OA_TasksAssigned.fID = SA_SocialOne.sData1 JOIN SA_Social SA_Social ON (OA_TasksAssigned.fID = SA_Social.SDATA1) AND (SA_Social.SPERSONID = ? ) AND (SA_Social.STYPEID = ?) AND (SA_Social.SVALIDSTATE = ?) AND (SA_Social.SGROUPID = SA_SocialOne.sGroupID) 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 = ?) WHERE OA_TasksAssigned.FSTATUS = ? ORDER BY fLastModifyTime DESC
--> binds: [87930426E1EE42C29F592484CA028A9C, RelativeOrg, 1, 87930426E1EE42C29F592484CA028A9C, RelativeOrg, 1, 87930426E1EE42C29F592484CA028A9C, Focus, 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.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT OA_TasksAssigned.fID AS OA_TasksAssigned, OA_TasksAssigned.FATTACHMENT AS fAttachment, OA_TasksAssigned.FCLOSER AS fCloser, OA_TasksAssigned.FCLOSERID AS fCloserID, OA_TasksAssigned.FCLOSERMEMO AS fCloserMemo, OA_TasksAssigned.FCONTENT AS fContent, OA_TasksAssigned.FCREATOR AS fCreator, OA_TasksAssigned.FCREATORID AS fCreatorID, OA_TasksAssigned.FCREATORTIME AS fCreatorTime, OA_TasksAssigned.FEXECUTOR AS fExecutor, OA_TasksAssigned.FEXECUTORID AS fExecutorID, OA_TasksAssigned.FLASTMODIFYTIME AS fLastModifyTime, OA_TasksAssigned.FNAME AS fName, OA_TasksAssigned.FSTATUS AS fStatus, SA_Social_att.SACTIVE AS sActive, SA_Social.SGROUPID AS sGroupID, SA_Social.SMESSAGENUMBER AS sMessageNumber, OA_TasksAssigned.VERSION AS version 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 (SA_Social.SVALIDSTATE = ?) GROUP BY SA_Social.SDATA1) SA_SocialOne ON OA_TasksAssigned.fID = SA_SocialOne.sData1 JOIN SA_Social SA_Social ON (OA_TasksAssigned.fID = SA_Social.SDATA1) AND (SA_Social.SPERSONID = ? ) AND (SA_Social.STYPEID = ?) AND (SA_Social.SVALIDSTATE = ?) AND (SA_Social.SGROUPID = SA_SocialOne.sGroupID) 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 = ?) WHERE OA_TasksAssigned.FSTATUS = ? ORDER BY fLastModifyTime DESC, binds: [87930426E1EE42C29F592484CA028A9C, RelativeOrg, 1, 87930426E1EE42C29F592484CA028A9C, RelativeOrg, 1, 87930426E1EE42C29F592484CA028A9C, Focus, 1, 未关闭]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 32 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'x5sys.oa_tasksassigned' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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.java: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)
... 33 more
打开MySQL数据库，找到相应的数据库表：OA_TasksAssigned和SA_Social，想打开这些表看看表结构如何，结果是打不开，提示如下：
说明这些表不存在。
使用Navicat for MySQL软件照样打不开这些数据库表。
这个问题如何解决？
除了这两个表打不开以外，起步所提供的这个协同OA办公系统还有好多个数据库也打不开。起步能否提供一个无错误的系统表？
|
|
IP卡
狗仔卡
发表于 2016-9-8 11:58:43
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2016-9-8 14:34:25
楼主
