回复： Re: Re: Tableau Server通过JDBC连接Kylin的问题

[禹荣虎 <ti...@pkfare.com>]

ok，thanks





来自钉钉专属商务邮箱------------------------------------------------------------------
发件人：Temple Zhou<db...@gmail.com>
日　期：2019年10月25日 17:04:00
收件人：禹荣虎<ti...@pkfare.com>; user<us...@kylin.apache.org>
主　题：Re: Re: Re: Tableau Server通过JDBC连接Kylin的问题

Hi Tiger

I have tried the Tableau Server(2019.2.4) on Windows(2008R2) and Linux(Ubuntu 18.04) and found that only the Tableau Server(Windows) will encounter the "no RTTI data" error.

When I publish the reports to the Tableau Server(for Linux), it runs smoothly.

I guess you are working with Tableau Server for Windows, if so, would you like to try the Tableau Server for Linux?
On Fri, Oct 25, 2019 at 11:37 AM 禹荣虎 <ti...@pkfare.com> wrote:

thanks


Tiger Yu



------------------------------------------------------------------
发件人：Temple Zhou <db...@gmail.com>
发送时间：2019年10月25日(星期五) 11:21
收件人：禹荣虎 <ti...@pkfare.com>
主　题：Re: Re: Re: Tableau Server通过JDBC连接Kylin的问题

Hi Tiger

Sorry for the late reply, I have reproduced the issue and I'm trying to fix it.
On Tue, Aug 27, 2019 at 4:54 PM 禹荣虎 <ti...@pkfare.com> wrote:
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 <db...@gmail.com>
Send Date:Tue Aug 27 16:34:02 2019
Recipients:禹荣虎 <ti...@pkfare.com>
CC:user <us...@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 禹荣虎 <ti...@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<db...@gmail.com>
日　期：2019年08月26日 16:01:44
收件人：user<us...@kylin.apache.org>; 禹荣虎<ti...@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 禹荣虎 <ti...@pkfare.com> wrote:
kylin团队：你们好！

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

谢谢