欢迎使用普元产品知识库,本知识库包含普元应用开发平台EOSPlatform,流程平台BPS,企业服务总线ESB,微服务平台Microservice,运维管理平台Devops,数据集成平台DI
欢迎使用普元文档库
【问题描述】
2015-06-18 17:44:26,611][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[select * from ( SELECT T.SRC_APP_CODE ,
T.DEST_OPERATION_CODE ,
T.SRC_IP,
CONVERT(datetime, T.STATISTICS_TIME, 120) STATISTICS_TIME,
SUM(T.TOTAL_DURATION ) TOTAL_DURATION ,
SUM(T.SUCCESS_NUM) SUCCESS_NUM,
SUM(T.SYSTEM_EXCEPTION_NUM) SYSTEM_EXCEPTION_NUM,
SUM(T.BUSI_EXCEPTION_NUM) BUSI_EXCEPTION_NUM,
SUM(T.TIMEOUT_NUM) TIMEOUT_NUM,
SUM(T.TOTAL_REQ_SIZE) TOTAL_REQ_SIZE,
SUM(T.TOTAL_RESP_SIZE) TOTAL_RESP_SIZE ,
SUM(T.ILLEGAL_USE_NUM) TOTAL_ILLEGAL_USE_NUM,
SUM(T.ILLEGAL_IP_NUM) TOTAL_ILLEGAL_IP_NUM
FROM SSM_SERVICE_STATISTICS T
GROUP BY T.SRC_APP_CODE ,
T.DEST_OPERATION_CODE ,
T.SRC_IP,
T.STATISTICS_TIME ) where 1!=1] execute error.
java.sql.SQLException: ORA-00904: "DATETIME": 标识符无效
SSM_SERVICE_STATISTICS表已经创建。
【解答】
补丁ESB_6.5.1.0_SAM_20141114_P1