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”的报错 >> 请问这是什么问题呢？ >> >> 谢谢 >> >> >
