kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "禹荣虎" <tiger...@pkfare.com>
Subject 回复:Re: Re: Tableau Server通过JDBC连接Kylin的问题
Date Tue, 27 Aug 2019 08:54:41 GMT
Hi Temple zhou,
    ​sorry, There are two logs。
    ​‘Access violation - no RTTI data!’, this error message is occur when use the
embedded authentication 

Tiger Yu
​

 ------------------Original Mail ------------------
Sender:Temple Zhou <dbaztp@gmail.com>
Send Date:Tue Aug 27 16:34:02 2019
Recipients:禹荣虎 <tiger.yu@pkfare.com>
CC:user <user@kylin.apache.org>
Subject:Re: Re: Tableau Server通过JDBC连接Kylin的问题

Hi Ronghu,

According to the "HTTP Status 401 – Unauthorized" in your logs, I think you can try to use
the embedded authentication when publishing the tableau report.
On Mon, Aug 26, 2019 at 4:22 PM 禹荣虎 <tiger.yu@pkfare.com> wrote:

hi,this is the error logs

2019-08-20 14:33:46.682 +0800 (Default,admin@local,2739621914B44C0F80943AC13807126C-1:0,XVuUR172zblhD5c0JhhcZwAAAzk)
catalina-exec-120 : ERROR wgsessionId=M94866W4TTCwkckPzkKAmg com.tableausoftware.controller.vizql.ExceptionController
- activity=handle-wrapped-tableau-ex url=/bootstrapSession/sessions/2739621914B44C0F80943AC13807126C-1:0
sess=2739621914B44C0F80943AC13807126C-1:0 user=admin site=Default site_id=1 guest=0 wg_session_id=M94866W4TTCwkckPzkKAmg
excp_msg="Access violation - no RTTI data!
尝试加载工作簿 \"/views/ds:test---kylin\" 时出错。加载无法成功完成。
" excp_type=com.tableausoftware.model.vizql.WrappedTableauException
com.tableausoftware.model.vizql.WrappedTableauException: Access violation - no RTTI data!
尝试加载工作簿 "/views/ds:test---kylin" 时出错。加载无法成功完成。
 at com.tableausoftware.model.vizql.util.WithSessionAspect.runAndCatchErrors(WithSessionAspect.java:264)
 at com.tableausoftware.model.vizql.util.WithSessionAspect.callJoinPointWithRetry(WithSessionAspect.java:191)
 at com.tableausoftware.model.vizql.util.WithSessionAspect.acquireAndReleaseSessionImpl_aroundBody0(WithSessionAspect.java:162)
 at com.tableausoftware.model.vizql.util.WithSessionAspect$AjcClosure1.run(WithSessionAspect.java:1)
 at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
 at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:73)
 at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:60)
 at com.tableausoftware.model.vizql.util.WithSessionAspect.acquireAndReleaseSessionImpl(WithSessionAspect.java:139)
 at com.tableausoftware.model.vizql.util.VizqlSessionAspectHelper.acquireAndReleaseSession(VizqlSessionAspectHelper.java:63)
 at com.tableausoftware.model.vizql.service.handler.BootstrapHandlerV2.handleRequest(BootstrapHandlerV2.java:707)
 at com.tableausoftware.model.vizql.service.handler.BootstrapHandlerV2.handleRequest(BootstrapHandlerV2.java:66)
 at com.tableausoftware.controller.vizql.handler.BootstrapHttpHandlerV2.handleRequest(BootstrapHttpHandlerV2.java:43)
 at com.tableausoftware.controller.vizql.SessionController.bootstrapSession(SessionController.java:548)
 at com.tableausoftware.vqlweb.RequestMapper.bootstrapSession_aroundBody12(RequestMapper.java:298)
 at com.tableausoftware.vqlweb.RequestMapper$AjcClosure13.run(RequestMapper.java:1)
 at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
 at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:73)
 at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:60)
 at com.tableausoftware.vqlweb.RequestMapper.bootstrapSession(RequestMapper.java:298)
 at sun.reflect.GeneratedMethodAccessor1214.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
 at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
 at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
 at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:849)
 at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:760)
 at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
 at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
 at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
 at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
 at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:743)
 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:485)
 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)
 at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
 at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
 at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
 at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at com.tableausoftware.controller.vizql.servlet.CrossSiteScriptingFilter.doFilter(CrossSiteScriptingFilter.java:49)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
 at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2555)
 at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2544)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Thread.java:748)



2019-08-20 14:31:59.585 +0800 (Default,admin@local,EBE738B8D68F4750882F2E1C29B07211-1:0,XVuT1F72zblhD5c0JhhXvwAAA1o)
catalina-exec-116 : ERROR wgsessionId=M94866W4TTCwkckPzkKAmg com.tableausoftware.controller.vizql.ExceptionController
- activity=handle-data-source-ex url=/bootstrapSession/sessions/EBE738B8D68F4750882F2E1C29B07211-1:0
sess=EBE738B8D68F4750882F2E1C29B07211-1:0 user=admin site=Default site_id=1 guest=0 wg_session_id=M94866W4TTCwkckPzkKAmg
excp_msg="java.sql.SQLException: java.io.IOException: POST failed, error code 401 and response:
<!doctype html><html lang=\"en\"><head><title>HTTP Status 401 –
Unauthorized</title><style type=\"text/css\">H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color
: black;}A.name {color : black;}HR {color : #525D76;}</style></head><body><h1>HTTP
Status 401 – Unauthorized</h1><hr class=\"line\" /><p><b>Type</b>
Status Report</p><p><b>Message</b> Unauthorized</p><p><b>Description</b>
The request has not been applied because it lacks valid authentication credentials for the
target resource.</p><hr class=\"line\" /><h3>Apache Tomcat/7.0.91</h3></body></html>
Generic JDBC connection error
java.sql.SQLException: java.io.IOException: POST failed, error code 401 and response: <!doctype
html><html lang=\"en\"><head><title>HTTP Status 401 – Unauthorized</title><style
type=\"text/css\">H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color
: black;}A.name {color : black;}HR {color : #525D76;}</style></head><body><h1>HTTP
Status 401 – Unauthorized</h1><hr class=\"line\" /><p><b>Type</b>
Status Report</p><p><b>Message</b> Unauthorized</p><p><b>Description</b>
The request has not been applied because it lacks valid authentication credentials for the
target resource.</p><hr class=\"line\" /><h3>Apache Tomcat/7.0.91</h3></body></html>
DataServiceFailure
数据源“test---kylin”存在错误。请验证是否正确配置了数据源。
" excp_type=com.tableausoftware.nativeapi.exceptions.FederatedDataSourceException------------------------------------------------------------------
发件人:Temple Zhou<dbaztp@gmail.com>
日 期:2019年08月26日 16:01:44
收件人:user<user@kylin.apache.org>; 禹荣虎<tiger.yu@pkfare.com>
主 题:Re: Tableau Server通过JDBC连接Kylin的问题

hi,

Can you provide some related information in the log of Tableau VizQL server.
On Mon, Aug 26, 2019 at 3:00 PM 禹荣虎 <tiger.yu@pkfare.com> wrote:

kylin团队:你们好!

    我们使用Tableau desktop2019.2.2 通过jdbc连接kylin3.0alpha版本是没有问题的,
    但是在将数据源发布到Tableau Server2019.2.2后,出现了“no RTTI data”的报错
    请问这是什么问题呢?

谢谢


Mime
View raw message