Recently I'm also using MSTR 10 + Kylin, with the ODBC driver on Windows.

Here is a summary about the integration with MSTR, it may help to
understand:
http://docs.kyligence.io/v2.4/en/integration/microstrategy_10_4.en.html

2017-08-24 10:15 GMT+08:00 Billy Liu <[email protected]>:

> 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(NativeMethodAcce
> ssorImpl.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$VirtualFil
> terChain.doFi
> > lter(FilterChainProxy.java:342)\n\tat
> > org.springframework.security.web.servletapi.SecurityContextH
> olderAwareRequ
> > 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(FilterChainProx
> y.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.Avat
> icaStatement.
> > 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.InternalE
> rrorException:
> > 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(NativeMethodAcce
> ssorImpl.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.SecurityContextH
> olderAwareRequ
> > 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.Avat
> icaConnection.
> > prepareAndExecuteInternal(AvaticaConnection.java:615)
> > 14328         at
> > org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.Avat
> icaStatement.
> > 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(NativeMethodAcce
> ssorImpl.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.SecurityContextH
> olderAwareRequ
> > 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.j
> ava: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(Http11Processo
> r.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(NativeMethodAcce
> ssorImpl.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.SecurityContextHo
> lderAwareRequ
> > 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(StandardEngineV
> alve.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(KylinCli
> ent.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 <020%208618%204704>][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 <020%205046%203488>][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 <020%205046%203488>][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 <021%201139%209680>][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.
> >
> >
>



-- 
Best regards,

Shaofeng Shi 史少锋

Reply via email to