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.SecurityContextHolderAwareRequestFilter.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(DefaultLoginPageGeneratingFilter.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.SecurityContextPersistenceFilter.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.SecurityContextHolderAwareRequestFilter.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(DefaultLoginPageGeneratingFilter.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.SecurityContextPersistenceFilter.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.SecurityContextHolderAwareRequestFilter.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(DefaultLoginPageGeneratingFilter.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.SecurityContextHolderAwareRequestFilter.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(SecurityContextPersistenceFilter.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.
