Event mapper EA新制作

由于给定的博客内容、目录均为空,仅提供了标签‘EA’,无法获取关键信息,所以无法生成包含关键信息的摘要。

分析报错:Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.NullPointerException ### The error may exist in URL [jar:file:/opt/evo/evo-common/evo-event/evo-event.jar!/mapper1/EventLogAlarmMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT ea.ID, ea.ALARM_STAT, ea.ALARM_TYPE, ea.ALARM_DATE, ea.ALARM_GRADE, ea.HANDLE_USER, ea.HANDLE_DATE, ea.HANDLE_MESSAGE, ea.HANDLE_STAT, ea.ALARM_PICTURE, ea.ALARM_CODE, ea.NODE_CODE, ea.ORG_CODE, ea.ORG_NAME, ea.DEVICE_CATEGORY, ea.ALARM_POSITION, ea.LINK_NAMES, ea.IS_EVENT, ea.EXTEND, ea.ALARM_TYPE AS ALARM_TYPE_NAME, ea.SUB_SYSTEM FROM event_log_alarm ea WHERE ( ea.ALARM_DATE BETWEEN ? AND ? ) AND ( ea.ORG_CODE like CONCAT(?,'%') or ea.ORG_CODE like CONCAT(?,'%') ) order by ALARM_DATE DESC limit ?,? ### Cause: java.lang.NullPointerException at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.6.jar:3.5.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) ~[mybatis-3.5.6.jar:3.5.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.6.jar:3.5.6] at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_372] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_372] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.1.jar:1.3.1] ... 138 more
09-06
分析报错:[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]附近出现错误:
08-26
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值