分析报错:[0825 11:11:57.913][evo-event][OperatorLogAspect:doAround:100][http-nio-8919-exec-7][ERROR] UUID[7e3dbe07ddd94372be5264af3151fa80]method[alarm/types/page][报警类型分页查询],system error:[
### Error querying database. Cause: dm.jdbc.driver.DMException: 第 2 行, 第 518 列[using]附近出现错误:
语法分析出错
### The error may exist in URL [jar:file:/opt/evo/evo-common/evo-event/evo-event.jar!/mapper/alarmPlan/EventAlarmTypeMapper.xml]
### The error may involve com.dahua.evo.event.business.mapper.alarmPlan.EventAlarmTypeMapper.selectPage_COUNT
### The error occurred while executing a query
### SQL: /*dialect*/select count(0) from ( /*dialect*/select et.ID, en.ALARM_TYPE_NAME, et.ALARM_TYPE, wm_concat(ea.AFFILIATION_NAME) as AFFILIATION_NAME , et.STATUS, et.ALARM_GRADE, et.ALARM_STORM, sum(et.USER_DEFINED) as USER_DEFINED , et.IS_SAVE, et.FAILURE, et.URL_NAME_KEY from event_alarm_type as et inner join event_alarm_type_name as en on et.ALARM_TYPE = en.ALARM_TYPE inner join event_alarm_type_affiliation as ea on et.AFFILIATION = ea.AFFILIATION where en.LANGUAGE = ? and ea.LANGUAGE = ? group by et.ALARM_TYPE order by convert(ALARM_TYPE_NAME using gbk) desc ) tmp_count
### Cause: dm.jdbc.driver.DMException: 第 2 行, 第 518 列[using]附近出现错误:
语法分析出错
; bad SQL grammar []; nested exception is dm.jdbc.driver.DMException: 第 2 行, 第 518 列[using]附近出现错误:
语法分析出错],timeout[18]ms
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: dm.jdbc.driver.DMException: 第 2 行, 第 518 列[using]附近出现错误:
语法分析出错
### The error may exist in URL [jar:file:/opt/evo/evo-common/evo-event/evo-event.jar!/mapper/alarmPlan/EventAlarmTypeMapper.xml]
### The error may involve com.dahua.evo.event.business.mapper.alarmPlan.EventAlarmTypeMapper.selectPage_COUNT
### The error occurred while executing a query
### SQL: /*dialect*/select count(0) from ( /*dialect*/select et.ID, en.ALARM_TYPE_NAME, et.ALARM_TYPE, wm_concat(ea.AFFILIATION_NAME) as AFFILIATION_NAME , et.STATUS, et.ALARM_GRADE, et.ALARM_STORM, sum(et.USER_DEFINED) as USER_DEFINED , et.IS_SAVE, et.FAILURE, et.URL_NAME_KEY from event_alarm_type as et inner join event_alarm_type_name as en on et.ALARM_TYPE = en.ALARM_TYPE inner join event_alarm_type_affiliation as ea on et.AFFILIATION = ea.AFFILIATION where en.LANGUAGE = ? and ea.LANGUAGE = ? group by et.ALARM_TYPE order by convert(ALARM_TYPE_NAME using gbk) desc ) tmp_count
### Cause: dm.jdbc.driver.DMException: 第 2 行, 第 518 列[using]附近出现错误:
语法分析出错
; bad SQL grammar []; nested exception is dm.jdbc.driver.DMException: 第 2 行, 第 518 列[using]附近出现错误: