You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2266 lines
202 KiB
2266 lines
202 KiB
2020-05-15 12:37:58,543 [http-nio-10000-exec-6] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.BadSqlGrammarException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap-Inline |
|
### The error occurred while setting parameters |
|
### SQL: exec pro_usage_analysis ?,?,?,?,?,? |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap(UsageAnalysisServiceImpl.java:31) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:56) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy154.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 12:37:58,543 [http-nio-10000-exec-7] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.BadSqlGrammarException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap-Inline |
|
### The error occurred while setting parameters |
|
### SQL: exec pro_usage_analysis ?,?,?,?,?,? |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap(UsageAnalysisServiceImpl.java:31) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:56) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy154.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 12:38:01,257 [http-nio-10000-exec-5] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.BadSqlGrammarException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap-Inline |
|
### The error occurred while setting parameters |
|
### SQL: exec pro_usage_analysis ?,?,?,?,?,? |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap(UsageAnalysisServiceImpl.java:31) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:56) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy154.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 12:38:01,257 [http-nio-10000-exec-9] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.BadSqlGrammarException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap-Inline |
|
### The error occurred while setting parameters |
|
### SQL: exec pro_usage_analysis ?,?,?,?,?,? |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap(UsageAnalysisServiceImpl.java:31) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:56) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_day202002' 无效。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy154.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:67) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 18:01:49,202 [http-nio-10000-exec-1] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.UncategorizedSQLException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap-Inline |
|
### The error occurred while setting parameters |
|
### SQL: select ROW_NUMBER() over(order by b.time) rowID,* from (SELECT time = a.cur_date totalUsed = SUM(a.calc_flow) FROM wt_building_month2020 a GROUP BY cur_date) as b |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
; uncategorized SQLException; SQL state [S0001]; error code [102]; “totalUsed”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap(UsageAnalysisServiceImpl.java:31) |
|
at com.mh.eems.util.UsageAnalysisUtil.queryChart(UsageAnalysisUtil.java:43) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAllHome(UsageAnalysisController.java:107) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy151.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 80 common frames omitted |
|
2020-05-15 18:02:06,502 [http-nio-10000-exec-4] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.UncategorizedSQLException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap-Inline |
|
### The error occurred while setting parameters |
|
### SQL: select ROW_NUMBER() over(order by b.time) rowID,* from (SELECT time = a.cur_date totalUsed = SUM(a.calc_flow) FROM wt_building_month2020 a GROUP BY cur_date) as b |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
; uncategorized SQLException; SQL state [S0001]; error code [102]; “totalUsed”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap(UsageAnalysisServiceImpl.java:31) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:55) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy151.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 18:02:06,503 [http-nio-10000-exec-5] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.UncategorizedSQLException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap-Inline |
|
### The error occurred while setting parameters |
|
### SQL: select ROW_NUMBER() over(order by b.time) rowID,* from (SELECT time = a.cur_date totalUsed = SUM(a.calc_flow) FROM wt_building_month2020 a GROUP BY cur_date) as b |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
; uncategorized SQLException; SQL state [S0001]; error code [102]; “totalUsed”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap(UsageAnalysisServiceImpl.java:31) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:55) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy151.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 18:05:39,202 [http-nio-10000-exec-9] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.UncategorizedSQLException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap2-Inline |
|
### The error occurred while setting parameters |
|
### SQL: select ROW_NUMBER() over(order by b.time) rowID,* from (SELECT time = a.cur_date totalUsed = SUM(a.calc_flow) FROM wt_building_month2020 a GROUP BY cur_date) as b |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
; uncategorized SQLException; SQL state [S0001]; error code [102]; “totalUsed”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap2(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap2(UsageAnalysisServiceImpl.java:35) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:55) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy151.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 18:05:39,202 [http-nio-10000-exec-4] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.UncategorizedSQLException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap2-Inline |
|
### The error occurred while setting parameters |
|
### SQL: select ROW_NUMBER() over(order by b.time) rowID,* from (SELECT time = a.cur_date totalUsed = SUM(a.calc_flow) FROM wt_building_month2020 a GROUP BY cur_date) as b |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
; uncategorized SQLException; SQL state [S0001]; error code [102]; “totalUsed”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap2(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap2(UsageAnalysisServiceImpl.java:35) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:55) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: “totalUsed”附近有语法错误。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy151.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 18:10:52,259 [http-nio-10000-exec-8] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:10:52,257 [http-nio-10000-exec-3] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:12:09,506 [http-nio-10000-exec-3] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:12:37,151 [http-nio-10000-exec-2] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:12:46,905 [http-nio-10000-exec-10] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:15:23,410 [http-nio-10000-exec-8] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:15:30,732 [http-nio-10000-exec-5] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:15:30,732 [http-nio-10000-exec-7] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:15:32,463 [http-nio-10000-exec-6] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:15:32,465 [http-nio-10000-exec-9] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:17:13,900 [http-nio-10000-exec-4] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:17:13,902 [http-nio-10000-exec-1] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
java.lang.NullPointerException: null |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:58) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
2020-05-15 18:34:40,974 [http-nio-10000-exec-7] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.BadSqlGrammarException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap2-Inline |
|
### The error occurred while setting parameters |
|
### SQL: select ROW_NUMBER() over(order by b.time) rowID,* from (SELECT time = a.cur_date ,totalUsed = SUM(a.calc_flow) FROM wt_building_month? a GROUP BY cur_date) as b |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap2(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap2(UsageAnalysisServiceImpl.java:35) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:55) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy151.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted |
|
2020-05-15 18:34:40,974 [http-nio-10000-exec-9] ERROR -[ExceptionHandlerAdvice.java:59]- 系统异常 |
|
org.springframework.jdbc.BadSqlGrammarException: |
|
### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
### The error may exist in com/mh/eems/mapper/UsageAnalysisMapper.java (best guess) |
|
### The error may involve com.mh.eems.mapper.UsageAnalysisMapper.queryUsageAnalysisByMap2-Inline |
|
### The error occurred while setting parameters |
|
### SQL: select ROW_NUMBER() over(order by b.time) rowID,* from (SELECT time = a.cur_date ,totalUsed = SUM(a.calc_flow) FROM wt_building_month? a GROUP BY cur_date) as b |
|
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) |
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) |
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) |
|
at com.sun.proxy.$Proxy87.selectList(Unknown Source) |
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) |
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) |
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) |
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) |
|
at com.sun.proxy.$Proxy122.queryUsageAnalysisByMap2(Unknown Source) |
|
at com.mh.eems.service.impl.UsageAnalysisServiceImpl.queryUsageAnalysisByMap2(UsageAnalysisServiceImpl.java:35) |
|
at com.mh.eems.controller.UsageAnalysisController.queryAll(UsageAnalysisController.java:55) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215) |
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142) |
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) |
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) |
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) |
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) |
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) |
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) |
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) |
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) |
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) |
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) |
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) |
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) |
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) |
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) |
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) |
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) |
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) |
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) |
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) |
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) |
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) |
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) |
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) |
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) |
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) |
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) |
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) |
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) |
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) |
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) |
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) |
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) |
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) |
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) |
|
at java.lang.Thread.run(Thread.java:745) |
|
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'wt_building_month@P0' 无效。 |
|
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) |
|
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) |
|
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) |
|
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) |
|
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) |
|
at com.sun.proxy.$Proxy151.execute(Unknown Source) |
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) |
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) |
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) |
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) |
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) |
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) |
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143) |
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) |
|
at com.sun.proxy.$Proxy149.query(Unknown Source) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) |
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) |
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
|
at java.lang.reflect.Method.invoke(Method.java:498) |
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) |
|
... 79 common frames omitted
|
|
|