Hi chen, The limitation of the RAW measure was discussed here:
http://apache-kylin.74782.x6.nabble.com/Discuss-Disable-hide-quot-RAW-quot-measure-in-Kylin-web-GUI-td6636.html Due to these limitations, I personally don't recommend to use it. 2017-04-24 15:30 GMT+08:00 <[email protected]>: > 您好： > > 问题一： > > kylin如何实现明细查询？换句话说，如果维度是多层级的情况，上层维度不会根据下层维度进行汇总。目前想到的是用kylin的raw > measure。 > 想问下用Kylin的raw measure是不是就是为了实现明细查询，为什么现在又不推荐了？ > 另外我发现mondrain目前并不支持raw这个关键词的解析，如何解决？ > > 问题二： > > 我使用kylin设计了一个model，一共一个事实表五个维度表，并基于此model设计了一个cube（ > 三个指标均设置为RAW类型），两者结构如下： > > > > Cube生成之后，在前台insight中进行查询： > select * > from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP" > join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on > "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" > join "V_BANK_RP_ORGANCUR_OP" as "V_BANK_RP_ORGANCUR_OP" on > "V_RP_BALADJOFF_OP"."ORGCOD" = "V_BANK_RP_ORGANCUR_OP"."ORGCOD" > join "RP_CCY_OP" as "RP_CCY_OP" on "V_RP_BALADJOFF_OP"."CCY" = > "RP_CCY_OP"."CCY" > join "RP_COGTALDTE" as "RP_COGTALDTE" on "V_RP_BALADJOFF_OP"."TALDTE"=" > RP_COGTALDTE"."TALDTE" > join "RP_COGTYP" as "RP_COGTYP" on "V_RP_BALADJOFF_OP"."TYP"="RP_ > COGTYP"."TYP" > > 发现只要关联标红的这张表，查询就会报错，如果不关联这张表就能正常查询，报错日志如下： > > 2017-04-24 15:09:26,085 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > service.QueryService:336 : Using project: IFAR > 2017-04-24 15:09:26,085 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > service.QueryService:337 : The original query: select * > from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP" > join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on > "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" > 2017-04-24 15:09:26,086 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > service.QueryService:440 : The corrected query: select * > from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP" > join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on > "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" > LIMIT 50 > 2017-04-24 15:09:26,109 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:48 : The project manager's reference is > org.apache.kylin.metadata.project.ProjectManager@630ea6f1 > 2017-04-24 15:09:26,109 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:60 : Find candidates by table IFAR.V_BANK_RP_SUBCUR_OP > and project=IFAR : CUBE[name=IFAR_CUBE_CM_1] > 2017-04-24 15:09:26,109 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query. > routing.rules.RemoveBlackoutRealizationsRule, realizations before: > [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)] > 2017-04-24 15:09:26,109 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query. > routing.rules.RemoveUncapableRealizationsRule, realizations before: > [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)] > 2017-04-24 15:09:26,110 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > rules.RealizationSortRule:40 : CUBE[name=IFAR_CUBE_CM_1] priority 1 cost > 604. > 2017-04-24 15:09:26,110 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query. > routing.rules.RealizationSortRule, realizations before: > [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)] > 2017-04-24 15:09:26,110 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:72 : The realizations remaining: [IFAR_CUBE_CM_1(CUBE)] > And the final chosen one is the first one > 2017-04-24 15:09:26,110 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:48 : The project manager's reference is > org.apache.kylin.metadata.project.ProjectManager@630ea6f1 > 2017-04-24 15:09:26,110 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:60 : Find candidates by table IFAR.V_RP_BALADJOFF_OP > and project=IFAR : CUBE[name=IFAR_CUBE_CM_1] > 2017-04-24 15:09:26,111 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query. > routing.rules.RemoveBlackoutRealizationsRule, realizations before: > [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)] > 2017-04-24 15:09:26,111 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > cube.CubeCapabilityChecker:191 : Cube CUBE[name=IFAR_CUBE_CM_1] > CapabilityInfluences: BAL_SUM@class org.apache.kylin.measure.raw. > RawMeasureType,DAYBAL_SUM@class org.apache.kylin.measure.raw. > RawMeasureType,TOTDAYBAL_SUM@class org.apache.kylin.measure.raw. > RawMeasureType > 2017-04-24 15:09:26,111 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query. > routing.rules.RemoveUncapableRealizationsRule, realizations before: > [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)] > 2017-04-24 15:09:26,111 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > rules.RealizationSortRule:40 : CUBE[name=IFAR_CUBE_CM_1] priority 1 cost > 43900. > 2017-04-24 15:09:26,112 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query. > routing.rules.RealizationSortRule, realizations before: > [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)] > 2017-04-24 15:09:26,112 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > routing.QueryRouter:72 : The realizations remaining: [IFAR_CUBE_CM_1(CUBE)] > And the final chosen one is the first one > 2017-04-24 15:09:26,136 DEBUG [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > enumerator.OLAPEnumerator:100 : query storage... > 2017-04-24 15:09:26,136 ERROR [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > service.QueryService:372 : Exception when execute sql > java.sql.SQLException: Error while executing SQL "select * > from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP" > join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on > "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" > LIMIT 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row > key desc > at org.apache.calcite.avatica.Helper.createException(Helper. > java:56) > at org.apache.calcite.avatica.Helper.createException(Helper. > java:41) > at org.apache.calcite.avatica.AvaticaStatement.executeInternal( > AvaticaStatement.java:147) > at org.apache.calcite.avatica.AvaticaStatement.executeQuery( > AvaticaStatement.java:208) > at org.apache.kylin.rest.service.QueryService.execute( > QueryService.java:538) > at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage( > QueryService.java:452) > at org.apache.kylin.rest.service.QueryService.query( > QueryService.java:151) > at org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:354) > at org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:69) > at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.springframework.web.method.support.InvocableHandlerMethod. > doInvoke(InvocableHandlerMethod.java:221) > at org.springframework.web.method.support.InvocableHandlerMethod. > invokeForRequest(InvocableHandlerMethod.java:136) > at org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:104) > at org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandleMethod( > RequestMappingHandlerAdapter.java:743) > at org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter. > java:672) > at org.springframework.web.servlet.mvc.method. > AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82) > at org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:933) > at org.springframework.web.servlet.DispatcherServlet. > doService(DispatcherServlet.java:867) > at org.springframework.web.servlet.FrameworkServlet. > processRequest(FrameworkServlet.java:951) > at org.springframework.web.servlet.FrameworkServlet. > doPost(FrameworkServlet.java:853) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at org.springframework.web.servlet.FrameworkServlet. > service(FrameworkServlet.java:827) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:303) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at org.apache.tomcat.websocket.server.WsFilter.doFilter( > WsFilter.java:52) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:241) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:330) > at org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) > at org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.access. > ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.session. > SessionManagementFilter.doFilter(SessionManagementFilter.java:103) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication. > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter. > java:113) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.servletapi. > SecurityContextHolderAwareRequestFilter.doFilter( > SecurityContextHolderAwareRequestFilter.java:54) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.savedrequest. > RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.www. > BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.ui. > DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt > er.java:91) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter( > AbstractAuthenticationProcessingFilter.java:183) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.logout. > LogoutFilter.doFilter(LogoutFilter.java:105) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.context. > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt > er.java:87) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.FilterChainProxy. > doFilterInternal(FilterChainProxy.java:192) > at org.springframework.security.web.FilterChainProxy.doFilter( > FilterChainProxy.java:160) > at org.springframework.web.filter.DelegatingFilterProxy. > invokeDelegate(DelegatingFilterProxy.java:343) > at org.springframework.web.filter.DelegatingFilterProxy.doFilter( > DelegatingFilterProxy.java:260) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:241) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:209) > at com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:244) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:241) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:220) > at org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.java:122) > at org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:505) > at org.apache.catalina.core.StandardHostValve.invoke( > StandardHostValve.java:169) > at org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:103) > at org.apache.catalina.valves.AccessLogValve.invoke( > AccessLogValve.java:956) > at org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:116) > at org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:436) > at org.apache.coyote.http11.AbstractHttp11Processor.process( > AbstractHttp11Processor.java:1078) > at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler. > process(AbstractProtocol.java:625) > at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor. > run(JIoEndpoint.java:316) > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:615) > at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.lang.NullPointerException: Column > IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL > does not exist in row key desc > at org.apache.kylin.cube.model.RowKeyDesc.getColDesc( > RowKeyDesc.java:65) > at org.apache.kylin.cube.model.RowKeyDesc.getColumnBitIndex( > RowKeyDesc.java:59) > at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid. > java:65) > at org.apache.kylin.storage.gtrecord. > GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104) > at org.apache.kylin.query.enumerator.OLAPEnumerator. > queryStorage(OLAPEnumerator.java:114) > at org.apache.kylin.query.enumerator.OLAPEnumerator. > moveNext(OLAPEnumerator.java:65) > at org.apache.calcite.linq4j.EnumerableDefaults.toLookup_( > EnumerableDefaults.java:2690) > at org.apache.calcite.linq4j.EnumerableDefaults.toLookup( > EnumerableDefaults.java:2682) > at org.apache.calcite.linq4j.EnumerableDefaults.toLookup( > EnumerableDefaults.java:2658) > at org.apache.calcite.linq4j.DefaultEnumerable.toLookup( > DefaultEnumerable.java:701) > at org.apache.calcite.linq4j.EnumerableDefaults$10. > enumerator(EnumerableDefaults.java:1092) > at Baz$5$1.<init>(Unknown Source) > at Baz$5.enumerator(Unknown Source) > at org.apache.calcite.linq4j.EnumerableDefaults$26. > enumerator(EnumerableDefaults.java:2494) > at org.apache.calcite.linq4j.AbstractEnumerable.iterator( > AbstractEnumerable.java:33) > at org.apache.calcite.avatica.MetaImpl.createCursor( > MetaImpl.java:85) > at org.apache.calcite.avatica.AvaticaResultSet.execute( > AvaticaResultSet.java:190) > at org.apache.calcite.jdbc.CalciteResultSet.execute( > CalciteResultSet.java:65) > at org.apache.calcite.jdbc.CalciteResultSet.execute( > CalciteResultSet.java:44) > at org.apache.calcite.avatica.AvaticaConnection$1.execute( > AvaticaConnection.java:605) > at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute( > CalciteMetaImpl.java:599) > at org.apache.calcite.avatica.AvaticaConnection. > prepareAndExecuteInternal(AvaticaConnection.java:613) > at org.apache.calcite.avatica.AvaticaStatement.executeInternal( > AvaticaStatement.java:139) > ... 76 more > 2017-04-24 15:09:26,137 INFO [Query > 81afd783-bc9b-47f8-87f5-870ab668479e-12861] > service.QueryService:284 : > ==========================[QUERY]=============================== > Query Id: 81afd783-bc9b-47f8-87f5-870ab668479e > SQL: select * > from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP" > join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on > "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" > LIMIT 50 > User: IFARUSR > Success: false > Duration: 0.0 > Project: IFAR > Realization Names: [IFAR_CUBE_CM_1] > Cuboid Ids: [] > Total scan count: 0 > Result row count: 0 > Accept Partial: true > Is Partial Result: false > Hit Exception Cache: false > Storage cache used: false > Message: Error while executing SQL "select * from "V_RP_BALADJOFF_OP" as > "V_RP_BALADJOFF_OP" join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on > "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" LIMIT > 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row key > desc > ==========================[QUERY]=============================== > > 2017-04-24 15:09:26,138 ERROR [http-bio-7070-exec-94] > controller.BasicController:44 : > org.apache.kylin.rest.exception.InternalErrorException: Error while > executing SQL "select * from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP" > join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on > "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" LIMIT > 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row key > desc > at org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:389) > at org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:69) > at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.springframework.web.method.support.InvocableHandlerMethod. > doInvoke(InvocableHandlerMethod.java:221) > at org.springframework.web.method.support.InvocableHandlerMethod. > invokeForRequest(InvocableHandlerMethod.java:136) > at org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:104) > at org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandleMethod( > RequestMappingHandlerAdapter.java:743) > at org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter. > java:672) > at org.springframework.web.servlet.mvc.method. > AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82) > at org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:933) > at org.springframework.web.servlet.DispatcherServlet. > doService(DispatcherServlet.java:867) > at org.springframework.web.servlet.FrameworkServlet. > processRequest(FrameworkServlet.java:951) > at org.springframework.web.servlet.FrameworkServlet. > doPost(FrameworkServlet.java:853) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at org.springframework.web.servlet.FrameworkServlet. > service(FrameworkServlet.java:827) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:303) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at org.apache.tomcat.websocket.server.WsFilter.doFilter( > WsFilter.java:52) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:241) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:330) > at org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) > at org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.access. > ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.session. > SessionManagementFilter.doFilter(SessionManagementFilter.java:103) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication. > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter. > java:113) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.servletapi. > SecurityContextHolderAwareRequestFilter.doFilter( > SecurityContextHolderAwareRequestFilter.java:54) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.savedrequest. > RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.www. > BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.ui. > DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt > er.java:91) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter( > AbstractAuthenticationProcessingFilter.java:183) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.authentication.logout. > LogoutFilter.doFilter(LogoutFilter.java:105) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.context. > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt > er.java:87) > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at org.springframework.security.web.FilterChainProxy. > doFilterInternal(FilterChainProxy.java:192) > at org.springframework.security.web.FilterChainProxy.doFilter( > FilterChainProxy.java:160) > at org.springframework.web.filter.DelegatingFilterProxy. > invokeDelegate(DelegatingFilterProxy.java:343) > at org.springframework.web.filter.DelegatingFilterProxy.doFilter( > DelegatingFilterProxy.java:260) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:241) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:209) > at com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:244) > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:241) > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > at org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:220) > at org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.java:122) > at org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:505) > at org.apache.catalina.core.StandardHostValve.invoke( > StandardHostValve.java:169) > at org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:103) > at org.apache.catalina.valves.AccessLogValve.invoke( > AccessLogValve.java:956) > at org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:116) > at org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:436) > at org.apache.coyote.http11.AbstractHttp11Processor.process( > AbstractHttp11Processor.java:1078) > at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler. > process(AbstractProtocol.java:625) > at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor. > run(JIoEndpoint.java:316) > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:615) > at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > > > ********************************************************* > 陈萌 > 中国农业银行软件开发中心应用开发五部 > 地址：北京市丰台区丽泽路18号院1号楼金唐国际金融大厦801E室 > 邮编：100073 > 电话：010-68126752 <010%206812%206752> > 邮箱：[email protected] > ********************************************************* -- Best regards, Shaofeng Shi 史少锋
