1 Reply Latest reply on Dec 22, 2012 7:05 AM by Shawn Wallwork

    No such table [TEMP].[#Tableau_614_Filter].Unable to calculate the sort for the field 'WBS Segment'.  The display may not show correct data.

    Ken Guyette

      I am very new to Tableau and not actually a developer (yet !!).  I am working with a group that is developing some dashboards and looking at the Tableau server errors being generated.   We had six errors (all the same message) generated over a few minutes.  I have a feeling it has to do with filtering we were doing on a single workbook. 

       

      The information above seems to be the key piece of info from this error but I cannot find any details on what can cause this.  I have conducted a search of this site and google with no success.  Any guidance on what can cause this type of error would be appreciated.  I am including the full text of the error for reference.

       

       

      Error      12/20/2012 11:01:36 AM              Tableau
      Server   4096      Debug   "2012-12-20
      11:01:36,390 catalina-exec-87 ERROR requestId=UNNERAoGAHEAAAyoZvkAAAI7:  wgsessionId=7828a871e2c947d7c375d048b75d343d
      com.tableausoftware.controller.vizql.ExceptionController - WrappedTableauException
      caught for vizql session: 48fd8acd-2:1com.tableausoftware.model.vizql.WrappedTableauException:
      No such table
      [TEMP].[#Tableau_614_Filter].Unable to calculate the sort for the field 'WBS
      Segment'.  The display may not show
      correct data.        
      at com.tableausoftware.model.vizql.util.ErrorMapper.runAndCatchErrors(ErrorMapper.java:73)           at
      com.tableausoftware.model.vizql.util.WithSessionAspect.acquireAndReleaseSession(WithSessionAspect.java:154)               at
      com.tableausoftware.model.vizql.service.session.SessionServiceImpl.bootstrapSession(SessionServiceImpl.java:924)               at
      com.tableausoftware.controller.vizql.SessionController.bootstrapSession(SessionController.java:494)               at
      com.tableausoftware.vqlweb.RequestMapper.bootstrapSession(RequestMapper.java:186)               at sun.reflect.GeneratedMethodAccessor246.invoke(Unknown
      Source)      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)            at
      java.lang.reflect.Method.invoke(Method.java:597)             at
      org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)               at
      org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)               at
      org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)               at
      org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)             at
      org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)               at
      org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)  at
      org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)   at
      javax.servlet.http.HttpServlet.service(HttpServlet.java:641)             at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)             at
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)    at
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)     at
      org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)    at
      org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)            at
      org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)   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:244)    at
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)   at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)               at
      org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)          at
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)    at
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)   at
      org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at
      org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)    at
      org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at
      org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)    at
      org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)        at
      org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)    at
      org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:284)        at
      org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:322)               at
      org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1684)   at
      java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)   at
      java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)           at
      java.lang.Thread.run(Thread.java:619)Caused by:
      com.tableausoftware.vizql.dll.DataSourceException: No such table
      [TEMP].[#Tableau_614_Filter].Unable to calculate the sort for the field 'WBS
      Segment'.  The display may not show
      correct data.   at
      com.tableausoftware.vizql.dll.DataSourceException.getDataSourceException(DataSourceException.java:39)               at
      com.tableausoftware.vizql.dll.VizqlJNI.DashboardImagePtr_DoLayout(Native
      Method)   at
      com.tableausoftware.vizql.dll.DashboardImagePtr.DoLayout(DashboardImagePtr.java:213)             at
      com.tableausoftware.model.vizql.service.session.SessionServiceImpl.bootstrapSession_aroundBody22(SessionServiceImpl.java:948)               at
      com.tableausoftware.model.vizql.service.session.SessionServiceImpl$AjcClosure23.run(SessionServiceImpl.java:1)               at
      org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)          at
      com.tableausoftware.model.vizql.util.ErrorMapper.runAndCatchErrors(ErrorMapper.java:54)           ... 45 more"