Hi Alan Have you set kylin.server.mode=job? If the server is going to answer queries, please set it to query or all.
2017-08-22 17:57 GMT+08:00 alantt <[email protected]>: > Hello! > > Kylin 2.0 > JDBC 2.0 > Microstrategy 10.4 Linux > > I am trying to connect using Microstrategy, a BI tool. I am using the GUI > to > write some SQL: > > SELECT TOP 4 * FROM SCV_WORK > > I chose this table as I can see the table metadata from the GUI. > > However I have this error in our log: > > > > 14317 2017-08-22 18:03:50.818+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:39561][THR: > 2102994688][Network > Classes][Error] MSINetStream::net_write(), socket send() error - error > code = 104 > 14318 2017-08-22 18:03:50.818+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID:39561][THR: > 2102994688][Kernel][Error] > Server trying to send reply, but SendToChannel failed. > 2017-08-22 18:03:52.541+09:00 > [HOST:ared302.db.test.co.jp][SERVER:][PID:18764][THR:2511296256][ > JdbcWrapper][Error] > JdbcSQLException occur. Error Message: Error while executing SQL "SELE > CT TOP 4 * FROM SCV_WORK": java.sql.SQLException: java.io.IOException: POST > failed, error code 500 and response: {"code":"999","data":null," > msg":"Query > is not allowed in web > mode.","stacktrace":"org.apache.kylin.rest.exception. > InternalErrorException: > Query is not allowed in web mode.\n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:325)\n\tat > org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:69)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 62)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java: 497)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.doInvoke( > InvocableHandlerMethod.java:221)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.invok > eForRequest(InvocableHandlerMethod.java:136)\n\tat > org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:10 > 4)\n\tat > org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandleMethod( > RequestMappingHandlerAdapter.java:743)\n\tat > org.springframework.web.servlet. > mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal( > RequestMappingHandlerAdapter.java:672)\n\tat > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter. > handl > e(AbstractHandlerMethodAdapter.java:82)\n\tat > org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:933)\n\tat > org.springframework.web.servlet.DispatcherServl > et.doService(DispatcherServlet.java:867)\n\tat > org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:951)\n\tat > org.springframework.web.servlet.FrameworkSer > vlet.doPost(FrameworkServlet.java:853)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:648)\n\tat > org.springframework.web.servlet.FrameworkServlet. > service(FrameworkServlet.ja > va:827)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:230)\n\tat > org > .apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:165)\n\tat > org.apache.tomcat.websocket.server.WsFilter.doFilter( > WsFilter.java:52)\n\tat > org.apache.catalin > a.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:165)\n\tat > org.sp > ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:330)\n\tat > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.invoke( > FilterSecurityInterceptor.java:118)\n\tat > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor. > java:84)\n\tat > org.springframework. > security.web.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:342)\n\tat > org.springframework.security.web.access.ExceptionTranslationFilter. > doFilter(ExceptionTranslationF > ilter.java:113)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.session.SessionManagem > entFilter.doFilter(SessionManagementFilter.java:103)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframewor > k.security.web.authentication.AnonymousAuthenticationFilter.doFilter( > AnonymousAuthenticationFilter.java:113)\n\tat > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi > lter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequ > estFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)\n\tat > or > g.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.savedrequest.RequestCacheAwareFilter. > doFilter( > RequestCacheAwareFilter.java:45)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authe > ntication.www.BasicAuthenticationFilter.doFilter( > BasicAuthenticationFilter.java:201)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.ja > va:342)\n\tat > org.springframework.security.web.authentication.ui. > DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt > er.java:91)\n\tat > org.springframework.security.web. > FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\ > tat > org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthen > ticationProcessingFilter.java:183)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.aut > hentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.spr > ingframework.security.web.context.SecurityContextPersistenceFilt > er.doFilter(SecurityContextPersistenceFilter.java:87)\n\tat > org.springframework.security.web.FilterChainProxy$VirtualFilterC > hain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.FilterChainProxy.doFilterInternal( > FilterChainProxy.java:192)\n\tat > org.springframework.security.web.FilterCh > ainProxy.doFilter(FilterChainProxy.java:160)\n\tat > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate( > DelegatingFilterProxy.java:343)\n\tat > org.springframework.web.filter. > DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.cata > lina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 165)\n\tat > com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:209)\n\tat > com.thetransactioncompany.cor > s.CORSFilter.doFilter(CORSFilter.java:244)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.Applicatio > nFilterChain.doFilter(ApplicationFilterChain.java:165)\n\tat > org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:198)\n\tat > org.apache.catalina.core.StandardCont > extValve.invoke(StandardContextValve.java:96)\n\tat > org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:474)\n\tat > org.apache.catalina.core.StandardHostValve. > invoke(StandardHostValve.java:140)\n\tat > org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:79)\n\tat > org.apache.catalina.valves.AbstractAccessLogValve.invoke(Abstrac > tAccessLogValve.java:624)\n\tat > org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:87)\n\tat > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav > a:349)\n\tat > org.apache.coyote.http11.Http11Processor.service( > Http11Processor.java:783)\n\tat > org.apache.coyote.AbstractProcessorLight.process( > AbstractProcessorLight.java:66)\n\tat > org.apa > che.coyote.AbstractProtocol$ConnectionHandler.process( > AbstractProtocol.java:789)\n\tat > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor. > doRun(NioEndpoint.java:1437)\n\tat > org.apache. > tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\n\tat > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142)\n\tat > java.util.concurrent.Thread > PoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61)\n\tat > java.lang.Thread.run(Thread.java:745)\n" ,"exception":"Query is not > allowed in web > mode.","url":"http://ascv102.prod.hnd1.bdd.local:7070/kylin/api/query"}, > Java Trace: java.sql.SQLException: Error while executing SQL "SELECT TOP > 4 * FROM SCV_WORK": java.sql.SQLException: java.io.IOException: POST > failed, > error code 500 and response: {"code":"999","data":null,"msg":"Query is not > allowed in web mode.","stacktrace":" > org.apache.kylin.rest.exception.InternalErrorException: Query is not > allowed > in web mode.\n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:325)\n\tat > org > .apache.kylin.rest.controller.QueryController.query( > QueryController.java:69)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat > sun.reflect.NativeMethodAccessorImpl.in > voke(NativeMethodAccessorImpl.java:62)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java:497)\n\ > at > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica. > Helper.createException(Helper.java:56) > 14321 at > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica. > Helper.createException(Helper.java:41) > 14322 at > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement. > executeInternal(AvaticaStatement.java:156) > 14323 at > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica. > AvaticaStatement.execute(AvaticaStatement.java:209) > 14324 at > com.microstrategy.database.Jdbc.JdbcStatement.execute(Unknown Source) > 14325 Caused by: java.lang.RuntimeException: java.sql.SQLException: > java.io.IOException: POST failed, error code 500 and response: > {"code":"999","data":null,"msg":"Query is not allowed in web mo > de.","stacktrace":"org.apache.kylin.rest.exception.InternalErrorException: > Query is not allowed in web mode.\n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:325)\n\tat > org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:69)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 62)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java:497)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.doInvoke( > InvocableHandlerMethod.java:221)\n\tat > org.springframework.web.method.support.InvocableHandler > Method.invokeForRequest(InvocableHandlerMethod.java:136)\n\tat > org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMe > thod.java:104)\n\tat > org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandleMethod( > RequestMappingHandlerAdapter.java:743)\n\tat > org.springframework. > web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter. > handleInternal(RequestMappingHandlerAdapter.java:672)\n\tat > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodA > dapter.handle(AbstractHandlerMethodAdapter.java:82)\n\tat > org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:933)\n\tat > org.springframework.web.servlet.Dis > patcherServlet.doService(DispatcherServlet.java:867)\n\tat > org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:951)\n\tat > org.springframework.web.servlet. > FrameworkServlet.doPost(FrameworkServlet.java:853)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:648)\n\tat > org.springframework.web.servlet.FrameworkServlet.service(Framewo > rkServlet.java:827)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:23 > 0)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:165)\n\tat > org.apache.tomcat.websocket.server.WsFilter.doFilter( > WsFilter.java:52)\n\tat > org.ap > ache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:165)\ > n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:330)\n\tat > org.springframework.security.web.access.intercept.FilterSecurityInterce > ptor.invoke(FilterSecurityInterceptor.java:118)\n\tat > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor. > java:84)\n\tat > org.spri > ngframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:342)\n\tat > org.springframework.security.web.access.ExceptionTranslationFilter. > doFilter(Exception > TranslationFilter.java:113)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.session.Se > ssionManagementFilter.doFilter(SessionManagementFilter.java:103)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.sp > ringframework.security.web.authentication.AnonymousAuthenticationFilter. > doFilter(AnonymousAuthenticationFilter.java:113)\n\tat > org.springframework.security.web.FilterChainProxy$VirtualFilt > erChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequ > estFilter.doFilter(SecurityContextHolderAwareRequestFilter.java: > 54)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.savedrequest.RequestCacheAwareFilt > er.doFilter(RequestCacheAwareFilter.java:45)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.securi > ty.web.authentication.www.BasicAuthenticationFilter.doFilter( > BasicAuthenticationFilter.java:201)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterC > hainProxy.java:342)\n\tat > org.springframework.security.web.authentication.ui. > DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt > er.java:91)\n\tat > org.springframework.s > ecurity.web.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter(Ab > stractAuthenticationProcessingFilter.java:183)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.secu > rity.web.authentication.logout.LogoutFilter.doFilter( > LogoutFilter.java:105)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n > \tat > org.springframework.security.web.context.SecurityContextPersistenceFilt > er.doFilter(SecurityContextPersistenceFilter.java:87)\n\tat > org.springframework.security.web.FilterChainProxy$Vi > rtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.FilterChainProxy.doFilterInternal( > FilterChainProxy.java:192)\n\tat > org.springframework.security. > web.FilterChainProxy.doFilter(FilterChainProxy.java:160)\n\tat > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate( > DelegatingFilterProxy.java:343)\n\tat > org.springframework > .web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java: > 260)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org > .apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:165)\n\tat > com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:209)\n\tat > com.thetransactio > ncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.cor > e.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)\n\tat > org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:198)\n\tat > org.apache.catalina.core. > StandardContextValve.invoke(StandardContextValve.java:96)\n\tat > org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:474)\n\tat > org.apache.catalina.core.Standa > rdHostValve.invoke(StandardHostValve.java:140)\n\tat > org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:79)\n\tat > org.apache.catalina.valves.AbstractAccessLogValve.in > voke(AbstractAccessLogValve.java:624)\n\tat > org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:87)\n\tat > org.apache.catalina.connector.CoyoteAdapter.service(Coyot > eAdapter.java:349)\n\tat > org.apache.coyote.http11.Http11Processor.service( > Http11Processor.java:783)\n\tat > org.apache.coyote.AbstractProcessorLight.process( > AbstractProcessorLight.java:66)\n > \tat > org.apache.coyote.AbstractProtocol$ConnectionHandler.process( > AbstractProtocol.java:789)\n\tat > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor. > doRun(NioEndpoint.java:1437)\n\tat > org.apache.tomcat.util.net.SocketProcessorBase.run( > SocketProcessorBase.java:49)\n\tat > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142)\n\tat > java.util.concu > rrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61)\n\tat > java.lang.Thread.run(Thread. java:745)\n","exception":"Query is not > allowed in web > mode.","url":"http://ascv102.prod.hnd1.bdd.local:7070/kylin/api/query"} > 14326 at > org.apache.kylin.jdbc.KylinMeta.prepareAndExecute(KylinMeta.java:115) > 14327 at > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaConnection. > prepareAndExecuteInternal(AvaticaConnection.java:615) > 14328 at > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.AvaticaStatement. > executeInternal(AvaticaStatement.java:148) > 14329 ... 2 more > Caused by: java.sql.SQLException: java.io.IOException: POST failed, error > code 500 and response: {"code":"999","data":null,"msg":"Query is not > allowed > in web mode.","stacktrace":"org.apach > e.kylin.rest.exception.InternalErrorException: Query is not allowed in web > mode.\n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:325)\n\tat > org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:69)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 62)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java:497)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.doInvoke( > InvocableHandlerMethod.java:221)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod. > invokeForRequest(Invo > cableHandlerMethod.java:136)\n\tat > org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:104)\n\tat > org.spr > ingframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandleMethod( > RequestMappingHandlerAdapter.java:743)\n\tat > org.springframework.web.servlet.mvc.method.annot > ation.RequestMappingHandlerAdapter.handleInternal( > RequestMappingHandlerAdapter.java:672)\n\tat > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter. > handle(AbstractHandle > rMethodAdapter.java:82)\n\tat > org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:933)\n\tat > org.springframework.web.servlet.DispatcherServlet.doService(Dis > patcherServlet.java:867)\n\tat > org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:951)\n\tat > org.springframework.web.servlet.FrameworkServlet.doPost(Fram > eworkServlet.java:853)\n\tat > javax.servlet.http.HttpServlet.service(HttpServlet.java:648)\n\tat > org.springframework.web.servlet.FrameworkServlet. > service(FrameworkServlet.java:827)\n\tat > ja vax.servlet.http.HttpServlet.service(HttpServlet.java:729)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:230)\n\tat > org.apache.catalina > .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 165)\n\tat > org.apache.tomcat.websocket.server.WsFilter.doFilter( > WsFilter.java:52)\n\tat > org.apache.catalina.core.Applicati > onFilterChain.internalDoFilter(ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:165)\n\tat > org.springframework.se > curity.web.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:330)\n\tat > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.invoke(FilterSecurityIn > terceptor.java:118)\n\tat > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor. > java:84)\n\tat > org.springframework.security.web.Fil > terChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.access.ExceptionTranslationFilter. > doFilter(ExceptionTranslationFilter.java:113)\ > n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.session.SessionManagementFilter.doFilt > er(SessionManagementFilter.java:103)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.a > uthentication.AnonymousAuthenticationFilter.doFilter( > AnonymousAuthenticationFilter.java:113)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChain > Proxy.java:342)\n\tat > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequ > estFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)\n\tat > org.springframewor > k.security.web.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:342)\n\tat > org.springframework.security.web.savedrequest.RequestCacheAwareFilter. > doFilter(RequestCacheAwar > eFilter.java:45)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication.www.Ba > sicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > or > g.springframework.security.web.authentication.ui. > DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt > er.java:91)\n\tat > org.springframework.security.web.FilterChainProxy > $VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter( > AbstractAuthenticationProcessi > ngFilter.java:183)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication.logo > ut.LogoutFilter.doFilter(LogoutFilter.java:105)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.sec > urity.web.context.SecurityContextPersistenceFilter.doFilter( > SecurityContextPersistenceFilter.java:87)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(Fi > lterChainProxy.java:342)\n\tat > org.springframework.security.web.FilterChainProxy.doFilterInternal( > FilterChainProxy.java:192)\n\tat > org.springframework.security.web.FilterChainProxy.doFilte > r(FilterChainProxy.java:160)\n\tat > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate( > DelegatingFilterProxy.java:343)\n\tat > org.springframework.web.filter.DelegatingFilter > Proxy.doFilter(DelegatingFilterProxy.java:260)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.Applic > ationFilterChain.doFilter(ApplicationFilterChain.java:165)\n\tat > com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:209)\n\tat > com.thetransactioncompany.cors.CORSFilter.doF > ilter(CORSFilter.java:244)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doF > ilter(ApplicationFilterChain.java:165)\n\tat > org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:198)\n\tat > org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.java:96)\n\tat > org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:474)\n\tat > org.apache.catalina.core.StandardHostValve.invoke(StandardH > ostValve.java:140)\n\tat > org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:79)\n\tat > org.apache.catalina.valves.AbstractAccessLogValve.invoke( > AbstractAccessLogValve. > java:624)\n\tat > org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:87)\n\tat > org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:349)\n\tat > org > .apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)\n\ > tat > org.apache.coyote.AbstractProcessorLight.process( > AbstractProcessorLight.java:66)\n\tat > org.apache.coyote.Abstr > actProtocol$ConnectionHandler.process(AbstractProtocol.java:789)\n\tat > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor. > doRun(NioEndpoint.java:1437)\n\tat > org.apache.tomcat.util.net. > SocketProcessorBase.run(SocketProcessorBase.java:49)\n\tat > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142)\n\tat > java.util.concurrent.ThreadPoolExecutor$Wor > ker.run(ThreadPoolExecutor.java:617)\n\tat > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61)\n\tat > java.lang.Thread.run(Thread.java:745)\n","exception":"Qu ery is not > allowed in web > mode.","url":"http://ascv102.prod.hnd1.bdd.local:7070/kylin/api/query"} > 14331 at > org.apache.kylin.jdbc.KylinResultSet.execute(KylinResultSet.java:71) > 14332 at > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica. > AvaticaConnection$1.execute(AvaticaConnection.java:607) > 14333 at > org.apache.kylin.jdbc.KylinMeta.prepareAndExecute(KylinMeta.java:111) > 14334 ... 4 more > 14335 Caused by: java.io.IOException: POST failed, error code 500 and > response: {"code":"999","data":null,"msg":"Query is not allowed in web > mode.","stacktrace":"org.apache.kylin.rest.exception. > InternalErrorException: Query is not allowed in web mode.\n\tat > org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:325)\n\tat > org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:69)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 62)\n\tat > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43)\n\tat > java.lang.reflect.Method.invoke(Method.java:497)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod.doInvoke( > InvocableHandlerMethod.java:221)\n\tat > org.springframework.web.method.support.InvocableHandlerMethod. > invokeForRequest(InvocableHandlerMethod.java > :136)\n\tat > org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:104)\n\tat > org.springframework.web.servle > t.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod( > RequestMappingHandlerAdapter.java:743)\n\tat > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHan > dlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)\n\tat > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter. > handle(AbstractHandlerMethodAdapter.java:82) > \n\tat > org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:933)\n\tat > org.springframework.web.servlet.DispatcherServlet. > doService(DispatcherServlet.java:867 > )\n\tat > org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:951)\n\tat > org.springframework.web.servlet.FrameworkServlet. > doPost(FrameworkServlet.java:853)\ > n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:648)\n\tat > org.springframework.web.servlet.FrameworkServlet. > service(FrameworkServlet.java:827)\n\tat > javax.servlet.http.HttpSe rvlet.service(HttpServlet.java:729)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:230)\n\tat > org.apache.catalina.core.ApplicationFilter > Chain.doFilter(ApplicationFilterChain.java:165)\n\tat > org.apache.tomcat.websocket.server.WsFilter.doFilter( > WsFilter.java:52)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalD > oFilter(ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:165)\n\tat > org.springframework.security.web.FilterChainP > roxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)\n\tat > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)\n\t > at > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor. > java:84)\n\tat > org.springframework.security.web.FilterChainProxy$VirtualFi > lterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.access.ExceptionTranslationFilter. > doFilter(ExceptionTranslationFilter.java:113)\n\tat > org.springframewo > rk.security.web.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:342)\n\tat > org.springframework.security.web.session.SessionManagementFilter. > doFilter(SessionManagementFil > ter.java:103)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication.Anonymous > AuthenticationFilter.doFilter(AnonymousAuthenticationFilter. > java:113)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > o > rg.springframework.security.web.servletapi.SecurityContextHolderAwareRequ > estFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)\n\tat > org.springframework.security.web.FilterCh > ainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.savedrequest.RequestCacheAwareFilter. > doFilter(RequestCacheAwareFilter.java:45)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication.www. > BasicAuthenticationFilter > .doFilter(BasicAuthenticationFilter.java:201)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.secur > ity.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter( > DefaultLoginPageGeneratingFilter.java:91)\n\tat > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doF > ilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter( > AbstractAuthenticationProcessingFilter.java:183)\n\ta > t > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.authentication.logout. > LogoutFilter.doFilte > r(LogoutFilter.java:105)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342)\n\tat > org.springframework.security.web.context.Secur > ityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt > er.java:87)\n\tat > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342 > )\n\tat > org.springframework.security.web.FilterChainProxy.doFilterInternal( > FilterChainProxy.java:192)\n\tat > org.springframework.security.web.FilterChainProxy.doFilter( > FilterChainProxy.java > :160)\n\tat > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate( > DelegatingFilterProxy.java:343)\n\tat > org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegati > ngFilterProxy.java:260)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doFilt > er(ApplicationFilterChain.java:165)\n\tat > com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:209)\n\tat > com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:2 > 44)\n\tat > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:192)\n\tat > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter > Chain.java:165)\n\tat > org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:198)\n\tat > org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.ja > va:96)\n\tat > org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:474)\n\tat > org.apache.catalina.core.StandardHostValve.invoke( > StandardHostValve.java:140)\n\ta > t > org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:79)\n\tat > org.apache.catalina.valves.AbstractAccessLogValve.invoke( > AbstractAccessLogValve.java:624)\n\tat > org.apa > che.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\ > n\tat > org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:349)\n\tat > org.apache.coyote.http11.H > ttp11Processor.service(Http11Processor.java:783)\n\tat > org.apache.coyote.AbstractProcessorLight.process( > AbstractProcessorLight.java:66)\n\tat > org.apache.coyote.AbstractProtocol$ConnectionH > andler.process(AbstractProtocol.java:789)\n\tat > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor. > doRun(NioEndpoint.java:1437)\n\tat > org.apache.tomcat.util.net.SocketProcessorBase.run > (SocketProcessorBase.java:49)\n\tat > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142)\n\tat > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecu > tor.java:617)\n\tat > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61)\n\tat > java.lang.Thread.run(Thread.java:745)\n","exception":"Query is not allowed > in w eb > mode.","url":"http://ascv102.prod.hnd1.bdd.local:7070/kylin/api/query"} > 14336 at > org.apache.kylin.jdbc.KylinClient.asIOException(KylinClient.java:416) > 14337 at > org.apache.kylin.jdbc.KylinClient.executeKylinQuery(KylinClient.java:376) > 14338 at > org.apache.kylin.jdbc.KylinClient.executeQuery(KylinClient.java:326) > 14339 at > org.apache.kylin.jdbc.KylinResultSet.execute(KylinResultSet.java:69) > 14340 ... 6 more > 14341 , Connection String: > DSN=KYLIN;JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/ > install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL= > jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_mart_rat > _session_summary;UID=ADMIN;, Statement String: SELECT TOP 4 * FROM > SCV_WORK, > JdbcCallMade: MIX_JdbcStatement_execute > 14342 2017-08-22 18:03:52.544+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:2488064][Database > Classes][Error] JdbcStatementWrapper::ExecQuery failed. > 14343 Error type: Jdbc success with info. Jdbc operation attempted: > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] Connection String: > DSN=KYLIN;JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/ > install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL= > jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_ > mart_rat_session_summary;UID=ADMIN;. > SQL Statement: SELECT TOP 4 * FROM SCV_WORK. > 14344 2017-08-22 18:03:52.544+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:2488064][Database > Classes][Error] Query execution failed when importing data from database or > web service. Error message: JdbcStatementWrapper::ExecQuery failed. > 14345 Error type: Jdbc success with info. Jdbc operation attempted: > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] Connection String: > DSN=KYLIN;JDBC;MSTR_JDBC_JAR_FOLDER=/usr/local/mstr/ > install/JDBC;DRIVER=org.apache.kylin.jdbc.Driver;URL= > jdbc:kylin://ascv102.prod.hnd1.bdd.local:7070/scv_rat_ > mart_rat_session_summary;UID=ADMIN;. > SQL Statement: SELECT TOP 4 * FROM SCV_WORK.. > 14346 2017-08-22 18:03:52.544+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:2488064][COM > Shared][Error][0x8004180E] Error in accessing information from the external > data source (Database Instance: (DataImport)[0], Error: > JdbcStatementWrapper::ExecQuery failed. > 14347 Error type: Jdbc success with info. Jdbc operation attempted: > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] ) > 14348 2017-08-22 18:03:52.883+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:2086184704][COM > Shared][Error][0x8004180E] Error in accessing information from the externa > l data source (Database Instance: (DataImport)[0], Error: > JdbcStatementWrapper::ExecQuery failed. > 14349 Error type: Jdbc success with info. Jdbc operation attempted: > MIX_JdbcStatement_execute. [:0: on SQLHANDLE] ) > > 14320,51-58 99% > > olap > > There is an error on the server. Details > ｲﾝﾃﾞｯｸｽが､範囲外です｡内部ｼｽﾃﾑ ｴﾗｰ: XMLRequest で例外を検出しました｡ :: Execute｡ Table pointer > is null. Cannot perform append operation. > > 2017-08-22 18:06:35.518+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:3803707136][Kernel][Info] > Contract Request Succeeded: Source=MDb::Table, Handle=1887, Size > =13303808, ContractedTotal=140668928, AvailableTotal=534490736306 > 14351 2017-08-22 18:06:59.868+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:2050463488][Dimensional > Storage][Error] The locale for the dataset is 0 and the locale for > current server instance is 1033. But don't worry, by default we have fixed > it for you. > 14352 2017-08-22 18:06:59.869+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:2050463488][Dimensional > Storage][Error] The locale for the dataset is 0 and the locale for > current server instance is 1033. But don't worry, by default we have fixed > it for you. > 14353 2017-08-22 18:10:47.768+09:00 > [HOST:ared302.db.test.co.jp][SERVER:CastorServer][PID: > 39561][THR:2111399680][Object > Server][Error][0x80041018] Index out of range > > .. > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/Query-is-not-allowed-in-web-mode-tp8778.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > >
