ok，thanks
来自钉钉专属商务邮箱------------------------------------------------------------------ 发件人：Temple Zhou<[email protected]> 日 期：2019年10月25日 17:04:00 收件人：禹荣虎<[email protected]>; user<[email protected]> 主 题：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 禹荣虎 <[email protected]> wrote: thanks Tiger Yu ------------------------------------------------------------------ 发件人：Temple Zhou <[email protected]> 发送时间：2019年10月25日(星期五) 11:21 收件人：禹荣虎 <[email protected]> 主 题：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 禹荣虎 <[email protected]> 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 <[email protected]> Send Date:Tue Aug 27 16:34:02 2019 Recipients:禹荣虎 <[email protected]> CC:user <[email protected]> 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 禹荣虎 <[email protected]> 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<[email protected]> 日 期：2019年08月26日 16:01:44 收件人：user<[email protected]>; 禹荣虎<[email protected]> 主 题：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 禹荣虎 <[email protected]> wrote: kylin团队：你们好！ 我们使用Tableau desktop2019.2.2 通过jdbc连接kylin3.0alpha版本是没有问题的， 但是在将数据源发布到Tableau Server2019.2.2后，出现了“no RTTI data”的报错 请问这是什么问题呢？ 谢谢
