系统自带的流程统计报错

江苏院-吴昊

<action process="/SA/process/report/processcase/processcaseProcess" activity="groupActivity" action-flag="__action_0__" executor="" execute-context="" name="processExecuteAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"></parameters></action>
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: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql:  SELECT ROWNUM NONUM,K.INSTANCENAME,K.SPROCESSNAME,K.SACTUALSTARTTIME,K.SACTUALFINISHTIME,K.TASKNUM FROM (SELECT  T.sName INSTANCENAME,T.sProcessName SPROCESSNAME,T.sActualStartTime SACTUALSTARTTIME,t.sActualFinishTime SACTUALFINISHTIME, TO_CHAR(T.sActualStartTime,'YYYY-MM-DD HH:MI:SS') SACTUALSTARTTIME,TO_CHAR(T.sActualFinishTime,'YYYY-MM-DD HH:MI:SS') SACTUALFINISHTIME, (SELECT COUNT(M.sKindID) FROM SA_TASK M WHERE M.sStatusID IN ('tesExecuting','tesReady','tesRemain','tesSleeping','tesPaused','tesWaited') AND (M.sKindID = 'tkTask' OR M.sKindID = 'tkExecutor')  AND M.sExecutorFID <> '' AND M.sCatalogID = 'tsProcess' AND M.sParentID = T.sID ) TASKNUM FROM SA_TASK T WHERE T.sStatusID IN ('tesExecuting','tesReady','tesRemain','tesSleeping','tesPaused','tesWaited') AND T.sKindID = 'tkProcessInstance'  ORDER BY T.sProcess)K WHERE K.TASKNUM > 0, binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at ProcessCaseProcedure.groupExecutingQuery(ProcessCaseProcedure.java:26)
        ... 27 more
Caused by: java.sql.SQLException: ORA-00918: 未明确定义列

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 30 more
[ERROR] 2017-05-11 11:41:54,433 com.justep.report.controller.DataController - 报表数据获取失败
执行sql:  SELECT ROWNUM NONUM,K.INSTANCENAME,K.SPROCESSNAME,K.SACTUALSTARTTIME,K.SACTUALFINISHTIME,K.TASKNUM FROM (SELECT  T.sName INSTANCENAME,T.sProcessName SPROCESSNAME,T.sActualStartTime SACTUALSTARTTIME,t.sActualFinishTime SACTUALFINISHTIME, TO_CHAR(T.sActualStartTime,'YYYY-MM-DD HH:MI:SS') SACTUALSTARTTIME,TO_CHAR(T.sActualFinishTime,'YYYY-MM-DD HH:MI:SS') SACTUALFINISHTIME, (SELECT COUNT(M.sKindID) FROM SA_TASK M WHERE M.sStatusID IN ('tesExecuting','tesReady','tesRemain','tesSleeping','tesPaused','tesWaited') AND (M.sKindID = 'tkTask' OR M.sKindID = 'tkExecutor')  AND M.sExecutorFID <> '' AND M.sCatalogID = 'tsProcess' AND M.sParentID = T.sID ) TASKNUM FROM SA_TASK T WHERE T.sStatusID IN ('tesExecuting','tesReady','tesRemain','tesSleeping','tesPaused','tesWaited') AND T.sKindID = 'tkProcessInstance'  ORDER BY T.sProcess)K WHERE K.TASKNUM > 0, binds: []出错
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        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.report.exception.ReportServerException: 执行sql:  SELECT ROWNUM NONUM,K.INSTANCENAME,K.SPROCESSNAME,K.SACTUALSTARTTIME,K.SACTUALFINISHTIME,K.TASKNUM FROM (SELECT  T.sName INSTANCENAME,T.sProcessName SPROCESSNAME,T.sActualStartTime SACTUALSTARTTIME,t.sActualFinishTime SACTUALFINISHTIME, TO_CHAR(T.sActualStartTime,'YYYY-MM-DD HH:MI:SS') SACTUALSTARTTIME,TO_CHAR(T.sActualFinishTime,'YYYY-MM-DD HH:MI:SS') SACTUALFINISHTIME, (SELECT COUNT(M.sKindID) FROM SA_TASK M WHERE M.sStatusID IN ('tesExecuting','tesReady','tesRemain','tesSleeping','tesPaused','tesWaited') AND (M.sKindID = 'tkTask' OR M.sKindID = 'tkExecutor')  AND M.sExecutorFID <> '' AND M.sCatalogID = 'tsProcess' AND M.sParentID = T.sID ) TASKNUM FROM SA_TASK T WHERE T.sStatusID IN ('tesExecuting','tesReady','tesRemain','tesSleeping','tesPaused','tesWaited') AND T.sKindID = 'tkProcessInstance'  ORDER BY T.sProcess)K WHERE K.TASKNUM > 0, binds: []出错
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more

江苏院-吴昊

SELECT
        ROWNUM NONUM,
        K .INSTANCENAME,
        K .SPROCESSNAME,
        K .SACTUALSTARTTIME,
        K .SACTUALFINISHTIME,
        K .TASKNUM
FROM
        (
                SELECT
                        T .sName INSTANCENAME,
                        T .sProcessName SPROCESSNAME,
                        T .sActualStartTime SACTUALSTARTTIME,
                        T .sActualFinishTime SACTUALFINISHTIME,
                        TO_CHAR (
                                T .sActualStartTime,
                                'YYYY-MM-DD HH:MI:SS'
                        ) SACTUALSTARTTIME,
                        TO_CHAR (
                                T .sActualFinishTime,
                                'YYYY-MM-DD HH:MI:SS'
                        ) SACTUALFINISHTIME,
                        (
                                SELECT
                                        COUNT (M .sKindID)
                                FROM
                                        SA_TASK M
                                WHERE
                                        M .sStatusID IN (
                                                'tesExecuting',
                                                'tesReady',
                                                'tesRemain',
                                                'tesSleeping',
                                                'tesPaused',
                                                'tesWaited'
                                        )
                                AND (
                                        M .sKindID = 'tkTask'
                                        OR M .sKindID = 'tkExecutor'
                                )
                                AND M .sExecutorFID <> ''
                                AND M .sCatalogID = 'tsProcess'
                                AND M .sParentID = T . SID
                        ) TASKNUM
                FROM
                        SA_TASK T
                WHERE
                        T .sStatusID IN (
                                'tesExecuting',
                                'tesReady',
                                'tesRemain',
                                'tesSleeping',
                                'tesPaused',
                                'tesWaited'
                        )
                AND T .sKindID = 'tkProcessInstance'
                ORDER BY
                        T .sProcess
        ) K
WHERE
        K .TASKNUM > 0


这是我从报错信息中获取的sql，仔细分析后发现子查询中有两个字段 重复定义了，所以orcale报错 “未明确定义”

jishuang

平台没有提供的待办统计的功能


/SA/process/report/processcase/processcaseProcess这个应该是自己项目组做的，可以找的相关的代码设置不一样的别名

江苏院-吴昊

jishuang 发表于 2017-5-11 14:06
平台没有提供的待办统计的功能

这个就是你们平台提供的功能啊。。。

jishuang

这个功能是不完善的，默认是不对外的，功能菜单中也是没有放开的，现在不推荐用

完善后版本特性中会有说明

江苏院-吴昊

jishuang 发表于 2017-5-11 17:56
这个功能是不完善的，默认是不对外的，功能菜单中也是没有放开的，现在不推荐用

完善后版本特性中会有说明 ...

明白了，是我全部勾选出来了。结贴。