org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'clsa-interviews.Phlebotomy'

JIRA | Yannick Marcon | 4 years ago
  1. 0

    * make a view based on table A * remove table A => view is not accessible and error 500 is reported {code} 2013-04-24 15:27:13,862 - ERROR - der.RuntimeExceptionMapper - Unhandled exception java.lang.RuntimeException: org.apache.shiro.subject.ExecutionException: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1' at org.obiba.magma.security.shiro.ShiroAuthorizer.silentSudo(ShiroAuthorizer.java:28) at org.obiba.magma.security.SudoValueTableReference.sudo(SudoValueTableReference.java:41) at org.obiba.magma.security.SudoValueTableReference.getWrappedValueTable(SudoValueTableReference.java:31) at org.obiba.magma.support.AbstractValueTableWrapper.getEntityType(AbstractValueTableWrapper.java:31) at org.obiba.magma.support.AbstractValueTableWrapper.getEntityType(AbstractValueTableWrapper.java:31) at org.obiba.magma.support.AbstractValueTableWrapper.getEntityType(AbstractValueTableWrapper.java:31) at org.obiba.opal.web.magma.Dtos.asDto(Dtos.java:217) at org.obiba.opal.web.magma.Dtos.asDto(Dtos.java:213) at org.obiba.opal.web.magma.TableResource.get(TableResource.java:92) at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:252) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:217) at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:151) at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:91) at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:503) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:480) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:207) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1329) at org.obiba.opal.server.httpd.OpalJettyServer$TransactionFilter$1.doInTransactionWithoutResult(OpalJettyServer.java:280) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.obiba.opal.server.httpd.OpalJettyServer$TransactionFilter.doFilterInternal(OpalJettyServer.java:276) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.obiba.opal.server.httpd.security.AuthenticationFilter.doFilterInternal(AuthenticationFilter.java:82) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.obiba.opal.server.httpd.OpalJettyServer$OpalVersionFilter.doFilterInternal(OpalJettyServer.java:260) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:445) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:363) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:920) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:982) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:722) Caused by: org.apache.shiro.subject.ExecutionException: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1' at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:346) at org.obiba.magma.security.shiro.ShiroAuthorizer.sudo(ShiroAuthorizer.java:34) at org.obiba.magma.security.shiro.ShiroAuthorizer.silentSudo(ShiroAuthorizer.java:26) ... 59 more Caused by: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1' at org.obiba.magma.support.AbstractDatasource.getValueTable(AbstractDatasource.java:79) at org.obiba.magma.datasource.hibernate.HibernateDatasource.getValueTable(HibernateDatasource.java:120) at org.obiba.magma.views.ViewAwareDatasource.getValueTable(ViewAwareDatasource.java:58) at org.obiba.magma.security.SecuredDatasource.getValueTable(SecuredDatasource.java:29) at org.obiba.magma.support.MagmaEngineTableResolver.resolveTable(MagmaEngineTableResolver.java:23) at org.obiba.magma.security.SudoValueTableReference$1.call(SudoValueTableReference.java:45) at org.obiba.magma.security.SudoValueTableReference$1.call(SudoValueTableReference.java:41) at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:344) ... 61 more {code}

    JIRA | 4 years ago | Yannick Marcon
    java.lang.RuntimeException: org.apache.shiro.subject.ExecutionException: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1'
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    * make a view based on table A * remove table A => view is not accessible and error 500 is reported {code} 2013-04-24 15:27:13,862 - ERROR - der.RuntimeExceptionMapper - Unhandled exception java.lang.RuntimeException: org.apache.shiro.subject.ExecutionException: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1' at org.obiba.magma.security.shiro.ShiroAuthorizer.silentSudo(ShiroAuthorizer.java:28) at org.obiba.magma.security.SudoValueTableReference.sudo(SudoValueTableReference.java:41) at org.obiba.magma.security.SudoValueTableReference.getWrappedValueTable(SudoValueTableReference.java:31) at org.obiba.magma.support.AbstractValueTableWrapper.getEntityType(AbstractValueTableWrapper.java:31) at org.obiba.magma.support.AbstractValueTableWrapper.getEntityType(AbstractValueTableWrapper.java:31) at org.obiba.magma.support.AbstractValueTableWrapper.getEntityType(AbstractValueTableWrapper.java:31) at org.obiba.opal.web.magma.Dtos.asDto(Dtos.java:217) at org.obiba.opal.web.magma.Dtos.asDto(Dtos.java:213) at org.obiba.opal.web.magma.TableResource.get(TableResource.java:92) at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:252) at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:217) at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:151) at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:91) at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:503) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:480) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:207) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1329) at org.obiba.opal.server.httpd.OpalJettyServer$TransactionFilter$1.doInTransactionWithoutResult(OpalJettyServer.java:280) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.obiba.opal.server.httpd.OpalJettyServer$TransactionFilter.doFilterInternal(OpalJettyServer.java:276) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.obiba.opal.server.httpd.security.AuthenticationFilter.doFilterInternal(AuthenticationFilter.java:82) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.obiba.opal.server.httpd.OpalJettyServer$OpalVersionFilter.doFilterInternal(OpalJettyServer.java:260) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:445) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:363) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:920) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:982) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:722) Caused by: org.apache.shiro.subject.ExecutionException: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1' at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:346) at org.obiba.magma.security.shiro.ShiroAuthorizer.sudo(ShiroAuthorizer.java:34) at org.obiba.magma.security.shiro.ShiroAuthorizer.silentSudo(ShiroAuthorizer.java:26) ... 59 more Caused by: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1' at org.obiba.magma.support.AbstractDatasource.getValueTable(AbstractDatasource.java:79) at org.obiba.magma.datasource.hibernate.HibernateDatasource.getValueTable(HibernateDatasource.java:120) at org.obiba.magma.views.ViewAwareDatasource.getValueTable(ViewAwareDatasource.java:58) at org.obiba.magma.security.SecuredDatasource.getValueTable(SecuredDatasource.java:29) at org.obiba.magma.support.MagmaEngineTableResolver.resolveTable(MagmaEngineTableResolver.java:23) at org.obiba.magma.security.SudoValueTableReference$1.call(SudoValueTableReference.java:45) at org.obiba.magma.security.SudoValueTableReference$1.call(SudoValueTableReference.java:41) at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:344) ... 61 more {code}

    JIRA | 4 years ago | Yannick Marcon
    java.lang.RuntimeException: org.apache.shiro.subject.ExecutionException: org.obiba.magma.NoSuchValueTableException: No value table exists with the specified name 'opal-data.Data1'

    Root Cause Analysis

    1. org.obiba.magma.NoSuchValueTableException

      No value table exists with the specified name 'clsa-interviews.Phlebotomy'

      at org.obiba.magma.support.AbstractDatasource.getValueTable()
    2. org.obiba.magma
      AbstractDatasource.getValueTable
      1. org.obiba.magma.support.AbstractDatasource.getValueTable(AbstractDatasource.java:76)
      1 frame
    3. org.obiba.opal
      RestDatasource.createWriter
      1. org.obiba.opal.rest.client.magma.RestDatasource.createWriter(RestDatasource.java:105)
      1 frame
    4. org.obiba.onyx
      EnrollmentIdDatasource.createWriter
      1. org.obiba.onyx.engine.variable.export.EnrollmentIdDatasource.createWriter(EnrollmentIdDatasource.java:48)
      1 frame
    5. org.obiba.magma
      DatasourceCopier.innerValueTableWriter
      1. org.obiba.magma.support.DatasourceCopier.createValueTableWriter(DatasourceCopier.java:230)
      2. org.obiba.magma.support.DatasourceCopier.innerValueTableWriter(DatasourceCopier.java:237)
      2 frames