点击流程记录报错：访问数据库出错，请联系客服！

lulijiaa

点击页面按钮流程记录报错：访问数据库出错，请联系客服！

lulijiaa

控制台报错：
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT V_EXECUTETASK.*  FROM V_EXECUTETASK V_EXECUTETASK WHERE (((V_EXECUTETASK.sFlowID in (select x.sFlowID from SA_Task x where (x.sData1 = 'DCAB6606FAAD4C05A5BB75EF58156697') and (x.sProcess='/ERP/newBuy/PUROUTBILL/process/outBill/outBillProcess'))))) LIMIT 0, 20
--> sql: SELECT  V_EXECUTETASK.EXPIRED AS EXPIRED, V_EXECUTETASK.SID AS V_EXECUTETASK, V_EXECUTETASK.SACTIVITYNAME AS sActivityName, V_EXECUTETASK.SACTUALFINISHTIME AS sActualFinishTime, V_EXECUTETASK.SACTUALSTARTTIME AS sActualStartTime, V_EXECUTETASK.SCONTENT AS sContent, V_EXECUTETASK.SEXECUTORDEPTNAME AS sExecutorDeptName, V_EXECUTETASK.SEXECUTORPERSONNAME AS sExecutorPersonName, V_EXECUTETASK.SNAME AS sName, V_EXECUTETASK.SSTATUSNAME AS sStatusName FROM V_EXECUTETASK V_EXECUTETASK  WHERE V_EXECUTETASK.SFLOWID IN (SELECT  x.SFLOWID AS sFlowID FROM SA_Task x  WHERE  (x.SDATA1 = ?) AND (x.SPROCESS = ?) )
--> binds: [DCAB6606FAAD4C05A5BB75EF58156697, /ERP/newBuy/PUROUTBILL/process/outBill/outBillProcess]
        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)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  V_EXECUTETASK.EXPIRED AS EXPIRED, V_EXECUTETASK.SID AS V_EXECUTETASK, V_EXECUTETASK.SACTIVITYNAME AS sActivityName, V_EXECUTETASK.SACTUALFINISHTIME AS sActualFinishTime, V_EXECUTETASK.SACTUALSTARTTIME AS sActualStartTime, V_EXECUTETASK.SCONTENT AS sContent, V_EXECUTETASK.SEXECUTORDEPTNAME AS sExecutorDeptName, V_EXECUTETASK.SEXECUTORPERSONNAME AS sExecutorPersonName, V_EXECUTETASK.SNAME AS sName, V_EXECUTETASK.SSTATUSNAME AS sStatusName FROM V_EXECUTETASK V_EXECUTETASK  WHERE V_EXECUTETASK.SFLOWID IN (SELECT  x.SFLOWID AS sFlowID FROM SA_Task x  WHERE  (x.SDATA1 = ?) AND (x.SPROCESS = ?) ), binds: [DCAB6606FAAD4C05A5BB75EF58156697, /ERP/newBuy/PUROUTBILL/process/outBill/outBillProcess]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 35 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在

        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)
        ... 36 more

jishuang

1.提示应该是项目组自己修改的平台默认没有这样的提示
2.错误中已经明确标出了表或视图不存在的错误

lulijiaa

好的，结贴吧