有流程的功能打开报错！

曹刚 · 发表于 2017-6-22 14:51:47

运行系统后，登录系统，点击系统自带的功能，只要是与流程有关的都报错，是怎么回事？

jishuang · 发表于 2017-6-22 15:30:01

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

曹刚 · 发表于 2017-6-22 16:59:01

jishuang 发表于 2017-6-22 15:30
看tomcat控制台的完整错误信息

这是控制台的报错

jishuang · 发表于 2017-6-22 17:16:43

发完整的错误信息

曹刚 · 发表于 2017-6-23 09:48:32

jishuang 发表于 2017-6-22 17:16
发完整的错误信息

这是上部分，因为超过一万字了，分两次

2017-06-23 09:45:36 excute stream action, params:{"accept":"application/json","action":"externalAdvanceProcessQueryAction","actionFlag":"__action_0__","activity":"orderReportActivity","contentType":"application/json","executeContext":"","executor":"/ORG01.ogn/PSN01@ORG01.psm","parameters":{"task":"089B3A69DC1B40E5A32E04E37E574365"},"process":"/demo/misc/process/order/orderProcess"}
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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 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: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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 Source)
at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
at com.justep.system.process.ProcessUtils.advanceProcessQuery(Unknown Source)
at ExternalProcessProcedure.advanceProcessQuery(ExternalProcessProcedure.java:26)
... 27 more

曹刚 · 发表于 2017-6-23 09:50:10

曹刚发表于 2017-6-23 09:48
这是上部分，因为超过一万字了，分两次

2017-06-23 09:45:36 excute stream action, params:{"accept":" ...

中部

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select t,t.sCustomerID,t.sWithdraw,t.sStatusID,t.sActualFinishTime,t.sPlanName,t.sVariable,t.sProcessTemplateItemSequence,t.sSummary,t.sFlowID,t.sAIStatusName,t.sDistributeTime,t.sETField32,t.sExecutorPosName,t.sStatusName,t.sETField31,t.sCreatorFName,t.sEDField21,t.sCreatorOgnName,t.sEDField24,t.sEIField41,t.sEIField42,t.sEDField22,t.sEIField43,t.sEDField23,t.sEIField44,t.sETField34,t.version,t.sETField33,t.sExpectFinishTime,t.sExecutorPersonName,t.sData2,t.sTypeName,t.sExecutorOgnName,t.sData1,t.sData4,t.sCreatorDeptName,t.sData3,t.sActivityNames,t.sCreatorPosName,t.sAIID,t.sLock,t.sActivity,t.sExpectStartTime,t.sProcessTemplateID2,t.sENField13,t.sENField14,t.sPlanID,t.sActive,t.sActivityInTemplate,t.sSequence,t.sKindID,t.sProcessName,t.sExecutorOgnID,t.sImportanceName,t.sCreatorPersonID,t.sCURL,t.sENField11,t.sENField12,t.sCode,t.sHints,t.sCreatorOgnID,t.sExecutorNames,t.sParent,t.sEmergencyName,t.sESField03,t.sTypeID,t.sESField04,t.sESField05,t.sESField06,t.sESField01,t.sESField02,t.sContent,t.sProcess,t.sExecuteMode,t.sCreatorPersonName,t.sCreateTime,t.sLimitTime,t.sWarningTime,t.sLimitSecond,t.sTempPermissionID,t.sSourceID,t.sEURL,t.sImportanceID,t.sCreatorPosID,t.sLastModifyTime,t.sESField07,t.sESField08,t.sExecutorPosID,t.sCreatorDeptID,t.sExecutorPersonID,t.sExecuteTime,t.sEBField51,t.sEBField52,t.sExecutorFName,t.sEBField53,t.sEBField54,t.sCreatorFID,t.sEmergencyID,t.sRemark,t.sAIStatusID,t.sActualStartTime,t.sCustomerName,t.sExecutorFID,t.sProjectID,t.sResponsible,t.sFrontID,t.sPreemptMode,t.sExecutorDeptName,t.sAIActive,t.sExecuteMode2,t.sName,t.sRemindMode,t.sProcessTemplateID,t.sExecutorDeptID,t.sCatalogID,t.sShortcut,t.sActivityName,t.sProjectName from SA_Task t where t.sFlowID = :flowID
--> sql: SELECT t.sID, t.SCUSTOMERID AS sCustomerID, t.SWITHDRAW AS sWithdraw, t.SSTATUSID AS sStatusID, t.SACTUALFINISHTIME AS sActualFinishTime, t.SPLANNAME AS sPlanName, t.SVARIABLE AS sVariable, t.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, t.SSUMMARY AS sSummary, t.SFLOWID AS sFlowID, t.SAISTATUSNAME AS sAIStatusName, t.SDISTRIBUTETIME AS sDistributeTime, t.SETFIELD32 AS sETField32, t.SEXECUTORPOSNAME AS sExecutorPosName, t.SSTATUSNAME AS sStatusName, t.SETFIELD31 AS sETField31, t.SCREATORFNAME AS sCreatorFName, t.SEDFIELD21 AS sEDField21, t.SCREATOROGNNAME AS sCreatorOgnName, t.SEDFIELD24 AS sEDField24, t.SEIFIELD41 AS sEIField41, t.SEIFIELD42 AS sEIField42, t.SEDFIELD22 AS sEDField22, t.SEIFIELD43 AS sEIField43, t.SEDFIELD23 AS sEDField23, t.SEIFIELD44 AS sEIField44, t.SETFIELD34 AS sETField34, t.VERSION AS version, t.SETFIELD33 AS sETField33, t.SEXPECTFINISHTIME AS sExpectFinishTime, t.SEXECUTORPERSONNAME AS sExecutorPersonName, t.SDATA2 AS sData2, t.STYPENAME AS sTypeName, t.SEXECUTOROGNNAME AS sExecutorOgnName, t.SDATA1 AS sData1, t.SDATA4 AS sData4, t.SCREATORDEPTNAME AS sCreatorDeptName, t.SDATA3 AS sData3, t.SACTIVITYNAMES AS sActivityNames, t.SCREATORPOSNAME AS sCreatorPosName, t.SAIID AS sAIID, t.SLOCK AS sLock, t.SACTIVITY AS sActivity, t.SEXPECTSTARTTIME AS sExpectStartTime, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SENFIELD13 AS sENField13, t.SENFIELD14 AS sENField14, t.SPLANID AS sPlanID, t.SACTIVE AS sActive, t.SACTIVITYINTEMPLATE AS sActivityInTemplate, t.SSEQUENCE AS sSequence, t.SKINDID AS sKindID, t.SPROCESSNAME AS sProcessName, t.SEXECUTOROGNID AS sExecutorOgnID, t.SIMPORTANCENAME AS sImportanceName, t.SCREATORPERSONID AS sCreatorPersonID, t.SCURL AS sCURL, t.SENFIELD11 AS sENField11, t.SENFIELD12 AS sENField12, t.SCODE AS sCode, t.SHINTS AS sHints, t.SCREATOROGNID AS sCreatorOgnID, t.SEXECUTORNAMES AS sExecutorNames, t.sParentID AS sParent, t.SEMERGENCYNAME AS sEmergencyName, t.SESFIELD03 AS sESField03, t.STYPEID AS sTypeID, t.SESFIELD04 AS sESField04, t.SESFIELD05 AS sESField05, t.SESFIELD06 AS sESField06, t.SESFIELD01 AS sESField01, t.SESFIELD02 AS sESField02, t.SCONTENT AS sContent, t.SPROCESS AS sProcess, t.SEXECUTEMODE AS sExecuteMode, t.SCREATORPERSONNAME AS sCreatorPersonName, t.SCREATETIME AS sCreateTime, t.SLIMITTIME AS sLimitTime, t.SWARNINGTIME AS sWarningTime, t.SLIMITSECOND AS sLimitSecond, t.STEMPPERMISSIONID AS sTempPermissionID, t.SSOURCEID AS sSourceID, t.SEURL AS sEURL, t.SIMPORTANCEID AS sImportanceID, t.SCREATORPOSID AS sCreatorPosID, t.SLASTMODIFYTIME AS sLastModifyTime, t.SESFIELD07 AS sESField07, t.SESFIELD08 AS sESField08, t.SEXECUTORPOSID AS sExecutorPosID, t.SCREATORDEPTID AS sCreatorDeptID, t.SEXECUTORPERSONID AS sExecutorPersonID, t.SEXECUTETIME AS sExecuteTime, t.SEBFIELD51 AS sEBField51, t.SEBFIELD52 AS sEBField52, t.SEXECUTORFNAME AS sExecutorFName, t.SEBFIELD53 AS sEBField53, t.SEBFIELD54 AS sEBField54, t.SCREATORFID AS sCreatorFID, t.SEMERGENCYID AS sEmergencyID, t.SREMARK AS sRemark, t.SAISTATUSID AS sAIStatusID, t.SACTUALSTARTTIME AS sActualStartTime, t.SCUSTOMERNAME AS sCustomerName, t.SEXECUTORFID AS sExecutorFID, t.SPROJECTID AS sProjectID, t.SRESPONSIBLE AS sResponsible, t.SFRONTID AS sFrontID, t.SPREEMPTMODE AS sPreemptMode, t.SEXECUTORDEPTNAME AS sExecutorDeptName, t.SAIACTIVE AS sAIActive, t.SEXECUTEMODE2 AS sExecuteMode2, t.SNAME AS sName, t.SREMINDMODE AS sRemindMode, t.SPROCESSTEMPLATEID AS sProcessTemplateID, t.SEXECUTORDEPTID AS sExecutorDeptID, t.SCATALOGID AS sCatalogID, t.SSHORTCUT AS sShortcut, t.SACTIVITYNAME AS sActivityName, t.SPROJECTNAME AS sProjectName FROM SA_Task t WHERE t.SFLOWID = ?
--> binds: [7EA8076C40E545C29EF18F43AB06AC3D]
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)
at com.justep.system.process.TaskDB.select(Unknown Source)
at com.justep.system.process.TaskDB.doLoadTasks(Unknown Source)
at com.justep.system.process.TaskDB.loadFlow(Unknown Source)
at com.justep.system.process.TaskDB.loadPI(Unknown Source)
at com.justep.system.process.TaskDB.loadPIByTask(Unknown Source)
at com.justep.system.process.ProcessEngine.init(Unknown Source)
at com.justep.system.process.TaskEngine.<init>(Unknown Source)
at com.justep.system.process.ProcessEngine.<init>(Unknown Source)
at ProcessProcedure.beforeQuery(ProcessProcedure.java:434)
at ProcessProcedure.beforeAdvanceProcessQuery(ProcessProcedure.java:338)
... 38 more

曹刚 · 发表于 2017-6-23 09:50:27

曹刚发表于 2017-6-23 09:50
中部

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, K ...

尾部

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT t.sID, t.SCUSTOMERID AS sCustomerID, t.SWITHDRAW AS sWithdraw, t.SSTATUSID AS sStatusID, t.SACTUALFINISHTIME AS sActualFinishTime, t.SPLANNAME AS sPlanName, t.SVARIABLE AS sVariable, t.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, t.SSUMMARY AS sSummary, t.SFLOWID AS sFlowID, t.SAISTATUSNAME AS sAIStatusName, t.SDISTRIBUTETIME AS sDistributeTime, t.SETFIELD32 AS sETField32, t.SEXECUTORPOSNAME AS sExecutorPosName, t.SSTATUSNAME AS sStatusName, t.SETFIELD31 AS sETField31, t.SCREATORFNAME AS sCreatorFName, t.SEDFIELD21 AS sEDField21, t.SCREATOROGNNAME AS sCreatorOgnName, t.SEDFIELD24 AS sEDField24, t.SEIFIELD41 AS sEIField41, t.SEIFIELD42 AS sEIField42, t.SEDFIELD22 AS sEDField22, t.SEIFIELD43 AS sEIField43, t.SEDFIELD23 AS sEDField23, t.SEIFIELD44 AS sEIField44, t.SETFIELD34 AS sETField34, t.VERSION AS version, t.SETFIELD33 AS sETField33, t.SEXPECTFINISHTIME AS sExpectFinishTime, t.SEXECUTORPERSONNAME AS sExecutorPersonName, t.SDATA2 AS sData2, t.STYPENAME AS sTypeName, t.SEXECUTOROGNNAME AS sExecutorOgnName, t.SDATA1 AS sData1, t.SDATA4 AS sData4, t.SCREATORDEPTNAME AS sCreatorDeptName, t.SDATA3 AS sData3, t.SACTIVITYNAMES AS sActivityNames, t.SCREATORPOSNAME AS sCreatorPosName, t.SAIID AS sAIID, t.SLOCK AS sLock, t.SACTIVITY AS sActivity, t.SEXPECTSTARTTIME AS sExpectStartTime, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SENFIELD13 AS sENField13, t.SENFIELD14 AS sENField14, t.SPLANID AS sPlanID, t.SACTIVE AS sActive, t.SACTIVITYINTEMPLATE AS sActivityInTemplate, t.SSEQUENCE AS sSequence, t.SKINDID AS sKindID, t.SPROCESSNAME AS sProcessName, t.SEXECUTOROGNID AS sExecutorOgnID, t.SIMPORTANCENAME AS sImportanceName, t.SCREATORPERSONID AS sCreatorPersonID, t.SCURL AS sCURL, t.SENFIELD11 AS sENField11, t.SENFIELD12 AS sENField12, t.SCODE AS sCode, t.SHINTS AS sHints, t.SCREATOROGNID AS sCreatorOgnID, t.SEXECUTORNAMES AS sExecutorNames, t.sParentID AS sParent, t.SEMERGENCYNAME AS sEmergencyName, t.SESFIELD03 AS sESField03, t.STYPEID AS sTypeID, t.SESFIELD04 AS sESField04, t.SESFIELD05 AS sESField05, t.SESFIELD06 AS sESField06, t.SESFIELD01 AS sESField01, t.SESFIELD02 AS sESField02, t.SCONTENT AS sContent, t.SPROCESS AS sProcess, t.SEXECUTEMODE AS sExecuteMode, t.SCREATORPERSONNAME AS sCreatorPersonName, t.SCREATETIME AS sCreateTime, t.SLIMITTIME AS sLimitTime, t.SWARNINGTIME AS sWarningTime, t.SLIMITSECOND AS sLimitSecond, t.STEMPPERMISSIONID AS sTempPermissionID, t.SSOURCEID AS sSourceID, t.SEURL AS sEURL, t.SIMPORTANCEID AS sImportanceID, t.SCREATORPOSID AS sCreatorPosID, t.SLASTMODIFYTIME AS sLastModifyTime, t.SESFIELD07 AS sESField07, t.SESFIELD08 AS sESField08, t.SEXECUTORPOSID AS sExecutorPosID, t.SCREATORDEPTID AS sCreatorDeptID, t.SEXECUTORPERSONID AS sExecutorPersonID, t.SEXECUTETIME AS sExecuteTime, t.SEBFIELD51 AS sEBField51, t.SEBFIELD52 AS sEBField52, t.SEXECUTORFNAME AS sExecutorFName, t.SEBFIELD53 AS sEBField53, t.SEBFIELD54 AS sEBField54, t.SCREATORFID AS sCreatorFID, t.SEMERGENCYID AS sEmergencyID, t.SREMARK AS sRemark, t.SAISTATUSID AS sAIStatusID, t.SACTUALSTARTTIME AS sActualStartTime, t.SCUSTOMERNAME AS sCustomerName, t.SEXECUTORFID AS sExecutorFID, t.SPROJECTID AS sProjectID, t.SRESPONSIBLE AS sResponsible, t.SFRONTID AS sFrontID, t.SPREEMPTMODE AS sPreemptMode, t.SEXECUTORDEPTNAME AS sExecutorDeptName, t.SAIACTIVE AS sAIActive, t.SEXECUTEMODE2 AS sExecuteMode2, t.SNAME AS sName, t.SREMINDMODE AS sRemindMode, t.SPROCESSTEMPLATEID AS sProcessTemplateID, t.SEXECUTORDEPTID AS sExecutorDeptID, t.SCATALOGID AS sCatalogID, t.SSHORTCUT AS sShortcut, t.SACTIVITYNAME AS sActivityName, t.SPROJECTNAME AS sProjectName FROM SA_Task t WHERE t.SFLOWID = ? , binds: [7EA8076C40E545C29EF18F43AB06AC3D]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 52 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.SLIMITSECOND' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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.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)
... 53 more

jishuang · 发表于 2017-6-23 10:29:17

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.SLIMITSECOND' in 'field list'

数据库中缺少字段

http://bbs.wex5.com/forum.php?mod=viewthread&tid=106167中提供的有数据库升级程序

		自动登录	找回密码
密码			注册

[结贴] 有流程的功能打开报错！