3.4版本中运行平台提供的任务归档功能,oracle数据库保存如下:
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: delete from SA_Task where sFlowID in (select sFlowID from (select sFlowID from SA_Task where sKindID=? and (sStatusID=? or sStatusID=?) and sActualFinishTime>=? and sActualFinishTime<=? and version=? ) as t_tmp), binds: [tkProcessInstance, tesAborted, tesFinished, 2016-06-06, 2016-06-08, -1]出错 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.data.SQL.executeUpdate(Unknown Source) at com.justep.system.data.SQL.executeUpdate(Unknown Source) at com.justep.system.data.SQL.executeUpdate(Unknown Source) at com.justep.system.process.ArchiveProcessEngine.execute(Unknown Source) at com.justep.system.process.ProcessUtils.archiveProcess(Unknown Source) at ProcessProcedure.archiveProcess(ProcessProcedure.java:101) ... 27 more Caused by: java.sql.SQLException: ORA-00907: 缺失右括号
把下面的classes解压放到\runtime\BusinessServer\WEB-INF下,然后重启tomcat服务
3.5正式版中已经解决了这个问题
评一波