启动登陆sam报错问题

【问题描述】

 登录SAM后台报错，是因为数据库日期类型的问题。暂时不影响SAM其他功能得使用
[2015-09-10 09:44:17,261][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[select * from ( SELECT T.SRC_APP_CODE ,
    T.DEST_OPERATION_CODE ,
T.SRC_IP,
    STR_TO_DATE(FROM_UNIXTIME( UNIX_TIMESTAMP(STR_TO_DATE(DATE_FORMAT(T.STATISTICS_TIME, '%Y-%m-%d %H:%i:%s'),'%Y-%m-%d %H:%i:%s')) - MOD( EXTRACT(MINUTE FROM T.STATISTICS_TIME),30)*60,'%Y-%m-%d %H:%i:%s' ),'%Y-%m-%d %H:%i:%s') 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,
         FROM_UNIXTIME( UNIX_TIMESTAMP(STR_TO_DATE(DATE_FORMAT(T.STATISTICS_TIME, '%Y-%m-%d %H:%i:%s'),'%Y-%m-%d %H:%i:%s')) - MOD( EXTRACT(MINUTE FROM T.STATISTICS_TIME),30)*60,'%Y-%m-%d %H:%i:%s' ) ) where 1!=1] execute error.
java.sql.SQLException: ORA-00904: "FROM_UNIXTIME": 标识符无效

【解答】

补丁ESB_6.5.1.0_SAM_20141114_P1